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

Re: idle in transaction...unexpected EOF on client connection

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: idle in transaction...unexpected EOF on client connection
Date: 2007-11-09 23:38:26
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C03062D85@egcrc-ex01.egcrc.org (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Tom,

Good to have you jump in.

The answer to your question (what JDBC version) is:
postgresql-8.1-404.jdbc3.jar
and the postgres version is: 8.2.4

I just downloaded postgresql-8.2-506.jdbc3.jar and
will go ahead and recompile the app over the weekend
with this one.

Aside from that, can this be caused by many deleted
rows from tables (and having neglected to vacuum)?

Tena Sakai
(tsakai(at)gallo(dot)ucsf(dot)edu)


-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Fri 11/9/2007 3:03 PM
To: Scott Marlowe
Cc: Tena Sakai; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] idle in transaction...unexpected EOF on client connection 
 
"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> writes:
> Hmmm.  Well, when you see an error like unexpected EOF on client
> connection then that means that the client "disappeared" without
> closing the connection, or the network connection went away.

More specifically, the client didn't send the expected "terminate session"
message before dropping the network connection.

I seem to recall that old versions of the JDBC driver had a bad habit
of not sending Terminate --- what JDBC version are you using?

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2007-11-10 00:29:43
Subject: Re: idle in transaction...unexpected EOF on clientconnection
Previous:From: joel zimmerliDate: 2007-11-09 23:27:17
Subject: HELP: I removed file pg_log, how can I recover?

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