2008/3/14, Alvaro Herrera <alvherre@commandprompt.com>:
> Clodoaldo escribió:
>
>
> > Postgresql was restarted twice, but yes, it is as if the crash left
> > some kind of permanent lock somewhere.
>
>
> A prepared transaction perhaps? SELECT * FROM pg_prepared_xacts;
>
> A quick look into pg_locks should tell you if it's blocking.
pg_prepared_xacts is empty and pg_locks has 288 rows:
# select locktype, mode, count(*) as total
from pg_locks group by locktype, mode;
locktype | mode | total
---------------+------------------+-------
transactionid | ExclusiveLock | 30
relation | RowExclusiveLock | 2
relation | AccessShareLock | 256
(3 rows)
Regards, Clodoaldo Pinto Neto