Re: PG 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held - Mailing list pgsql-bugs

From Tom Lane
Subject Re: PG 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held
Date
Msg-id 15941.1220045413@sss.pgh.pa.us
Whole thread Raw
In response to Re: PG 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held  (Michael Milligan <milli@acmeps.com>)
Responses Re: PG 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held
List pgsql-bugs
Michael Milligan <milli@acmeps.com> writes:
> Tom Lane wrote:
>> Huh, that shouldn't happen.  What object is that?  The 16385 should be
>> a database OID, and the 16467 is most likely a table's OID within that
>> database.

Please answer the above question.

> And a correction, the transaction that caused this error was inserting
> 13.5 million rows and failed near the end.

Once you've determined which table the error message is talking about,
please show us what the transaction does with that table.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Michael Milligan
Date:
Subject: Re: PG 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held
Next
From: Michael Milligan
Date:
Subject: Re: PG 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held