| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Goldner | 2006-10-11 19:09:16 | Re: "Hanging Connection" blocks access to table (JBossMQ) |
| Previous Message | Michael Goldner | 2006-10-11 18:21:26 | Re: "Hanging Connection" blocks access to table (JBossMQ) |