PDA

View Full Version : sql error



supermad4it
08-02-2010, 06:26 AM
Hi, I'm getting this error when trying to import a large HH file:

The Error: ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

Occurred when running ExecuteNonQuery with this query: SAVEPOINT beforegame;

So none of the hands are being imported.

Thanks

Patvs
08-02-2010, 09:04 AM
How large are these text files??

Read: http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

supermad4it
08-02-2010, 09:10 AM
its 1 million hands in dozens of small files

Patvs
08-02-2010, 09:21 AM
Split the 1 million hands into 4 batches. (suppose they are 10.000 files---> 4 folders each with 2.500 files)

See link above (edit the postgresql.conf, etc. AND REBOOT)
Please update to the latest version - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Create a NEW database--> then import the folders one at a time.
After each folder vacuum/analyse your database.