PDA

View Full Version : Optimizing Players error



harmonica
05-05-2011, 04:18 PM
Hi

I was playing a session earlier today, when I saw a guy at my table I thought I had more hands on than was being displayed by my HUD, so I went into Reports, then I got an error pop up that I sadly haven't gotten a pic of. I then came out of HEM and clicked my icon then I got the Optimizing Players thing come up, so I left it doing its thing, I then came back and got this error pop up

http://img3.imageshack.us/img3/6241/61883848.jpg

So I then closed it down and tried to find this error through google and came up with a page where somebody said to do a full vacuum, reindex - I do a normal vacuum/reindex and defrag on a weekly basis - and then a defrag, so I did all of that, I then shut my computer down and restarted HEM it then came up with the Optimizing Players thing again, but it has come up with that same error again. Could you please point me in the right direction?.

Thanks


Ps my current version of HEM is 1.11.05e

Patvs
05-05-2011, 10:59 PM
Please update to the latest version - http://www.holdemmanager.com/Downloads/HmUpdate.exe

Which SQL version are you using?
Read the editing of postgresql.conf section @
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html



Try creating a new database, and reimport the hands from your archive folder.

harmonica
05-06-2011, 06:55 AM
I have got the latest patch for HEM, I opened it, it then started doing the Optimizing Players thing again, I left it and it has came up again with that time out error. I think am using version 8.3 for Postgres, but then I went to pgAdmin3 opened that up and it mentions something about a version 1.8.2.99.

Thanks

fozzy71
05-06-2011, 08:35 AM
You can run our optimizer to tune the config file automatically - http://faq.holdemmanager.com/questions/437/Postgres+Optimization

If that doesn't help, try running a Full/Vac/Analyze and Reindex in PGAdmin - http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+

If none of that helps, you will have to try creating a new database or reinstall SQL completely.

*Try creating a new UTF DB - http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.
*Make sure you export/backup everything before deleting the old DB - http://faq.holdemmanager.com/questions/372/Reinstalling+on+a+new+PC+-+Backup+Tips


if you need to reinstall SQL:

*Please update to the latest beta - http://rvgsoftware.fileburst.com/HmBetaUpdate.exe

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe