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?
>

I was just able to get some problems on my dual Athlon machine
(after about 10 runs) with a clean cvs download.

Linux thunder.mshome.net 2.4.21-0.13_test #35 SMP Wed Apr 9 07:29:10 MDT
2003 i686 unknown unknown GNU/Linux

gcc (GCC) 3.2.2 (Mandrake Linux 9.1 3.2.2-3mdk)

<./configure --with-pgport=5433 --prefix=/usr/local/pgsql_cvs>
<sh src/tools/pgtest>
<sh src/tools/pgtest -n>

*** ./expected/triggers.out Thu Jul 24 11:52:50 2003
--- ./results/triggers.out Fri Jul 25 21:20:34 2003
***************
*** 92,97 ****
--- 92,98 ----
DROP TABLE pkeys;
DROP TABLE fkeys;
DROP TABLE fkeys2;
+ ERROR: could not open relation with OID 119498
-- -- I've disabled the funny_dup17 test because the new semantics
-- -- of AFTER ROW triggers, which get now fired at the end of a
-- -- query always, cause funny_dup17 to enter an endless loop.

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

*** ./expected/sanity_check.out Wed May 28 10:04:02 2003
--- ./results/sanity_check.out Fri Jul 25 21:20:37 2003
***************
*** 15,20 ****
--- 15,21 ----
bt_name_heap | t
bt_txt_heap | t
fast_emp4000 | t
+ fkeys2 | 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 21:14:51 2003
--- ./results/misc.out Fri Jul 25 21:20:39 2003
***************
*** 598,603 ****
--- 598,604 ----
equipment_r
f_star
fast_emp4000
+ fkeys2
float4_tbl
float8_tbl
func_index_heap
***************
*** 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');
--- 661,667 ----
toyemp
varchar_tbl
xacttest
! (97 rows)

--SELECT name(equipment(hobby_construct(text 'skywalking', text
'mer'))) AS equip_name; SELECT hobbies_by_name('basketball');

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

--
21:23:44 up 8 days, 1:24, 2 users, load average: 0.11, 1.04, 1.31