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