Re: Problems with 7.3.1
От | Olivier PRENANT |
---|---|
Тема | Re: Problems with 7.3.1 |
Дата | |
Msg-id | Pine.UW2.4.21.0212271255420.24349-100000@server обсуждение исходный текст |
Ответ на | Re: Problems with 7.3.1 (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Problems with 7.3.1
|
Список | pgsql-hackers |
Tom, I'm puzzled! I tried postgresql 7.3 and 7.3.1 and they both fail regressin when creating plpgsql language. However, when installed, createlang plpgsql template1 work like a charm. Could it be because the machine is slow (and disks too!) Regards,On Thu, 26 Dec 2002, Tom Lane wrote: > Date: Thu, 26 Dec 2002 13:44:51 -0500 > From: Tom Lane <tgl@sss.pgh.pa.us> > To: ohp@pyrenet.fr > Cc: pgsql-hackers list <pgsql-hackers@postgresql.org> > Subject: Re: [HACKERS] Problems with 7.3.1 > > Olivier PRENANT <ohp@pyrenet.fr> writes: > > Compile works ok however make check fails wile creating pl/pgsql with : > > WARNING: bt_getroot[pg_proc_proname_nsp_index]: fixing root page > > ERROR: bt_fixroot: not valid old root page. > > Wow. Is the behavior reproducible? How about if you go ahead and > install, and do a plain "make installcheck" (or even just try a manual > createlang in a fresh database)? > > That code thinks it is dealing with a concurrent index root page split, > but there couldn't be any concurrent operations happening during the > create-plpgsql step of a regression test run. Can you step through > _bt_getroot() (it's in src/backend/access/nbtree/nbtpage.c) and figure > out exactly how it's getting confused? > > If the behavior is reproducible I'm inclined to suspect a compiler bug; > it's hard to see how _bt_getroot could get so confused otherwise. > > regards, tom lane > -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) Quartier 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)
В списке pgsql-hackers по дате отправления: