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

Re: "Hanging Connection" blocks access to table (JBossMQ)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Goldner <mgoldner(at)agmednet(dot)com>
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, Michael Goldner <mike(dot)goldner(at)comcast(dot)net>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)
Date: 2006-10-11 18:57:07
Message-ID: 12649.1160593027@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
Michael Goldner <mgoldner(at)agmednet(dot)com> writes:
> I shut down postgresql manually (pg_ctl restart -m immediiate) after I had
> first stopped Jboss and waited about 30 seconds to see that the two blocking
> connections were not closing.

Really?  "-m immediate" should boot backends off lock waits in any case
... and does according to my tests.  Whether Jboss notices the
connections dropping right away might be another story.  What are you
observing as a "not closed" connection?

I wouldn't personally use "-m immediate" for this purpose mind you.
"-m fast" is safer and should have the same result.

			regards, tom lane

In response to

Responses

pgsql-jdbc by date

Next:From: Michael GoldnerDate: 2006-10-11 19:09:16
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)
Previous:From: Michael GoldnerDate: 2006-10-11 18:21:26
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)

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