Обсуждение: [ADMIN] Lock Error

Hi all;


Anyone know what the cause of this error might be?


ERROR:  lock main [some number] is not held

for example:

ERROR:  lock main 74764 is not held


Thanks in advance...

ProPAAS DBA <dba@propaas.com> writes:
> Anyone know what the cause of this error might be?
> ERROR:  lock main [some number] is not held

That would be a bug.  If you can reproduce it, we'd like to see how.

            regards, tom lane

I'll check with the client and see if we can re-create it, they claim
this error is happening daily.  Would a log file help to start with?



On 01/10/2017 07:26 PM, Tom Lane wrote:
> ProPAAS DBA <dba@propaas.com> writes:
>> Anyone know what the cause of this error might be?
>> ERROR:  lock main [some number] is not held
> That would be a bug.  If you can reproduce it, we'd like to see how.
>
>             regards, tom lane

It would also be great to know the version of PG, since it could have been a long fixed bug.

Thanks.

I'll check with the client and see if we can re-create it, they claim this error is happening daily.  Would a log file help to start with?



On 01/10/2017 07:26 PM, Tom Lane wrote:

ProPAAS DBA <dba@propaas.com> writes:

Anyone know what the cause of this error might be?
ERROR:  lock main [some number] is not held

That would be a bug.  If you can reproduce it, we'd like to see how.

            regards, tom lane