From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Khangelani Gama <Khangelani(dot)Gama(at)ucs-software(dot)co(dot)za> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: ERROR: cannot read block 15157 of hp_tran: Success |
Date: | 2010-04-15 17:54:48 |
Message-ID: | 4987.1271354088@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Khangelani Gama <Khangelani(dot)Gama(at)ucs-software(dot)co(dot)za> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Khangelani Gama | 2010-04-15 18:20:06 | Re: ERROR: cannot read block 15157 of hp_tran: Success |
Previous Message | Khangelani Gama | 2010-04-15 17:41:34 | ERROR: cannot read block 15157 of hp_tran: Success |