PDA

View Full Version : bulk import hangs during import



mssoftware
08-06-2009, 08:19 PM
The bulk import (from folder) and auto import feature both stop working after importing several thousands of hands.

Holdem Manager version 1.09beta 23a.

In the ImportError-Logfile i noticed multiple warnings:


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

Postgres SQL server pg_log:



2009-08-07 02:05:11 CEST ERROR: duplicate key value violates unique constraint "playerhandsflop_pkey"
2009-08-07 02:05:11 CEST STATEMENT: EXECUTE PHCashKeyEXECUTE(1298470,6989988,to_timestamp('08/05/2009 07:22:05','MM/DD/YYYY HH24:MI:SS'),2,1135,6,3,0,0,0,0,0,0,False,False,0, 0,0,0,0,0,0,0,0,0,False,False,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,0,0); EXECUTE PHCashMiscEXECUTE(6989988,20000,20000,1,2,-1,False,-1,0,0,0,0,0,-1,-1,False,False,False,False,False,False,False,0,0);
...
2009-08-07 02:05:11 CEST ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-08-07 02:05:11 CEST STATEMENT: SAVEPOINT beforegame;
FATAL: could not reattach to shared memory (key=280, addr=02490000): 487
2009-08-07 02:08:10 CEST WARNING: worker took too long to start; cancelled


I already tried to reindex the database and finally created a new HM database. But the import still does not work stable.

What else could i do?

fozzy71
08-06-2009, 10:01 PM
My guess would be to do a a complete SQL reinstall. I will forward it to my support manager to see if he has any other ideas.

fabio
08-07-2009, 06:59 AM
You get the same with a new database? What PostgreSQL version are you running?

Thella
08-24-2011, 08:05 PM
Got the same problem, but after normal auto import during playtime. Did not exactly know what happened.

The synopsis was, that hands got import errors, postgres log fills up with the above error message:

2009-08-07 02:05:11 CEST ERROR: duplicate key value violates unique constraint "playerhandsflop_pkey"

But some hands got imported. Namely those hands, which hasn't seen a flop. Hands which seen a flop produce the error.

This is my workaround:

- Open pgadmin
- Select server, database, schemata, public, sequences
- Select "pokerhands_pokerhand_id_seq"
- Right click "Properties"
- Increase the actual value... mine was "11726630", so i set it to "20000000"
- Click "OK"

After that, everything got imported again.

My guess is, that holdem manager try to insert hands into the playerhandsflop table, using a playerhand_id which already exists. The playerhand_id comes from the above mentioned sequence. So increasing it works just fine.

netsrak
08-25-2011, 03:48 AM
Next time you get this please try a reindex via pgadmin->maintenance.