Alex Shulgin <a...@commandprompt.com> writes: > > Figured it out with a pg_usleep in bootstrap.c anyway. Does this look sane? > > > DEBUG: inserting column 6 value "0" > DEBUG: inserted -> 0 > DEBUG: inserting column 7 value "varchar_transform" > TRAP: FailedAssertion("!(((xmax) >= ((TransactionId) 3)))", File: > "/home/ash/src/postgresql/src/backend/storage/ipc/procarray.c", Line: 1414)
I've tried to debug this and I feel really dumbfound... DEBUG: inserting column 7 value "varchar_transform" Breakpoint 1, GetSnapshotData (snapshot=0xdb2d60 <CatalogSnapshotData>) at /home/ash/src/postgresql/src/backend/storage/ipc/procarray.c:1413 1413 xmax = ShmemVariableCache->latestCompletedXid; (gdb) p ShmemVariableCache->latestCompletedXid $1 = 4294967295 (gdb) p *ShmemVariableCache $2 = {nextOid = 10000, oidCount = 0, nextXid = 3, oldestXid = 3, xidVacLimit = 200000003, xidWarnLimit = 2136483650, xidStopLimit = 2146483650, xidWrapLimit = 2147483650, oldestXidDB = 1, oldestCommitTs = 1, newestCommitTs = 0, latestCompletedXid = 4294967295} (gdb) p xmax $3 = 0 (gdb) n 1414 Assert(TransactionIdIsNormal(xmax)); (gdb) p xmax $4 = 1 (gdb) p *ShmemVariableCache $5 = {nextOid = 10000, oidCount = 0, nextXid = 3, oldestXid = 3, xidVacLimit = 200000003, xidWarnLimit = 2136483650, xidStopLimit = 2146483650, xidWrapLimit = 2147483650, oldestXidDB = 1, oldestCommitTs = 1, newestCommitTs = 0, latestCompletedXid = 4294967295} (gdb) p ShmemVariableCache->latestCompletedXid $6 = 4294967295 (gdb) How? Is there an another concurrent process with the old view of VariableCacheData struct where latestCompletedXid still points to oldestCommitTs? This only happens with the CommitTs commit in effect. -- Alex -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers