Page 1 of 2

Unable to rebuild cache

PostPosted: Mon Mar 23, 2015 4:57 am
by vigor1
Hi,
I get this message when I try to rebuild cache: "Unable to rebuild cache. Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: invalid input syntax for integer: "" CONTEXT: PL/pgSQL function "update_cash_custom_cache_playerrange" line 12 at FOR over SELECT rows )".
This happened after I've downloaded and imported some stats. As suggested here https://www.pokertracker.com/forums/vie ... 58&t=57277, I have created and successfully rebuilt a new db.

Re: Unable to rebuild cache

PostPosted: Mon Mar 23, 2015 7:46 am
by kraada
Which stats did you download and import?

Re: Unable to rebuild cache

PostPosted: Mon Mar 23, 2015 8:19 am
by vigor1
Fold to Preflop 4Bet after Squeeze - Fold to Cold 4Bet After 3Bet - Squeeze responses - 5Bet+ PF After 3Bet - 4Bet Preflop IP & OOP - Fold to PF5Bet after 4Bet - Call vs MP Open - Call vs EP Open - 4Bet Preflop After Steal - Fold to PF 4Bet After 3Bet BTN vs CO - 4Bet Preflop CO vs BTN - Fold to CBet Total - CBet Total. I imported "BB/100 stats for Holdem Hand Range Visualizer" too, I used it in HRV only, then I deleted it.

Re: Unable to rebuild cache

PostPosted: Mon Mar 23, 2015 1:13 pm
by kraada
When you deleted that stat did you delete the columns that it uses as well or just the statistic itself?

Re: Unable to rebuild cache

PostPosted: Mon Mar 23, 2015 2:16 pm
by vigor1
Just the statistic itself after trying rebuild cache

Re: Unable to rebuild cache

PostPosted: Mon Mar 23, 2015 3:09 pm
by kraada
Try going in and deleting its column - the columns are what actually matters for the cache. If you could help us narrow down the column that's causing the problem for you that would be a big help, as we've tested these stats before approving them and haven't seen these problems in our testing environments.

Re: Unable to rebuild cache

PostPosted: Mon Mar 23, 2015 3:22 pm
by vigor1
The columns used by that stat are built-in ones

Re: Unable to rebuild cache

PostPosted: Mon Mar 23, 2015 3:34 pm
by kraada
Ah yes. To try narrowing it down further could you please try removing the columns and stats one at a time (you can always reimport them later - pick a stat, remove it, and then remove its columns) and rebuilding the cache between each? That should pinpoint the stat that's the problem and we'll be able to get it fixed then.

Re: Unable to rebuild cache

PostPosted: Mon Mar 23, 2015 3:38 pm
by vigor1
The prob is my db is enough big it will take so long to rebuild each time, 2h or more each try maybe :(

Re: Unable to rebuild cache

PostPosted: Mon Mar 23, 2015 4:36 pm
by kraada
Try pulling half then half again if it isn't fixed - that will narrow it down pretty quickly.