Postgres Pro
Downloads
Home   >   mailing lists

Thread: spoonbill - rare buildfarm failures in test_shm_mq_pipelined()

spoonbill - rare buildfarm failures in test_shm_mq_pipelined()

From
Stefan Kaltenbrunner
Date:
Spoonbill is very rarely (ie once every few months) failing like this:

[2016-08-29 18:15:35.273 CEST:57c45f88.52d4:8] LOG:  statement: SELECT
test_shm_mq_pipelined(16384, (select
string_agg(chr(32+(random()*95)::int), '') from
generate_series(1,270000)), 200, 3);
[2016-08-29 18:15:35.282 CEST:57c45f88.52d4:9] ERROR:  floating-point
exception
[2016-08-29 18:15:35.282 CEST:57c45f88.52d4:10] DETAIL:  An invalid
floating-point operation was signaled. This probably means an
out-of-range result or an invalid operation, such as division by zero.
[2016-08-29 18:15:35.282 CEST:57c45f88.52d4:11] STATEMENT:  SELECT
test_shm_mq_pipelined(16384, (select
string_agg(chr(32+(random()*95)::int), '') from
generate_series(1,270000)), 200, 3);


Some examples:


http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=spoonbill&dt=2016-10-22%2023%3A00%3A06
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=spoonbill&dt=2016-08-29%2011%3A00%3A06
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=spoonbill&dt=2016-06-21%2023%3A00%3A06


Any ideas on what is causing this? IIrc we had issues with that specific
test on spoonbill (and other sparc based boxes) before so maybe we
failed to fix the issue completely...




Stefan

Re: spoonbill - rare buildfarm failures in test_shm_mq_pipelined()

From
Tom Lane
Date:
Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> Spoonbill is very rarely (ie once every few months) failing like this:

Yeah, I've been wondering about that ...

> Any ideas on what is causing this?

No, but it would sure be interesting to get a stack trace showing where
the SIGFPE is happening.

Could you change the ereport(ERROR) in FloatExceptionHandler to
ereport(PANIC) and run that single test over and over till you
get a panic?
        regards, tom lane