Thread: what's that error?

what's that error?

From
"Henrik Steffen"
Date:
while vacuuming I got:

ERROR:  cannot open segment 1 of relation basiseintrag_firma_idx (target block 808923185): No such file or directory


--

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
--------------------------------------------------------


Re: what's that error?

From
Tom Lane
Date:
"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

Re: what's that error?

From
"Henrik Steffen"
Date:
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?


> "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
>