Обсуждение: [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.
On 11/01/2017 05:50, ProPAAS DBA wrote:
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?That would be a bug. If you can reproduce it, we'd like to see how.
ERROR: lock main [some number] is not held
regards, tom lane