Problems w HUD & update cache problem

[JBMSweden]

HUD:s been working very badly and works sporadically. Upgraded postgres from 8.3 to 8.15. Still worked badly so I updated cache (allthough it showed 100%) and received a whole range of errors which began like this;

There were errors during the housekeeping process:
Unable to execute query: SELECT holdem_hand_player_statistics.id_player, holdem_hand_player_statistics.id_limit, holdem_hand_summary.cnt_players, ((case when( lookup_positions.flg_blinds) then 0 else (case when( lookup_positions.flg_ep) then 1 else (case when( lookup_positions.flg_mp) then 2 else 3 end) end) end)), (sum( (CASE WHEN ( (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult)) 0 THEN ((holdem_hand_player_statistics.amt_won * 1.0 )/( (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult))) ELSE 0 END) )), (sum(holdem_hand_player_detail.amt_blind)), (sum(holdem_hand_summary.amt_mgr)), (sum( (case when(holdem_hand_player_statistics.flg_won_hand AND holdem_hand_summary.amt_rake>.001) then (holdem_hand_summary.amt_rake * ( (holdem_hand_player_statistics.amt_won + holdem_hand_player_detail.amt_bet_ttl) * 1.0 / (holdem_hand_summary.amt_pot - holdem_hand_summary.amt_rake)) ) else 0 end))), etc etc

Any ideas?

[JBMSweden]

Here is the full statement of ERRORS:

