Re: BUG #1512: Assertion failure (lock.c:1537) with SELECT FOR UPDATE and savepoints

On Tue, Mar 01, 2005 at 02:04:30AM +0000, Stephen Clouse wrote:

> TRAP: FailedAssertion("!(SHMQueueEmpty(&(lock->procLocks)))", File:
> "lock.c", Line: 1537)

I can duplicate this on FreeBSD 4.11-STABLE with the latest code
from REL8_0_STABLE (--enable-cassert required during build). Here's
a stack trace:

#0 0x284997ac in kill () from /usr/lib/libc.so.4
#1 0x284db0a6 in abort () from /usr/lib/libc.so.4
#2 0x81ed93b in ExceptionalCondition () at assert.c:51
#3 0x8183191 in LockReleaseAll (lockmethodid=1, allxids=1 '\001') at lock.c:1537
#4 0x8183dbd in ProcReleaseLocks (isCommit=0) at proc.c:439
#5 0x81ffe69 in ResourceOwnerReleaseInternal (owner=0x82fefbc, phase=RESOURCE_RELEASE_LOCKS, isCommit=0 '\000', isTopLevel=1 '\001') at resowner.c:252
#6 0x81ffd12 in ResourceOwnerRelease (owner=0x82fefbc, phase=RESOURCE_RELEASE_LOCKS, isCommit=0 '\000', isTopLevel=1 '\001') at resowner.c:160
#7 0x809bedd in AbortTransaction () at xact.c:1694
#8 0x809c141 in CommitTransactionCommand () at xact.c:1906
#9 0x818ae7e in finish_xact_command () at postgres.c:1843
#10 0x8189da4 in exec_simple_query (query_string=0x836d01c "ROLLBACK;") at postgres.c:965
#11 0x818c2ab in PostgresMain (argc=4, argv=0x82fd274, username=0x82fd24c "mfuhr") at postgres.c:3007
#12 0x8163f41 in BackendRun (port=0x8313600) at postmaster.c:2816
#13 0x8163742 in BackendStartup (port=0x8313600) at postmaster.c:2452
#14 0x8161c9e in ServerLoop () at postmaster.c:1199
#15 0x81616a6 in PostmasterMain (argc=3, argv=0xbfbffc88) at postmaster.c:918
#16 0x8132b15 in main (argc=3, argv=0xbfbffc88) at main.c:268

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/