[ADMIN] idle in transaction...unexpected EOF on client connection

2007-11-09 Thread Tena Sakai
Hi Everybody, I see in serverlog many entries that read: LOG: unexpected EOF on client connection LOG: unexpected EOF on client connection LOG: unexpected EOF on client connection LOG: unexpected EOF on client connection This occurs regularly and frequently and I am wondering if it is

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

2007-11-09 Thread Scott Marlowe
On Nov 9, 2007 3:58 PM, Tena Sakai <[EMAIL PROTECTED]> wrote: > > Hi Everybody, > > I see in serverlog many entries that read: > LOG: unexpected EOF on > client connection > LOG: unexpected EOF on > client connection > LOG: unexpected EOF on > client connection > LOG: unexpected EOF on

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

2007-11-09 Thread Campbell, Lance
PROTECTED] [mailto:[EMAIL PROTECTED] 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: LOG: unexpected EOF on client

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

2007-11-09 Thread Alvaro Herrera
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

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

2007-11-09 Thread Scott Marlowe
On Nov 9, 2007 4:29 PM, Alvaro Herrera <[EMAIL PROTECTED]> 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 co

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

2007-11-09 Thread Tena Sakai
ct: Re: [ADMIN] idle in transaction...unexpected EOF on client connection On Nov 9, 2007 3:58 PM, Tena Sakai <[EMAIL PROTECTED]> wrote: > > Hi Everybody, > > I see in serverlog many entries that read: > LOG: unexpected EOF on > client connection > LOG: unexpected E

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

2007-11-09 Thread Tom Lane
"Scott Marlowe" <[EMAIL PROTECTED]> 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 "t

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

2007-11-09 Thread Scott Marlowe
On Nov 9, 2007 4:36 PM, Tena Sakai <[EMAIL PROTECTED]> 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

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

2007-11-09 Thread Tena Sakai
transaction...unexpected EOF on client connection "Scott Marlowe" <[EMAIL PROTECTED]> 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

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

2007-11-09 Thread Alvaro Herrera
Tena Sakai escribió: > Aside from that, can this be caused by many deleted > rows from tables (and having neglected to vacuum)? No. -- Alvaro Herrerahttp://www.advogato.org/person/alvherre Major Fambrough: You wish to see the frontier? John Dunbar: Yes sir, before it's g