| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS APPLICATIONS]" <m(dot)l(dot)wilson(at)nasa(dot)gov>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: postgres 8.2.9 can't drop database in single user mode |
| Date: | 2009-04-22 17:13:58 |
| Message-ID: | 1240420438.2119.73.camel@jd-laptop.pragmaticzealot.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 2009-04-22 at 13:10 -0400, Maria L. Wilson wrote:
> wow - I am finally back in business!!
> Question - is there any maintenance type item that we could to to check
> for uncommitted transactions on a regular basis - outside of the
> pg_prepared_xacts table?
> How about from a developers position - most of our code accessing
> the databases is jboss/java/jdbc. What could have happened from the
> code side that caused these uncommitted transactions?
The use of XA/two phase commit transactions that assume rollback on
disconnect.
Joshua D. Drake
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-04-22 17:31:00 | Re: postgres 8.2.9 can't drop database in single user mode |
| Previous Message | Maria L. Wilson | 2009-04-22 17:10:22 | Re: postgres 8.2.9 can't drop database in single user mode |