AccessShareLock on pg_authid

Started by Granthana Biswasover 12 years ago1 messagesgeneral
Jump to latest
#1Granthana Biswas
granthana.biswas@gmail.com

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

/messages/by-id/7386.1315434323@sss.pgh.pa.us

Has anyone come across this issue and debugged it successfully?

Thanks & Regards,
GB