help with error i am getting when i try to import...

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

help with error i am getting when i try to import...

Postby urm0msadictator » Mon Jul 09, 2012 12:34 pm

recently i left laptop on all nite after a session of mtt's and the laptop died in middle of nite while my pt3 still had auto import turned on. not sure if that has anything to do with this issue i am having now but fairly sure it is cus never had my laptop die during import and also have never had this error so figured i should tell ya that bit of info before i copy/paste a line of the error i am getting in my import status window...

2012/07/09 12:28:52: PokerStars: Unable to import hand (#83046749861). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 0 of relation 1663/16403/16713: read only 0 of 8192 bytes CONTEXT: COPY tourney_holdem_hand_summary, line 1: "590183 100 11026 9 9033 83046749861 2012/07/08 22:17:52 2012/07/09 12:28:50 9 2 2 2 1729.00 -0.00 -0..." )

this is what it is saying when i now try to import. tried to use it a bit during session yesterday and the hud was very slow to pop up if at all and also the hud boxes werent uder the right players like they normally are even after i made sure my preferred seating was still correct. so was figuring its some kinda bug or something got messed up when my laptop died the other nite. any help would really be appreciated cus i am not very good at fixing these kinds of things and this forum has always been a huge help with my pt3 issues. thanks again
urm0msadictator
 
Posts: 3
Joined: Sun Apr 03, 2011 5:31 am

Re: help with error i am getting when i try to import...

Postby kraada » Mon Jul 09, 2012 1:13 pm

Please follow this troubleshooting tutorial and that should get things working for you properly.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: help with error i am getting when i try to import...

Postby dakky316 » Tue Aug 21, 2012 1:26 pm

kraada wrote:Please follow this troubleshooting tutorial and that should get things working for you properly.



I ran the reindex and got this error, is it a hardware problem???

There were errors during the housekeeping process:
Unable to execute query: REINDEX DATABASE "PT3 DB"; Reason: Fatal Error (ERROR: invalid page header in block 88898 of relation "tourney_holdem_hand_player_detail" )
Unable to execute query: VACUUM;; Reason: Fatal Error (ERROR: invalid page header in block 88898 of relation "tourney_holdem_hand_player_detail" )
Unable to execute query: ANALYZE;; Reason: Fatal Error (ERROR: invalid page header in block 88902 of relation "tourney_holdem_hand_player_detail" )
Unable to execute query: SELECT DISTINCT id_player FROM tourney_holdem_hand_player_statistics;; Reason: Fatal Error (ERROR: invalid page header in block 65400 of relation "tourney_holdem_hand_player_statistics" )
dakky316
 
Posts: 16
Joined: Sun Jan 11, 2009 2:58 pm

Re: help with error i am getting when i try to import...

Postby kraada » Tue Aug 21, 2012 2:08 pm

Yes, please follow the remaining steps:

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 --> Reload Configuration and PostgreSQL will ignore the damaged data.
If you continue to have problems with that hard drive, you should consider replacing it.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 28 guests