-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
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
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
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
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