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:11:46 -0600
Message-ID: <dcc563d10711091411l5f401a91v7e742334f02bdd5b@mail.gmail.com> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C03062D82@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C03062D82@egcrc-ex01.egcrc.org>
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.
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: <dcc563d10711091411l5f401a91v7e742334f02bdd5b@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