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.
The platform is Linux 2.4, gcc 3.2. I've attached the regression.diffs
file.
Any ideas on what the cause might be?
Cheers,
Neil
--
Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC
*** ./expected/triggers.out Sat Nov 23 13:13:22 2002
--- ./results/triggers.out Fri Mar 7 15:48:41 2003
***************
*** 88,93 ****
--- 88,94 ----
NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted
DROP TABLE pkeys;
DROP TABLE fkeys;
+ ERROR: DeleteRelationTuple: cache lookup failed for relation 122479
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/inherit.out Thu Mar 6 00:47:52 2003
--- ./results/inherit.out Fri Mar 7 15:48:41 2003
***************
*** 26,31 ****
--- 26,32 ----
INSERT INTO c(aa) VALUES('ccccccc');
INSERT INTO c(aa) VALUES('cccccccc');
INSERT INTO d(aa) VALUES('ddd');
+ ERROR: Relation 125442 does not exist
INSERT INTO d(aa) VALUES('dddd');
INSERT INTO d(aa) VALUES('ddddd');
INSERT INTO d(aa) VALUES('dddddd');
***************
*** 52,64 ****
c | cccccc
c | ccccccc
c | cccccccc
- d | ddd
d | dddd
d | ddddd
d | dddddd
d | ddddddd
d | dddddddd
! (24 rows)
SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid;
relname | aa | bb
--- 53,64 ----
c | cccccc
c | ccccccc
c | cccccccc
d | dddd
d | ddddd
d | dddddd
d | ddddddd
d | dddddddd
! (23 rows)
SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid;
relname | aa | bb
***************
*** 69,81 ****
b | bbbbbb |
b | bbbbbbb |
b | bbbbbbbb |
- d | ddd |
d | dddd |
d | ddddd |
d | dddddd |
d | ddddddd |
d | dddddddd |
! (12 rows)
SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid;
relname | aa | cc
--- 69,80 ----
b | bbbbbb |
b | bbbbbbb |
b | bbbbbbbb |
d | dddd |
d | ddddd |
d | dddddd |
d | ddddddd |
d | dddddddd |
! (11 rows)
SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid;
relname | aa | cc
***************
*** 86,109 ****
c | cccccc |
c | ccccccc |
c | cccccccc |
- d | ddd |
d | dddd |
d | ddddd |
d | dddddd |
d | ddddddd |
d | dddddddd |
! (12 rows)
SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid;
relname | aa | bb | cc | dd
---------+----------+----+----+----
- d | ddd | | |
d | dddd | | |
d | ddddd | | |
d | dddddd | | |
d | ddddddd | | |
d | dddddddd | | |
! (6 rows)
SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid;
relname | aa
--- 85,106 ----
c | cccccc |
c | ccccccc |
c | cccccccc |
d | dddd |
d | ddddd |
d | dddddd |
d | ddddddd |
d | dddddddd |
! (11 rows)
SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid;
relname | aa | bb | cc | dd
---------+----------+----+----+----
d | dddd | | |
d | ddddd | | |
d | dddddd | | |
d | ddddddd | | |
d | dddddddd | | |
! (5 rows)
SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid;
relname | aa
***************
*** 141,153 ****
SELECT relname, d.* FROM ONLY d, pg_class where d.tableoid = pg_class.oid;
relname | aa | bb | cc | dd
---------+----------+----+----+----
- d | ddd | | |
d | dddd | | |
d | ddddd | | |
d | dddddd | | |
d | ddddddd | | |
d | dddddddd | | |
! (6 rows)
UPDATE a SET aa='zzzz' WHERE aa='aaaa';
UPDATE ONLY a SET aa='zzzzz' WHERE aa='aaaaa';
--- 138,149 ----
SELECT relname, d.* FROM ONLY d, pg_class where d.tableoid = pg_class.oid;
relname | aa | bb | cc | dd
---------+----------+----+----+----
d | dddd | | |
d | ddddd | | |
d | dddddd | | |
d | ddddddd | | |
d | dddddddd | | |
! (5 rows)
UPDATE a SET aa='zzzz' WHERE aa='aaaa';
UPDATE ONLY a SET aa='zzzzz' WHERE aa='aaaaa';
***************
*** 175,187 ****
c | cccccc
c | ccccccc
c | cccccccc
- d | ddd
d | dddd
d | ddddd
d | dddddd
d | ddddddd
d | dddddddd
! (24 rows)
SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid;
relname | aa | bb
--- 171,182 ----
c | cccccc
c | ccccccc
c | cccccccc
d | dddd
d | ddddd
d | dddddd
d | ddddddd
d | dddddddd
! (23 rows)
SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid;
relname | aa | bb
***************
*** 192,204 ****
b | bbbbbb |
b | bbbbbbb |
b | bbbbbbbb |
- d | ddd |
d | dddd |
d | ddddd |
d | dddddd |
d | ddddddd |
d | dddddddd |
! (12 rows)
SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid;
relname | aa | cc
--- 187,198 ----
b | bbbbbb |
b | bbbbbbb |
b | bbbbbbbb |
d | dddd |
d | ddddd |
d | dddddd |
d | ddddddd |
d | dddddddd |
! (11 rows)
SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid;
relname | aa | cc
***************
*** 209,232 ****
c | cccccc |
c | ccccccc |
c | cccccccc |
- d | ddd |
d | dddd |
d | ddddd |
d | dddddd |
d | ddddddd |
d | dddddddd |
! (12 rows)
SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid;
relname | aa | bb | cc | dd
---------+----------+----+----+----
- d | ddd | | |
d | dddd | | |
d | ddddd | | |
d | dddddd | | |
d | ddddddd | | |
d | dddddddd | | |
! (6 rows)
SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid;
relname | aa
--- 203,224 ----
c | cccccc |
c | ccccccc |
c | cccccccc |
d | dddd |
d | ddddd |
d | dddddd |
d | ddddddd |
d | dddddddd |
! (11 rows)
SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid;
relname | aa | bb | cc | dd
---------+----------+----+----+----
d | dddd | | |
d | ddddd | | |
d | dddddd | | |
d | ddddddd | | |
d | dddddddd | | |
! (5 rows)
SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid;
relname | aa
***************
*** 264,276 ****
SELECT relname, d.* FROM ONLY d, pg_class where d.tableoid = pg_class.oid;
relname | aa | bb | cc | dd
---------+----------+----+----+----
- d | ddd | | |
d | dddd | | |
d | ddddd | | |
d | dddddd | | |
d | ddddddd | | |
d | dddddddd | | |
! (6 rows)
UPDATE b SET aa='new';
SELECT relname, a.* FROM a, pg_class where a.tableoid = pg_class.oid;
--- 256,267 ----
SELECT relname, d.* FROM ONLY d, pg_class where d.tableoid = pg_class.oid;
relname | aa | bb | cc | dd
---------+----------+----+----+----
d | dddd | | |
d | ddddd | | |
d | dddddd | | |
d | ddddddd | | |
d | dddddddd | | |
! (5 rows)
UPDATE b SET aa='new';
SELECT relname, a.* FROM a, pg_class where a.tableoid = pg_class.oid;
***************
*** 299,306 ****
d | new
d | new
d | new
! d | new
! (24 rows)
SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid;
relname | aa | bb
--- 290,296 ----
d | new
d | new
d | new
! (23 rows)
SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid;
relname | aa | bb
***************
*** 316,323 ****
d | new |
d | new |
d | new |
! d | new |
! (12 rows)
SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid;
relname | aa | cc
--- 306,312 ----
d | new |
d | new |
d | new |
! (11 rows)
SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid;
relname | aa | cc
***************
*** 333,340 ****
d | new |
d | new |
d | new |
! d | new |
! (12 rows)
SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid;
relname | aa | bb | cc | dd
--- 322,328 ----
d | new |
d | new |
d | new |
! (11 rows)
SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid;
relname | aa | bb | cc | dd
***************
*** 344,351 ****
d | new | | |
d | new | | |
d | new | | |
! d | new | | |
! (6 rows)
SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid;
relname | aa
--- 332,338 ----
d | new | | |
d | new | | |
d | new | | |
! (5 rows)
SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid;
relname | aa
***************
*** 388,395 ****
d | new | | |
d | new | | |
d | new | | |
! d | new | | |
! (6 rows)
UPDATE a SET aa='new';
DELETE FROM ONLY c WHERE aa='new';
--- 375,381 ----
d | new | | |
d | new | | |
d | new | | |
! (5 rows)
UPDATE a SET aa='new';
DELETE FROM ONLY c WHERE aa='new';
***************
*** 413,420 ****
d | new
d | new
d | new
! d | new
! (18 rows)
SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid;
relname | aa | bb
--- 399,405 ----
d | new
d | new
d | new
! (17 rows)
SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid;
relname | aa | bb
***************
*** 430,437 ****
d | new |
d | new |
d | new |
! d | new |
! (12 rows)
SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid;
relname | aa | cc
--- 415,421 ----
d | new |
d | new |
d | new |
! (11 rows)
SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid;
relname | aa | cc
***************
*** 441,448 ****
d | new |
d | new |
d | new |
! d | new |
! (6 rows)
SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid;
relname | aa | bb | cc | dd
--- 425,431 ----
d | new |
d | new |
d | new |
! (5 rows)
SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid;
relname | aa | bb | cc | dd
***************
*** 452,459 ****
d | new | | |
d | new | | |
d | new | | |
! d | new | | |
! (6 rows)
SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid;
relname | aa
--- 435,441 ----
d | new | | |
d | new | | |
d | new | | |
! (5 rows)
SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid;
relname | aa
***************
*** 490,497 ****
d | new | | |
d | new | | |
d | new | | |
! d | new | | |
! (6 rows)
DELETE FROM a;
SELECT relname, a.* FROM a, pg_class where a.tableoid = pg_class.oid;
--- 472,478 ----
d | new | | |
d | new | | |
d | new | | |
! (5 rows)
DELETE FROM a;
SELECT relname, a.* FROM a, pg_class where a.tableoid = pg_class.oid;
======================================================================
*** ./expected/vacuum.out Sat Jul 20 00:58:14 2002
--- ./results/vacuum.out Fri Mar 7 15:48:41 2003
***************
*** 30,35 ****
--- 30,36 ----
VACUUM FULL vactst;
UPDATE vactst SET i = i + 1;
+ ERROR: Relation 124108 does not exist
INSERT INTO vactst SELECT * FROM vactst;
INSERT INTO vactst SELECT * FROM vactst;
INSERT INTO vactst SELECT * FROM vactst;
======================================================================
*** ./expected/sanity_check.out Mon Aug 19 15:33:36 2002
--- ./results/sanity_check.out Fri Mar 7 15:48:48 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 Sat Feb 22 20:01:12 2003
--- ./results/misc.out Fri Mar 7 15:48:51 2003
***************
*** 598,603 ****
--- 598,604 ----
equipment_r
f_star
fast_emp4000
+ fkeys
float4_tbl
float8_tbl
func_index_heap
***************
*** 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');
--- 660,666 ----
toyemp
varchar_tbl
xacttest
! (96 rows)
--SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))) AS equip_name;
SELECT hobbies_by_name('basketball');
======================================================================
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
