Re: [GENERAL] db sever seems to be dropping connections

2006-03-22 Thread Tom Lane
"Rushabh Doshi" <[EMAIL PROTECTED]> writes: > DBI handle: DBI::db=HASH(0x9480bdc) # this is the stale handle > DBD::Pg::db disconnect failed: rollback failed at *** line 241. > result of disconnect: > disconnect failed for DBI::db=HASH(0x9480bdc): DBD::Pg::db disconnect > failed: rollback failed

Re: [GENERAL] db sever seems to be dropping connections

2006-03-22 Thread Vivek Khera
On Mar 21, 2006, at 4:39 PM, Rushabh Doshi wrote: This is my problem. I have a connection to the database using DB- >connect. Apparently, this connection sits idle for around an hour or so because of my application, and after that it has to do something. So I check that if the handle is st

Re: [GENERAL] db sever seems to be dropping connections

2006-03-22 Thread Rushabh Doshi
[GENERAL] db sever seems to be dropping connections Chris <[EMAIL PROTECTED]> writes: > Rushabh Doshi wrote: >> I'm facing an issue with PostgreSQL .. The server seems to drop the >> connection to my script after a couple of hours (sometimes, not always). > Sounds mor

Re: [GENERAL] db sever seems to be dropping connections

2006-03-20 Thread Tom Lane
Chris <[EMAIL PROTECTED]> writes: > Rushabh Doshi wrote: >> I'm facing an issue with PostgreSQL .. The server seems to drop the >> connection to my script after a couple of hours (sometimes, not always). > Sounds more like a network issue. Yeah --- in particular, it sounds like a connection timeo

Re: [GENERAL] db sever seems to be dropping connections

2006-03-20 Thread Rushabh Doshi
Rushabh Doshi wrote: > I'm facing an issue with PostgreSQL .. The server seems to drop the > connection to my script after a couple of hours (sometimes, not always). > > DBD::Pg::db selectrow_array failed: could not receive data from server: > > > :server closed the connection unexpected

Re: [GENERAL] db sever seems to be dropping connections

2006-03-19 Thread Chris
Rushabh Doshi wrote: I'm facing an issue with PostgreSQL .. The server seems to drop the connection to my script after a couple of hours (sometimes, not always). DBD::Pg::db selectrow_array failed: could not receive data from server: :server closed the connection unexpectedly. Do y

[GENERAL] db sever seems to be dropping connections

2006-03-18 Thread Rushabh Doshi
I'm facing an issue with PostgreSQL .. The server seems to drop the connection to my script after a couple of hours (sometimes, not always). DBD::Pg::db selectrow_array failed: could not receive data from server: :server closed the connection unexpectedly. And in another scenario it f