[GENERAL] Postgres 8.3.1 RowExclusiveLock With JDBC XA

2008-09-12 Thread Urciolo, Kevin
I am having a problem where row exclusive locks are causing applications and vacuums to hang. I shutdown all applications, but the locks remain. I stop and start postgres, but the locks are still there. A pid is not listed. This problem started showing up after switching to the XA datasource wit

Re: [GENERAL] Postgres 8.3.1 RowExclusiveLock With JDBC XA

2008-09-08 Thread Tom Lane
"Urciolo, Kevin" <[EMAIL PROTECTED]> writes: > I am having a problem where row exclusive locks are causing applications > and vacuums to hang. I shutdown all applications, but the locks remain. > I stop and start postgres, but the locks are still there. A pid is not > listed. This problem starte

[GENERAL] Postgres 8.3.1 RowExclusiveLock With JDBC XA

2008-09-08 Thread Urciolo, Kevin
I am having a problem where row exclusive locks are causing applications and vacuums to hang. I shutdown all applications, but the locks remain. I stop and start postgres, but the locks are still there. A pid is not listed. This problem started showing up after switching to the XA datasource wit