Vous n'êtes pas identifié(e).
Salut,
J'ai remarqué dans mes logs ces erreurs qui datent depuis un certains moment.
<1167 - 2012-03-15 17:17:56 EDT - 10.8.0.14> idleLOG: could not receive data from client: Connection timed out
<1167 - 2012-03-15 17:17:56 EDT - 10.8.0.14> idleLOG: unexpected EOF on client connection
pourtant le réseau 10.8.0.0 est autorisé dans le fichier pg_hba.conf
aviez vous une idée?
Merci
Hors ligne
Bonjour.
Ce genre de message apparait quand un logiciel client est déconnecté brutalement (kill du process, déconnexion réseau ...).
Julien.
https://rjuju.github.io/
Hors ligne
Merci, effectivement, c'est dû aux ruptures de mes connexion ssh sur mon serveur.
merci
Hors ligne
Salut,
Il me semble que le problème ne vient pas forcement de la car hier on a constaté une lenteur du serveur vers 19h, et j'ai vu dans les logs une 20taine de ce message de suite provenant de notre serveur web.
je pense que ce doit être le paramètre max-connexions qui a été dépassé par le nombre de connexion.
je vais augmenter ce paramètre de 100 a 150.
qu'est ce que tu en penses?
Hors ligne
Le message que vous montrez ci-dessus n'a rien à voir à un dépassement du max_connections.
Guillaume.
Hors ligne
mais a quoi cela peut etre du, je vous envois une bonne partie du log
<12345 - 2012-03-22 19:54:55 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<12345 - 2012-03-22 19:54:55 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<12339 - 2012-03-22 19:55:06 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<12339 - 2012-03-22 19:55:06 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<24181 - 2012-03-22 19:56:51 EDT -209.xxx.xx.220> SELECTLOG: duration: 3028.592 ms execute S_3: SELECT addresses.address_id, addresses.street_address, addresses.city, addresses.province, addresses.country, addresses.is_correct FROM address.mappoint_address addresses WHERE addresses.latitude_wgs84 = $1 AND addresses.longitude_wgs84 = $2
<24181 - 2012-03-22 19:56:51 EDT -209.xxx.xx.220> SELECTDETAIL: parameters: $1 = '45.2864', $2 = '-74.0365'
<12319 - 2012-03-22 19:57:48 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<12319 - 2012-03-22 19:57:48 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<11583 - 2012-03-22 20:00:03 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<11583 - 2012-03-22 20:00:03 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<24194 - 2012-03-22 20:00:14 EDT -209.xxx.xx.220> SELECTLOG: duration: 3654.631 ms execute S_2: SELECT addresses.address_id, addresses.street_address, addresses.city, addresses.province, addresses.country, addresses.is_correct FROM address.mappoint_address addresses WHERE addresses.latitude_wgs84 = $1 AND addresses.longitude_wgs84 = $2
<24194 - 2012-03-22 20:00:14 EDT -209.xxx.xx.220> SELECTDETAIL: parameters: $1 = '45.2862', $2 = '-74.0373'
<24181 - 2012-03-22 20:00:15 EDT -209.xxx.xx.220> SELECTLOG: duration: 3705.581 ms execute S_3: SELECT addresses.address_id, addresses.street_address, addresses.city, addresses.province, addresses.country, addresses.is_correct FROM address.mappoint_address addresses WHERE addresses.latitude_wgs84 = $1 AND addresses.longitude_wgs84 = $2
<24181 - 2012-03-22 20:00:15 EDT -209.xxx.xx.220> SELECTDETAIL: parameters: $1 = '45.4876', $2 = '-75.6424'
<11582 - 2012-03-22 20:00:24 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<11582 - 2012-03-22 20:00:24 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<11581 - 2012-03-22 20:00:30 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<11581 - 2012-03-22 20:00:30 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<11579 - 2012-03-22 20:00:30 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<11579 - 2012-03-22 20:00:30 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<11580 - 2012-03-22 20:00:30 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<11580 - 2012-03-22 20:00:30 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<11578 - 2012-03-22 20:01:10 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<11578 - 2012-03-22 20:01:10 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<25097 - 2012-03-22 20:01:26 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<25097 - 2012-03-22 20:01:26 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<1247 - 2012-03-22 20:01:27 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<1247 - 2012-03-22 20:01:27 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<14812 - 2012-03-22 20:01:40 EDT -209.xxx.xx.216> idleLOG: could not receive data from client: Connection timed out
<14812 - 2012-03-22 20:01:40 EDT -209.xxx.xx.216> idleLOG: unexpected EOF on client connection
<11577 - 2012-03-22 20:01:54 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<11577 - 2012-03-22 20:01:54 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<11658 - 2012-03-22 20:01:55 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<11658 - 2012-03-22 20:01:55 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<11677 - 2012-03-22 20:01:56 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<11677 - 2012-03-22 20:01:56 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<12304 - 2012-03-22 20:01:56 EDT -209.xxx.xx.220> idleLOG: could not receive data from client: Connection timed out
<12304 - 2012-03-22 20:01:56 EDT -209.xxx.xx.220> idleLOG: unexpected EOF on client connection
<24194 - 2012-03-22 20:02:35 EDT -209.xxx.xx.220> SELECTLOG: duration: 3159.124 ms execute S_2: SELECT addresses.address_id, addresses.street_address, addresses.city, addresses.province, addresses.country, addresses.is_correct FROM address.mappoint_address addresses WHERE addresses.latitude_wgs84 = $1 AND addresses.longitude_wgs84 = $2
<24194 - 2012-03-22 20:02:35 EDT -209.xxx.xx.220> SELECTDETAIL: parameters: $1 = '48.2664', $2 = '-70.8745'
Hors ligne
Apparemment, le client ne finit pas la phase de connexion.
Guillaume.
Hors ligne