spoonbill - rare buildfarm failures in test_shm_mq_pipelined()

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: PostgreSQL mailing lists <pgsql-hackers(at)postgreSQL(dot)org>
Subject: spoonbill - rare buildfarm failures in test_shm_mq_pipelined()
Date: 2016-10-25 17:15:45
Message-ID: fc8ee078-9592-01f8-5245-84bc2e61c8e5@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-10-25 17:18:47 Re: Proposal: scan key push down to heap [WIP]
Previous Message Robert Haas 2016-10-25 17:14:47 Re: [BUG] pg_basebackup from disconnected standby fails