Skip site navigation (1) Skip section navigation (2)

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

From: Jeremy Yoder <jyoder(at)fame(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Postgres 7.4.1 "make check" failed "stats" test on Solaris 2.6
Date: 2004-01-23 14:45:27
Message-ID: 40113387.5030705@fame.com (view raw or flat)
Thread:
Lists: 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(at)fame(dot)com                                Fax:   (734) 332-4440
**********************************************************************


Responses

pgsql-bugs by date

Next:From: Tanya MamedalinDate: 2004-01-23 16:30:53
Subject: signal 11
Previous:From: PostgreSQL Bugs ListDate: 2004-01-23 13:26:15
Subject: BUG #1063: tcp/ip

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group