Page 1 of 2

error importing after each hand

PostPosted: Tue Jun 01, 2010 9:02 pm
by OFFTITL
random problem arises after 2 yrs of working fine..

Error message after each hand it tries to import while i play:

Full Tilt: Unable to import hand (#21296506075). Reason: Unable to execute query: COPY holdem_hand_histories FROM STDIN;; Reason: Fatal Error (ERROR: could not extend relation base/16395/148142: Invalid argument HINT: Check free disk space. CONTEXT: COPY holdem_hand_histories, line 1: "993883 Full Tilt Poker Game #21296506075: Table Wood (6 max) - $0.25/$0.50 - No Limit Hold'em - 20:2..." )

I seem to have a couple of gigs of space on my hard drive so I dont think thats the problem.

Re: error importing after each hand

PostPosted: Wed Jun 02, 2010 9:57 am
by kraada
Have you tried freeing up any space on the drive to see if that helps?

Re: error importing after each hand

PostPosted: Wed Jun 02, 2010 5:06 pm
by OFFTITL
yes. it didn't help

Re: error importing after each hand

PostPosted: Wed Jun 02, 2010 5:24 pm
by OFFTITL
NEW ERROR MSG:

2010/06/02 14:14:24: Full Tilt: Unable to import hand (#21296875198). Reason: Unable to execute query: COPY holdem_hand_histories FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 44239 of relation base/16395/148142: Invalid argument CONTEXT: COPY holdem_hand_histories, line 1: "993957 Full Tilt Poker Game #21296875198: Table Wood (6 max) - $0.25/$0.50 - No Limit Hold'em - 20:4..." )

Re: error importing after each hand

PostPosted: Wed Jun 02, 2010 5:25 pm
by kraada
What version of PT3 are you currently running?

Re: error importing after each hand

PostPosted: Wed Jun 02, 2010 6:01 pm
by OFFTITL
v3.06.2

also, tournament import works but cash doesnt.

thanks for the help!

Re: error importing after each hand

PostPosted: Wed Jun 02, 2010 6:12 pm
by kraada
Try upgrading to 3.07.1 and see if that helps.

Re: error importing after each hand

PostPosted: Wed Jun 02, 2010 7:18 pm
by OFFTITL
didnt help

Re: error importing after each hand

PostPosted: Thu Jun 03, 2010 9:05 am
by kraada
Try 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. Then Start --> Programs --> PostgreSQL --> Stop Service followed by S -> P -> P -> Start Service and see if things work for you then.

Re: error importing after each hand

PostPosted: Thu Jun 03, 2010 9:37 pm
by OFFTITL
i dont see the option "configuration files"

highfalutin