pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC gives pq_recvbuf: unexpected EOF on client connection
4+ messages / 4 participants
[nested] [flat]
* ODBC gives pq_recvbuf: unexpected EOF on client connection
@ 2001-01-21 10:47 Cedar Cox <cedarc@visionforisrael.com>
0 siblings, 2 replies; 4+ messages in thread
From: Cedar Cox @ 2001-01-21 10:47 UTC (permalink / raw)
To: pgsql-interfaces
Hi,
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? I haven't been too bothered by
this but I do wonder...
Many thanks for any tips!
-Cedar
(yes I did copy the JDBC post.. ;)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ODBC gives pq_recvbuf: unexpected EOF on client connection
@ 2001-01-21 18:39 Tom Lane <tgl@sss.pgh.pa.us>
parent: Cedar Cox <cedarc@visionforisrael.com>
1 sibling, 1 reply; 4+ messages in thread
From: Tom Lane @ 2001-01-21 18:39 UTC (permalink / raw)
To: Cedar Cox <cedarc@visionforisrael.com>; +Cc: pgsql-interfaces
Cedar Cox <cedarc@visionforisrael.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.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ODBC gives pq_recvbuf: unexpected EOF on client connection
@ 2001-01-22 20:45 Peter Mount <peter@retep.org.uk>
parent: Cedar Cox <cedarc@visionforisrael.com>
1 sibling, 0 replies; 4+ messages in thread
From: Peter Mount @ 2001-01-22 20:45 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; Cedar Cox <cedarc@visionforisrael.com>; +Cc: pgsql-interfaces; pgsql-jdbc@postgresql.org
At 13:39 21/01/01 -0500, Tom Lane wrote:
>Cedar Cox <cedarc@visionforisrael.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] ODBC gives pq_recvbuf: unexpected EOF on client connection
@ 2001-01-24 18:47 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2001-01-24 18:47 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Cedar Cox <cedarc@visionforisrael.com>; PostgreSQL-development <pgsql-hackers@postgreSQL.org>; PostgreSQL odbc list <pgsql-odbc@postgreSQL.org>
Can someone research this? I heard JDBC has the same problem.
> Cedar Cox <cedarc@visionforisrael.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.
>
> regards, tom lane
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-01-24 18:47 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-21 10:47 ODBC gives pq_recvbuf: unexpected EOF on client connection Cedar Cox <cedarc@visionforisrael.com>
2001-01-21 18:39 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-01-24 18:47 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-01-22 20:45 ` Peter Mount <peter@retep.org.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox