Yet another error message
Join Date: Sep 2007
Posts: 85
" PokerStars: Unable to import hand (#29005360992). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 403 of relation "tourney_holdem_hand_summary" CONTEXT: COPY tourney_holdem_hand_summary, line 1: "467 100 285 9 1692 29005360992 2009/06/05 03:32:35 2009/06/05 11:52:34 7 2 0 0 1290.00 2230.00 0.00 ..." )"
So, what do I do this time, guy?
See our Commercial Software thread
Join Date: May 2005
Posts: 6,489
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.
Join Date: Sep 2007
Posts: 85
much thanks. This did happen because of a faulty drive.
thanks for the quick response.