Thread: Re: regression failure on latest CVS

Re: regression failure on latest CVS

From
Larry Rosenman
Date:
On Jul 25 2005, ohp@pyrenet.fr wrote:

> Sorry to follow up my own post but this is weird.
>
> I've tested again and more closely.
> And intervall check is ok when configured with --enable-debug and fails
> (with the same error) otherwise.
>
> It could be a compiler optimizer bug or the way the code is written.
> Could someone point me to the source file so that I have a look?

Look at 'firefly' on the pgbuildfarm, and tell me what I need
to change to duplicate your setup.

LER

>
> BTW this is still on UnixWare 714
>
> Regards,
> On Fri, 22 Jul 2005 ohp@pyrenet.fr wrote:
>
> > Date: Fri, 22 Jul 2005 11:28:52 +0200 (MET DST)
> > From: ohp@pyrenet.fr
> > Newsgroups: pgsql.hackers
> > Subject: regressin failure on latest CVS
> >
> > Hi,
> >
> > I tried the latest cvs this morning (07/22 11:00 CET)
> > and interval test fails.
> > Here's the regression.diffs.
> >
> > *** ./expected/interval.out    Fri Jul 22 10:32:21 2005
> > --- ./results/interval.out    Fri Jul 22 11:07:54 2005
> > ***************
> > *** 217,224 ****
> >   -- updating pg_aggregate.agginitval
> >   select avg(f1) from interval_tbl;
> >                          avg
> > ! -------------------------------------------------
> > !  @ 4 years 1 mon 10 days 4 hours 18 mins 23 secs
> >   (1 row)
> >
> >   -- test long interval input
> > --- 217,224 ----
> >   -- updating pg_aggregate.agginitval
> >   select avg(f1) from interval_tbl;
> >                         avg
> > ! ------------------------------------------------
> > !  @ 4 years 1 mon 9 days 4 hours 18 mins 23 secs
> >   (1 row)
> >
> >   -- test long interval input
> >
> > ======================================================================
> >
> > Regards
> >
>
>

--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611



Re: regression failure on latest CVS

From
ohp@pyrenet.fr
Date:
Hi Larry,

I'm quitge sure you'll see a problem if you remove --enable-debug
--enable-cassert from your ./configure

This is the problem I have.

Regards
On Mon, 25 Jul 2005, Larry Rosenman wrote:

> Date: 25 Jul 2005 09:00:41 -0500
> From: Larry Rosenman <ler@lerctr.org>
> To: ohp@pyrenet.fr
> Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] regression failure on latest CVS
>
> On Jul 25 2005, ohp@pyrenet.fr wrote:
>
> > Sorry to follow up my own post but this is weird.
> >
> > I've tested again and more closely.
> > And intervall check is ok when configured with --enable-debug and fails
> > (with the same error) otherwise.
> >
> > It could be a compiler optimizer bug or the way the code is written.
> > Could someone point me to the source file so that I have a look?
>
> Look at 'firefly' on the pgbuildfarm, and tell me what I need
> to change to duplicate your setup.
>
> LER
>
> >
> > BTW this is still on UnixWare 714
> >
> > Regards,
> > On Fri, 22 Jul 2005 ohp@pyrenet.fr wrote:
> >
> > > Date: Fri, 22 Jul 2005 11:28:52 +0200 (MET DST)
> > > From: ohp@pyrenet.fr
> > > Newsgroups: pgsql.hackers
> > > Subject: regressin failure on latest CVS
> > >
> > > Hi,
> > >
> > > I tried the latest cvs this morning (07/22 11:00 CET)
> > > and interval test fails.
> > > Here's the regression.diffs.
> > >
> > > *** ./expected/interval.out    Fri Jul 22 10:32:21 2005
> > > --- ./results/interval.out    Fri Jul 22 11:07:54 2005
> > > ***************
> > > *** 217,224 ****
> > >   -- updating pg_aggregate.agginitval
> > >   select avg(f1) from interval_tbl;
> > >                          avg
> > > ! -------------------------------------------------
> > > !  @ 4 years 1 mon 10 days 4 hours 18 mins 23 secs
> > >   (1 row)
> > >
> > >   -- test long interval input
> > > --- 217,224 ----
> > >   -- updating pg_aggregate.agginitval
> > >   select avg(f1) from interval_tbl;
> > >                         avg
> > > ! ------------------------------------------------
> > > !  @ 4 years 1 mon 9 days 4 hours 18 mins 23 secs
> > >   (1 row)
> > >
> > >   -- test long interval input
> > >
> > > ======================================================================
> > >
> > > Regards
> > >
> >
> >
>
>

