Hello What is state of this issue? http://archives.postgresql.org/pgsql-hackers/2011-09/msg00423.php
We detect this issue in our servers - we use 9.1.6 on Linux locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted ----------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-------+-----------------+--------- relation | 5630403 | 1259 | | | | | | | | 20/0 | 14960 | AccessShareLock | t Interesting of this issue - it is blocks DBI login Exception thrown: DBI connect('database=xxx;host=yyy;port=5432','username',...) failed: FATAL: lock AccessShareLock on object 5630403/1259/0 is already held#012 but I am able to login to this database from command line without problems There is unfriendly error message - I cannot get information about statement that exactly raise this fatal state. The most old message that I found is Dec 10 15:01:51 cl-pdwh-d01 postgres[32548]: [6-1] (2012-12-10 15:01:51 CET db_hw7ny3roi257xe886fvc5krqgosp6g23) Dec 10 15:01:51 cl-pdwh-d01 postgres[32548]: [6-2] ERROR: canceling statement due to user request Dec 10 15:01:51 cl-pdwh-d01 postgres[32738]: [6-1] (2012-12-10 15:01:51 CET db_hw7ny3roi257xe886fvc5krqgosp6g23) Dec 10 15:01:51 cl-pdwh-d01 postgres[32738]: [6-2] FATAL: lock AccessShareLock on object 5630403/1259/0 is already held Dec 10 15:01:51 cl-pdwh-d01 postgres[32739]: [6-1] (2012-12-10 15:01:51 CET db_hw7ny3roi257xe886fvc5krqgosp6g23) Dec 10 15:01:51 cl-pdwh-d01 postgres[32739]: [6-2] FATAL: lock AccessShareLock on object 5630403/1259/0 is already held Dec 10 15:02:29 cl-pdwh-d01 postgres[957]: [6-1] (2012-12-10 15:02:29 CET db_hw7ny3roi257xe886fvc5krqgosp6g23) Dec 10 15:02:29 cl-pdwh-d01 postgres[957]: [6-2] FATAL: lock AccessShareLock on object 5630403/1259/0 is already held Regards Pavel Stehule -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers