Re: what's that error?

hi tom,

thanks for your answer. in fact, i succeeded in dropping and
then recreating the index without any problem.

it's such problems that do worry me, when they happen.

do you remember when i had such problems every day? we discussed it
on the list, and i finally changed the hardware...

and now, suddenly, there is another filesystem problem...

it's these things that worry me most. against programmer's bugs
i can create bugfixes -- but these system dependend stuff makes
me completely helpless.... :(

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, November 21, 2002 3:50 PM
Subject: Re: [GENERAL] what's that error?

> "Henrik Steffen" <steffen(at)city-map(dot)de> writes:
> > while vacuuming I got:
> > ERROR: cannot open segment 1 of relation basiseintrag_firma_idx (target block 808923185): No such file or directory
>
> Apparently you have a corrupted link pointer in that index. You can
> probably recover by reindexing basiseintrag_firma_idx.
>
> As for how it got that way, would need a lot more info to investigate.
>
> regards, tom lane
>