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

statement stuck when the connection grew up to 45 or more

From: kah_hang_ang(at)toray(dot)com(dot)my
To: pgsql-bugs(at)postgresql(dot)org
Subject: statement stuck when the connection grew up to 45 or more
Date: 2006-05-30 02:41:47
Message-ID: OFD5C84655.E4EC8280-ON4825717E.000D636C@pengroup.com.my (view raw or flat)
Thread:
Lists: pgsql-bugs



Hi,

I'm using Postgresql 8.1.3.

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.

Could anyone give me some idea how could this be?
Is it a bug of PostgreSQL?

This is the statement which having problem:
      select count(distinct empno) as counter1 from pay_master_history
            where empno in (select empno from pay_batch_basic_history where
organizationid like '015003%')
      and processyear = '2006'
      and processmonth = '05'
      and processbatch = '1'

Thanks!


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-05-30 03:01:13
Subject: Re: pg_restore problem
Previous:From: Michael AndreasenDate: 2006-05-29 22:29:33
Subject: pg_restore problem

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