Обсуждение: Re: 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 > > > > -- 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
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)
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?"