Postgres Pro
Downloads
Home   >   mailing lists

AccessShareLock on pg_authid - Mailing list pgsql-general

From Granthana Biswas
Subject AccessShareLock on pg_authid
Date
Msg-id CAAPsc-R03dsNU9U=VcQUaQ6vK9q3Swf+z3EJ4+JFpnJAb3W_ig@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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:

Previous
From: Paul Jungwirth
Date:
Subject: Create a deferrably-unique index
Next
From: Tom Lane
Date:
Subject: Re: Create a deferrably-unique index