April 23rd, 2013, 12:30 AM
Vacuum and Reindex Problem
I have a problem to run vacuum and reindex my db.
Everytime I run vacuum, it will stuck at a table.
ERROR: could not read block 76 of relation 1663/16385/545891: success
I will reindex the table and when I run vacuum again, it will stcu at another table
This problem will continue happen and I have no idea whats actually the error
I try to reindex database but the error comes out:
ERROR: could not read block 0 of relation 1663/16385/545909: Bad address
Can someone help?
April 23rd, 2013, 02:55 AM
I'd say your harddisk has an rror. Shutdown Postgres now and make a physical copy of the data directory (and other important data)
Originally Posted by firdzak
Then run some tool on the harddisk to detect and mark bad sectors.
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
Tips on how to ask better questions:
April 23rd, 2013, 11:36 PM
I will do the steps and update this thread if it is really hardware failure problem
June 17th, 2013, 12:51 AM
Forgot to update
It is really a hard disk problem and when we move to another hard disk, the error gone.
Thanks to shammat on this