Unable to maintain database

[alex_boyko]

Hi, after I imported some hands, I got this message in the end:



Manual housekeeping also fails:



Thanks in advance,
Alex.

[WhiteRider]

I'm not familiar with that error - it's possible Kraada will have come across it.
If you create a new database and set it to be Active (Database > Database Management) can you import hands there?

[kraada]

This shouldn't affect new databases only that one, from what I can tell. It looks like the most common explanation for this error has to do with upgrading PostgreSQL - have you updated this database recently?

[alex_boyko]

I reinstalled Windows 3 days ago, and imported all the hands I got, so PostgreSQL is pretty new.
Also, it started this mistake while importing hands:



HUD is not working on half of the tables

Here's one line of this (it doesn't fully copy for whatever reason )

03:33:54 pm: Error: PokerStars: Unable to import hand (#140949795134). Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: right sibling's left-link doesn't match: block 26269 links to 28550 instead of expected 57220 in index "tourney_cache_primary_key" 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_cold::integer,playerdata.cnt_p_4bet_cold_opp::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_def_opp_when_open_raised::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 24 at SQL statement )

[kraada]

Your database is definitely very confused. When you reinstalled Windows did PostgreSQL persist through the reinstallation or is this a 3 day old database? How many hands are in it (roughly)?

[alex_boyko]

Its a 3 day old database, about 1.2mln hands

[kraada]

Try creating a new database and import half of those hands to it and see if that database works well. I'm wondering if one or more of the hand history files you imported has a problem with it and if we could narrow it down to the problem file or files then we can figure out what's causing this behavior.

[Assassin85]

I will use this thread for my problem, because it's more or less the same topic and don't want to make to many similiar threads.



I already tried the Tips from this link:
https://www.pokertracker.com/guides/PT4/troubleshooting/postgresql-troubleshooting#unable-to-import-hand
but didn't change anything.

I have 2 DB's, one with my own hands (12 GB) and one for the other players hands (31 GB).
The problem appeared after I wanted to do some maintaince stuff for the big DB to make the Cache stuff up2date and faster.
After the error during the Cache-maintaince the DB-size went crazy and was only 1/3 or so as before and because Reindex and all the other stuff don't run as it should be, I couldn't fix it that way.
At the beginning with a new made DB it seemed that the problems were gone, but after a while they were back
And now I also get the more or less same error pop-ups when I do maintaince at my own DB, no matter which kind of maintaince it is

I could create a new DB for the other players hands (and my DB too), but that won't solve the problem and maybe in 1 week or 1 monath or sometime the same problem is back.
I havn't changed anything (afaik) in any PT or windows settings in the past which could have an effect on that.
In the past I never had any problems like this with my DBs and I use PT since years.

I'm a little bit desperate, pls HELP ME!!!

[kraada]

This error is actually a bit different than the one earlier in the thread and tends to indicate hardware level problems. Please try running Scandisk on your machine as it's likely your hard drive is having problems.

[alex_boyko]

New DB seems to work fine, thanks.