pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedidle in transaction...unexpected EOF on client connection
11+ messages / 5 participants
[nested] [flat]
* idle in transaction...unexpected EOF on client connection
@ 2007-11-09 21:58 Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:11 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 22:26 ` Re: idle in transaction...unexpected EOF on client connection Campbell, Lance <lance@uiuc.edu>
0 siblings, 2 replies; 11+ messages in thread
From: Tena Sakai @ 2007-11-09 21:58 UTC (permalink / raw)
To: pgsql-admin
Hi Everybody,
I see in serverlog many entries that read:
<gadb 2007-11-09 13:13:47 PST idle in transaction>LOG: unexpected EOF on client connection
<gadb 2007-11-09 13:23:08 PST idle in transaction>LOG: unexpected EOF on client connection
<gadb 2007-11-09 13:23:44 PST idle in transaction>LOG: unexpected EOF on client connection
<gadb 2007-11-09 13:25:42 PST idle in transaction>LOG: unexpected EOF on client connection
This occurs regularly and frequently and I am
wondering if it is indicative of any underlying
issue(s). Would you please let me know what
you know?
Thank you.
Tena Sakai
tsakai@gallo.ucsf.edu
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: idle in transaction...unexpected EOF on client connection
2007-11-09 21:58 idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
@ 2007-11-09 22:11 ` Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 22:36 ` Re: idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
1 sibling, 1 reply; 11+ messages in thread
From: Scott Marlowe @ 2007-11-09 22:11 UTC (permalink / raw)
To: Tena Sakai <tsakai@gallo.ucsf.edu>; +Cc: pgsql-admin
On Nov 9, 2007 3:58 PM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
>
> Hi Everybody,
>
> I see in serverlog many entries that read:
> <gadb 2007-11-09 13:13:47 PST idle in transaction>LOG: unexpected EOF on
> client connection
> <gadb 2007-11-09 13:23:08 PST idle in transaction>LOG: unexpected EOF on
> client connection
> <gadb 2007-11-09 13:23:44 PST idle in transaction>LOG: unexpected EOF on
> client connection
> <gadb 2007-11-09 13:25:42 PST idle in transaction>LOG: unexpected EOF on
> client connection
>
> This occurs regularly and frequently and I am
> wondering if it is indicative of any underlying
> issue(s). Would you please let me know what
> you know?
Most likely what is happening is that you have a firewall between your
app and your db server that is closing idle connections after x
minutes. Could be other things, like crashing clients, etc... Hard
to say without more evidence.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: idle in transaction...unexpected EOF on client connection
2007-11-09 21:58 idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:11 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
@ 2007-11-09 22:36 ` Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:41 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 11+ messages in thread
From: Tena Sakai @ 2007-11-09 22:36 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: pgsql-admin
Hi Scott,
> Most likely what is happening is that you have a firewall between your
> app and your db server that is closing idle connections after x minutes.
Thanks for your comment.
I hate to be disagreeable, but the app and postgres are running
on the same computer. The app is a java program using jdbc to
issue postgres commands. However, I see the same message via
psql (on the same machine).
Tena Sakai
tsakai@gallo.ucsf.edu
-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
Sent: Fri 11/9/2007 2:11 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] idle in transaction...unexpected EOF on client connection
On Nov 9, 2007 3:58 PM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
>
> Hi Everybody,
>
> I see in serverlog many entries that read:
> <gadb 2007-11-09 13:13:47 PST idle in transaction>LOG: unexpected EOF on
> client connection
> <gadb 2007-11-09 13:23:08 PST idle in transaction>LOG: unexpected EOF on
> client connection
> <gadb 2007-11-09 13:23:44 PST idle in transaction>LOG: unexpected EOF on
> client connection
> <gadb 2007-11-09 13:25:42 PST idle in transaction>LOG: unexpected EOF on
> client connection
>
> This occurs regularly and frequently and I am
> wondering if it is indicative of any underlying
> issue(s). Would you please let me know what
> you know?
Most likely what is happening is that you have a firewall between your
app and your db server that is closing idle connections after x
minutes. Could be other things, like crashing clients, etc... Hard
to say without more evidence.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: idle in transaction...unexpected EOF on client connection
2007-11-09 21:58 idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:11 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 22:36 ` Re: idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
@ 2007-11-09 22:41 ` Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 23:03 ` Re: idle in transaction...unexpected EOF on client connection Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 11+ messages in thread
From: Scott Marlowe @ 2007-11-09 22:41 UTC (permalink / raw)
To: Tena Sakai <tsakai@gallo.ucsf.edu>; +Cc: pgsql-admin
On Nov 9, 2007 4:36 PM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
> Hi Scott,
>
>
> > Most likely what is happening is that you have a firewall between your
> > app and your db server that is closing idle connections after x minutes.
>
> Thanks for your comment.
>
> I hate to be disagreeable, but the app and postgres are running
> on the same computer. The app is a java program using jdbc to
> issue postgres commands. However, I see the same message via
> psql (on the same machine).
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. Either
way, the pgsql backend was still alive, and tried to send something to
the client, and the client wasn't there. I.e. the problem isn't
generally a postgresql problem, it's a client problem. So, the more
info about the client app the better chance of fixing it.
Note that if you've got a lot of "idle in transactions" connections,
that's a bad thing because it prevents postgresql from being properly
vacuumed. Most connection managers can be set to NOT issue a begin as
part of a connection reset when returning it to the pool.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: idle in transaction...unexpected EOF on client connection
2007-11-09 21:58 idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:11 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 22:36 ` Re: idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:41 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
@ 2007-11-09 23:03 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-11-09 23:38 ` Re: idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
0 siblings, 1 reply; 11+ messages in thread
From: Tom Lane @ 2007-11-09 23:03 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Tena Sakai <tsakai@gallo.ucsf.edu>; pgsql-admin
"Scott Marlowe" <scott.marlowe@gmail.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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: idle in transaction...unexpected EOF on client connection
2007-11-09 21:58 idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:11 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 22:36 ` Re: idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:41 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 23:03 ` Re: idle in transaction...unexpected EOF on client connection Tom Lane <tgl@sss.pgh.pa.us>
@ 2007-11-09 23:38 ` Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-10 00:29 ` Re: idle in transaction...unexpected EOF on client connection Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 11+ messages in thread
From: Tena Sakai @ 2007-11-09 23:38 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; Scott Marlowe <scott.marlowe@gmail.com>; +Cc: 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@gallo.ucsf.edu)
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Fri 11/9/2007 3:03 PM
To: Scott Marlowe
Cc: Tena Sakai; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] idle in transaction...unexpected EOF on client connection
"Scott Marlowe" <scott.marlowe@gmail.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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: idle in transaction...unexpected EOF on client connection
2007-11-09 21:58 idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:11 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 22:36 ` Re: idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:41 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 23:03 ` Re: idle in transaction...unexpected EOF on client connection Tom Lane <tgl@sss.pgh.pa.us>
2007-11-09 23:38 ` Re: idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
@ 2007-11-10 00:29 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-11-10 00:38 ` Re: idle in transaction...unexpected EOF on clientconnection Tena Sakai <tsakai@gallo.ucsf.edu>
0 siblings, 1 reply; 11+ messages in thread
From: Alvaro Herrera @ 2007-11-10 00:29 UTC (permalink / raw)
To: Tena Sakai <tsakai@gallo.ucsf.edu>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Scott Marlowe <scott.marlowe@gmail.com>; pgsql-admin
Tena Sakai escribió:
> Aside from that, can this be caused by many deleted
> rows from tables (and having neglected to vacuum)?
No.
--
Alvaro Herrera http://www.advogato.org/person/alvherre
Major Fambrough: You wish to see the frontier?
John Dunbar: Yes sir, before it's gone.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: idle in transaction...unexpected EOF on clientconnection
2007-11-09 21:58 idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:11 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 22:36 ` Re: idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:41 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 23:03 ` Re: idle in transaction...unexpected EOF on client connection Tom Lane <tgl@sss.pgh.pa.us>
2007-11-09 23:38 ` Re: idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-10 00:29 ` Re: idle in transaction...unexpected EOF on client connection Alvaro Herrera <alvherre@commandprompt.com>
@ 2007-11-10 00:38 ` Tena Sakai <tsakai@gallo.ucsf.edu>
0 siblings, 0 replies; 11+ messages in thread
From: Tena Sakai @ 2007-11-10 00:38 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Scott Marlowe <scott.marlowe@gmail.com>; pgsql-admin
Thank you!
Tena
-----Original Message-----
From: Alvaro Herrera [mailto:alvherre@commandprompt.com]
Sent: Fri 11/9/2007 4:29 PM
To: Tena Sakai
Cc: Tom Lane; Scott Marlowe; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] idle in transaction...unexpected EOF on clientconnection
Tena Sakai escribió:
> Aside from that, can this be caused by many deleted
> rows from tables (and having neglected to vacuum)?
No.
--
Alvaro Herrera http://www.advogato.org/person/alvherre
Major Fambrough: You wish to see the frontier?
John Dunbar: Yes sir, before it's gone.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: idle in transaction...unexpected EOF on client connection
2007-11-09 21:58 idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
@ 2007-11-09 22:26 ` Campbell, Lance <lance@uiuc.edu>
2007-11-09 22:29 ` Re: idle in transaction...unexpected EOF on client connection Alvaro Herrera <alvherre@commandprompt.com>
1 sibling, 1 reply; 11+ messages in thread
From: Campbell, Lance @ 2007-11-09 22:26 UTC (permalink / raw)
To: Tena Sakai <tsakai@gallo.ucsf.edu>; pgsql-admin
I notice this in my log file as well. I do not have a fire wall that
would impact this.
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
________________________________
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Tena Sakai
Sent: Friday, November 09, 2007 3:58 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] idle in transaction...unexpected EOF on client
connection
Hi Everybody,
I see in serverlog many entries that read:
<gadb 2007-11-09 13:13:47 PST idle in transaction>LOG: unexpected EOF
on client connection
<gadb 2007-11-09 13:23:08 PST idle in transaction>LOG: unexpected EOF
on client connection
<gadb 2007-11-09 13:23:44 PST idle in transaction>LOG: unexpected EOF
on client connection
<gadb 2007-11-09 13:25:42 PST idle in transaction>LOG: unexpected EOF
on client connection
This occurs regularly and frequently and I am
wondering if it is indicative of any underlying
issue(s). Would you please let me know what
you know?
Thank you.
Tena Sakai
tsakai@gallo.ucsf.edu
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: idle in transaction...unexpected EOF on client connection
2007-11-09 21:58 idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:26 ` Re: idle in transaction...unexpected EOF on client connection Campbell, Lance <lance@uiuc.edu>
@ 2007-11-09 22:29 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-11-09 22:33 ` Re: idle in transaction...unexpected EOF on client connection Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 11+ messages in thread
From: Alvaro Herrera @ 2007-11-09 22:29 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; +Cc: Tena Sakai <tsakai@gallo.ucsf.edu>; pgsql-admin
Campbell, Lance wrote:
> I notice this in my log file as well. I do not have a fire wall that
> would impact this.
It could be a monitoring tool that's opening the socket to check whether
Postgres is listening. If it connects then closes the socket without
actually talking the PG protocol, this is exactly what you would see.
Is there any reason you're so fond of top-posting?
--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J
"Escucha y olvidarás; ve y recordarás; haz y entenderás" (Confucio)
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: idle in transaction...unexpected EOF on client connection
2007-11-09 21:58 idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:26 ` Re: idle in transaction...unexpected EOF on client connection Campbell, Lance <lance@uiuc.edu>
2007-11-09 22:29 ` Re: idle in transaction...unexpected EOF on client connection Alvaro Herrera <alvherre@commandprompt.com>
@ 2007-11-09 22:33 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 11+ messages in thread
From: Scott Marlowe @ 2007-11-09 22:33 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: Campbell, Lance <lance@uiuc.edu>; Tena Sakai <tsakai@gallo.ucsf.edu>; pgsql-admin
On Nov 9, 2007 4:29 PM, Alvaro Herrera <alvherre@commandprompt.com> wrote:
> Campbell, Lance wrote:
> > I notice this in my log file as well. I do not have a fire wall that
> > would impact this.
>
> It could be a monitoring tool that's opening the socket to check whether
> Postgres is listening. If it connects then closes the socket without
> actually talking the PG protocol, this is exactly what you would see.
That might explain Lance's problem but not Tena's, since his (hers?)
are idle in transaction, which means the connection at least did a
begin; after connecting.
Also possible for Lance's is an application that isn't properly
closing its connections.
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2007-11-10 00:38 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-09 21:58 idle in transaction...unexpected EOF on client connection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:11 ` Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 22:36 ` Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:41 ` Scott Marlowe <scott.marlowe@gmail.com>
2007-11-09 23:03 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-11-09 23:38 ` Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-10 00:29 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-11-10 00:38 ` Re: idle in transaction...unexpected EOF on clientconnection Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-09 22:26 ` Campbell, Lance <lance@uiuc.edu>
2007-11-09 22:29 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-11-09 22:33 ` Scott Marlowe <scott.marlowe@gmail.com>
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