View Full Version : thousands of import errors?
infurrrno
02-11-2011, 04:38 AM
I'm getting thousands of import errors when I try and import to my db. Is there anywhere I can check a log and find out what is causing them? Causing me much frustration :)
cheers
netsrak
02-11-2011, 04:50 AM
We have some logging in the importing subfolder of your Holdemmanager installation path.
Which site are the hands from?
Which gametype?
Mined hands?
Which hm version?
What happens if you create a new database and import some of the hands via import file or import from folder?
infurrrno
02-11-2011, 06:46 AM
We have some logging in the importing subfolder of your Holdemmanager installation path.
Which site are the hands from?
Which gametype?
Mined hands?
Which hm version?
What happens if you create a new database and import some of the hands via import file or import from folder?
stars, ft and ub.
yes, mined hands. (cash nl100 - nl1000)
version 1.11.05d
I havent tried a new db but will get back to u.
infurrrno
02-11-2011, 10:34 AM
I found my import errors log, it is reading the following sort of thing;
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1710.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1711.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1712.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1713.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1714.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1715.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1716.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1717.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1718.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1719.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.172.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1720.txt
...You get the idea. I can't make sense of it though.
infurrrno
02-11-2011, 11:04 AM
I read every other thread on this particular error. Haven't found a common solution yet. Here is what I have done so far;
Updated to latest version 1.11.06a (still errors)
Tried importing subfolders rather than parent folder (still errors)
Vaccuumed etc (still errors)
***Creating new db worked.
Once again thanks for the great support!
netsrak
02-11-2011, 01:03 PM
Your original database is damaged. If a reindex via pgadminII->maintenance doesn't help you need to reimport all your hands into a new database.
And you should do regular database backups in future.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.