Обсуждение: !!!!!UrgentERROR: cannot read block 95 of t : Input/output error

Поиск
Список
Период
Сортировка

!!!!!UrgentERROR: cannot read block 95 of t : Input/output error

От
"Priya G"
Дата:
<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><divclass="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">Somebodyplease help to fix this problem</div><div class="RTE"> </div><div class="RTE">Thanks,</div><div
class="RTE">Pnair</div></div><brclear="all" /><hr /><a href="http://g.msn.com/8HMAENUS/2755??PS=">Check your PC for
viruseswith the FREE McAfee online computer scan.</a> 

Re: !!!!!UrgentERROR: cannot read block 95 of t : Input/output error

От
"Goulet, Dick"
Дата:
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 the FREE McAfee online computer scan.

Re: !!!!!UrgentERROR: cannot read block 95 of t :

От
Oliver Elphick
Дата:
On Tue, 2004-01-06 at 16:26, Priya G wrote:
> Help needed please--
>
> ERROR:  cannot read block 2 of pg_toast_17939_idx: Input/output error"
> ERROR:  cannot read block 95 of t: Input/output error
>
>
> Somebody please help to fix this problem
>
Input/output error suggests that you urgently need a new disk.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Thou shalt not avenge, nor bear any grudge against the
      children of thy people, but thou shalt love thy
      neighbour as thyself. I am the LORD."
                                 Leviticus 19:18