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

The following bug has been logged online:

Bug reference:      6218
Logged by:          YAMAMOTO Takashi
Email address:      yamt@mwd.biglobe.ne.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)