Обсуждение: Strange message in logs..

Поиск
Список
Период
Сортировка

Strange message in logs..

От
"Mitch Vincent"
Дата:
I'm getting a lot of 

pq_recvbuf: unexpected EOF on client connection

... in my postgres.log file (PostgreSQL 7.0.0), is this to be expected? 


- Mitch

"The only real failure is quitting."





Re: Strange message in logs..

От
Kovacs Zoltan Sandor
Дата:
> pq_recvbuf: unexpected EOF on client connection
My Windows application (via ODBC) does the same result on shutting the
connection. I find this as a normal behaviour.

Zoltan



Re: Strange message in logs..

От
Tom Lane
Дата:
"Mitch Vincent" <mitch@venux.net> writes:
> I'm getting a lot of 
> pq_recvbuf: unexpected EOF on client connection
> ... in my postgres.log file (PostgreSQL 7.0.0), is this to be expected? 

It is if you are using client apps that don't bother to close the
connection cleanly (ie, first sending an 'X' message) when they quit.

It appears that our ODBC driver doesn't send 'X' during connection
close, which I would call a (minor) bug in the ODBC driver.  Of course
the problem would appear anyway if the client app is in the habit of
exiting without telling the interface library to shut down first.

The backend doesn't particularly care; it'll close up shop the same
way with or without 'X'.
        regards, tom lane