Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfacespgsql-jdbcpgsql-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

pgsql-hackers by date

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

pgsql-odbc by date

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

pgsql-interfaces by date

Next:From: Dave PageDate: 2001-01-22 20:55:07
Subject: RE: Re: extremely newbie questions
Previous:From: Michael DavisDate: 2001-01-22 17:58:56
Subject: RE: extremely newbie questions

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group