Re: Upgrade 10.5->10.6 : db crash BUS ERROR (sig 10), reproducible

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Palle Girgensohn <girgen(at)FreeBSD(dot)org>
Cc: Peter <pmc(at)citylink(dot)dinoex(dot)sub(dot)org>, pgsql-admin(at)postgresql(dot)org, "pgsql\(at)freebsd(dot)org" <pgsql(at)FreeBSD(dot)org>
Subject: Re: Upgrade 10.5->10.6 : db crash BUS ERROR (sig 10), reproducible
Date: 2019-03-07 23:30:19
Message-ID: 87tvgeb796.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>>>>> "Palle" == Palle Girgensohn <girgen(at)FreeBSD(dot)org> writes:

>> Clang's __builtin_isinf(x) function, which is supposed to test if x is
>> infinite, does not work reliably on i386 when the x87 registers are used
>> for floating point. It does work if the SSE2 registers are used instead,
>> which clang will do if the -msse2 option is used. The downside of course
>> is that the code will no longer run on CPUs that are old enough to vote.

Palle> For this reason, we build i386 with gcc starting with version
Palle> 10.6. the CFLAGS+=--msse2 was not realiable for all CPU:s since
Palle> not all i386 CPU:s support SSE2.

Palle> We had one report of a user who had SSE2 flag still on (int
Palle> /etc/make.conf) when building, and got the same problem.
Palle> [https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=236025
Palle> <https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=236025>]

The user in that bug report was using a Pentium 4, which supports SSE2,
so it's not the lack of SSE2 that caused the problem.

Furthermore, the crash was in XLogReadRecord, which does not use floats.

So I'm going to guess that your bug 236025 is actually an alignment
problem, with the compiler making some assumption about alignment that
we're violating. I'll investigate and see what I can find.

--
Andrew.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2019-03-08 00:02:55 Re: Upgrade 10.5->10.6 : db crash BUS ERROR (sig 10), reproducible
Previous Message Tom Lane 2019-03-07 19:40:51 Re: Upgrade 10.5->10.6 : db crash BUS ERROR (sig 10), reproducible