PDA

View Full Version : An error occurred when retrieving the player list: ERROR: 53200: out of memory



snowwhite
07-28-2011, 04:46 AM
An error occurred when retrieving the player list: ERROR: 53200: out of memory

This is the message I get when I open HEM. It still opens, but Hud is incomplete.

netsrak
07-28-2011, 08:39 AM
How big is your database?
Can you try with a new database and only some hands?

snowwhite
07-28-2011, 10:03 AM
13GB. New database works as it should.

netsrak
07-29-2011, 03:35 AM
Ok, then there is a problem with your old database. Please run a vacuum: http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+
and a reindex on the original database and try again.

snowwhite
07-29-2011, 07:56 AM
Automatic vacuuming says error. Manual vacuum says: ERROR: invalid page header in block 200562 of relation base/16873/16901

netsrak
07-29-2011, 08:12 AM
The database is damaged.
You should import all your hands to the new one.
You should find them in the archive folder (default c:\hmarchive) from where you can import them via import file or import from folder.

snowwhite
07-29-2011, 09:11 AM
Ok. Thanks. So did I break my database or what did? Do you know how I could prevent this in the future?

Patvs
07-29-2011, 11:56 PM
Database corruption is a common issue, that can be caused if your computer crashes/reboots (during a session).

Creating backups often is the only solution.
Since restoring a backup is 100x faster than reimporting 5 million handhistories into a new database.