Thread: Postgres 7.4.1 "make check" failed "stats" test on Solaris 2.6

Postgres 7.4.1 "make check" failed "stats" test on Solaris 2.6

From
Jeremy Yoder
Date:
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
**********************************************************************

Re: Postgres 7.4.1 "make check" failed "stats" test on Solaris 2.6

From
Tom Lane
Date:
Jeremy Yoder <jyoder@fame.com> writes:
> 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?

Much more likely this indicates that the stats collector failed to start
up.  The reason the test is there is that we've seen this happen on
systems with strangely-configured networking.  Look at the postmaster's
log file (stderr output or syslog, depending on how you have it
configured) to see if there's any bleating about not being able to bind
to the stats collection socket, or errors along that line.  They'd be
right near the top, during postmaster startup.

In any case, showing only the output "stats ... FAILED" is of little use
in diagnosing the reason for a test failure.  You have to look at the
actual regression.diffs file if you want to do more than guess.

            regards, tom lane