Re: cvs head initdb hangs on unixware

Dear all,
On Mon, 8 Dec 2008, Heikki Linnakangas wrote:

> Date: Mon, 08 Dec 2008 09:17:52 +0200
> From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
> To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Cc: ohp(at)pyrenet(dot)fr, Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>,
> pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
> Subject: Re: [HACKERS] cvs head initdb hangs on unixware
>
> Tom Lane wrote:
>> ohp(at)pyrenet(dot)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(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)