-- 
Olivier PRENANT                    Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges                +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
FRANCE                          Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)


Re: regression failure on latest CVS

From
"Jim C. Nasby"
Date:
Would it be useful to hackers if build animals periodically ran builds
with those options removed?

On Mon, Jul 25, 2005 at 07:19:05PM +0200, ohp@pyrenet.fr wrote:
> Hi Larry,
> 
> I'm quitge sure you'll see a problem if you remove --enable-debug
> --enable-cassert from your ./configure
> 
> This is the problem I have.
> 
> Regards
> On Mon, 25 Jul 2005, Larry Rosenman wrote:
> 
> > Date: 25 Jul 2005 09:00:41 -0500
> > From: Larry Rosenman <ler@lerctr.org>
> > To: ohp@pyrenet.fr
> > Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
> > Subject: Re: [HACKERS] regression failure on latest CVS
> >
> > On Jul 25 2005, ohp@pyrenet.fr wrote:
> >
> > > Sorry to follow up my own post but this is weird.
> > >
> > > I've tested again and more closely.
> > > And intervall check is ok when configured with --enable-debug and fails
> > > (with the same error) otherwise.
> > >
> > > It could be a compiler optimizer bug or the way the code is written.
> > > Could someone point me to the source file so that I have a look?
> >
> > Look at 'firefly' on the pgbuildfarm, and tell me what I need
> > to change to duplicate your setup.
> >
> > LER
> >
> > >
> > > BTW this is still on UnixWare 714
> > >
> > > Regards,
> > > On Fri, 22 Jul 2005 ohp@pyrenet.fr wrote:
> > >
> > > > Date: Fri, 22 Jul 2005 11:28:52 +0200 (MET DST)
> > > > From: ohp@pyrenet.fr
> > > > Newsgroups: pgsql.hackers
> > > > Subject: regressin failure on latest CVS
> > > >
> > > > Hi,
> > > >
> > > > I tried the latest cvs this morning (07/22 11:00 CET)
> > > > and interval test fails.
> > > > Here's the regression.diffs.
> > > >
> > > > *** ./expected/interval.out    Fri Jul 22 10:32:21 2005
> > > > --- ./results/interval.out    Fri Jul 22 11:07:54 2005
> > > > ***************
> > > > *** 217,224 ****
> > > >   -- updating pg_aggregate.agginitval
> > > >   select avg(f1) from interval_tbl;
> > > >                          avg
> > > > ! -------------------------------------------------
> > > > !  @ 4 years 1 mon 10 days 4 hours 18 mins 23 secs
> > > >   (1 row)
> > > >
> > > >   -- test long interval input
> > > > --- 217,224 ----
> > > >   -- updating pg_aggregate.agginitval
> > > >   select avg(f1) from interval_tbl;
> > > >                         avg
> > > > ! ------------------------------------------------
> > > > !  @ 4 years 1 mon 9 days 4 hours 18 mins 23 secs
> > > >   (1 row)
> > > >
> > > >   -- test long interval input
> > > >
> > > > ======================================================================
> > > >
> > > > Regards
> > > >
> > >
> > >
> >
> >
> 
> -- 
> Olivier PRENANT                    Tel: +33-5-61-50-97-00 (Work)
> 15, Chemin des Monges                +33-5-61-50-97-01 (Fax)
> 31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
> FRANCE                          Email: ohp@pyrenet.fr
> ------------------------------------------------------------------------------
> Make your life a dream, make your dream a reality. (St Exupery)
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 

-- 
Jim C. Nasby, Database Consultant               decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"