Re: 9.3.9 and pg_multixact corruption

From: Christoph Berg <christoph(dot)berg(at)credativ(dot)de>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Bernd Helmle <bernd(at)oopsware(dot)de>, Andreas Seltenreich <andreas(dot)seltenreich(at)credativ(dot)de>
Subject: Re: 9.3.9 and pg_multixact corruption
Date: 2015-09-20 14:23:05
Message-ID: 20150920142305.GC31429@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Re: Andreas Seltenreich 2015-09-13 <87si6i1875(dot)fsf(at)credativ(dot)de>
> I managed disassemble RecordNewMultiXact from the core dump using a
> cross-binutils, and it reveals that the compiler[1] appears to have
> indeed generated a signed division here. I'm attaching a piece of C
> code that does the same computation as the assembly (I think), as well
> as the disassembly itself.
>
> Footnotes:
> [1] Sun C 5.12 SunOS_sparc Patch 148917-07 2013/10/18, 64-bit

Hi,

a short update here: the customer updated the compiler to a newer
version, is now compiling using -O2 instead of -O3, and the code
generated now looks sane, so this turned out to be a compiler issue.
(Though it's unclear if the upgrade fixed it, or the different -O
level.)

Thanks to all who provided feedback, it was very valuable in actually
tracking down the root of the issue.

Christoph

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Petr Jelinek 2015-09-20 14:24:43 Re: WIP: Rework access method interface
Previous Message Tom Lane 2015-09-20 14:18:32 Re: WIP: Rework access method interface