ERROR: cannot read block 15157 of hp_tran: Success

From: Khangelani Gama <Khangelani(dot)Gama(at)ucs-software(dot)co(dot)za>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: ERROR: cannot read block 15157 of hp_tran: Success
Date: 2010-04-15 17:41:34
Message-ID: D78A8169F9436B4DB978300336168F3B3359AFDF1D@SWBREXCH00.ucs-software.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Please help

Please bear with us we are in process of upgrade but many servers are still using version 7.3.4 of PostgreSQL running on RedHat5

A certain table seems to be corrupt when trying to select everything from this table, it throws out an error. See the error below

db0303=# SELECT count(*) from hp_tran;
ERROR: cannot read block 15157 of hp_tran: Success
db0303=#

There is no problem with the disc

Please assist, I am a Juniour DBA,

Confidentiality Notice:http://ucs.co.za/conf.html

________________________________
The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential information of UCS Group and/or its subsidiaries. Any review, use or dissemination thereof by anyone other than the intended addressee is prohibited. If you are not the intended addressee please notify the writer immediately and destroy the e-mail. UCS Group Limited and its subsidiaries distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-04-15 17:54:48 Re: ERROR: cannot read block 15157 of hp_tran: Success
Previous Message Kevin Grittner 2010-04-15 17:27:31 Re: Query is stuck