Thread

1. Regression test failure.

   Robert Hentosh <hentosh@io.com> — 2002-10-22T16:38:07Z

   I am receiving a regression test failure in about 1 out of 12 test runs.  
   I searched the bugs mailling list and have not found a similar problem.
   
   The system is a RedHat 7.3 system running the UP kernel 2.4.18-10 on an 
   800MHz Athlon. I didn't do any kernel tuning.
   
   I am compiling postgresql-7.2.3 with the following options:
   
    ./configure  --with-tcl --enable-syslog --enable-multibyte
   
   greping FAILED on regression.out gives:
        create_index         ... FAILED
   test sanity_check         ... FAILED
   test select               ... FAILED
   
   I have attached a bzip2 tar file that contains
   
     log/postmaster.log
     regression.diffs
   
   
   
   Thanks,
   Robert
   

2. Re: Regression test failure.

   Tom Lane <tgl@sss.pgh.pa.us> — 2002-10-22T17:32:57Z

   Robert Hentosh <hentosh@io.com> writes:
   > I am receiving a regression test failure in about 1 out of 12 test runs.  
   
   I am amazed no one has reported this before :-(
   
   Upon looking, I see that the parallel test schedule tries to run
   create_misc and create_index in parallel, but the latter uses tables
   that are created by the former.  AFAICT the diffs you show can all
   be explained by create_misc not having executed completely when
   create_index looks at those tables.
   
   By rights this failure should have been noticed long ago.  Perhaps there
   is some scheduler peculiarity on your machine that makes it more prone
   than others to execute the different jobs with just the right timing to
   manifest the error.
   
   We really gotta do some work to validate the parallel test schedule
   a little better... this sort of thing has popped up before.
   
   			regards, tom lane
   
   

3. Re: Regression test failure.

   Peter Eisentraut <peter_e@gmx.net> — 2002-10-22T22:21:21Z

   Tom Lane writes:
   
   > Robert Hentosh <hentosh@io.com> writes:
   > > I am receiving a regression test failure in about 1 out of 12 test runs.
   >
   > I am amazed no one has reported this before :-(
   
   Someone did. :-)
   
   -- 
   Peter Eisentraut   peter_e@gmx.net
   
   
   

4. Re: Regression test failure.

   Tom Lane <tgl@sss.pgh.pa.us> — 2002-10-22T22:23:25Z

   Peter Eisentraut <peter_e@gmx.net> writes:
   > Tom Lane writes:
   >> Robert Hentosh <hentosh@io.com> writes:
   > I am receiving a regression test failure in about 1 out of 12 test runs.
   >> 
   >> I am amazed no one has reported this before :-(
   
   > Someone did. :-)
   
   Yeah, I found your message awhile later.  I was surprised you hadn't
   fixed the schedule file...
   
   			regards, tom lane
   
   

5. Re: Regression test failure.

   Robert Hentosh <hentosh@io.com> — 2002-10-22T22:35:55Z

   On Tue, 22 Oct 2002, Tom Lane wrote:
   
   > Robert Hentosh <hentosh@io.com> writes:
   > > I am receiving a regression test failure in about 1 out of 12 test runs.  
   > 
   > I am amazed no one has reported this before :-(
   > 
   > Upon looking, I see that the parallel test schedule tries to run
   > create_misc and create_index in parallel, but the latter uses tables
   > that are created by the former.  AFAICT the diffs you show can all
   > be explained by create_misc not having executed completely when
   > create_index looks at those tables.
   
   Thanks for the prompt diagnosis.
   
   > By rights this failure should have been noticed long ago.  Perhaps there
   > is some scheduler peculiarity on your machine that makes it more prone
   > than others to execute the different jobs with just the right timing to
   > manifest the error.
   
   It occured on my first test after I compiled it.  I then repeated the 
   regression test and couldn't get it to happen again and was thinking maybe 
   it only occured on a fresh install.  I was about to do a fresh install, 
   when I got it to fail again on the 24th "make check" according to my 
   history file.
   
   I probably should have scripted it...
   
   Regards,
   Robert
   
   
   
   

6. Re: Regression test failure.

   Robert Hentosh <hentosh@io.com> — 2002-10-22T22:38:12Z

   On Tue, 22 Oct 2002, Tom Lane wrote:
   
   > Peter Eisentraut <peter_e@gmx.net> writes:
   > > Tom Lane writes:
   > >> Robert Hentosh <hentosh@io.com> writes:
   > > I am receiving a regression test failure in about 1 out of 12 test runs.
   > >> 
   > >> I am amazed no one has reported this before :-(
   > 
   > > Someone did. :-)
   > 
   > Yeah, I found your message awhile later.  I was surprised you hadn't
   > fixed the schedule file...
   > 
   > 			regards, tom lane
   
   
   Was this a post in the bugs mailling list?  I am just wondering if I 
   didn't search for the problem correctly.
   
   Regards,
   Robert