Hi all,

I've been giving a shot to beta3 since yesterday.
make check produces a hang when testing the 14 parallel tests (limit...)
at that point, no tests ever returns, one postmaster is 100% cpu bound and
nothing occurs.

Beta2 was ok; I wonder what changed.
Also, I tried to compile with --enable-cassert, this causes a "symbol not
found" in createlang while make check.

Is there anything I can provide the list to help debug this?

TIA and regards

-- 
Olivier PRENANT        	        Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou           +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)

Sat, 9 Oct 2004 16:13:09 +0200 (MET DST)
ohp@pyrenet.fr
beta3 on unixware 714
ohp@pyrenet.fr writes:
> Also, I tried to compile with --enable-cassert, this causes a "symbol not
> found" in createlang while make check.

Sounds like picking up the wrong version of a shared library.

			regards, tom lane

Sat, 09 Oct 2004 11:19:51 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: beta3 on unixware 714 
On Sat, 9 Oct 2004, Tom Lane wrote:

> Date: Sat, 09 Oct 2004 11:19:51 -0400
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: ohp@pyrenet.fr
> Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] beta3 on unixware 714
>
> ohp@pyrenet.fr writes:
> > Also, I tried to compile with --enable-cassert, this causes a "symbol not
> > found" in createlang while make check.
>
> Sounds like picking up the wrong version of a shared library.
>
> 			regards, tom lane
>
not sure:
createlang: language installation failed: ERROR:  could not load library
 "/home/postgres/postgresql-snapshot/src/test/regress/./tmp_check/install//usr/local/pgsql/lib/plpgsql.so": dynamic linker: /home/postgres/postgresql-snapshot/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/postmaster: relocation error: symbol not found: assert_enabled; referenced from: /home/postgres/postgresql-snapshot/src/test/regress/./tmp_check/install//usr/local/pgsql/lib/plpgsql.so

gmake[2]: *** [check] Error 2
gmake[1]: *** [check] Error 2
gmake: *** [check] Error 2
UX:make: ERREUR: erreur irrï¿½mï¿½diable.
no old pgsql library involved (this is with snapshot but same message with
beta3)

As for the first part of my message (hang in make check)
the hang occurs when compiling with --enable-thread-safey and NOT
otherwise.

While I strongly suspect a SCO pthread bug, I'm at lost why it works
perfectly with beta1 and 2.

Did signal handling changed between beta2 and beta3?

Regards
-- 
Olivier PRENANT        	        Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou           +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)

Sat, 9 Oct 2004 17:37:12 +0200 (MET DST)
ohp@pyrenet.fr
Re: beta3 on unixware 714 
ohp@pyrenet.fr writes:
> not sure:
> createlang: language installation failed: ERROR:  could not load library
>  "/home/postgres/postgresql-snapshot/src/test/regress/./tmp_check/install//usr/local/pgsql/lib/plpgsql.so": dynamic linker: /home/postgres/postgresql-snapshot/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/postmaster: relocation error: symbol not found: assert_enabled; referenced from: /home/postgres/postgresql-snapshot/src/test/regress/./tmp_check/install//usr/local/pgsql/lib/plpgsql.so

Hmm.  That looks like trying to load an assert-enabled plpgsql.so into a
*not* assert-enabled backend.  You sure you built the whole thing with
asserts?

> As for the first part of my message (hang in make check)
> the hang occurs when compiling with --enable-thread-safey and NOT
> otherwise.
> While I strongly suspect a SCO pthread bug, I'm at lost why it works
> perfectly with beta1 and 2.
> Did signal handling changed between beta2 and beta3?

No, but Bruce has been fooling with the configure logic for threads,
IIRC, so it's quite possible that we are now supplying a different
set of compile or link switches, or a different set of libraries
requested in the link.  That's probably the first thing to look at.

			regards, tom lane

Sat, 09 Oct 2004 11:46:36 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: beta3 on unixware 714 
On Sat, 9 Oct 2004, Tom Lane wrote:

> Date: Sat, 09 Oct 2004 11:46:36 -0400
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: ohp@pyrenet.fr
> Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] beta3 on unixware 714
>
> ohp@pyrenet.fr writes:
> > not sure:
> > createlang: language installation failed: ERROR:  could not load library
> >  "/home/postgres/postgresql-snapshot/src/test/regress/./tmp_check/install//usr/local/pgsql/lib/plpgsql.so": dynamic linker: /home/postgres/postgresql-snapshot/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/postmaster: relocation error: symbol not found: assert_enabled; referenced from: /home/postgres/postgresql-snapshot/src/test/regress/./tmp_check/install//usr/local/pgsql/lib/plpgsql.so
>
> Hmm.  That looks like trying to load an assert-enabled plpgsql.so into a
> *not* assert-enabled backend.  You sure you built the whole thing with
> asserts?
Positive! (make distclean, configure, make;make check several times)
But it doesn't matter now with what you said below...
I wanted this to debug my thread bug...
Thanks anyway
>
> > As for the first part of my message (hang in make check)
> > the hang occurs when compiling with --enable-thread-safey and NOT
> > otherwise.
> > While I strongly suspect a SCO pthread bug, I'm at lost why it works
> > perfectly with beta1 and 2.
> > Did signal handling changed between beta2 and beta3?
>
> No, but Bruce has been fooling with the configure logic for threads,
> IIRC, so it's quite possible that we are now supplying a different
> set of compile or link switches, or a different set of libraries
> requested in the link.  That's probably the first thing to look at.
>
> 			regards, tom lane
>

-- 
Olivier PRENANT        	        Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou           +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)

Sat, 9 Oct 2004 17:49:27 +0200 (MET DST)
ohp@pyrenet.fr
Re: beta3 on unixware 714 
Dear all,

I'm still strugggling with beta3 on unixware 714
I now know for sure that make check/instalcheck hangs in plpgsql statement
select blockme();

this NEVER returns...

Any idea how to debug this? I guess it was not on beta2...

Regards
On Sat, 9 Oct 2004, Tom Lane wrote:

> Date: Sat, 09 Oct 2004 11:46:36 -0400
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: ohp@pyrenet.fr
> Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] beta3 on unixware 714
>
> ohp@pyrenet.fr writes:
> > not sure:
> > createlang: language installation failed: ERROR:  could not load library
> >  "/home/postgres/postgresql-snapshot/src/test/regress/./tmp_check/install//usr/local/pgsql/lib/plpgsql.so": dynamic linker: /home/postgres/postgresql-snapshot/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/postmaster: relocation error: symbol not found: assert_enabled; referenced from: /home/postgres/postgresql-snapshot/src/test/regress/./tmp_check/install//usr/local/pgsql/lib/plpgsql.so
>
> Hmm.  That looks like trying to load an assert-enabled plpgsql.so into a
> *not* assert-enabled backend.  You sure you built the whole thing with
> asserts?
>
> > As for the first part of my message (hang in make check)
> > the hang occurs when compiling with --enable-thread-safey and NOT
> > otherwise.
> > While I strongly suspect a SCO pthread bug, I'm at lost why it works
> > perfectly with beta1 and 2.
> > Did signal handling changed between beta2 and beta3?
>
> No, but Bruce has been fooling with the configure logic for threads,
> IIRC, so it's quite possible that we are now supplying a different
> set of compile or link switches, or a different set of libraries
> requested in the link.  That's probably the first thing to look at.
>
> 			regards, tom lane
>

-- 
Olivier PRENANT        	        Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou           +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)

Sun, 10 Oct 2004 20:11:29 +0200 (MET DST)
ohp@pyrenet.fr
Re: beta3 on unixware 714 