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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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