. Still this keeps
happening. I've tried using connect_cached but to no effect.
Thanks,
--Rushabh Doshi
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, March 20, 2006 2:16 PM
To: Chris
Cc: Rushabh Doshi; pgsql-general@postgresql.org
Subject: Re: [GENERAL] db sever
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
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 at ***
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.
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 timeout
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
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