Re: Regression test failure date.

I am now seeing this error in 2003-03-03.

CREATE TABLE INSERT_CHILD (cx INT default 42,
cy INT CHECK (cy > x))
INHERITS (INSERT_TBL);
+ ERROR: RelationClearRelation: relation 130996 deleted while still in use

---------------------------------------------------------------------------

Bruce Momjian wrote:
>
> I am testing this today. I found 2003-03-03 to not generate a failure
> in 20 tests, so I am moving forward to April/May.
>
> ---------------------------------------------------------------------------
>
> Robert Creager wrote:
> -- Start of PGP signed section.
> >
> > I will stand by the fact that I cannot generate failures from
> > 2003-02-15 (200+ runs), and I can from 2003-02-16. Just to make sure I
> > didn't screw up the cvs usage, I'll try again tonight if I get the
> > chance and re-download re-test these two days.
> >
> > I can set up a script that will step through weekly dates starting from
> > 'now' and see if the 02-16 problem might of been fixed and then
> > re-introduced if you like.
> >
> > 2003-02-16 fails 6/50
> > vacuum failed 1 times
> > misc failed 3 times
> > sanity_check failed 3 times
> > inherit failed 1 times
> > triggers failed 4 times
> >
> > Cheers,
> > Rob
> >
> > On Mon, 28 Jul 2003 02:14:32 -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 have only been running nightly paralell regression runs since June
> > > > 27, so it is possible that the paralell regression was broken in
> > > > February, fixed in May, then broken some time after that.
> > >
> > > Any further progress on this?
> > >
> > > My best theory at the moment is that we have a problem with relcache
> > > entry creation failing if it's interrupted by an SI inval message at
> > > just the right time. I don't much want to grovel through six months
> > > worth of changelog entries looking for candidate mistakes, though.
> > >
> > > regards, tom lane
> > >
> > > ---------------------------(end of
> > > broadcast)--------------------------- TIP 3: if posting/reading
> > > through Usenet, please send an appropriate
> > > subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> > > your message can get through to the mailing list cleanly
> > >
> > >
> >
> >
> > --
> > 06:57:40 up 10 days, 10:57, 2 users, load average: 2.17, 2.08, 1.83
> -- End of PGP section, PGP failed!
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073