HUD: Amount Won - Tournaments difference betw PT2 and 3?

[WhiteRider]

I can't guarantee it, but I'm pretty sure it will be added.

[Thomas42]

I can't guarantee it, but I'm pretty sure it will be added.

Well, we are still waiting for it

Also, tried to add this using you script in an earlier comment, plus looked at the summary stat to copy any changes, but then when I was rebuilding the cache it just idled on it for the whole night (9h). Had to use Task Manager to force PT3 to quit since canceling would only say it will cancel when current task was completed...

BTW, ROI and Tourneys played would also be very useful to have in the HUD as complement to net money won. I am going to try and duplicate them as well.

Since these stats are available already, wouldn't it be an easy way to simple have a check-box for each stat "Make this stat available in the HUD"? Then I would be able to quickly add any stat without having to duplicate them.

[Thomas42]

Oki, I have now gone over this again to make sure everything is correct, but there are still problems.

I have confirmed the custom Net Won Player stat is working by using it in a report. There it correctly shows the right values, both with and without filtering the available data.

However, when I do a complete housekeeping it never completes. First time it got stuck on rebuilding index. After +1h I had to use Task Manager to force PT to quit. After restart I ran HK again and it is now up to 1h30m and looks stuck on rebuilding cache.

The value sort of showed up in the HUD when I tested it on a replay hand. Problem was that the values seemed to be very random. All players, even those with just a few hands had positive values and my value was only a 10th of the real profit. When hovering over my net won the bubble indicated it was showing for this session only.

Any idea what is going on here?

[Thomas42]

Latest update is that I just had to use the task manager to kill PT3, again, after it doing housekeeping for more that 3h.

Will try it again with logging turned on to see if that will tell me what it gets stuck on.

[kraada]

Exactly which options were you using for housekeeping?

[Thomas42]

All of them since I want everything to be correct after adding these new columns etc.

Its been running for 10 minutes now, is on rebuilding cache.

It did pass one time before when I didn't use the advanced options, but that's the only time.

[kraada]

The only thing affected by new stats is the cache - rebuild cache is the only thing you'd need (though vacuum and analyze are never bad to do). Cluster and Reindex are only needed if there are specific problems. You can let it finish though - reindex is more likely to help given your situation than cluster and it did fail the first time so your indexes might be corrupt and the reindex might be needed now.

[Thomas42]

Since I have to kill it via the task manager, I though it would be best to do that.

It definitely gets stuck on rebuilding the tourney cache. Everything works fine until then, after that every % it rebuilds the cache takes 10-15 minutes or so. I also got an PostgreaSQL error:

2011/05/11 21:45:51.456: [0000293C][StatManager] Cache update is 1 percent complete (95/9,404).
2011/05/11 21:57:11.927: [0000293C][StatManager] Cache update is 2 percent complete (189/9,404).
2011/05/11 22:06:05.622: [0000293C][PostgresPreparedStatement (Error)] Unable to execute prepared query: prepared_statement_2; Reason: Fatal Error (ERROR: numeric field overflow DETAIL: A field with precision 11, scale 2 must round to an absolute value less than 10^9. )
2011/05/11 22:10:28.716: [0000293C][StatManager] Cache update is 3 percent complete (283/9,404).

Any idea what this can be?

If it helps, I can take screenshots of the involved stats settings, archive the log and upload it to the issue tracker.

[kraada]

You've got some stat which is producing really massive results - what custom stats have you added recently?

[Thomas42]

I got no other custom stats than this one.

I just killed PT again, can't wait the 20h it would take to rebuild the cache...

Will take screenshots of all the settings, archive the log and file it in an issue now. Give me 5 mins...