Re: !!!!!UrgentERROR: cannot read block 95 of t : Input/output error
| От | Goulet, Dick |
|---|---|
| Тема | Re: !!!!!UrgentERROR: cannot read block 95 of t : Input/output error |
| Дата | |
| Msg-id | 4001DEAF7DF9BD498B58B45051FBEA656D7FED@25exch1.vicorpower.vicr.com обсуждение исходный текст |
| Ответ на | !!!!!UrgentERROR: cannot read block 95 of t : Input/output error ("Priya G" <sreepriya@hotmail.com>) |
| Список | pgsql-admin |
Sounds like what we in Oracle land would call a corrupt block. It also sounds like it's an index block that got messed up. I'd try dropping and rebuilding the index if possible before hitting the panic button. As a quick check try selecting all of the rows out of the table without a where clause. If that succeeds you can be assured that data is safe, just the index got trashed. Therefore, drop the index, vacuum the table, and rebuild the index.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Priya G [mailto:sreepriya@hotmail.com]
Sent: Tuesday, January 06, 2004 11:27 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] !!!!!UrgentERROR: cannot read block 95 of t : Input/output errorHelp needed please--ERROR: cannot read block 2 of pg_toast_17939_idx: Input/output error"what does this mean?.After some investigation found out that this happened after a vacuum of a tablevacuum t;
ERROR: cannot read block 95 of t: Input/output errorSomebody please help to fix this problemThanks,Pnair
Check your PC for viruses with the FREE McAfee online computer scan.
В списке pgsql-admin по дате отправления: