Postgres 7.4.1 "make check" failed "stats" test on Solaris 2.6 - Mailing list pgsql-bugs

I compiled with zlib 1.2.1 and can't reproduce the error, but that
probably has nothing to do with it.  It looks like there's a sleep right
before the test that failed.  Perhaps it didn't sleep long enough?  As I
said, I haven't been able to reproduce the problem but I thought I'd
send it on in case it's something as easy as increasing the sleep time
to make the test more likely to succeed.  If there's anything you'd like
me to test let me know and I'd be happy to oblige.

Jeremy

Platform: Solaris 2.6 Generic_105181-35 sun4u sparc SUNW,Ultra-4

Packages:
GCC 2.95.3
Postgres 7.4.1
Readline 4.3
Zlib 1.1.4

Commands issued to produce the problem:
./configure
make
make check

make check output:
....
============== running regression test queries        ==============
parallel group (13 tests):  boolean char name varchar text int4 int2 oid
int8 float8 float4 bit numeric
     boolean              ... ok
     char                 ... ok
     name                 ... ok
     varchar              ... ok
     text                 ... ok
     int2                 ... ok
     int4                 ... ok
     int8                 ... ok
     oid                  ... ok
     float4               ... ok
     float8               ... ok
     bit                  ... ok
     numeric              ... ok
test strings              ... ok
test numerology           ... ok
parallel group (20 tests):  point circle timetz comments lseg path box
polygon date interval reltime type_sanity time timestamptz abstime
tinterval timestamp inet oidjoins opr_sanity
     point                ... ok
     lseg                 ... ok
     box                  ... ok
     path                 ... ok
     polygon              ... ok
     circle               ... ok
     date                 ... ok
     time                 ... ok
     timetz               ... ok
     timestamp            ... ok
     timestamptz          ... ok
     interval             ... ok
     abstime              ... ok
     reltime              ... ok
     tinterval            ... ok
     inet                 ... ok
     comments             ... ok
     oidjoins             ... ok
     type_sanity          ... ok
     opr_sanity           ... ok
test geometry             ... ok
test horology             ... ok
test insert               ... ok
test create_function_1    ... ok
test create_type          ... ok
test create_table         ... ok
test create_function_2    ... ok
test copy                 ... ok
parallel group (7 tests):  create_aggregate create_operator vacuum
triggers inherit constraints create_misc
     constraints          ... ok
     triggers             ... ok
     create_misc          ... ok
     create_aggregate     ... ok
     create_operator      ... ok
     inherit              ... ok
     vacuum               ... ok
parallel group (2 tests):  create_view create_index
     create_index         ... ok
     create_view          ... ok
test sanity_check         ... ok
test errors               ... ok
test select               ... ok
parallel group (17 tests):  select_distinct_on select_distinct
select_having select_into union select_implicit aggregates random case
transactions subselect portals update hash_index btree_index arrays join
     select_into          ... ok
     select_distinct      ... ok
     select_distinct_on   ... ok
     select_implicit      ... ok
     select_having        ... ok
     subselect            ... ok
     union                ... ok
     case                 ... ok
     join                 ... ok
     aggregates           ... ok
     transactions         ... ok
     random               ... ok
     portals              ... ok
     arrays               ... ok
     btree_index          ... ok
     hash_index           ... ok
     update               ... ok
test privileges           ... ok
test misc                 ... ok
parallel group (5 tests):  portals_p2 select_views cluster rules foreign_key
     select_views         ... ok
     portals_p2           ... ok
     rules                ... ok
     foreign_key          ... ok
     cluster              ... ok
parallel group (14 tests):  limit polymorphism stats conversion prepare
copy2 without_oid sequence domain rangefuncs truncate temp plpgsql
alter_table
     limit                ... ok
     plpgsql              ... ok
     copy2                ... ok
     temp                 ... ok
     domain               ... ok
     rangefuncs           ... ok
     prepare              ... ok
     without_oid          ... ok
     conversion           ... ok
     truncate             ... ok
     alter_table          ... ok
     sequence             ... ok
     polymorphism         ... ok
     stats                ... FAILED
============== shutting down postmaster               ==============

=======================
 1 of 93 tests failed.
=======================


[16:20:31] csite2$ vi ./src/test/regress/regression.diffs
"./src/test/regress/regression.diffs" 22 lines, 762 characters
*** ./expected/stats.out        Fri Oct 31 22:18:20 2003
--- ./results/stats.out Thu Jan 22 16:00:36 2004
***************
*** 62,68 ****
   WHERE st.relname='tenk2' AND cl.relname='tenk2';
   ?column? | ?column? | ?column? | ?column?
  ----------+----------+----------+----------
!  t        | t        | t        | t
  (1 row)

  SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,
--- 62,68 ----
   WHERE st.relname='tenk2' AND cl.relname='tenk2';
   ?column? | ?column? | ?column? | ?column?
  ----------+----------+----------+----------
!  f        | f        | f        | f
  (1 row)

  SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,

======================================================================


--

**********************************************************************
 Jeremy Yoder    FAME Information Services, Inc Phone: (734) 332-4429
 jyoder@fame.com                                Fax:   (734) 332-4440
**********************************************************************