parallel regression test failure - Mailing list pgsql-hackers

From Bruce Momjian
Subject parallel regression test failure
Date
Msg-id 200307252147.h6PLloW12464@candle.pha.pa.us
Whole thread Raw
Responses Re: parallel regression test failure  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: parallel regression test failure  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: parallel regression test failure  (Kurt Roeckx <Q@ping.be>)
List pgsql-hackers
I am seeing the following parallel regression test failures.  Any idea
on the cause?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
*** ./expected/constraints.out    Fri Jul 25 17:36:36 2003
--- ./results/constraints.out    Fri Jul 25 17:37:07 2003
***************
*** 80,102 ****
  CREATE TABLE CHECK2_TBL (x int, y text, z int,
      CONSTRAINT SEQUENCE_CON
      CHECK (x > 3 and y <> 'check failed' and z < 8));
  INSERT INTO CHECK2_TBL VALUES (4, 'check ok', -2);
  INSERT INTO CHECK2_TBL VALUES (1, 'x check failed', -2);
! ERROR:  new row for relation "check2_tbl" violates CHECK constraint "sequence_con"
  INSERT INTO CHECK2_TBL VALUES (5, 'z check failed', 10);
! ERROR:  new row for relation "check2_tbl" violates CHECK constraint "sequence_con"
  INSERT INTO CHECK2_TBL VALUES (0, 'check failed', -2);
! ERROR:  new row for relation "check2_tbl" violates CHECK constraint "sequence_con"
  INSERT INTO CHECK2_TBL VALUES (6, 'check failed', 11);
! ERROR:  new row for relation "check2_tbl" violates CHECK constraint "sequence_con"
  INSERT INTO CHECK2_TBL VALUES (7, 'check ok', 7);
  SELECT '' AS two, * from CHECK2_TBL;
!  two | x |    y     | z
! -----+---+----------+----
!      | 4 | check ok | -2
!      | 7 | check ok |  7
! (2 rows)
!
  --
  -- Check constraints on INSERT
  --
--- 80,100 ----
  CREATE TABLE CHECK2_TBL (x int, y text, z int,
      CONSTRAINT SEQUENCE_CON
      CHECK (x > 3 and y <> 'check failed' and z < 8));
+ ERROR:  cache lookup failed for relation 126262
  INSERT INTO CHECK2_TBL VALUES (4, 'check ok', -2);
+ ERROR:  relation "check2_tbl" does not exist
  INSERT INTO CHECK2_TBL VALUES (1, 'x check failed', -2);
! ERROR:  relation "check2_tbl" does not exist
  INSERT INTO CHECK2_TBL VALUES (5, 'z check failed', 10);
! ERROR:  relation "check2_tbl" does not exist
  INSERT INTO CHECK2_TBL VALUES (0, 'check failed', -2);
! ERROR:  relation "check2_tbl" does not exist
  INSERT INTO CHECK2_TBL VALUES (6, 'check failed', 11);
! ERROR:  relation "check2_tbl" does not exist
  INSERT INTO CHECK2_TBL VALUES (7, 'check ok', 7);
+ ERROR:  relation "check2_tbl" does not exist
  SELECT '' AS two, * from CHECK2_TBL;
! ERROR:  relation "check2_tbl" does not exist
  --
  -- Check constraints on INSERT
  --

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

*** ./expected/triggers.out    Fri Jul 25 12:38:34 2003
--- ./results/triggers.out    Fri Jul 25 17:37:06 2003
***************
*** 91,96 ****
--- 91,97 ----
  NOTICE:  check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted
  DROP TABLE pkeys;
  DROP TABLE fkeys;
+ ERROR:  cache lookup failed for relation 122552
  DROP TABLE fkeys2;
  -- -- I've disabled the funny_dup17 test because the new semantics
  -- -- of AFTER ROW triggers, which get now fired at the end of a

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

*** ./expected/sanity_check.out    Wed May 28 12:04:02 2003
--- ./results/sanity_check.out    Fri Jul 25 17:37:14 2003
***************
*** 15,20 ****
--- 15,21 ----
   bt_name_heap        | t
   bt_txt_heap         | t
   fast_emp4000        | t
+  fkeys               | t
   func_index_heap     | t
   hash_f8_heap        | t
   hash_i4_heap        | t
***************
*** 62,68 ****
   shighway            | t
   tenk1               | t
   tenk2               | t
! (52 rows)

  --
  -- another sanity check: every system catalog that has OIDs should have
--- 63,69 ----
   shighway            | t
   tenk1               | t
   tenk2               | t
! (53 rows)

  --
  -- another sanity check: every system catalog that has OIDs should have

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

*** ./expected/misc.out    Fri Jul 25 17:36:36 2003
--- ./results/misc.out    Fri Jul 25 17:37:17 2003
***************
*** 580,586 ****
   c
   c_star
   char_tbl
-  check2_tbl
   check_seq
   check_tbl
   circle_tbl
--- 580,585 ----
***************
*** 598,603 ****
--- 597,603 ----
   equipment_r
   f_star
   fast_emp4000
+  fkeys
   float4_tbl
   float8_tbl
   func_index_heap

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


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: v7.3.4 bundled ...
Next
From: Greg Stark
Date:
Subject: Re: libpq_r