getting error when importing hands as observer on full tilt

[themightyjim2k]

consistently getting this error about once ever 10-15 hands.


2008/08/07 14:25:14: Full Tilt: Unable to import hand (#7549121194). Reason: Unable to execute query: COPY holdem_hand_player_detail FROM STDIN;; Reason: Fatal Error (ERROR: index "hhpd:idx2-id_player" contains unexpected zero page at block 11764 HINT: Please REINDEX it. CONTEXT: COPY holdem_hand_player_detail, line 5: "736438 15623 5 0 0 4645.25 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1 0 0 0 f f f f f f f f f f f f f 35.0..." )

any suggestions?

thanks

[keggler]

you may have db corruption - might be worth backing off the db with pg_dumpall, creating a new db, and psql'ing the dump back to the new db...


susan

[themightyjim2k]

thanks for the help.

any chance you know how I could figure out if that is the problem, and then maybe could give me some directions on how to fix it.

sorry but I still don't know PT3 very well.

[themightyjim2k]

I just vaccuumed and clustered the DB and now I'm not getting the error. we'll see if that was the problem.