after update to 4.11 PT4 doesn't work

[TedHawkins]

The hands updating while playing is extremely slow. I have just sent a support ticket. I rebuild the database cache on both v4.11.0 and v4.11.1. Other than that I do not have other problems.

[kraada]

We are working on the slow import problem and I'm told we're now having trouble reproducing it. Could everybody with the slow import problem try the following steps here and paste the output for me:

(1) Open PGAdmin III from your Start menu.
(2) Double click on your server to connect to it (enter your password if needed).
(3) Expand "Databases" with the small + sign.
(4) Click on your current updated 4.11.1 database and click the SQL magnifying glass from the toolbar.
(5) In the window that appears paste the code below and click the green play icon in the toolbar.
(6) Once there are results (it should take well under a tenth of a second to complete) click at the top left of the results output (in the bottom half of the screen) and that will highlight all data.
(7) Press ctrl+c to copy that data, and paste it here so that we can see if you are missing any indexes.

The query to run is:

Code: Select all

SELECT i.relname as indname,
       i.relowner as indowner,
       idx.indrelid::regclass,
       am.amname as indam,
       idx.indkey,
       ARRAY(
       SELECT pg_get_indexdef(idx.indexrelid, k + 1, true)
       FROM generate_subscripts(idx.indkey, 1) as k
       ORDER BY k
       ) as indkey_names,
       idx.indexprs IS NOT NULL as indexprs,
       idx.indpred IS NOT NULL as indpred
FROM   pg_index as idx
JOIN   pg_class as i
ON     i.oid = idx.indexrelid
JOIN   pg_am as am
ON     i.relam = am.oid WHERE idx.indrelid = 'cash_cache'::regclass OR idx.indrelid = 'cash_custom_cache'::regclass;

Edit: Updated information.

[82rott]

"cash_cache_primary_key";10;"cash_cache";"btree";"1 2 3 4 5 6 7 8 9";"{id_player,id_gametype,id_limit,cnt_players,position_type,flg_has_position_f,flg_has_position_t,flg_has_position_r,date_played_year_week}";f;f
"cash_cache_id_player_idx";10;"cash_cache";"btree";"1";"{id_player}";f;f
"cash_custom_cache_primary_key";10;"cash_custom_cache";"btree";"1 2 3 4 5 6 7 8 9";"{id_player,id_gametype,id_limit,cnt_players,position_type,flg_has_position_f,flg_has_position_t,flg_has_position_r,date_played_year_week}";f;f
"cash_custom_cache_id_player_idx";10;"cash_custom_cache";"btree";"1";"{id_player}";f;f


ticket 152465 btw

[Raziel12]

ERROR: relation "cash_cache" does not exist
LINE 17: ON i.relam = am.oid WHERE idx.indrelid = 'cash_cache...
^

********** Chyba **********

ERROR: relation "cash_cache" does not exist
Stav SQL: 42P01
Znak: 600

[Raziel12]

-- Spouští se dotaz:
SELECT i.relname as indname,
i.relowner as indowner,
idx.indrelid::regclass,
am.amname as indam,
idx.indkey,
ARRAY(
SELECT pg_get_indexdef(idx.indexrelid, k + 1, true)
FROM generate_subscripts(idx.indkey, 1) as k
ORDER BY k
) as indkey_names,
idx.indexprs IS NOT NULL as indexprs,
idx.indpred IS NOT NULL as indpred
FROM pg_index as idx
JOIN pg_class as i
ON i.oid = idx.indexrelid
JOIN pg_am as am
ON i.relam = am.oid WHERE idx.indrelid = 'cash_cache'::regclass OR idx.indrelid = 'cash_custom_cache'::regclass;
ERROR: relation "cash_cache" does not exist
LINE 17: ON i.relam = am.oid WHERE idx.indrelid = 'cash_cache...
^

********** Chyba **********

ERROR: relation "cash_cache" does not exist
Stav SQL: 42P01
Znak: 600

-- Spouští se dotaz:
SELECT i.relname as indname,
i.relowner as indowner,
idx.indrelid::regclass,
am.amname as indam,
idx.indkey,
ARRAY(
SELECT pg_get_indexdef(idx.indexrelid, k + 1, true)
FROM generate_subscripts(idx.indkey, 1) as k
ORDER BY k
) as indkey_names,
idx.indexprs IS NOT NULL as indexprs,
idx.indpred IS NOT NULL as indpred
FROM pg_index as idx
JOIN pg_class as i
ON i.oid = idx.indexrelid
JOIN pg_am as am
ON i.relam = am.oid WHERE idx.indrelid = 'cash_cache'::regclass OR idx.indrelid = 'cash_custom_cache'::regclass;
ERROR: relation "cash_cache" does not exist
LINE 17: ON i.relam = am.oid WHERE idx.indrelid = 'cash_cache...
^

********** Chyba **********

ERROR: relation "cash_cache" does not exist
Stav SQL: 42P01
Znak: 600

[kraada]

Raziel: Please make sure you've selected your PT4 database; that error is saying there is no cache. If there is no cache you'll need to run a Cache Rebuild to build it and that would definitely be a reason for slowness.

[hockeyhero31]

so heres whats going on with my pt 4.
downloaded pt 4.11 nothing worked so i rebuilt cache, download patch 4.11.1.
My Hud works but that is about it. does not import hands, does not stop getting hands and i am forced to shut down PT4 via the task manager everytime i want to exit the program. the hud also stays visible even after closing down pt4 via the task manager and goes away only after leaving the tables u playing at.
my CPU usage is also alarming when running 4.11.1 reaching its almost full capacity at times but usually staying around 30-35%.
what do i do now to try and fix this and what are you guys going to do to have PT4 running smoothly like it did with the previous version. I should also mention that i do not use custom stats so i shouldnt have as many issues as others have seem to have

[Xys66]

I just want to say that after previous problems I also updated PostgreSQL database to 9.3.4. and now everything works very fast (hud and import)

[diogogarcia]

"cash_cache_primary_key";10;"cash_cache";"btree";"1 2 3 4 5 6 7 8 9";"{id_player,id_gametype,id_limit,cnt_players,position_type,flg_has_position_f,flg_has_position_t,flg_has_position_r,date_played_year_week}";f;f
"cash_cache_id_player_idx";10;"cash_cache";"btree";"1";"{id_player}";f;f
"cash_custom_cache_primary_key";10;"cash_custom_cache";"btree";"1 2 3 4 5 6 7 8 9";"{id_player,id_gametype,id_limit,cnt_players,position_type,flg_has_position_f,flg_has_position_t,flg_has_position_r,date_played_year_week}";f;f
"cash_custom_cache_id_player_idx";10;"cash_custom_cache";"btree";"1";"{id_player}";f;f

[tghay]

What's the default password for postgres? I mean what is the password to enter to connect to the server in pgAdminIII to connect because "postgres", "admin", "user", "userpass", everything I could use in google doesn't work and I certainly didn't change it from the default.