| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2013-08-19 17:03:20 | Re: Select performance variation based on the different combinations of using where lower(), order by, and limit |
| Previous Message | Robert Sosinski | 2013-08-19 15:59:38 | Re: Memory Issue with array_agg? |