[BUGS] Postgres 7.4.1 "make check" failed "stats" test on Solaris 2.6

Mon, 26 Jan 2004 09:13:21 -0800

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
[EMAIL PROTECTED]                                Fax:   (734) 332-4440
**********************************************************************


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to