PDA

View Full Version : Import error 25p02



justdoit
05-26-2010, 08:54 AM
Hi,
my HM/Postgres has a strange problem.
The hands I play myself will get imported.
Datamined hands wont and i receive the following error from the log:

FEHLER: 25P02: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert
HM just doesnt import the hands, only import errors.
I have no idea wat it is.
I tried the following:
Purge, Full Vacuum, Reindex, Backup, Restore in a new DB. Everything hasnt helped.

Any Ideas?
:confused::confused:
Thanks for the help, bye.


edit:
have another wird problem
my ev is calculated wrong. it shows an absurd high sum after a few hundred hands of cashgame.

Sarek
05-26-2010, 03:04 PM
what this message means in English?
can you change Postgre language via pgadmin?

Edit the postgres.conf file via Start > Programs > Postgres > Configruation Files > Edit postgres.conf; and find the line with lc_messages in it.
Put a # at the start of the line (to comment it out) and then add this line below it:
lc_messages='English_United States.1252'
Save the file and then do Start > Programs > Postgres > Reload Configuration.

justdoit
05-26-2010, 06:23 PM
it means:

25P02 - current transaction is aborted, commands ignored


oh its sooo tilting.
i reinstalled postgres and it didnt change anything :(

Sarek
05-27-2010, 04:18 AM
try to do DB mainternamce via Pgadmin (vacuum + reindex)
FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+)

justdoit
05-27-2010, 06:37 AM
Hi,
I tried the following:
Purge, Full Vacuum, Reindex,

any other ideas?

bye