Quote:
Originally Posted by ChazDazzle
Looks like there's an issue with doing sessions on sqlite. Try installing mysql or postgres and it should work.
I installed and configured postgresql and test imported a few existing HH files.
I then set up to bulk import all 2014 hands.
First thing I noticed is that the hands were parsed in an arbitrary order -- not by date/time nor alphabetically.
Next problem is that after a time, the process failed.
I removed the "offending" file, recreated the tables, and re-imported.
After I had collected 10 such "failed" files, I noticed that the failures all happened when around 2200 files had been imported +/- a couple of hundred.
I then did a test import on the failed files, and they all imported, but the next one failed.
The error messages seemed strange.
Here is a fairly typical set of messages on failure:
2014-02-19 14:12:18,173 - parser INFO Read 42 hands (0 failed) in 0.203 seconds
2014-02-19 14:12:20,484 - importer ERROR Importer._import_hh_file: '<type 'file'>' Fatal error: ''Traceback (most recent call last): File "Importer.pyc", line 469, in _import_hh_file File "Hand.pyc", line 360, in updateSessionsCache File "Database.pyc", line 2704, in storeSessionsCacheKeyError: \'sessionStart\'''
2014-02-19 14:12:20,484 - importer ERROR 'u"PokerStars Hand #111883204506: 5 Card Draw Limit ($0.25/$0.50 USD) - 2014/02/15 13:57:24 PT [2014/02/15 16:57:24 ET]\nTable 'Kurhah IV' 6-max Seat #6 is the button\nSeat 2: Bilbobeutl. ($9.87 in chips)"'
I then set cacheSessions="False" and imported all 15K hands in short order.
Is there a place I can upload my log files?
Regards,
--D