Page 1 of 1

Low cache and error during housekeeping problem

PostPosted: Wed May 30, 2012 5:35 pm
by oahukid
Hey,

I'm a newbie PT3 user and would need some help. My cache is at 36%, tried to make the housekeeping, but got the following message at the end of the process:
http://imageshack.us/photo/my-images/833/errorqx.jpg/

I've downloaded some stats, hud from the download section. Then started making my own hud, checking it continously in the replayer. But it took a lot of time after every change for the stats to be refreshed. I've also imported additional hands into the database which could also cause the problem.

So i looked into the troubleshooting section and saw that i should make some housekeeping, but the cache remained 36%. I've done everything, vacuum, analyze and update the cache. Then tried rebuild the cache and cluster. No change. Could you pls help me guys? Thx

Re: Low cache and error during housekeeping problem

PostPosted: Thu May 31, 2012 2:46 am
by WhiteRider
Without seeing the full error message I can't be sure, but often when we see that kind of error it is because you have more than one column with the same name, different only by case. I forget the exact name, but often we see a pair of column names which are identical except that one ends with _bb and the other with _BB.

If you can see the end of the error message by scrolling down then check it out and look up the column name mentioned. If the above proves to be the case then delete one of the matching names and make sure the stats which use it use the version you keep.
That should let the cache build (although you may have a couple of columns like that so you may need to fix another too).

If you still have problems after that please report your problem so that we can see the full error message in your log file.

Re: Low cache and error during housekeeping problem

PostPosted: Thu May 31, 2012 3:13 am
by oahukid
Thx for your reply. I've sent the log file with my ticket. I've tried to see the columns, but couldn't find the one in the message. And tbh don't really understand what you wrote:)

Re: Low cache and error during housekeeping problem

PostPosted: Thu May 31, 2012 7:38 am
by oahukid
After having checked some threads I realized that i've got the same problem like others previously.
The error message with the end:
http://imageshack.us/photo/my-images/837/enduw.jpg/

So I should delete columns which cause the problem. But couldnt figure it out how to do that. Could you pls let me know?

Re: Low cache and error during housekeeping problem

PostPosted: Thu May 31, 2012 8:00 am
by oahukid
One thing to add. In the columns section couldnt find the mentioned one.

Re: Low cache and error during housekeeping problem

PostPosted: Thu May 31, 2012 8:29 am
by kraada
Click Configure --> Configure Statistics, choose the Holdem Cash Player Statistics section on the Sections tab, then switch to Columns and you should see it.

Re: Low cache and error during housekeeping problem

PostPosted: Thu May 31, 2012 12:01 pm
by oahukid
Okay, in the meantime i could figure it and removed the duplicated columns.
So, my cache is now at 100% and made all the housekeeping work successfully.
However, my initial problem is not solved. So i open up a hand in the replayer, the hud is coming out with stats for every player, but the stats in the popups are just not, it's totally empty.....

Re: Low cache and error during housekeeping problem

PostPosted: Thu May 31, 2012 1:21 pm
by kraada
Then please restart PT3 with the Logging Enabled link on your Start menu, open up one such replayer popup, then report this problem and we'll investigate further for you.

Re: Low cache and error during housekeeping problem

PostPosted: Fri Jun 01, 2012 1:27 am
by oahukid
Okay, have opened a new ticket for the issue