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

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