ERROR: cannot read block 15157 of hp_tran: Success

--_000_D78A8169F9436B4DB978300336168F3B3359AFDF1DSWBREXCH00u cs_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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 t=
his table, it throws out an error. See the error below

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



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 address=
ee only, and may contain the confidential information of UCS Group and/or i=
ts subsidiaries. Any review, use or dissemination thereof by anyone other t=
han the intended addressee is prohibited. If you are not the intended addre=
ssee please notify the writer immediately and destroy the e-mail. UCS Group=
Limited and its subsidiaries distance themselves from and accept no liabil=
ity for unauthorised use of their e-mail facilities or e-mails sent other t=
han strictly for business purposes.

--_000_D78A8169F9436B4DB978300336168F3B3359AFDF1DSWBREXCH00u cs_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">

>

Re: ERROR: cannot read block 15157 of hp_tran: Success

Khangelani Gama writes:
> 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

Egad...

> 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

This probably indicates that the table has been truncated in mid-block,
ie the file isn't a multiple of 8K long. Recent versions of PG would
give you a message that made that clearer, but I don't think 7.3 will.
You could try using dd to pad the file out to the next 8K boundary
(with zeroes), but I expect you'll find that the data on that page
is trashed and you'll have to truncate it away instead in order to not
get errors.

> There is no problem with the disc

If the underlying OS is as unmaintained as the database is, you might
well be encountering kernel bugs :-(

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: ERROR: cannot read block 15157 of hp_tran: Success

Thanks Tom

...but could you please supply with an example on how I should pad the file =
using dd?


-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql=
..org] On Behalf Of Tom Lane
Sent: Thursday, April 15, 2010 7:55 PM
To: Khangelani Gama
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] ERROR: cannot read block 15157 of hp_tran: Success

Khangelani Gama writes:
> Please bear with us we are in process of upgrade but many servers are sti=
ll using version 7.3.4 of PostgreSQL running on RedHat5

Egad...

> 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=3D# SELECT count(*) from hp_tran;
> ERROR: cannot read block 15157 of hp_tran: Success

This probably indicates that the table has been truncated in mid-block,
ie the file isn't a multiple of 8K long. Recent versions of PG would
give you a message that made that clearer, but I don't think 7.3 will.
You could try using dd to pad the file out to the next 8K boundary
(with zeroes), but I expect you'll find that the data on that page
is trashed and you'll have to truncate it away instead in order to not
get errors.

> There is no problem with the disc

If the underlying OS is as unmaintained as the database is, you might
well be encountering kernel bugs :-(

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin