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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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