Skip site navigation (1) Skip section navigation (2)

Re: statement stuck when the connection grew up to 45 or more

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: statement stuck when the connection grew up to 45 or more
Date: 2006-06-02 06:11:35
Message-ID: e5okqn$jdc$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
<kah_hang_ang(at)toray(dot)com(dot)my> wrote
>
> Recently I facing one problem, when the connection for postgresql grow 
> up
> to 45 or more, when I trigger a statement from WebApp
> this statement will stuck forever.
> I try to kill this transaction and then trigger the same statement 
> again
> but it still the same.
> But this time I leave the transaction there and try to kill other
> connections that is not in use.
> It's weird that after I kill around 5-10 unused connections, the 
> statement
> start to run and finish.
>

I can hardly believe that's Postgres's problem. Are you sure the query 
was processing by the server? Try to do:

    ps -auxw|grep postgres

to see if you can see the query was stuck there.

Regards,
Qingqing 



In response to

Responses

pgsql-bugs by date

Next:From: Stefan van AalstDate: 2006-06-02 06:29:00
Subject: Infinite increment of postgre.exe in taskmanager
Previous:From: StephenDate: 2006-06-02 05:08:14
Subject: BUG #2462: pg_dump ftell mismatch error (cont'd)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group