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/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq