The only help I can be is that on Unixware (only) the backend is
compiled with threading enabled. This might be showing some thread
bugs.
---------------------------------------------------------------------------
ohp@pyrenet.fr wrote:
> Hi every one,
>
> I need help to debug the problem I have on Unixware 714 and beta3.
> postgresql make check hangs on plpgsql test when compiled with
> --enable-thread-safty.
>
> It does hang on select block_me();
>
> This select should be canceled by the set statement_timeout=1000, instead,
> the backend is 100% CPU bound and only kill -9 can kill it.
>
> It works ok when compiled without -enable-thread-safty.
>
> I've tried almost every thing I could think of, but not knowing so much
> about threads and PG source code, I request that someone can help me as to
> find a way to debug this. It worked up until beta2, but I'm not sure
> block_me()was there.
>
> I really need someone to tell me where to begin.
>
> TIA
>
> --
> 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)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073