From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | dpage(at)pgadmin(dot)org |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | What in the world is happening with castoroides and protosciurus? |
Date: | 2014-08-26 00:46:42 |
Message-ID: | 25275.1409014002@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
For the last month or so, these two buildfarm animals (which I believe are
the same physical machine) have been erratically failing with errors that
reflect low-order differences in floating-point calculations.
A recent example is at
http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=protosciurus&dt=2014-08-25%2010%3A39%3A52
where the only regression diff is
*** /export/home/dpage/pgbuildfarm/protosciurus/HEAD/pgsql.22860/src/test/regress/expected/hash_index.out Mon Aug 25 11:41:00 2014
--- /export/home/dpage/pgbuildfarm/protosciurus/HEAD/pgsql.22860/src/test/regress/results/hash_index.out Mon Aug 25 11:57:26 2014
***************
*** 171,179 ****
SELECT h.seqno AS i8096, h.random AS f1234_1234
FROM hash_f8_heap h
WHERE h.random = '-1234.1234'::float8;
! i8096 | f1234_1234
! -------+------------
! 8906 | -1234.1234
(1 row)
UPDATE hash_f8_heap
--- 171,179 ----
SELECT h.seqno AS i8096, h.random AS f1234_1234
FROM hash_f8_heap h
WHERE h.random = '-1234.1234'::float8;
! i8096 | f1234_1234
! -------+-------------------
! 8906 | -1234.12356777216
(1 row)
UPDATE hash_f8_heap
... a result that certainly makes no sense. The results are not
repeatable, failing in equally odd ways in different tests on different
runs. This is happening in all the back branches too, not just HEAD.
Has there been a system software update on this machine a month or so ago?
If not, it's hard to think anything except that the floating point
hardware on this box has developed problems.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2014-08-26 00:57:19 | Re: Add .NOTPARALLEL to contrib/Makefile |
Previous Message | Andrew Gierth | 2014-08-26 00:45:40 | Re: Final Patch for GROUPING SETS |