pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gerhard Hintermayer <g.hintermayer@inode.at>
To: pgsql-interfaces@postgresql.org
Subject: Re: libpgtcl: pq_recvbuf: unexpected EOF on client connection
Date: Mon, 02 Sep 2002 18:34:53 +0200
Message-ID: <kt30la.c9q.ln@schere.mfa.at> (raw)
References: <23187.1030982048@sss.pgh.pa.us>

Tom Lane wrote:
> g.hintermayer@inode.at (Gerhard Hintermayer) writes:
> 
>>I constantly keep getting this message in the log files when
>>disconnection with pg_disconnect (TCL-interface)
> 
> 
> Yeah, I see it too --- though everything's fine if you just exit the
> client program without an explicit pg_disconnect.  I think the problem
> is that pg_disconnect shouldn't be unregistering the notifier_channel;
> I bet TCL thinks it should close the socket when we do that.  Then
> the later PQfinish call will be unable to send the normal termination
> message to the backend.  Probably the best fix is to move the unregister
> call into PgDelConnectionId(), after we do PQfinish.
> 
> 			regards, tom lane

Hope my posting works.

I don't understand what you're thinking of, because the unregistering triggers 
the call to PgDelConnectionId, so who will close the connection if you remove 
the unregister call ?
I wonder what has changed either in the Tcl or the PQ internals, since this 
worked in Tcl8.3.2 combined with PostgreSQL 7.0.2. Going to check that tomorrow 
at work.
Btw, is the PQfinish syncroneous (?) or not ? Maybe the problem is we're sending 
the X and close the connection immediately instead of letting the server close it.

Gerhard

-- 
Gerhard Hintermayer
http://www.inode.at/g.hintermayer




view thread (4+ messages)  latest in thread

Message-ID: <kt30la.c9q.ln@schere.mfa.at>
Permalink:  ../kt30la.c9q.ln@schere.mfa.at/
Also on:    postgresql.org/message-id/kt30la.c9q.ln@schere.mfa.at

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: g.hintermayer@inode.at
  Subject: Re: libpgtcl: pq_recvbuf: unexpected EOF on client connection
  In-Reply-To: <kt30la.c9q.ln@schere.mfa.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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