PokerTracker

Hi,

when i want to do housekeeping in my database i get following errors:

Unable to execute query: CLUSTER;; Reason: Fatal Error (ERROR: invalid page header in block 82660 of relation "holdem_hand_player_detail" )
Unable to execute query: VACUUM FULL;; Reason: Fatal Error (ERROR: invalid page header in block 82660 of relation "holdem_hand_player_detail" )
Unable to execute query: ANALYZE;; Reason: Fatal Error (ERROR: invalid page header in block 82671 of relation "holdem_hand_player_detail" )
Unable to prepare query: INSERT INTO holdem_cache SELECT holdem_hand_player_statistics.id_player, holdem_hand_player_statistics.id_limit, holdem_hand_summary.cnt_players, ((case when( lookup_positions.flg_blinds) then 0 else (case when( lookup_positions.flg_ep) then 1 else (case when( lookup_positions.flg_mp) then 2 else 3 end) end) end)),
(sum( (CASE WHEN ( (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult)) 0 THEN ((holdem_hand_player_statistics.amt_won * 1.0 )/( (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult))) ELSE 0 END) )),

This only happens in one of my 2 databases. I think this database is broken, and I will try to create a new one and import the hands into this one.

but maybe someone can tell me why this error occurs.

This issue is often the result of faulty hardware or a system crash. You can set PostgreSQL to ignore these errors by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf. In the configuration file that appears, go to the bottom of the file and add the text "zero_damaged_pages = on" on a new line and then save and close the file. Click Start --> Programs --> PostgreSQL --> Stop Service and then Start --> Programs --> PostgreSQL --> Start Service and PostgreSQL will ignore the damaged data. If you continue to have problems with that hard drive, you should consider replacing it.