Re: regression failure in CVS HEAD

Neil Conway <neilc(at)samurai(dot)com> writes:
> About 1 in every 5 runs of the (parallel) regression tests are failing
> for me with CVS HEAD: the triggers, inherit, vacuum, sanity_check, and
> misc tests fail. I can make the failures occur fairly consistently by
> running "make check" over and over again until the problem crops up.

Yipes. I have not been running the parallel tests (my habit is to run
make installcheck, instead) but there is clearly something busted.
I got a bunch of failures similar to yours in my first attempt with
make check on HPUX --- see attached.

> Any ideas on what the cause might be?

No. Can anyone offer data on when this started?

regards, tom lane

*** ./expected/constraints.out Sat Mar 8 00:16:33 2003
--- ./results/constraints.out Sat Mar 8 00:21:00 2003
***************
*** 11,31 ****
--
CREATE TABLE DEFAULT_TBL (i int DEFAULT 100,
x text DEFAULT 'vadim', f float8 DEFAULT 123.456);
INSERT INTO DEFAULT_TBL VALUES (1, 'thomas', 57.0613);
INSERT INTO DEFAULT_TBL VALUES (1, 'bruce');
INSERT INTO DEFAULT_TBL (i, f) VALUES (2, 987.654);
INSERT INTO DEFAULT_TBL (x) VALUES ('marc');
INSERT INTO DEFAULT_TBL VALUES (3, null, 1.0);
SELECT '' AS five, * FROM DEFAULT_TBL;
! five | i | x | f
! ------+-----+--------+---------
! | 1 | thomas | 57.0613
! | 1 | bruce | 123.456
! | 2 | vadim | 987.654
! | 100 | marc | 123.456
! | 3 | | 1
! (5 rows)
!
CREATE SEQUENCE DEFAULT_SEQ;
CREATE TABLE DEFAULTEXPR_TBL (i1 int DEFAULT 100 + (200-199) * 2,
i2 int DEFAULT nextval('default_seq'));
--- 11,29 ----
--
CREATE TABLE DEFAULT_TBL (i int DEFAULT 100,
x text DEFAULT 'vadim', f float8 DEFAULT 123.456);
+ ERROR: cache lookup of relation 119389 failed
INSERT INTO DEFAULT_TBL VALUES (1, 'thomas', 57.0613);
+ ERROR: Relation "default_tbl" does not exist
INSERT INTO DEFAULT_TBL VALUES (1, 'bruce');
+ ERROR: Relation "default_tbl" does not exist
INSERT INTO DEFAULT_TBL (i, f) VALUES (2, 987.654);
+ ERROR: Relation "default_tbl" does not exist
INSERT INTO DEFAULT_TBL (x) VALUES ('marc');
+ ERROR: Relation "default_tbl" does not exist
INSERT INTO DEFAULT_TBL VALUES (3, null, 1.0);
+ ERROR: Relation "default_tbl" does not exist
SELECT '' AS five, * FROM DEFAULT_TBL;
! ERROR: Relation "default_tbl" does not exist
CREATE SEQUENCE DEFAULT_SEQ;
CREATE TABLE DEFAULTEXPR_TBL (i1 int DEFAULT 100 + (200-199) * 2,
i2 int DEFAULT nextval('default_seq'));

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

*** ./expected/misc.out Sat Mar 8 00:16:33 2003
--- ./results/misc.out Sat Mar 8 00:21:52 2003
***************
*** 590,596 ****
d_star
date_tbl
default_seq
- default_tbl
defaultexpr_tbl
dept
e_star
--- 590,595 ----
***************
*** 659,665 ****
toyemp
varchar_tbl
xacttest
! (95 rows)

--SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))) AS equip_name;
SELECT hobbies_by_name('basketball');
--- 658,664 ----
toyemp
varchar_tbl
xacttest
! (94 rows)

--SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))) AS equip_name;
SELECT hobbies_by_name('basketball');

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