Updated to 4.11 now stuck "updating database"

[Adreno]

Kraada, as much as I would love to help you betatest your new software, my priority right now is to be able to play poker. I love PokerTracker and I'm excited to see all these new features and updates, but right now I just want to play poker and I figure it's going to be easier to get the old version working again than it is to get the new version working. Can you please help me do that?

So I installed PokerTracker v4.10.9 over the new version, restored my database from backup, hit "start getting hands" and there was 2 new hands I played on ipoker like 20 minutes ago. It looked like the hands weren't getting imported so I hit "stop getting hands" - this caused PokerTracker to go sluggish / semi unresponsive. I thought it crashed but this time I let it run for like 10 minutes. Then this message appeared:

03:54:56 pm: Error: iPoker: Unable to import hand (#5731605718). Reason: Unable to execute query: EXECUTE cash_cache_insert(1,1,1,2,0,false,false,false,201247,0.00000000000000000000,4.00,3.0828000000,0.00000000000000000000,0.00,0.0000000000,0,0,0.0000000000000000000000,0.000000000000000000000000000000,0.00,0.0000000000,0.00,0.0000000000,0.0000000000000000000000,0.000000000000000000000000000000,0.00,0.0000000000,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,3,0,0,0,0,0,1,1,0,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,4,0,4,0,0,4,0,4,0,0,0,0,0,0,0,0,0,4,4,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,4,0,4,0,0,0,0,0,0,0,0,4,0,4,1,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,4,0,3,0,0,0,0,0,0,'USD',0,0,0,0,0);; Reason: Fatal Error (ERROR: invalid input syntax for integer: "USD" )

PokerTracker was still semi unresponsive. After about 5 more minutes, another similar message appeared, referring to the other hand (there were 2 new hands to be imported). Despite these errors, I can now see both hands in my database. Import status lists imported hands: 2 and errors: 2.

What is broken and how can I fix it to get version 4.10.9 working again?

[kraada]

That error is implying that the cache is not as PT4 expects it. A cache rebulid in 4.10.9 should fix it.

[Adreno]

I am now at "Updating Cache".

The progress bar started at 50%, is at 50% now, elapsed time and estimated time both read "0:00:00" and nothing is changing. I read from the other thread that a cache rebuild will take a really long time, possibly days?

[kraada]

Did you start with Logging Enabled? If so you can check in the log file to see exactly where it is percentage wise and exactly when the log file was last updated.

[Adreno]

I stopped the Cache update, made a new database, imported all 2014 hands and this time I was able to set my aliases & able to import the 2 new hands into my database. Everything seems to work, trying to import 2013 hands now, if it still works maybe I can play some poker tonight.

[kraada]

Sounds good, it should work now going forward.

[Seitz333]

I restarted the processes manually. I ran the Rebuild Cache, only took about 1-2min. I am getting an error on importing all hands I played last night that I had not imported yet. I'm waiting for Carbon to come back up (they are down at the moment) and try importing some new hands. Here is the error:

10:47:10 am: Error: Merge: Unable to import hand (#77136961-56). Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: duplicate key value violates unique constraint "tourney_cache_primary_key" DETAIL: Key (id_player, id_gametype, id_blinds, cnt_players, position_type, flg_has_position_f, flg_has_position_t, flg_has_position_r, date_played_year_week)=(1, 1, 1, 7, 5, t, t, t, 201206) already exists. CONTEXT: SQL statement "INSERT INTO tourney_cache VALUES(playerdata.id_player, playerdata.id_gametype, playerdata.id_blinds, playerdata.cnt_players,playerdata.position_type::integer,playerdata.flg_has_position_f::boolean,playerdata.flg_has_position_t::boolean,playerdata.flg_has_position_r::boolean,playerdata.date_played_year_week::integer,playerdata.amt_bb_won::numeric(14,2),playerdata.amt_blind::numeric(14,2),playerdata.amt_chips_won::numeric(14,2),playerdata.amt_expected_bb_won::numeric(14,2),playerdata.amt_expected_won::numeric(14,2),playerdata.amt_r_call::numeric(14,2),playerdata.amt_r_call_won::numeric(14,2),playerdata.cnt_blind::integer,playerdata.cnt_f_2bet_def_action_call::integer,playerdata.cnt_f_2bet_def_action_fold::integer,playerdata.cnt_f_3bet::integer,playerdata.cnt_f_3bet_def_action_call::integer,playerdata.cnt_f_3bet_def_action_fold::integer,playerdata.cnt_f_3bet_def_opp::integer,playerdata.cnt_f_3bet_opp::integer,playerdata.cnt_f_4bet::integer,playerdata.cnt_f_4bet_def_action_call::integer,playerdata.cnt_f_4bet_def_action_fold::integer,playerdata.cnt_f_4bet_def_opp::integer,playerdata.cnt_f_4bet_opp::integer,playerdata.cnt_f_allin::integer,playerdata.cnt_f_allin_valid::integer,playerdata.cnt_f_bet::integer,playerdata.cnt_f_bet_def_action_call::integer,playerdata.cnt_f_bet_def_action_fold::integer,playerdata.cnt_f_bet_def_action_raise::integer,playerdata.cnt_f_bet_def_opp::integer,playerdata.cnt_f_bet_limp_pot::integer,playerdata.cnt_f_call::integer,playerdata.cnt_f_cbet::integer,playerdata.cnt_f_cbet_3bet_pot::integer,playerdata.cnt_f_cbet_def_action_call::integer,playerdata.cnt_f_cbet_def_action_call_in_pos::integer,playerdata.cnt_f_cbet_def_action_call_out_of_pos::integer,playerdata.cnt_f_cbet_def_action_fold::integer,playerdata.cnt_f_cbet_def_action_fold_in_pos::integer,playerdata.cnt_f_cbet_def_action_fold_out_of_pos::integer,playerdata.cnt_f_cbet_def_action_raise::integer,playerdata.cnt_f_cbet_def_action_raise_in_pos::integer,playerdata.cnt_f_cbet_def_action_raise_out_of_pos::integer,playerdata.cnt_f_cbet_def_opp::integer,playerdata.cnt_f_cbet_face_raise::integer,playerdata.cnt_f_cbet_face_raise_3bet_pot::integer,playerdata.cnt_f_cbet_fold_to_raise::integer,playerdata.cnt_f_cbet_fold_to_raise_3bet_pot::integer,playerdata.cnt_f_cbet_opp::integer,playerdata.cnt_f_cbet_opp_3bet_pot::integer,playerdata.cnt_f_cbet_success::integer,playerdata.cnt_f_check::integer,playerdata.cnt_f_check_raise::integer,playerdata.cnt_f_check_raise_opp::integer,playerdata.cnt_f_donk::integer,playerdata.cnt_f_donk_3bet_pot::integer,playerdata.cnt_f_donk_def_opp::integer,playerdata.cnt_f_donk_def_opp_3bet_pot::integer,playerdata.cnt_f_donk_def_opp_action_call::integer,playerdata.cnt_f_donk_def_opp_action_fold::integer,playerdata.cnt_f_donk_def_opp_action_fold_3bet_pot::integer,playerdata.cnt_f_donk_def_opp_action_raise::integer,playerdata.cnt_f_donk_def_opp_action_raise_3bet_pot::integer,playerdata.cnt_f_donk_face_raise::integer,playerdata.cnt_f_donk_fold::integer,playerdata.cnt_f_donk_opp::integer,playerdata.cnt_f_donk_opp_3bet_pot::integer,playerdata.cnt_f_face_xr::integer,playerdata.cnt_f_face_xr_call::integer,playerdata.cnt_f_face_xr_fold::integer,playerdata.cnt_f_face_xr_raise::integer,playerdata.cnt_f_float::integer,playerdata.cnt_f_float_3bet_pot::integer,playerdata.cnt_f_float_def_opp::integer,playerdata.cnt_f_float_def_opp_action_call::integer,playerdata.cnt_f_float_def_opp_action_fold::integer,playerdata.cnt_f_float_def_opp_action_raise::integer,playerdata.cnt_f_float_face_raise::integer,playerdata.cnt_f_float_fold::integer,playerdata.cnt_f_float_opp::integer,playerdata.cnt_f_float_opp_3bet_pot::integer,playerdata.cnt_f_fold::integer,playerdata.cnt_f_open_opp_limp_pot::integer,playerdata.cnt_f_raise::integer,playerdata.cnt_f_raise_def_opp::integer,playerdata.cnt_f_saw::integer,playerdata.cnt_f_saw_won::integer,playerdata.cnt_hands::integer,playerdata.cnt_hands_won::integer,playerdata.cnt_p_2bet_def_action_call::integer,playerdata.cnt_p_2bet_def_action_fold::integer,playerdata.cnt_p_2bet_def_opp::integer,playerdata.cnt_p_2bet_def_opp_vs_btn_open::integer,playerdata.cnt_p_2bet_def_opp_vs_co_open::integer,playerdata.cnt_p_3bet::integer,playerdata.cnt_p_3bet_def_action_call::integer,playerdata.cnt_p_3bet_def_action_call_after_2b::integer,playerdata.cnt_p_3bet_def_action_fold::integer,playerdata.cnt_p_3bet_def_action_fold_when_open_raised::integer,playerdata.cnt_p_3bet_def_action_fold_when_open_raised_ip::integer,playerdata.cnt_p_3bet_def_action_fold_when_open_raised_oop::integer,playerdata.cnt_p_3bet_def_opp::integer,playerdata.cnt_p_3bet_def_opp_after_2b::integer,playerdata.cnt_p_3bet_def_opp_when_open_raised::integer,playerdata.cnt_p_3bet_def_opp_when_open_raised_ip::integer,playerdata.cnt_p_3bet_def_opp_when_open_raised_oop::integer,playerdata.cnt_p_3bet_f_cbet_def_action_call::integer,playerdata.cnt_p_3bet_f_cbet_def_action_fold::integer,playerdata.cnt_p_3bet_f_cbet_def_action_raise::integer,playerdata.cnt_p_3bet_f_cbet_def_opp::integer,playerdata.cnt_p_3bet_opp::integer,playerdata.cnt_p_3bet_opp_vs_bb_2bet::integer,playerdata.cnt_p_3bet_opp_vs_btn_2bet::integer,playerdata.cnt_p_3bet_opp_vs_btn_open::integer,playerdata.cnt_p_3bet_opp_vs_co_2bet::integer,playerdata.cnt_p_3bet_opp_vs_co_open::integer,playerdata.cnt_p_3bet_opp_vs_ep_2bet::integer,playerdata.cnt_p_3bet_opp_vs_mp_2bet::integer,playerdata.cnt_p_3bet_opp_vs_sb_2bet::integer,playerdata.cnt_p_3bet_r_cbet_def_action_call::integer,playerdata.cnt_p_3bet_r_cbet_def_action_fold::integer,playerdata.cnt_p_3bet_r_cbet_def_action_raise::integer,playerdata.cnt_p_3bet_r_cbet_def_opp::integer,playerdata.cnt_p_3bet_success::integer,playerdata.cnt_p_3bet_t_cbet_def_action_call::integer,playerdata.cnt_p_3bet_t_cbet_def_action_fold::integer,playerdata.cnt_p_3bet_t_cbet_def_action_raise::integer,playerdata.cnt_p_3bet_t_cbet_def_opp::integer,playerdata.cnt_p_3bet_vs_bb_2bet::integer,playerdata.cnt_p_3bet_vs_btn_2bet::integer,playerdata.cnt_p_3bet_vs_btn_open::integer,playerdata.cnt_p_3bet_vs_co_2bet::integer,playerdata.cnt_p_3bet_vs_co_open::integer,playerdata.cnt_p_3bet_vs_ep_2bet::integer,playerdata.cnt_p_3bet_vs_mp_2bet::integer,playerdata.cnt_p_3bet_vs_sb_2bet::integer,playerdata.cnt_p_4bet::integer,playerdata.cnt_p_4bet_after_raising::integer,playerdata.cnt_p_4bet_def_action_call::integer,playerdata.cnt_p_4bet_def_action_fold::integer,playerdata.cnt_p_4bet_def_action_fold_after_3b::integer,playerdata.cnt_p_4bet_def_opp::integer,playerdata.cnt_p_4bet_def_opp_after_3b::integer,playerdata.cnt_p_4bet_opp::integer,playerdata.cnt_p_4bet_opp_when_open_raised::integer,playerdata.cnt_p_5bet::integer,playerdata.cnt_p_5bet_def_action_fold::integer,playerdata.cnt_p_5bet_def_opp::integer,playerdata.cnt_p_5bet_opp::integer,playerdata.cnt_p_allin::integer,playerdata.cnt_p_allin_valid::integer,playerdata.cnt_p_bb_v_sb_3bet::integer,playerdata.cnt_p_bb_v_sb_3bet_opp::integer,playerdata.cnt_p_bb_v_sb_call::integer,playerdata.cnt_p_bb_v_sb_fold::integer,playerdata.cnt_p_call::integer,playerdata.cnt_p_call_vs_btn_open::integer,playerdata.cnt_p_call_vs_co_open::integer,playerdata.cnt_p_ccall::integer,playerdata.cnt_p_ccall_3bet::integer,playerdata.cnt_p_ccall_3bet_opp::integer,playerdata.cnt_p_ccall_opp::integer,playerdata.cnt_p_facing_limpers::integer,playerdata.cnt_p_fold::integer,playerdata.cnt_p_fold_vs_btn_open::integer,playerdata.cnt_p_fold_vs_co_open::integer,playerdata.cnt_p_limp::integer,playerdata.cnt_p_limp_call::integer,playerdata.cnt_p_limp_faceraise::integer,playerdata.cnt_p_limp_fold::integer,playerdata.cnt_p_limp_opp::integer,playerdata.cnt_p_limp_raise::integer,playerdata.cnt_p_open_opp::integer,playerdata.cnt_p_open_opp_btn::integer,playerdata.cnt_p_open_opp_ep::integer,playerdata.cnt_p_raise::integer,playerdata.cnt_p_raise_3bet::integer,playerdata.cnt_p_raise_first_in::integer,playerdata.cnt_p_raise_limpers::integer,playerdata.cnt_p_rfi_btn::integer,playerdata.cnt_p_rfi_ep::integer,playerdata.cnt_p_squeeze::integer,playerdata.cnt_p_squeeze_def_call::integer,playerdata.cnt_p_squeeze_def_fold::integer,playerdata.cnt_p_squeeze_def_opp::integer,playerdata.cnt_p_squeeze_def_raise::integer,playerdata.cnt_p_squeeze_opp::integer,playerdata.cnt_pfr::integer,playerdata.cnt_pfr_opp::integer,playerdata.cnt_prev_callers_limp::integer,playerdata.cnt_r_2bet_def_action_call::integer,playerdata.cnt_r_2bet_def_action_fold::integer,playerdata.cnt_r_3bet::integer,playerdata.cnt_r_3bet_def_action_call::integer,playerdata.cnt_r_3bet_def_action_fold::integer,playerdata.cnt_r_3bet_def_opp::integer,playerdata.cnt_r_3bet_opp::integer,playerdata.cnt_r_4bet::integer,playerdata.cnt_r_4bet_def_action_call::integer,playerdata.cnt_r_4bet_def_action_fold::integer,playerdata.cnt_r_4bet_def_opp::integer,playerdata.cnt_r_4bet_opp::integer,playerdata.cnt_r_allin::integer,playerdata.cnt_r_allin_valid::integer,playerdata.cnt_r_bet::integer,playerdata.cnt_r_bet_def_action_call::integer,playerdata.cnt_r_bet_def_action_fold::integer,playerdata.cnt_r_bet_def_action_raise::integer,playerdata.cnt_r_bet_def_opp::integer,playerdata.cnt_r_call::integer,playerdata.cnt_r_call_hands::integer,playerdata.cnt_r_cbet::integer,playerdata.cnt_r_cbet_3bet_pot::integer,playerdata.cnt_r_cbet_def_action_call::integer,playerdata.cnt_r_cbet_def_action_fold::integer,playerdata.cnt_r_cbet_def_action_raise::integer,playerdata.cnt_r_cbet_def_opp::integer,playerdata.cnt_r_cbet_face_raise::integer,playerdata.cnt_r_cbet_face_raise_3bet_pot::integer,playerdata.cnt_r_cbet_fold_to_raise::integer,playerdata.cnt_r_cbet_fold_to_raise_3bet_pot::integer,playerdata.cnt_r_cbet_opp::integer,playerdata.cnt_r_cbet_opp_3bet_pot::integer,playerdata.cnt_r_cbet_success::integer,playerdata.cnt_r_check::integer,playerdata.cnt_r_check_raise::integer,playerdata.cnt_r_check_raise_opp::integer,playerdata.cnt_r_donk::integer,playerdata.cnt_r_donk_3bet_pot::integer,playerdata.cnt_r_donk_def_action_call::integer,playerdata.cnt_r_donk_def_action_fold::integer,playerdata.cnt_r_donk_def_action_fold_3bet_pot::integer,playerdata.cnt_r_donk_def_action_raise::integer,playerdata.cnt_r_donk_def_opp::integer,playerdata.cnt_r_donk_def_opp_3bet_pot::integer,playerdata.cnt_r_donk_face_raise::integer,playerdata.cnt_r_donk_fold::integer,playerdata.cnt_r_donk_opp::integer,playerdata.cnt_r_donk_opp_3bet_pot::integer,playerdata.cnt_r_face_xr::integer,playerdata.cnt_r_face_xr_call::integer,playerdata.cnt_r_face_xr_fold::integer,playerdata.cnt_r_face_xr_raise::integer,playerdata.cnt_r_float::integer,playerdata.cnt_r_float_3bet_pot::integer,playerdata.cnt_r_float_def_action_call::integer,playerdata.cnt_r_float_def_action_fold::integer,playerdata.cnt_r_float_def_action_raise::integer,playerdata.cnt_r_float_def_opp::integer,playerdata.cnt_r_float_face_raise::integer,playerdata.cnt_r_float_fold::integer,playerdata.cnt_r_float_opp::integer,playerdata.cnt_r_float_opp_3bet_pot::integer,playerdata.cnt_r_fold::integer,playerdata.cnt_r_probe::integer,playerdata.cnt_r_probe_3bet_pot::integer,playerdata.cnt_r_probe_def_action_call::integer,playerdata.cnt_r_probe_def_action_fold::integer,playerdata.cnt_r_probe_def_action_raise::integer,playerdata.cnt_r_probe_def_opp::integer,playerdata.cnt_r_probe_face_raise::integer,playerdata.cnt_r_probe_fold::integer,playerdata.cnt_r_probe_opp::integer,playerdata.cnt_r_probe_opp_3bet_pot::integer,playerdata.cnt_r_raise::integer,playerdata.cnt_r_raise_wtsd::integer,playerdata.cnt_r_raise_wtsd_won::integer,playerdata.cnt_r_saw::integer,playerdata.cnt_steal_3bet_def_action_fold::integer,playerdata.cnt_steal_3bet_def_opp::integer,playerdata.cnt_steal_att::integer,playerdata.cnt_steal_att_lp::integer,playerdata.cnt_steal_att_sb::integer,playerdata.cnt_steal_def_3bet_opp::integer,playerdata.cnt_steal_def_3bet_opp_vs_lp::integer,playerdata.cnt_steal_def_action_call::integer,playerdata.cnt_steal_def_action_call_vs_lp::integer,playerdata.cnt_steal_def_action_fold::integer,playerdata.cnt_steal_def_action_fold_vs_lp::integer,playerdata.cnt_steal_def_action_raise::integer,playerdata.cnt_steal_def_action_raise_vs_lp::integer,playerdata.cnt_steal_def_opp::integer,playerdata.cnt_steal_def_opp_vs_lp::integer,playerdata.cnt_steal_opp::integer,playerdata.cnt_steal_opp_lp::integer,playerdata.cnt_steal_opp_sb::integer,playerdata.cnt_steal_reraise_def_action_fold::integer,playerdata.cnt_steal_reraise_def_opp::integer,playerdata.cnt_steal_success::integer,playerdata.cnt_t_2bet_def_action_call::integer,playerdata.cnt_t_2bet_def_action_fold::integer,playerdata.cnt_t_3bet::integer,playerdata.cnt_t_3bet_def_action_call::integer,playerdata.cnt_t_3bet_def_action_fold::integer,playerdata.cnt_t_3bet_def_opp::integer,playerdata.cnt_t_3bet_opp::integer,playerdata.cnt_t_4bet::integer,playerdata.cnt_t_4bet_def_action_call::integer,playerdata.cnt_t_4bet_def_action_fold::integer,playerdata.cnt_t_4bet_def_opp::integer,playerdata.cnt_t_4bet_opp::integer,playerdata.cnt_t_allin::integer,playerdata.cnt_t_allin_showdown::integer,playerdata.cnt_t_allin_valid::integer,playerdata.cnt_t_bet::integer,playerdata.cnt_t_bet_def_action_call::integer,playerdata.cnt_t_bet_def_action_fold::integer,playerdata.cnt_t_bet_def_action_raise::integer,playerdata.cnt_t_bet_def_opp::integer,playerdata.cnt_t_call::integer,playerdata.cnt_t_cbet::integer,playerdata.cnt_t_cbet_3bet_pot::integer,playerdata.cnt_t_cbet_def_action_call::integer,playerdata.cnt_t_cbet_def_action_fold::integer,playerdata.cnt_t_cbet_def_action_raise::integer,playerdata.cnt_t_cbet_def_opp::integer,playerdata.cnt_t_cbet_face_raise::integer,playerdata.cnt_t_cbet_face_raise_3bet_pot::integer,playerdata.cnt_t_cbet_fold_to_raise::integer,playerdata.cnt_t_cbet_fold_to_raise_3bet_pot::integer,playerdata.cnt_t_cbet_opp::integer,playerdata.cnt_t_cbet_opp_3bet_pot::integer,playerdata.cnt_t_cbet_success::integer,playerdata.cnt_t_check::integer,playerdata.cnt_t_check_raise::integer,playerdata.cnt_t_check_raise_opp::integer,playerdata.cnt_t_donk::integer,playerdata.cnt_t_donk_3bet_pot::integer,playerdata.cnt_t_donk_def_action_call::integer,playerdata.cnt_t_donk_def_action_fold::integer,playerdata.cnt_t_donk_def_action_fold_3bet_pot::integer,playerdata.cnt_t_donk_def_action_raise::integer,playerdata.cnt_t_donk_def_opp::integer,playerdata.cnt_t_donk_def_opp_3bet_pot::integer,playerdata.cnt_t_donk_face_raise::integer,playerdata.cnt_t_donk_fold::integer,playerdata.cnt_t_donk_opp::integer,playerdata.cnt_t_donk_opp_3bet_pot::integer,playerdata.cnt_t_face_xr::integer,playerdata.cnt_t_face_xr_call::integer,playerdata.cnt_t_face_xr_fold::integer,playerdata.cnt_t_face_xr_raise::integer,playerdata.cnt_t_float::integer,playerdata.cnt_t_float_3bet_pot::integer,playerdata.cnt_t_float_def_action_call::integer,playerdata.cnt_t_float_def_action_fold::integer,playerdata.cnt_t_float_def_action_raise::integer,playerdata.cnt_t_float_def_opp::integer,playerdata.cnt_t_float_face_raise::integer,playerdata.cnt_t_float_fold::integer,playerdata.cnt_t_float_opp::integer,playerdata.cnt_t_float_opp_3bet_pot::integer,playerdata.cnt_t_fold::integer,playerdata.cnt_t_probe::integer,playerdata.cnt_t_probe_3bet_pot::integer,playerdata.cnt_t_probe_def_action_call::integer,playerdata.cnt_t_probe_def_action_fold::integer,playerdata.cnt_t_probe_def_action_raise::integer,playerdata.cnt_t_probe_def_opp::integer,playerdata.cnt_t_probe_face_raise::integer,playerdata.cnt_t_probe_fold::integer,playerdata.cnt_t_probe_opp::integer,playerdata.cnt_t_probe_opp_3bet_pot::integer,playerdata.cnt_t_raise::integer,playerdata.cnt_t_raise_wtsd::integer,playerdata.cnt_t_raise_wtsd_won::integer,playerdata.cnt_t_saw::integer,playerdata.cnt_vpip::integer,playerdata.cnt_vpip_sb::integer,playerdata.cnt_walks::integer,playerdata.cnt_won_hand::integer,playerdata.cnt_wtsd::integer,playerdata.cnt_wtsd_non_small::integer,playerdata.cnt_wtsd_won::integer,playerdata.cnt_wtsd_won_non_small::integer,playerdata.cnt_wtsd_won_when_r_call::integer,playerdata.val_equity::numeric(14,2),playerdata.val_f_equity::numeric(14,2),playerdata.val_p_equity::numeric(14,2),playerdata.val_r_equity::numeric(14,2),playerdata.val_t_equity::numeric(14,2))" PL/pgSQL function "update_tourney_cache" line 35 at SQL statement )

[kraada]

Could you please check your custom columns via Configure -> Statistics -> Columns and set the combo box at the bottom left to show Custom Only. Make sure none of the columns that use any live data are set to be Cached. If any got incorrectly flagged to be cached it could cause this kind of error.

[Bajnok]

it is still updating for 18 hours... i have 10M hands in my database...
what should i do? i would like to play!

[kraada]

What are the specs on your system? Are you on an SSD or HDD?