Hi
How would I fix an error below:
server.log file :
2010-03-07 15:46:40,220 DEBUG [ucs.instore.ejb.debtors.AccountSessionBean] getNcaHpAccountEvents query =
SELECT hp_tran.cus_acno, 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_id = 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_acno, hp_tran.hp_sub_acno,date(audit.aud_doc_ts), audit.act_typ ORDER BY hp_tran.cus_acno, hp_tran.hp_sub_acno,date(audit.aud_doc_ts)
2010-03-07 15:48:49,626 INFO [ucs.instore.ejb.debtors.AccountSessionBean] EJBERROR - Cause null
2010-03-07 15:48:49,664 INFO [ucs.instore.ejb.debtors.AccountSessionBean] - File QueryExecutor.java
2010-03-07 15:48:49,664 INFO [ucs.instore.ejb.debtors.AccountSessionBean] - Class org.postgresql.core.QueryExecutor
2010-03-07 15:48:49,664 INFO [ucs.instore.ejb.debtors.AccountSessionBean] - Method execute
2010-03-07 15:48:49,665 INFO [ucs.instore.ejb.debtors.AccountSessionBean] - Line 131
2010-03-07 15:48:49,665 INFO [ucs.instore.ejb.debtors.AccountSessionBean] - Native false
2010-03-07 15:48:49,665 ERROR [ucs.instore.ejb.debtors.AccountSessionBean] EJB ERROR Info :
java.sql.SQLException: 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