Re: [HACKERS] lock AccessShareLock on object 0/1260/0 is already held

2013-03-15 Thread Pavel Stehule
Hello 2013/1/4 Pavel Stehule pavel.steh...@gmail.com: 2013/1/4 Tom Lane t...@sss.pgh.pa.us: Pavel Stehule pavel.steh...@gmail.com writes: What is state of this issue? http://archives.postgresql.org/pgsql-hackers/2011-09/msg00423.php AFAICS we never identified the cause. It was pretty clear

[HACKERS] lock AccessShareLock on object 0/1260/0 is already held

2013-01-04 Thread Pavel Stehule
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 |

Re: [HACKERS] lock AccessShareLock on object 0/1260/0 is already held

2013-01-04 Thread Tom Lane
Pavel Stehule pavel.steh...@gmail.com writes: What is state of this issue? http://archives.postgresql.org/pgsql-hackers/2011-09/msg00423.php AFAICS we never identified the cause. It was pretty clear that something was failing to clean up shared-memory lock data structures, but not what that

Re: [HACKERS] lock AccessShareLock on object 0/1260/0 is already held

2013-01-04 Thread Pavel Stehule
2013/1/4 Tom Lane t...@sss.pgh.pa.us: Pavel Stehule pavel.steh...@gmail.com writes: What is state of this issue? http://archives.postgresql.org/pgsql-hackers/2011-09/msg00423.php AFAICS we never identified the cause. It was pretty clear that something was failing to clean up shared-memory