Re: parallel regression test failure - Mailing list pgsql-hackers

On Fri, 25 Jul 2003 19:57:04 -0400
Tom Lane <tgl@sss.pgh.pa.us> said something like:

> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I am seeing the following parallel regression test failures.  Any
> > idea on the cause?
> 
> I don't see it here, on either of two different architectures.  Maybe
> you need a make distclean and rebuild?
> 

And another failure:

*** ./expected/constraints.out    Fri Jul 25 21:14:51 2003
--- ./results/constraints.out    Fri Jul 25 21:34:09 2003
***************
*** 212,244 **** DROP SEQUENCE INSERT_SEQ; CREATE SEQUENCE INSERT_SEQ START 4; CREATE TABLE tmp (xd INT, yd TEXT, zd
INT);INSERT INTO tmp VALUES (null, 'Y', null); INSERT INTO tmp VALUES (5, '!check failed', null); INSERT INTO tmp
VALUES(null, 'try again', null); INSERT INTO INSERT_TBL(y) select yd from tmp; SELECT '' AS three, * FROM INSERT_TBL;
three| x |       y       | z  
 
! -------+---+---------------+----
!        | 4 | Y             | -4
!        | 5 | !check failed | -5
!        | 6 | try again     | -6
! (3 rows)  INSERT INTO INSERT_TBL SELECT * FROM tmp WHERE yd = 'try again'; INSERT INTO INSERT_TBL(y,z) SELECT yd, -7
FROMtmp WHERE yd = 'try
 
again';  INSERT INTO INSERT_TBL(y,z) SELECT yd, -8 FROM tmp WHERE yd =
'try again';! ERROR:  new row for relation "insert_tbl" violates CHECK
constraint "insert_con"  SELECT '' AS four, * FROM INSERT_TBL;  four | x |       y       | z  
! ------+---+---------------+----
!       | 4 | Y             | -4
!       | 5 | !check failed | -5
!       | 6 | try again     | -6
!       |   | try again     |   
!       | 7 | try again     | -7
! (5 rows)  DROP TABLE tmp; -- -- Check constraints on UPDATE --
--- 212,244 ---- DROP SEQUENCE INSERT_SEQ; CREATE SEQUENCE INSERT_SEQ START 4; CREATE TABLE tmp (xd INT, yd TEXT, zd
INT);
+ ERROR:  relation 126260 deleted while still in use INSERT INTO tmp VALUES (null, 'Y', null);
+ ERROR:  relation "tmp" does not exist INSERT INTO tmp VALUES (5, '!check failed', null);
+ ERROR:  relation "tmp" does not exist INSERT INTO tmp VALUES (null, 'try again', null);
+ ERROR:  relation "tmp" does not exist INSERT INTO INSERT_TBL(y) select yd from tmp;
+ ERROR:  relation "tmp" does not exist SELECT '' AS three, * FROM INSERT_TBL;  three | x | y | z 
! -------+---+---+---
! (0 rows)  INSERT INTO INSERT_TBL SELECT * FROM tmp WHERE yd = 'try again';
+ ERROR:  relation "tmp" does not exist INSERT INTO INSERT_TBL(y,z) SELECT yd, -7 FROM tmp WHERE yd = 'try
again';+ ERROR:  relation "tmp" does not exist INSERT INTO INSERT_TBL(y,z) SELECT yd, -8 FROM tmp WHERE yd = 'try
again';! ERROR:  relation "tmp" does not exist SELECT '' AS four, * FROM INSERT_TBL;  four | x | y | z 
! ------+---+---+---
! (0 rows)  DROP TABLE tmp;
+ ERROR:  table "tmp" does not exist -- -- Check constraints on UPDATE --
***************
*** 246,261 **** UPDATE INSERT_TBL SET x = 6 WHERE x = 6; UPDATE INSERT_TBL SET x = -z, z = -x; UPDATE INSERT_TBL SET x
=z, z = x;
 
- ERROR:  new row for relation "insert_tbl" violates CHECK constraint
"insert_con"  SELECT * FROM INSERT_TBL;  x |       y       | z  
! ---+---------------+----
!  4 | Y             | -4
!    | try again     |   
!  7 | try again     | -7
!  5 | !check failed |   
!  6 | try again     | -6
! (5 rows)  -- DROP TABLE INSERT_TBL; --
--- 246,255 ---- UPDATE INSERT_TBL SET x = 6 WHERE x = 6; UPDATE INSERT_TBL SET x = -z, z = -x; UPDATE INSERT_TBL SET x
=z, z = x; SELECT * FROM INSERT_TBL;  x | y | z 
 
! ---+---+---
! (0 rows)  -- DROP TABLE INSERT_TBL; --

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



-- 21:34:48 up 8 days,  1:35,  2 users,  load average: 0.89, 0.65, 0.85