Re: Buildfarm alarms

> -----Original Message-----
> From: Michael Meskes [mailto:meskes(at)postgresql(dot)org]
> Sent: 26 September 2006 08:57
> To: Joachim Wieland
> Cc: Dave Page; meskes(at)postgresql(dot)org
> Subject: Re: [HACKERS] Buildfarm alarms
>
> On Mon, Sep 25, 2006 at 09:20:19PM +0200, Joachim Wieland wrote:
> > Michael, could you please check and apply?
>
> Works for me, so I applied it. But then I only tested on Linux. :-)

OK, I now see just one, date format related failure:

============== running regression test queries ==============
/usr/local/src/postgresql-8.2-dev/src/interfaces/ecpg/test/./tmp_check/i
nstall//usr/local/pgsql/bin/createuser -R -S -D -q regressuser1
/usr/local/src/postgresql-8.2-dev/src/interfaces/ecpg/test/./tmp_check/i
nstall//usr/local/pgsql/bin/createuser -R -S -D -q connectuser
/usr/local/src/postgresql-8.2-dev/src/interfaces/ecpg/test/./tmp_check/i
nstall//usr/local/pgsql/bin/createuser -R -S -D -q connectdb
testing connect/test1.pgc ... ok
testing connect/test2.pgc ... ok
testing connect/test3.pgc ... ok
testing connect/test4.pgc ... ok
testing connect/test5.pgc ... ok
testing compat_informix/charfuncs.pgc ... ok
testing compat_informix/dec_test.pgc ... ok
testing compat_informix/rfmtdate.pgc ... ok
testing compat_informix/rfmtlong.pgc ... ok
testing compat_informix/rnull.pgc ... ok
testing compat_informix/test_informix.pgc ... ok
testing compat_informix/test_informix2.pgc ... ok
testing preproc/comment.pgc ... ok
testing preproc/define.pgc ... ok
testing preproc/init.pgc ... ok
testing preproc/type.pgc ... ok
testing preproc/variable.pgc ... FAILED (log, output)
testing preproc/whenever.pgc ... ok
testing pgtypeslib/dt_test.pgc ... ok
testing pgtypeslib/dt_test2.pgc ... ok
testing pgtypeslib/num_test.pgc ... ok
testing pgtypeslib/num_test2.pgc ... ok
testing sql/array.pgc ... ok
testing sql/binary.pgc ... ok
testing sql/code100.pgc ... ok
testing sql/copystdout.pgc ... ok
testing sql/define.pgc ... ok
testing sql/desc.pgc ... ok
testing sql/dynalloc.pgc ... ok
testing sql/dynalloc2.pgc ... ok
testing sql/dyntest.pgc ... ok
testing sql/execute.pgc ... ok
testing sql/fetch.pgc ... ok
testing sql/func.pgc ... ok
testing sql/indicators.pgc ... ok
testing sql/quote.pgc ... ok
testing sql/show.pgc ... ok
testing sql/update.pgc ... ok
testing thread/thread.pgc ... ok
testing thread/thread_implicit.pgc ... ok
============== shutting down postmaster ==============
server stopped
make[1]: *** [check] Error 1
make[1]: Leaving directory
`/usr/local/src/postgresql-8.2-dev/src/interfaces/ecpg/test'
make: *** [check] Error 2

*** expected/preproc-variable.stderr Fri Sep 8 10:03:40 2006
--- results/preproc-variable.stderr Tue Sep 26 09:51:00 2006
***************
*** 44,50 ****
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGstore_result: line 68: allocating memory for 1 tuples
[NO_PID]: sqlca: code: 0, state: 00000
! [NO_PID]: ECPGget_data line 68: RESULT: 07-14-1987 offset: -1 array:
Yes
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGget_data line 68: RESULT: 3 offset: -1 array: Yes
[NO_PID]: sqlca: code: 0, state: 00000
--- 44,50 ----
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGstore_result: line 68: allocating memory for 1 tuples
[NO_PID]: sqlca: code: 0, state: 00000
! [NO_PID]: ECPGget_data line 68: RESULT: 14-07-1987 offset: -1 array:
Yes
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGget_data line 68: RESULT: 3 offset: -1 array: Yes
[NO_PID]: sqlca: code: 0, state: 00000
***************
*** 60,66 ****
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGstore_result: line 68: allocating memory for 1 tuples
[NO_PID]: sqlca: code: 0, state: 00000
! [NO_PID]: ECPGget_data line 68: RESULT: 07-14-1987 offset: -1 array:
Yes
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGget_data line 68: RESULT: 3 offset: -1 array: Yes
[NO_PID]: sqlca: code: 0, state: 00000
--- 60,66 ----
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGstore_result: line 68: allocating memory for 1 tuples
[NO_PID]: sqlca: code: 0, state: 00000
! [NO_PID]: ECPGget_data line 68: RESULT: 14-07-1987 offset: -1 array:
Yes
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGget_data line 68: RESULT: 3 offset: -1 array: Yes
[NO_PID]: sqlca: code: 0, state: 00000
*** expected/preproc-variable.stdout Fri Sep 8 10:03:40 2006
--- results/preproc-variable.stdout Tue Sep 26 09:51:00 2006
***************
*** 1,5 ****
! Mum , married 07-14-1987, children = 3
! Dad , born 19610721, married 07-14-1987, children = 3
Child 1 , age = 16
Child 2 , age = 14
Child 3 , age = 9
--- 1,5 ----
! Mum , married 14-07-1987, children = 3
! Dad , born 19610721, married 14-07-1987, children = 3
Child 1 , age = 16
Child 2 , age = 14
Child 3 , age = 9

Regards, Dave

On Tue, Sep 26, 2006 at 09:57:16AM +0100, Dave Page wrote:
> OK, I now see just one, date format related failure:
> ...

Did you run it with Joachim's patch or with up-to-date CVS checkout? It
seems to me that you do not have the latest changes to CVS. We added a
"set datestyle" to variable.pgc that should fix this failure.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

> -----Original Message-----
> From: Michael Meskes [mailto:meskes(at)postgresql(dot)org]
> Sent: 26 September 2006 10:39
> To: Dave Page
> Cc: Joachim Wieland; pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Buildfarm alarms
>
> On Tue, Sep 26, 2006 at 09:57:16AM +0100, Dave Page wrote:
> > OK, I now see just one, date format related failure:
> > ...
>
> Did you run it with Joachim's patch or with up-to-date CVS
> checkout? It
> seems to me that you do not have the latest changes to CVS. We added a
> "set datestyle" to variable.pgc that should fix this failure.

No, I used Joachim's patch as anoncvs hadn't caught up. I'll run it
again - thanks.

Regards Dave

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Dave Page
> Sent: 26 September 2006 10:41
> To: Michael Meskes
> Cc: Joachim Wieland; pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Buildfarm alarms
>
>
>
> > -----Original Message-----
> > From: Michael Meskes [mailto:meskes(at)postgresql(dot)org]
> > Sent: 26 September 2006 10:39
> > To: Dave Page
> > Cc: Joachim Wieland; pgsql-hackers(at)postgresql(dot)org
> > Subject: Re: [HACKERS] Buildfarm alarms
> >
> > On Tue, Sep 26, 2006 at 09:57:16AM +0100, Dave Page wrote:
> > > OK, I now see just one, date format related failure:
> > > ...
> >
> > Did you run it with Joachim's patch or with up-to-date CVS
> > checkout? It
> > seems to me that you do not have the latest changes to CVS.
> We added a
> > "set datestyle" to variable.pgc that should fix this failure.
>
> No, I used Joachim's patch as anoncvs hadn't caught up. I'll run it
> again - thanks.

Yep - passes all tests now :-)

Thanks, Dave.