Re: what's that error?
От | Henrik Steffen |
---|---|
Тема | Re: what's that error? |
Дата | |
Msg-id | 018101c2917d$ccd759c0$7100a8c0@STEINKAMP обсуждение исходный текст |
Ответ на | what's that error? ("Henrik Steffen" <steffen@city-map.de>) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: