From: Scott Marlowe <scott.marlowe@gmail.com>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: idle in transaction...unexpected EOF on client connection
Date: Fri, 9 Nov 2007 16:41:34 -0600
Message-ID: <dcc563d10711091441v24fba20fq275ac75f22f5636e@mail.gmail.com> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C03062D83@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C03062D82@egcrc-ex01.egcrc.org>
<dcc563d10711091411l5f401a91v7e742334f02bdd5b@mail.gmail.com>
<FE44E0D7EAD2ED4BB2165071DB8E328C03062D83@egcrc-ex01.egcrc.org>
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.
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-admin@postgresql.org
Cc: scott.marlowe@gmail.com, tsakai@gallo.ucsf.edu
Subject: Re: idle in transaction...unexpected EOF on client connection
In-Reply-To: <dcc563d10711091441v24fba20fq275ac75f22f5636e@mail.gmail.com>
* 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