Skip site navigation (1) Skip section navigation (2)

lock AccessShareLock on object 0/1260/0 is already held

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: lock AccessShareLock on object 0/1260/0 is already held
Date: 2013-01-04 09:48:03
Message-ID: CAFj8pRAHVzUPfBx+8EY-XHfwBo8bxVu_YNMBAPSDj8W-ARatLA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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


Responses

pgsql-hackers by date

Next:From: Samuel VogelDate: 2013-01-04 12:00:21
Subject: Re: Print b-tree tuples
Previous:From: Alexander KorotkovDate: 2013-01-04 08:42:13
Subject: Re: Statistics and selectivity estimation for ranges

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group