4.01.17 Tuning SQL bug

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

4.01.17 Tuning SQL bug

Postby bkkgrinder1 » Thu Apr 19, 2012 12:41 am

Hey,

I've encountered a bug where after tuning my database, I no longer can execute housekeeping in database management. I cannot reindex or vacuum/analyze. It gives me a out of memory error after a minute for reindexing and just gives me a cannot execute query when I try to vacuum. After reverting the tuning, I am able to run the reindex and vacuum option.
bkkgrinder1
 
Posts: 11
Joined: Mon Mar 19, 2012 6:06 am

Re: 4.01.17 Tuning SQL bug

Postby WhiteRider » Thu Apr 19, 2012 3:29 am

Please open the PokerTracker4.log file from C:\Users\yourname\AppData\Local\PokerTracker 4\ (which you can access from the PT4 File menu) and find the line near the start that looks like this:

2012/04/19 14:28:03.968 [00001]: [- Main -][SystemInfo] Physical Memory: 4,096 mb (4,096 mb available) Virtual Memory: 2,048 mb (1,930 mb available) Page File: 4,096 mb (4,096 mb available)

Paste what you have in your log here so that the development team can see what settings you have.
Thanks
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: 4.01.17 Tuning SQL bug

Postby bkkgrinder1 » Thu Apr 19, 2012 8:41 am

2012/04/19 11:13:37.308 [00000]: [- Main -][SystemInfo] Physical Memory: 4,096 mb (3,444 mb available) Virtual Memory: 2,048 mb (1,906 mb available) Page File: 4,096 mb (4,096 mb available)

Want to remind you that I already reverted back to pre-tuning.
bkkgrinder1
 
Posts: 11
Joined: Mon Mar 19, 2012 6:06 am

Re: 4.01.17 Tuning SQL bug

Postby WhiteRider » Fri Apr 20, 2012 3:40 am

A change has been made to the PostgreSQL tuning to correct this for the next Beta. Thanks for bringing this to our attention.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 0 guests