Re: MultiXactId error after upgrade to 9.3.4 - Mailing list pgsql-hackers
From | Stephen Frost |
---|---|
Subject | Re: MultiXactId error after upgrade to 9.3.4 |
Date | |
Msg-id | 20140331133603.GP4582@tamriel.snowman.net Whole thread Raw |
In response to | Re: MultiXactId error after upgrade to 9.3.4 (Andres Freund <andres@2ndquadrant.com>) |
Responses |
Re: MultiXactId error after upgrade to 9.3.4
|
List | pgsql-hackers |
Andres, * Andres Freund (andres@2ndquadrant.com) wrote: > Without having looked at the code, IIRC this looks like some place > misses passing allow_old=true where it's actually required. Any chance > you can get a backtrace for the error message? I know you said somewhere > below that you'd worked around the problem, but maybe you have a copy of > the database somewhere? #0 GetMultiXactIdMembers (allow_old=<optimized out>, members=0x7fff78200ca0, multi=6849409) at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/access/transam/multixact.c:1130 #1 GetMultiXactIdMembers (multi=6849409, members=0x7fff78200ca0, allow_old=<optimized out>) at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/access/transam/multixact.c:1056 #2 0x00007f46e9e707f8 in FreezeMultiXactId (flags=<synthetic pointer>, cutoff_multi=<optimized out>, cutoff_xid=4285178915,t_infomask=<optimized out>, multi=6849409) at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/access/heap/heapam.c:5355 #3 heap_prepare_freeze_tuple (tuple=0x7f46e2d9a328, cutoff_xid=4285178915, cutoff_multi=<optimized out>, frz=0x7f46ec4d31b0)at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/access/heap/heapam.c:5593 #4 0x00007f46e9f72aca in lazy_scan_heap (scan_all=0 '\000', nindexes=2, Irel=<optimized out>, vacrelstats=<optimized out>,onerel=0x7f46e9d65ca0) at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/commands/vacuumlazy.c:899 #5 lazy_vacuum_rel (onerel=0x7f46e9d65ca0, vacstmt=<optimized out>, bstrategy=<optimized out>) at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/commands/vacuumlazy.c:236 #6 0x00007f46e9f70755 in vacuum_rel (relid=288284, vacstmt=0x7f46ec59f780, do_toast=1 '\001', for_wraparound=0 '\000') at/tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/commands/vacuum.c:1205 #7 0x00007f46e9f71445 in vacuum (vacstmt=0x7f46ec59f780, relid=<optimized out>, do_toast=1 '\001', bstrategy=<optimizedout>, for_wraparound=0 '\000', isTopLevel=<optimized out>) at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/commands/vacuum.c:234 #8 0x00007f46ea05e773 in standard_ProcessUtility (parsetree=0x7f46ec59f780, queryString=0x7f46ec59ec90 "vacuum common.wave_supplemental;",context=<optimized out>, params=0x0, dest=<optimized out>, completionTag=0x7fff782016e0 "") at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/tcop/utility.c:639 #9 0x00007f46ea05b5a3 in PortalRunUtility (portal=0x7f46ec4f82e0, utilityStmt=0x7f46ec59f780, isTopLevel=1 '\001', dest=0x7f46ec59fae0,completionTag=0x7fff782016e0 "") at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/tcop/pquery.c:1187 #10 0x00007f46ea05c1d6 in PortalRunMulti (portal=0x7f46ec4f82e0, isTopLevel=1 '\001', dest=0x7f46ec59fae0, altdest=0x7f46ec59fae0,completionTag=0x7fff782016e0 "") at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/tcop/pquery.c:1318 #11 0x00007f46ea05ce6d in PortalRun (portal=0x7f46ec4f82e0, count=9223372036854775807, isTopLevel=1 '\001', dest=0x7f46ec59fae0,altdest=0x7f46ec59fae0, completionTag=0x7fff782016e0 "") at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/tcop/pquery.c:816 #12 0x00007f46ea05908c in exec_simple_query (query_string=0x7f46ec59ec90 "vacuum common.wave_supplemental;") at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/tcop/postgres.c:1048 #13 PostgresMain (argc=<optimized out>, argv=<optimized out>, dbname=0x7f46ec4b9010 "mine", username=<optimized out>) at/tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/tcop/postgres.c:3997 #14 0x00007f46ea01487d in BackendRun (port=0x7f46ec4fc2c0) at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/postmaster/postmaster.c:3996 #15 BackendStartup (port=0x7f46ec4fc2c0) at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/postmaster/postmaster.c:3685 #16 ServerLoop () at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/postmaster/postmaster.c:1586 #17 PostmasterMain (argc=<optimized out>, argv=<optimized out>) at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/postmaster/postmaster.c:1253 #18 0x00007f46e9e4950c in main (argc=5, argv=0x7f46ec4b81f0) at /tmp/buildd/postgresql-9.3-9.3.4/build/../src/backend/main/main.c:206 Looks like your idea that is has to do w/ freezeing is accurate... Thanks, Stephen
pgsql-hackers by date: