HELP ......Fatal Error

[enchouenchou]

Reason: Unable to execute query: COPY holdem_hand_player_combinations FROM STDIN;; Reason: Fatal Error (ERROR: index "hhpc:idx2-id_player" contains unexpected zero page at block 3099 HINT: Please REINDEX it. CONTEXT: COPY holdem_hand_player_combinations, line 1: "3192706 23976 f f f f f f f


what'd I do ?? :?:

[WhiteRider]

Please try using the ReIndex option in Database > Housekeeping.

The second reason for this error is a result of faulty hardware. 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.

[enchouenchou]

Please try using the ReIndex option in Database > Housekeeping.

The second reason for this error is a result of faulty hardware. 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.

It has been 1~2 weeks
I just finish Housekeeping yesterday

the second reason It's too Difficulty I dont know how to do :cry:
my PostgreSQL is 8.4 ...HELP ME ><"

you should consider replacing it...mean...replacing PT3 or PostgreSQL ??

[WhiteRider]

Did you enable the ReIndex option when you ran housekeeping? That is not enabled by default so please try using that option.

The PostgreSQL.conf file isn't available through the Start menu for PostgreSQL versions after 8.3 but you can open it manually (using Notepad or any other plain text editor) from the folder:

C:\Program Files (x86)\PostgreSQL\8.4\data

If you use Windows 7 or Vista you will need to open Notepad by right clicking and choosing Run As Administrator in order to be able to save your changes.

If you continue to have problems with that hard drive, you should consider replacing it.

"it" refers to your hard drive. Sometimes this kind of error can indicate bad sectors on a drive, and that can mean that the drive is deteriorating.
Try running chkdsk to see if there are any problems with your drive. If there are, I'd suggest making a backup of any important data somewhere other than that drive (I'd suggest you do that anyway - even new drives can fail at any time without warning).

[enchouenchou]

ReIndex option ...ok I do again

Did you enable the ReIndex option when you ran housekeeping? That is not enabled by default so please try using that option.

The PostgreSQL.conf file isn't available through the Start menu for PostgreSQL versions after 8.3 but you can open it manually (using Notepad or any other plain text editor) from the folder:

C:\Program Files (x86)\PostgreSQL\8.4\data

If you use Windows 7 or Vista you will need to open Notepad by right clicking and choosing Run As Administrator in order to be able to save your changes.

If you continue to have problems with that hard drive, you should consider replacing it.

"it" refers to your hard drive. Sometimes this kind of error can indicate bad sectors on a drive, and that can mean that the drive is deteriorating.
Try running chkdsk to see if there are any problems with your drive. If there are, I'd suggest making a backup of any important data somewhere other than that drive (I'd suggest you do that anyway - even new drives can fail at any time without warning).

[enchouenchou]

I had finish housekeeping with Reindex

now......Cake: Error: No players listed (Hand #) (Hand #2798011406000886)
Cake: Error: Invalid button specified: 0 (Hand #) (Hand #2798011406000888)
:( :(

[WhiteRider]

Those are probably genuine errors in the hand histories - we see them from time to time in Cake hands. If you attach the files giving the errors to a Support ticket we'll check them out for you.

[enchouenchou]

SOS

Hand#2798011406000876 - Pebble Beach (6-Max) 11406 -- $0.25/$0.50 NL Hold'em -- 2011/12/04 - 03:00:08
Seat 2: marv***2 ($134.76 in chips) DEALER
Seat 3: Donk***3 ($17.77 in chips)
Seat 4: cake***4 ($9.25 in chips)
Seat 5: JUANYI ($11.08 in chips)
Seat 6: mzac***6 ($43.40 in chips)
Donk***3: posts small blind $0.25
cake***4: posts big blind $0.50
Dealt to JUANYI [Th,6h]
JUANYI: folds
mzac***6: raises to $1.50
marv***2: folds
Donk***3: folds
cake***4: folds
mzac***6: returns uncalled bet $1
***SHOW DOWN***
mzac***6: mucks
mzac***6: wins $1.25

Hand#2798011406000877 - Pebble Beach (6-Max) 11406 -- $0.25/$0.50 NL Hold'em -- 2011/12/04 - 03:00:33
Seat 2: marv***2 ($134.76 in chips)
Seat 3: Donk***3 ($17.52 in chips) DEALER
Seat 4: cake***4 ($8.75 in chips)
Seat 5: JUANYI ($11.08 in chips)
Seat 6: mzac***6 ($44.15 in chips)
Seat 7: Rese***7 ($0 in chips)
cake***4: posts small blind $0.25
JUANYI: posts big blind $0.50
Dealt to JUANYI [4c,9d]
mzac***6: folds
marv***2: folds
Donk***3: raises to $1.18
cake***4: folds
JUANYI: folds
Donk***3: returns uncalled bet $0.68
***SHOW DOWN***
Donk***3: mucks
Donk***3: wins $1.25

Hand#2798011406000878 - Pebble Beach (6-Max) 11406 -- $0.25/$0.50 NL Hold'em -- 2011/12/04 - 03:01:13
Seat 2: marv***2 ($134.76 in chips)
Seat 3: Donk***3 ($18.27 in chips)
Seat 4: cake***4 ($8.50 in chips) DEALER
Seat 5: JUANYI ($10.58 in chips)
Seat 6: mzac***6 ($44.15 in chips)
Seat 7: ????***7 ($30 in chips)
JUANYI: posts small blind $0.25
mzac***6: posts big blind $0.50
Dealt to JUANYI [5c,8h]
marv***2: folds
Donk***3: folds
cake***4: folds
JUANYI: folds
***SHOW DOWN***
mzac***6: mucks
mzac***6: wins $0.75

[WhiteRider]

Those hands all import fine for me. Please update to v3.11.6 Beta as there have been several fixes recently, including changes related to the new Cake software.

Download page
PT3 Build History / Release Notes

If you still have problems in v3.11.6 please attach the full original hand history file to a Support ticket so that we can investigate further. Often copy&pasting information like this can lose important information.

[enchouenchou]

NEW ERROR ...help!!!!!!!!

:45:24: Cake: Error: Invalid pot size/winnings for hand #10337892000352 (calculated pot: $890.00; reported winnings: $995.00) (Hand #10337892000352)
2011/12/08 15:45:26: Cake: Error: Invalid pot size/winnings for hand #2802011457001078 (calculated pot: $62.50; reported winnings: $22.80) (Hand #2802011457001078)