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

AccessShareLock on pg_authid

From: Granthana Biswas <granthana(dot)biswas(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: AccessShareLock on pg_authid
Date: 2013-08-19 16:58:09
Message-ID: CAAPsc-R03dsNU9U=VcQUaQ6vK9q3Swf+z3EJ4+JFpnJAb3W_ig@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi,

Processes are failing due to the following error on Postgresql 8.3.5:

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

1260 oid belongs to pg_authid. This error is not coming for every
transaction.

I have found these two links related to the above error but not quite
helpful:

http://web.archiveorange.com/archive/v/alpsnhads7a0RcdRyB5t

http://www.postgresql.org/message-id/7386.1315434323@sss.pgh.pa.us

Has anyone come across this issue and debugged it successfully?

Thanks & Regards,
GB

pgsql-general by date

Next:From: Jeff JanesDate: 2013-08-19 17:03:20
Subject: Re: Select performance variation based on the different combinations of using where lower(), order by, and limit
Previous:From: Robert SosinskiDate: 2013-08-19 15:59:38
Subject: Re: Memory Issue with array_agg?

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