There were errors during the housekeeping process:
Unable to execute query: VACUUM;; Reason: Fatal Error (ERROR: current transaction is aborted, commands ignored until end of transaction block )
Unable to execute query: VACUUM holdem_table_session_summary;; Reason: Fatal Error (ERROR: current transaction is aborted, commands ignored until end of transaction block )
Unable to execute query: CREATE TABLE holdem_cache (id_player integer NOT NULL, id_limit integer NOT NULL, cnt_players integer NOT NULL, position_type integer, amt_bb_won numeric(11,2), amt_blind numeric(11,2), amt_mgr numeric(11,2), amt_rake numeric(11,2), amt_won numeric(11,2), amt_won_curr_conv numeric(11,2), amt_won_curr_raw numeric(11,2), cnt_bb integer, cnt_bb_steal_call integer, cnt_bb_steal_fold integer, cnt_bb_steal_raise integer, cnt_blind integer, cnt_f_3bet integer, cnt_f_3bet_def_action_call integer, cnt_f_3bet_def_action_fold integer, cnt_f_3bet_def_action_raise integer, cnt_f_3bet_def_opp integer, cnt_f_3bet_opp integer, cnt_f_4bet integer, cnt_f_4bet_def_action_call integer, cnt_f_4bet_def_action_fold integer, cnt_f_4bet_def_action_raise integer, cnt_f_4bet_def_opp integer, cnt_f_4bet_opp integer, cnt_f_bet integer, cnt_f_bet_def_action_call integer, cnt_f_bet_def_action_fold integer, cnt_f_bet_def_action_raise integer, cnt_f_bet_def_opp integer, cnt_f_bet_raise_hands integer, cnt_f_call integer, cnt_f_call_hands integer, cnt_f_cbet integer, cnt_f_cbet_def_action_call integer, cnt_f_cbet_def_action_call_in_pos integer, cnt_f_cbet_def_action_call_out_of_pos integer, cnt_f_cbet_def_action_fold integer, cnt_f_cbet_def_action_fold_in_pos integer, cnt_f_cbet_def_action_fold_out_of_pos integer, cnt_f_cbet_def_action_raise integer, cnt_f_cbet_def_action_raise_in_pos integer, cnt_f_cbet_def_action_raise_out_of_pos integer, cnt_f_cbet_def_opp integer, cnt_f_cbet_face_raise integer, cnt_f_cbet_fold_to_raise integer, cnt_f_cbet_opp integer, cnt_f_cbet_success integer, cnt_f_check integer, cnt_f_check_raise integer, cnt_f_check_raise_opp integer, cnt_f_donk integer, cnt_f_donk_def_opp integer, cnt_f_donk_def_opp_action_call integer, cnt_f_donk_def_opp_action_fold integer, cnt_f_donk_def_opp_action_raise integer, cnt_f_donk_opp integer, cnt_f_face_xr integer, cnt_f_face_xr_call integer, cnt_f_face_xr_fold integer, cnt_f_face_xr_raise integer, cnt_f_float integer, cnt_f_float_def_opp integer, cnt_f_float_def_opp_action_call integer, cnt_f_float_def_opp_action_fold integer, cnt_f_float_def_opp_action_raise integer, cnt_f_float_opp integer, cnt_f_fold integer, cnt_f_raise integer, cnt_f_raise_def_action_call integer, cnt_f_raise_def_action_fold integer, cnt_f_raise_def_opp integer, cnt_f_saw integer, cnt_f_saw_won integer, cnt_f_total_actions integer, cnt_first_limp integer, cnt_fold_when_f_bet_raise integer, cnt_fold_when_f_call integer, cnt_fold_when_p_bet_raise integer, cnt_fold_when_p_call integer, cnt_fold_when_r_bet_raise integer, cnt_fold_when_r_call integer, cnt_fold_when_t_bet_raise integer, cnt_fold_when_t_call integer, cnt_hands integer, cnt_hands_raked integer, cnt_hands_with_flop integer, cnt_hands_won integer, cnt_p_3b_face_4b integer, cnt_p_3bet integer, cnt_p_3bet_def_action_call integer, cnt_p_3bet_def_action_fold integer, cnt_p_3bet_def_action_fold_when_open_raised integer, cnt_p_3bet_def_action_raise integer, cnt_p_3bet_def_opp integer, cnt_p_3bet_def_opp_when_open_raised integer, cnt_p_3bet_f_cbet_def_action_call integer, cnt_p_3bet_f_cbet_def_action_fold integer, cnt_p_3bet_f_cbet_def_action_raise integer, cnt_p_3bet_f_cbet_def_opp integer, cnt_p_3bet_fold integer, cnt_p_3bet_opp integer, cnt_p_4bet integer, cnt_p_4bet_def_action_call integer, cnt_p_4bet_def_action_fold integer, cnt_p_4bet_def_action_raise integer, cnt_p_4bet_def_opp integer, cnt_p_4bet_opp integer, cnt_p_bb_fold_to_sb integer, cnt_p_bb_fold_to_sb_opp integer, cnt_p_bb_v_sb_steal_call integer, cnt_p_bb_v_sb_steal_fold integer, cnt_p_bb_v_sb_steal_raise integer, cnt_p_bet_raise_hands integer, cnt_p_call integer, cnt_p_call_hands integer, cnt_p_ccall integer, cnt_p_ccall_opp integer, cnt_p_check integer, cnt_p_face_raise integer, cnt_p_facing_limpers integer, cnt_p_first_raise integer, cnt_p_fold integer, cnt_p_limp integer, cnt_p_limp_after_limpers_opp integer, cnt_p_limp_call integer, cnt_p_limp_faceraise integer, cnt_p_limp_fold integer, cnt_p_limp_opp integer, cnt_p_limp_raise integer, cnt_p_open_opp integer, cnt_p_pfr_call integer, cnt_p_pfr_call_opp integer, cnt_p_raise integer, cnt_p_raise_first_in integer, cnt_p_raise_limpers integer, cnt_p_squeeze integer, cnt_p_squeeze_def_call integer, cnt_p_squeeze_def_fold integer, cnt_p_squeeze_def_opp integer, cnt_p_squeeze_def_raise integer, cnt_p_squeeze_opp integer, cnt_p_total_actions integer, cnt_pfr integer, cnt_pfr_f_bet integer, cnt_pfr_f_call integer, cnt_pfr_f_check integer, cnt_pfr_f_checkraise integer, cnt_pfr_f_fold integer, cnt_pfr_f_none integer, cnt_pfr_f_raise integer, cnt_prev_callers_limp integer, cnt_prev_callers_raise integer, cnt_r_3bet integer, cnt_r_3bet_def_action_call integer, cnt_r_3bet_def_action_fold integer, cnt_r_3bet_def_action_raise integer, cnt_r_3bet_def_opp integer, cnt_r_3bet_opp integer, cnt_r_4bet integer, cnt_r_4bet_def_action_call integer, cnt_r_4bet_def_action_fold integer, cnt_r_4bet_def_action_raise integer, cnt_r_4bet_def_opp integer, cnt_r_4bet_opp integer, cnt_r_bet integer, cnt_r_bet_def_action_call integer, cnt_r_bet_def_action_fold integer, cnt_r_bet_def_action_raise integer, cnt_r_bet_def_opp integer, cnt_r_bet_raise_hands integer, cnt_r_call integer, cnt_r_call_hands integer, cnt_r_cbet integer, cnt_r_cbet_def_action_call integer, cnt_r_cbet_def_action_fold integer, cnt_r_cbet_def_action_raise integer, cnt_r_cbet_def_opp integer, cnt_r_cbet_face_raise integer, cnt_r_cbet_fold_to_raise integer, cnt_r_cbet_opp integer, cnt_r_check integer, cnt_r_check_raise integer, cnt_r_check_raise_opp integer, cnt_r_donk integer, cnt_r_donk_def_action_call integer, cnt_r_donk_def_action_fold integer, cnt_r_donk_def_action_raise integer, cnt_r_donk_def_opp integer, cnt_r_donk_opp integer, cnt_r_face_xr integer, cnt_r_face_xr_call integer, cnt_r_face_xr_fold integer, cnt_r_face_xr_raise integer, cnt_r_float integer, cnt_r_float_def_action_call integer, cnt_r_float_def_action_fold integer, cnt_r_float_def_action_raise integer, cnt_r_float_def_opp integer, cnt_r_float_opp integer, cnt_r_fold integer, cnt_r_probe integer, cnt_r_probe_opp integer, cnt_r_raise integer, cnt_r_raise_def_action_call integer, cnt_r_raise_def_action_fold integer, cnt_r_raise_def_opp integer, cnt_r_raise_wtsd integer, cnt_r_raise_wtsd_won integer, cnt_r_saw integer, cnt_r_total_actions integer, cnt_sb integer, cnt_sb_steal_call integer, cnt_sb_steal_fold integer, cnt_sb_steal_raise integer, cnt_sessions integer, cnt_sessions_won integer, cnt_steal_att integer, cnt_steal_att_btn integer, cnt_steal_att_cutoff integer, cnt_steal_att_fold integer, cnt_steal_att_no_sd integer, cnt_steal_att_sb integer, cnt_steal_att_wtsd integer, cnt_steal_def_opp_bb integer, cnt_steal_def_opp_bb_nosd integer, cnt_steal_def_opp_bb_win_sd integer, cnt_steal_def_opp_bb_win_wo_sd integer, cnt_steal_def_opp_bb_wtsd integer, cnt_steal_def_opp_sb integer, cnt_steal_def_opp_sb_nosd integer, cnt_steal_def_opp_sb_win_sd integer, cnt_steal_def_opp_sb_win_wo_sd integer, cnt_steal_def_opp_sb_wtsd integer, cnt_steal_opp integer, cnt_steal_opp_btn integer, cnt_steal_opp_cutoff integer, cnt_steal_opp_sb integer, cnt_steal_reraise_def_action_fold integer, cnt_steal_reraise_def_opp integer, cnt_steal_success integer, cnt_steal_win_sd integer, cnt_steal_win_wo_sd integer, cnt_t_3bet integer, cnt_t_3bet_def_action_call integer, cnt_t_3bet_def_action_fold integer, cnt_t_3bet_def_action_raise integer, cnt_t_3bet_def_opp integer, cnt_t_3bet_opp integer, cnt_t_4bet integer, cnt_t_4bet_def_action_call integer, cnt_t_4bet_def_action_fold integer, cnt_t_4bet_def_action_raise integer, cnt_t_4bet_def_opp integer, cnt_t_4bet_opp integer, cnt_t_bet integer, cnt_t_bet_def_action_call integer, cnt_t_bet_def_action_fold integer, cnt_t_bet_def_action_raise integer, cnt_t_bet_def_opp integer, cnt_t_bet_raise_hands integer, cnt_t_call integer, cnt_t_call_hands integer, cnt_t_cbet integer, cnt_t_cbet_def_action_call integer, cnt_t_cbet_def_action_fold integer, cnt_t_cbet_def_action_raise integer, cnt_t_cbet_def_opp integer, cnt_t_cbet_face_raise integer, cnt_t_cbet_fold_to_raise integer, cnt_t_cbet_opp integer, cnt_t_check integer, cnt_t_check_raise integer, cnt_t_check_raise_opp integer, cnt_t_donk integer, cnt_t_donk_def_action_call integer, cnt_t_donk_def_action_fold integer, cnt_t_donk_def_action_raise integer, cnt_t_donk_def_opp integer, cnt_t_donk_opp integer, cnt_t_face_xr integer, cnt_t_face_xr_call integer, cnt_t_face_xr_fold integer, cnt_t_face_xr_raise integer, cnt_t_float integer, cnt_t_float_def_action_call integer, cnt_t_float_def_action_fold integer, cnt_t_float_def_action_raise integer, cnt_t_float_def_opp integer, cnt_t_float_opp integer, cnt_t_fold integer, cnt_t_probe integer, cnt_t_probe_opp integer, cnt_t_raise integer, cnt_t_raise_def_action_call integer, cnt_t_raise_def_action_fold integer, cnt_t_raise_def_opp integer, cnt_t_raise_wtsd integer, cnt_t_raise_wtsd_won integer, cnt_t_saw integer, cnt_t_total_actions integer, cnt_total_actions integer, cnt_vpip integer, cnt_vpip_sb integer, cnt_won_hand integer, cnt_won_showdown integer, cnt_wtsd integer, cnt_wtsd_when_f_bet_raise integer, cnt_wtsd_when_f_call integer, cnt_wtsd_when_p_bet_raise integer, cnt_wtsd_when_p_call integer, cnt_wtsd_when_r_bet_raise integer, cnt_wtsd_when_r_call integer, cnt_wtsd_when_t_bet_raise integer, cnt_wtsd_when_t_call integer, cnt_wtsd_won integer, cnt_wtsd_won_when_f_bet_raise integer, cnt_wtsd_won_when_f_call integer, cnt_wtsd_won_when_p_bet_raise integer, cnt_wtsd_won_when_p_call integer, cnt_wtsd_won_when_r_bet_raise integer, cnt_wtsd_won_when_r_call integer, cnt_wtsd_won_when_t_bet_raise integer, cnt_wtsd_won_when_t_call integer, cnt_wwosd_f_bet_raise integer, cnt_wwosd_f_call integer, cnt_wwosd_p_bet_raise integer, cnt_wwosd_p_call integer, cnt_wwosd_r_bet_raise integer, cnt_wwosd_r_call integer, cnt_wwosd_t_bet_raise integer, cnt_wwosd_t_call integer, cnt_p_3bet_bb integer, cnt_p_3bet_btn integer, cnt_p_3bet_co integer, cnt_p_3bet_hj integer, cnt_p_3bet_sb integer, cnt_p_3bet_opp_bb integer, cnt_p_3bet_opp_btn integer, cnt_p_3bet_opp_co integer, cnt_p_3bet_opp_hj integer, cnt_p_3bet_opp_sb integer, cnt_p_open_opp_bu integer, cnt_p_open_opp_co integer, cnt_p_open_opp_hj integer, cnt_p_open_opp_sb integer, cnt_p_open_opp_utg integer, cnt_p_raise_first_in_bu integer, cnt_p_raise_first_in_co integer, cnt_p_raise_first_in_hj integer, cnt_p_raise_first_in_sb integer, cnt_p_raise_first_in_utg integer);; Reason: Fatal Error (ERROR: current transaction is aborted, commands ignored until end of transaction block )

[kraada]

Check your firewall - the transaction should only be aborted if PostgreSQL is crashing, if something is stopping it, or if you actively direct PT3 to do something else.

[JBMSweden]

This is all greek to me - what should I be looking for or do?

[WhiteRider]

Check our Firewall Guide to stop your firewall interfering.
If it still happens check the Event Viewer (click Start and type "event", or find it via Control Panel on XP) for errors related to PostgreSQL and post the error here or attach a screenshot to a Support ticket.

[JBMSweden]

Problem still persists.
Can't find any problems related to Postgres in event viewer.

Should I reinstall Postgres and PT3?

[kraada]

I don't think that's the right step yet. Please reproduce this problem with Logging Enabled (Start --> PokerTracker 3 --> PokerTracker 3 (Logging Enabled)), and report this problem so that we can investigate other errors that may be occurring in the log file.