pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
!!!!!UrgentERROR: cannot read block 95 of t : Input/output error 2+ messages / 2 participants [nested] [flat]
* !!!!!UrgentERROR: cannot read block 95 of t : Input/output error @ 2004-01-06 16:26 Priya G <sreepriya@hotmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Priya G @ 2004-01-06 16:26 UTC (permalink / raw) To: pgsql-admin <html><div style='background-color:'><DIV class=RTE>Help needed please--</DIV> <DIV class=RTE> </DIV> <DIV class=RTE><STRONG>ERROR: cannot read block 2 of pg_toast_17939_idx: Input/output error" </STRONG></DIV> <DIV class=RTE> </DIV> <DIV class=RTE>what does this mean?.</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>After some investigation found out that this happened after a vacuum of a table</DIV> <DIV class=RTE>vacuum t;<BR><STRONG>ERROR: cannot read block 95 of t: Input/output error<BR></STRONG></DIV> <DIV class=RTE> </DIV> <DIV class=RTE>Somebody please help to fix this problem</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>Thanks,</DIV> <DIV class=RTE>Pnair</DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMAENUS/2755??PS=">Check your PC for viruses with the FREE McAfee online computer scan.</a> </html> ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: !!!!!UrgentERROR: cannot read block 95 of t : Input/output error @ 2004-01-06 16:44 Goulet, Dick <DGoulet@vicr.com> 0 siblings, 0 replies; 2+ messages in thread From: Goulet, Dick @ 2004-01-06 16:44 UTC (permalink / raw) To: 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 error Help 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 table vacuum t; ERROR: cannot read block 95 of t: Input/output error Somebody please help to fix this problem Thanks, Pnair _____ Check your PC for viruses with <http://g.msn.com/8HMAENUS/2755??PS=; the FREE McAfee online computer scan. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-01-06 16:44 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-01-06 16:26 !!!!!UrgentERROR: cannot read block 95 of t : Input/output error Priya G <sreepriya@hotmail.com> 2004-01-06 16:44 Re: !!!!!UrgentERROR: cannot read block 95 of t : Input/output error Goulet, Dick <DGoulet@vicr.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox