cannot read block 432382 of audit: Success

[gkhangelani]

Hi


How would I fix an error below:


server.log file :



2010-03-07 15:46:40,220 DEBUG [ucs.instore.ejb .debtors.Accoun tSessionBean] getNcaHpAccount Events query =
SELECT hp_tran.cus_acn o, hp_tran.hp_sub_ acno,date(audit .aud_doc_ts) as aud_doc_ts, sum(hptran_amt) as amount, audit.act_typ FROM hp_doc JOIN hp_tran on hp_tran.hpdoc_i d = hp_doc.hpdoc_id JOIN audit USING (aud_id) JOIN audmth USING (aud_id) WHERE hpdoc_is_fin is true AND audit.act_typ not in ( 4276, 4275, 4776 , 4775) GROUP BY hp_tran.cus_acn o, hp_tran.hp_sub_ acno,date(audit .aud_doc_ts), audit.act_typ ORDER BY hp_tran.cus_acn o, hp_tran.hp_sub_ acno,date(audit .aud_doc_ts)
2010-03-07 15:48:49,626 INFO [ucs.instore.ejb .debtors.Accoun tSessionBean] EJBERROR - Cause null
2010-03-07 15:48:49,664 INFO [ucs.instore.ejb .debtors.Accoun tSessionBean] - File QueryExecutor.j ava
2010-03-07 15:48:49,664 INFO [ucs.instore.ejb .debtors.Accoun tSessionBean] - Class org.postgresql. core.QueryExecu tor
2010-03-07 15:48:49,664 INFO [ucs.instore.ejb .debtors.Accoun tSessionBean] - Method execute
2010-03-07 15:48:49,665 INFO [ucs.instore.ejb .debtors.Accoun tSessionBean] - Line 131
2010-03-07 15:48:49,665 INFO [ucs.instore.ejb .debtors.Accoun tSessionBean] - Native false
2010-03-07 15:48:49,665 ERROR [ucs.instore.ejb .debtors.Accoun tSessionBean] EJB ERROR Info :
java.sql.SQLExc eption: ERROR: cannot read block 432382 of audit: Success



There is table called audit. This tables keeps all the transaction numbers generated by the system. It looks like there is 4 audits that got corrupted, see below:


db0305=# SELECT * from audit where aud_id = 3283031;
ERROR: cannot read block 432382 of audit: Success
db0305=# SELECT * from audit where aud_id = 3283032;
ERROR: cannot read block 432382 of audit: Success
db0305=# SELECT * from audit where aud_id = 3283033;
ERROR: cannot read block 432382 of audit: Success
db0305=#
db0305=#
db0305=#
db0305=# SELECT * from audit where aud_id = 3283034;
ERROR: cannot read block 432382 of audit: Success
db0305=# SELECT * from audit where aud_id = 3283035;




This machine is running on PostgreSQL7.3.4 in CentOS version




Please assist, please explain it in simple terms or you can refer me to a relevent document

[rski]

ERROR: cannot read block 432382

did you have any problems with disk? Did you check disk for bad blocks?

[gkhangelani]

No, the disc didn't have problems, like dmessages didn't give any errors. we ended up restoring from the back up, of which it's not what we want because it takes a long time because you have copy a dump file from a backup machine which is far away from the affected server.

[rski]

Do you have any indexes on that table if so try to delete them and recreate.

And run fsck to check the disk

[gkhangelani]

Many Thanks, I will try that.

[jkukard]

Question

Hi Kanga,

If you find out how to fix this, I have found the same problem with another branch. Please give me a call.

[gkhangelani]

Try to REINDEX the table affected and also try to reindex the whole database.... I didn't find the solution in my previous problem I had. we restored the database from the back up server.

[jkukard]

Ok thanks. Perhaps I'll just assign the log to DB services.

By the way, are there any Nik Naks in the vending machine?

[gkhangelani]

there are Nik Naks james in vending machine, u might as well help yourself