what's that error?

"Henrik Steffen" <steffen@city-map.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

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@topconcepts.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@sss.pgh.pa.us>
To: "Henrik Steffen" <steffen@city-map.de>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, November 21, 2002 3:50 PM
Subject: Re: [GENERAL] what's that error?