Problem with custom stats in popup if big sample size

[Poker_Pro_81]

Hi,

i have the following custom stats in a pop up in my HUD, that I found here https://www.pokertracker.com/custom/stats

Call PF 3Bet After Raise IP
(cnt_p_3bet_def_action_call_when_open_raised_ip / cnt_p_3bet_def_opp_when_open_raised_ip) * 100

Call PF 3Bet After Raise OOP
(cnt_p_3bet_def_action_call_when_open_raised_oop / cnt_p_3bet_def_opp_when_open_raised_oop) * 100

If I have to big sample size on a player they don’t work. Roughly it doesn’t work if I have more then 30k-50k hand on the opponent.

I use these stats by position, so I have them on 8 places in the same popup, so I can understand its big queries to run every time I open the popup. Does its sound normal that problem occurs with big sample size? Is it something I can do to get around this problem?

[kraada]

Does the data ever populate? If you wait 15 seconds or so with the popup open do you get any data?

[Poker_Pro_81]

Yes, I do wait, and I can see that it sometimes take 10-20 sec. But even after that it sometimes doesn’t work, and when it doesn’t work I got session stats instead of lifetime stats on, on the same time I got lifetime stats on other kinds stats in the same popup.

I tried to run in logging mode. I created a new popup with only this stat in it, just to make the log file easy to read. And I found this when
I recreated the error on purpose: "Reason: Fatal Error (ERROR: invalid input syntax for integer: "

It works on some opponents with more number of hands then 50k, but it is always the same players it doesn’t work on, and most of the case they have more hands then 30k-50k hands.

I have reindex, vacuum an analyze, and rebuild cache, but still the same problem

I use version 4.05.3 beta.

A use PostgreSQL 9.1, even if it not is recommended.

[kraada]

Please restart PT4 using the Logging Enabled link on your Start Menu and reproduce this problem. Then please send us the PokerTracker4.log file via a support ticket so that we can investigate this further for you. You can find this file by clicking File -> Open User Data Folder in the main PT4 window. The file we need is the text file called PokerTracker that's in the folder that appears.

[Poker_Pro_81]

Created a new HUD profile just with one stat and connected to a popup, and then imported the popup with my "Call PF 3Bet After Raise IP/OOP" stats. I did this because I wanted to recreate the error in an environment that produces just what we need in the log file, and nothing more.

To my big surprise it now works, I was not able to recreate the error. I guess the other HUD profile must be partly broken, or something, I don’t know. Because I had the error in both of the identical HUD profile I use. I normally have on for PartyPoker and one for Replayer (where I can see my lifetime stats).

I guess I need to create a new HUD profile and rebuild my HUD step by step, hopefully I can import section by section again.

I think I now will be able to recreate everything as I like it. Do you still want me to create a report ticket anyway, I don´t care myself, but of course I do it if you still are interesting for your own sake, are you?

[kraada]

We would need that log file in order to figure out what was going on that caused the error. Can you reproduce it with the old profile still?

[Poker_Pro_81]

Yes I can, will do this in an hour or so, when the kids are in bed

[kraada]

Sounds good, thanks.

[Poker_Pro_81]

I am very sure that I have found what causing the error.

It seems very strange but it is two other custom stats in another popup in the same tablegroup that in some unknown way causing this. Recently I added, "3bet vs RWPC" and "3bet wo RWPC". I found them in the download site for custom states. I just found that they had the same problem if the sample size was too big. But the strangest is that if I remove both of them from one popup then my problem with “Call PF 3Bet After Raise IP/OOP” disappear in another popup.

I have now tried like ten times, added "3bet vs RWPC" and "3bet wo RWPC" again, I both tried them together, and also one at a time. And “Call PF 3Bet After Raise IP/OOP” only works when I don’t use any of the two RWPC stats.

To be extra clear, when I say that I use both kind of RWPC, I actually use both of them by position, so it’s actually more than two of them in the popup, but I don’t think that matters.

So my recommendation is to start looking on the RWPC stats, they are the devils

EDIT: Before I found this I added a support ticket.

[Poker_Pro_81]

Have one more question, forgive me if it is wrong to post it here, but it is a little related to "Call PF 3Bet After Raise IP/OOP".

I have myself created two custom stats. But I don’t get the "show times/opportunities" to work, I only see (). I can live without it, but maybe you have a quick answer. (And it’s not because I don't wait long enough, have tried to wait several minutes)

Raise PF 3Bet After Raise IP
100-(((cnt_p_3bet_def_action_call_when_open_raised_ip + cnt_p_3bet_def_action_fold_when_open_raised_ip) / cnt_p_3bet_def_opp_when_open_raised_ip) * 100)

Raise PF 3Bet After Raise OOP
100-(((cnt_p_3bet_def_action_call_when_open_raised_oop + cnt_p_3bet_def_action_fold_when_open_raised_oop) / cnt_p_3bet_def_opp_when_open_raised_oop) * 100)

(Except that "show times/opportunities" doesn’t work those also only works if I don't us RWPC.)