Re: cvs head initdb hangs on unixware - Mailing list pgsql-hackers

From ohp@pyrenet.fr
Subject Re: cvs head initdb hangs on unixware
Date
Msg-id Pine.UW2.4.63.0812081552520.17458@sun.pyrenet
Whole thread Raw
In response to Re: cvs head initdb hangs on unixware  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: cvs head initdb hangs on unixware
List pgsql-hackers
Dear all,
On Mon, 8 Dec 2008, Heikki Linnakangas wrote:

> Date: Mon, 08 Dec 2008 09:17:52 +0200
> From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
> To: Tom Lane <tgl@sss.pgh.pa.us>
> Cc: ohp@pyrenet.fr, Zdenek Kotala <Zdenek.Kotala@Sun.COM>,
>     pgsql-hackers list <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] cvs head initdb hangs on unixware
> 
> Tom Lane wrote:
>> ohp@pyrenet.fr writes:
>>> As you can see in attached initdb.log, it seems fsm_search_avail is called
>>> repeatedly and args are sort of looping...
>> 
>> That's expected, since the system is inserting a lot of tuples
>> successively. 
>
> Right. I suspect it was in the infinite loop yet. Try to run it for *much* 
> longer (it'll probably take much longer than usual because it's printing all 
> the debug stuff), until it gets stuck looping over the same pages in same 
> relation.
>
the infinite loop occurs in fsm_search_avail when called for the 32nd 
time.

It loops between restart: and goto restart

the long (95M) initdb.log can be found at 
ftp://ftp.pyrenet.fr/private/initdb.log
>

regards,

-- 
Olivier PRENANT                    Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges                +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)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: new vacuum is slower for small tables
Next
From: Andrew Chernow
Date:
Subject: Re: user-based query white list