Re: ODBC gives pq_recvbuf: unexpected EOF on client connection

From: Peter Mount <peter(at)retep(dot)org(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Cedar Cox <cedarc(at)visionforisrael(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: ODBC gives pq_recvbuf: unexpected EOF on client connection
Date: 2001-01-22 20:45:55
Message-ID: 5.0.2.1.0.20010122204328.009e3b60@mail.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces pgsql-jdbc pgsql-odbc

At 13:39 21/01/01 -0500, Tom Lane wrote:
>Cedar Cox <cedarc(at)visionforisrael(dot)com> writes:
> > I'm using ODBC/MS Access and every time my client shuts down
> > I get the log message:
> > pq_recvbuf: unexpected EOF on client connection
> > Is there something I'm doing wrong here?
>
>Not you, the ODBC driver --- it's just unceremoniously closing the
>socket connection without being polite enough to send the disconnect
>message (a single 'X', I think) first.
>
>Somebody ought to fix that, but it's not a real high priority.
>There's no bad side-effects other than cluttering the postmaster log.
>
> > (yes I did copy the JDBC post.. ;)
>
>I haven't looked at the JDBC code, but evidently it's equally impolite.

This was fixed in 6.5.3 as long as the client doesn't kill the JVM
prematurely. As long as client code calls the Connection's close() method
then the backend will get the X message. Problem is most people
conveniently forget to put close() in their code.

Peter

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB 2001-01-22 20:49:29 AW: AW: Re: MySQL and BerkleyDB (fwd)
Previous Message Peter Mount 2001-01-22 20:40:53 Re: postgres memory management

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dave Page 2001-01-22 20:55:07 RE: Re: extremely newbie questions
Previous Message Michael Davis 2001-01-22 17:58:56 RE: extremely newbie questions

Browse pgsql-jdbc by date

  From Date Subject
Next Message The Hermit Hacker 2001-01-22 21:21:23 Re: Why does the JDBC driver not support prepareCall?
Previous Message Peter Mount 2001-01-22 20:40:53 Re: postgres memory management

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2001-01-22 21:19:25 Driver updates for 7.1
Previous Message Tom Lane 2001-01-21 18:39:22 Re: ODBC gives pq_recvbuf: unexpected EOF on client connection