Re: parallel regression test failure

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

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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 FROM tmp 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