PDA

View Full Version : Player Hand Error



Wargos
10-23-2012, 05:06 AM
Hello,

I have some problems with my PC and i reinstall windows. The first 2 days i import like 3mill hands correctly.

But now, when i try to important hands, when i reach 400.000 hands (more or less), HM stop to import hands and show the following error.


87651

Patvs
10-23-2012, 12:26 PM
Are you using HM1?
Which PostgreSQL version are you using?


Try reindexing the database in pgadminIII:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html,

Wargos
10-23-2012, 12:40 PM
Yes i.m using HM1. And hands are from pokerstars.

The PostgreSQL are 8.4.

Ok, i will try the reindexing.

Patvs
10-23-2012, 12:50 PM
If the reindex doesn't resolve it, it looks like some sort of database corruption.
You can try the top 10 performance tips: editing postgresql.config, and turning off logging. (reboot when you make changes)

Then reimport the handhistories into a new database.
Don't import 4 million simultaneously. Break them up into for example 10 batches/folders importing 400.000 each.