Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M247464=pgsql-hackers-arkari@postgresql.org>)
 id 1WUcLe-0004CK-5D
 for pgsql-hackers@arkaria.postgresql.org; Mon, 31 Mar 2014 13:33:58 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M247464=pgsql-hackers-arkari@postgresql.org>)
 id 1WUcLd-0005e1-KU
 for pgsql-hackers@arkaria.postgresql.org; Mon, 31 Mar 2014 13:33:57 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <sfrost@tamriel.snowman.net>) id 1WUcLb-0005ba-94
 for pgsql-hackers@postgresql.org; Mon, 31 Mar 2014 13:33:55 +0000
Received: from tamriel.snowman.net ([2001:4830:167b::11])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <sfrost@tamriel.snowman.net>) id 1WUcLU-0008Fr-7g
 for pgsql-hackers@postgresql.org; Mon, 31 Mar 2014 13:33:54 +0000
Received: by tamriel.snowman.net (Postfix, from userid 1000)
 id 64DF55F7B4; Mon, 31 Mar 2014 09:36:03 -0400 (EDT)
Date: Mon, 31 Mar 2014 09:36:03 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Andres Freund <andres@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: MultiXactId error after upgrade to 9.3.4
Message-ID: <20140331133603.GP4582@tamriel.snowman.net>
References: <20140330040029.GY4582@tamriel.snowman.net>
 <20140331093841.GC13135@alap3.anarazel.de>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature"; boundary="9qlt36SziopUxSkf"
Content-Disposition: inline
In-Reply-To: <20140331093841.GC13135@alap3.anarazel.de>
X-Editor: Vim http://www.vim.org/
X-Info: http://www.snowman.net
X-Operating-System: Linux/3.8.0-35-generic (x86_64)
X-Uptime: 09:17:51 up 60 days, 15:16,  5 users,  load average: 0.12, 0.07,
 0.06
User-Agent: Mutt/1.5.21 (2010-09-15)
X-Pg-Spam-Score: -2.5 (--)
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org


--9qlt36SziopUxSkf
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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=<optimized out>, 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

--9qlt36SziopUxSkf
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)

iQIcBAEBAgAGBQJTOW9DAAoJEO1sijiDR2RVFEcP/inzDQZVb6QdI2Pjdi88mw4a
Z1XW9zp2thpl28GslDO+Fp72MPTAfItT6hrWuB2rVcI2DmBzkhZuRKpVqTrjkNaz
Gb1h/zR+jSDmCK5W3dQ28/DZvuFbwCdK8Qjk5JlBMhAlYY85UkJp3dfsLfFLlgaH
XGW8C3Ayxla4H8p9LgTs51+LwoWop9pFe6ntbNpa/Q1phSXO3roPgk4PxL5kIrTr
HRWMlD9eY8wNxNDmQ943Q4RA7G1Hx19XiXsBBsAJrjiegnEUBSn2ieC5w6t5FYZ0
qjDavAZpB9vMTVJNMAnXR+p9ZAw1ZdxpDWFprRmg2kyRzsUDzyfSCFlEqauaOfRb
pW9HfeeYZzWrHMdm6VV/xdfWt1ra7aoRbXG05CpgyVq0fY/z5WJvXMQKZtQX622m
Vreax8z/v5dH7DyZwDygUmvr4B21MbuNZAKdUXxu6aNQ7YYUMx6NnXkzBUm+IeDQ
JPXyQUrLqvcAcJTub8XGL2xNzvc4Ql6bOYsfhyg+CbvhX2eXoVvitRKoKtRohNw6
rwZ34IYTJbVC6yXbOxZv+VHAnGrulEd2jvwLxFU1SvOQ/Uog5tOMY1FF9ITtjRlK
/0t8y7o72cHx46vP2KjncqEjz29cDjwuMEKa3AhmGuOKRkCQUIE6ZxmdJ8/G9mbH
MfVYR0jv0P51bI8V9ElW
=VegF
-----END PGP SIGNATURE-----

--9qlt36SziopUxSkf--