Dear Bruce,

Thanks for your reply, I was desperate I did'nt get one!

As I said, I'm quite sure there is a bug in pthread library, Before saying
this to SCO, I have to prove it. Postgresql is the way to prove it!

What I need is to know where to start from (I'd like to put elogs where
statement_timeout is processed to see what really happens and why it
doesn't cancel the query).

Could someone tell me where to look for? If anyone is interessed in
debugging this issue with me, I can set up  an account on a test unixware
machine.

TIA
 On Tue, 26 Oct 2004, Bruce Momjian wrote:

> Date: Tue, 26 Oct 2004 17:59:17 -0400 (EDT)
> From: Bruce Momjian <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Unixware 714 pthreads
>
>
> 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
> >
>
>

-- 
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 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to