Housekeeping error

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

Housekeeping error

Postby anothercooler » Sun Jun 17, 2012 7:07 pm

Hi guys

I get the following message everytime I run housekeeping.

I am running PT3 v3.13.7beta

Anyone got any ideas?

There were errors during the housekeeping process:
Unable to execute query: VACUUM;; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 268435452. )
anothercooler
 
Posts: 91
Joined: Wed May 28, 2008 8:24 am

Re: Housekeeping error

Postby WhiteRider » Mon Jun 18, 2012 2:56 am

Are you also using PT4?
If you are and you've run PostgreSQL tuning there please try running it again in v4.01.21 as the values were changed a little to avoid this kind of problem. If that doesn't work try reverting the tuning and see if that helps. (Database > Database Management > Housekeeping)
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Housekeeping error

Postby anothercooler » Mon Jun 18, 2012 6:50 pm

Not sure what you mean Whiterider.

I did download PT4 beta and tried it a little, but have not had the time to fully get aquainted with it. Uninstalled it and continuing to use PT3 until such time I can give PT4 my full attention.

Will some settings have been changed due to PT4 install?

Regards

Stephen
anothercooler
 
Posts: 91
Joined: Wed May 28, 2008 8:24 am

Re: Housekeeping error

Postby WhiteRider » Tue Jun 19, 2012 3:13 am

If you did the PostgreSQL tuning in PT4, yes. PT4 has a function to tune PostgreSQL to make it more effective, but on some systems the settings were a little aggressive in the previous version so you may need to revert them.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Housekeeping error

Postby kraada » Tue Jun 19, 2012 8:12 am

If they were originally tuned a couple of betas ago, reverting then re-running tuning should result in still tuned settings that are not so aggressive as to cause problems.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Housekeeping error

Postby anothercooler » Wed Jun 20, 2012 10:26 am

Thnaks guys

Is it possible to revert/retune using PT3 or do i need to install PT4 again to achieve this?

Regards

Stephen
anothercooler
 
Posts: 91
Joined: Wed May 28, 2008 8:24 am

Re: Housekeeping error

Postby kraada » Wed Jun 20, 2012 1:09 pm

PT3 does not have that functionality and so you will need to use PT4.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests