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?
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?