BUG #6218: TRAP: FailedAssertion("!(owner->nsnapshots == 0)", File: "resowner.c", Line: 365)

The following bug has been logged online:

Bug reference: 6218
Logged by: YAMAMOTO Takashi
Email address: yamt(at)mwd(dot)biglobe(dot)ne(dot)jp
PostgreSQL version: 9.2
Operating system: NetBSD
Description: TRAP: FailedAssertion("!(owner->nsnapshots == 0)", File:
"resowner.c", Line: 365)
Details:

9.2devel (2562dcea811eb642e1c5442e1ede9fe268278157)

ERROR: could not serialize access due to concurrent update
STATEMENT: UPDATE file SET atime = current_timestamp WHERE fileid = $1
TRAP: FailedAssertion("!(owner->nsnapshots == 0)", File: "resowner.c", Line:
365)
LOG: server process (PID 16832) was terminated by signal 6: Abort trap
LOG: terminating any other active server processes

Core was generated by `postgres'.
Program terminated with signal 6, Aborted.
#0 0xbbb9c547 in _lwp_kill () from /usr/lib/libc.so.12
(gdb) bt
#0 0xbbb9c547 in _lwp_kill () from /usr/lib/libc.so.12
#1 0xbbb9c503 in raise (s=6) at /siro/nbsd/src/lib/libc/gen/raise.c:48
#2 0xbbb9bced in abort () at /siro/nbsd/src/lib/libc/stdlib/abort.c:74
#3 0x08400d8b in ExceptionalCondition (
conditionName=0x85a28f3 "!(owner->nsnapshots == 0)",
errorType=0x85a280b "FailedAssertion", fileName=0x85a2800 "resowner.c",
lineNumber=365) at assert.c:57
#4 0x084272a7 in ResourceOwnerDelete (owner=0x99be23f0) at resowner.c:365
#5 0x080d96f3 in CleanupTransaction () at xact.c:2374
#6 0x080d98d9 in CommitTransactionCommand () at xact.c:2538
#7 0x08318802 in finish_xact_command () at postgres.c:2378
#8 0x08317c19 in exec_execute_message (portal_name=0x99b2f01c "",
max_rows=2147483647) at postgres.c:1915
#9 0x0831a6cf in PostgresMain (argc=2, argv=0xbb9117b0,
username=0xbb911704 "takashi") at postgres.c:3909
#10 0x082c47b0 in BackendRun (port=0xbb93d0f0) at postmaster.c:3512
#11 0x082c3e12 in BackendStartup (port=0xbb93d0f0) at postmaster.c:3197
#12 0x082c0e94 in ServerLoop () at postmaster.c:1333
#13 0xbb93d0f0 in ?? ()
#14 0x085f8850 in UnBlockSig ()
#15 0x00000000 in ?? ()
(gdb) fr 4
#4 0x084272a7 in ResourceOwnerDelete (owner=0x99be23f0) at resowner.c:365
365 Assert(owner->nsnapshots == 0);
(gdb) p *owner
$1 = {parent = 0x0, firstchild = 0x99b2c174, nextchild = 0x0,
name = 0x844bfb2 "TopTransaction", nbuffers = 0, buffers = 0x0,
maxbuffers = 0, ncatrefs = 0, catrefs = 0x99b85f88, maxcatrefs = 16,
ncatlistrefs = 0, catlistrefs = 0x0, maxcatlistrefs = 0, nrelrefs = 0,
relrefs = 0x0, maxrelrefs = 0, nplanrefs = 0, planrefs = 0x0,
maxplanrefs = 0, ntupdescs = 0, tupdescs = 0x0, maxtupdescs = 0,
nsnapshots = 1, snapshots = 0xbb9f4fa4, maxsnapshots = 16, nfiles = 0,
files = 0x0, maxfiles = 0}
(gdb) p *owner->snapshots[0]
$7 = {satisfies = 0x8435138 <HeapTupleSatisfiesMVCC>, xmin = 991, xmax =
991,
xcnt = 0, xip = 0x0, subxcnt = 0, subxip = 0x0, suboverflowed = 0 '\0',
takenDuringRecovery = 0 '\0', curcid = 1, active_count = 0, regd_count =
1,
copied = 1 '\001'}
(gdb) p CurrentTransactionState
$8 = (TransactionState) 0x85bea00
(gdb) p *CurrentTransactionState
$9 = {transactionId = 990, subTransactionId = 1, name = 0x0,
savepointLevel = 0, state = TRANS_ABORT, blockState = TBLOCK_ABORT_END,
nestingLevel = 1, gucNestLevel = 1, curTransactionContext = 0xbb912a40,
curTransactionOwner = 0x99be23f0, childXids = 0x0, nChildXids = 0,
maxChildXids = 0, prevUser = 10, prevSecContext = 0,
prevXactReadOnly = 0 '\0', startedInRecovery = 0 '\0', parent = 0x0}
(gdb) p debug_query_string
$12 = 0x99b2f428 "ROLLBACK"
(gdb)