Re: [ADMIN] ' in transaction' problem in mod_perl/DBI/DBD-Pg environment.

2004-10-25 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1

Re: [ADMIN] ' in transaction' problem in mod_perl/DBI/DBD-Pg

2004-10-25 Thread Tsirkin Evgeny
probably you had a deadlock and the postgresql solved it by itself if that is true - you will have another one soon. On Mon, 25 Oct 2004, Rajesh Kumar Mallah wrote: > Hi, > > > Somehow those pids automatically got terminated > and my problem was solved. I did not issue any kill as i > do not h

Re: [ADMIN] ' in transaction' problem in mod_perl/DBI/DBD-Pg

2004-10-25 Thread Rajesh Kumar Mallah
Hi, Somehow those pids automatically got terminated and my problem was solved. I did not issue any kill as i do not have access to the server. curious how it happened any idea?? Regds mallah. Tsirkin Evgeny wrote: On Mon, 25 Oct 2004, Rajesh Kumar Mallah wrote: Hi, We run our webserver using m

Re: [ADMIN] ' in transaction' problem in mod_perl/DBI/DBD-Pg

2004-10-25 Thread Tsirkin Evgeny
On Mon, 25 Oct 2004, Rajesh Kumar Mallah wrote: > > Hi, > > We run our webserver using mod_perl and perl/DBI/DBD-Pg . > I have observed that most of the pg backends that block other queries > are in ' in transaction' state. Usually sending a -INT or -TERM > to such blocking backends solve the p

[ADMIN] ' in transaction' problem in mod_perl/DBI/DBD-Pg environment.

2004-10-24 Thread Rajesh Kumar Mallah
Hi, We run our webserver using mod_perl and perl/DBI/DBD-Pg . I have observed that most of the pg backends that block other queries are in ' in transaction' state. Usually sending a -INT or -TERM to such blocking backends solve the problem. My question is 1. Are there some precuation to be taken i