Re: BUG #1512: Assertion failure (lock.c:1537) with SELECT FOR UPDATE and savepoints - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: BUG #1512: Assertion failure (lock.c:1537) with SELECT FOR UPDATE and savepoints
Date
Msg-id 20050301030052.GA81150@winnie.fuhr.org
Whole thread Raw
In response to BUG #1512: Assertion failure (lock.c:1537) with SELECT FOR UPDATE and savepoints  ("Stephen Clouse" <stephenc@theiqgroup.com>)
List pgsql-bugs
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/

pgsql-bugs by date:

Previous
From: "Stephen Clouse"
Date:
Subject: BUG #1512: Assertion failure (lock.c:1537) with SELECT FOR UPDATE and savepoints
Next
From: Tom Lane
Date:
Subject: Re: BUG #1512: Assertion failure (lock.c:1537) with SELECT FOR UPDATE and savepoints