Re: pg_recvbuf errors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex <alex(at)meerkatsoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_recvbuf errors
Date: 2003-12-29 04:19:32
Message-ID: 8011.1072671572@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alex <alex(at)meerkatsoft(dot)com> writes:
> i noticed in my server logs (which have grown to over 100mb) that i got
> a lot of error messages saying pg_recvbuf: unexpected EOF on client
> connection.

This indicates a client disconnecting without sending a polite goodbye
(namely a Terminate or 'X' message). This isn't really dangerous,
unless the client failed partway through a transaction; but still you
might want to clean it up to avoid the chatter in the log.

Some of our client libraries used to be in the habit of just
disconnecting, so if you're using older client libraries then an update
is the first thing to try.

Otherwise, it's likely an application programming bug, ie, quitting
without closing down your database connections first.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-12-29 04:21:11 Re: Change onership of database and all tables? (fwd)
Previous Message Bruno Wolff III 2003-12-29 04:02:35 Re: Variables in PostgreSQL? [was: Is my MySQL Gaining?]