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.
--------------------------------------------------------------------------- [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > ------------------------------------------------------------------------------ > 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
