Re: regression failure in CVS HEAD - Mailing list pgsql-hackers

Neil Conway <neilc@samurai.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);
INSERTINTO 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
DEFAULT100 + (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');

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