PT3 freezes up when importing duplicate SNG history

[mixan]

I use PT3 beta17. I play S'nG on PartyPoker and import SNG hand histories from the saved text of the e-mails.

When i try to import a tourney that is already contained in the database import just freezes up, the timer is ticking but nothing else happens. PT3 and postgres continue to use 100% of the CPU time.
Import status window looks like this:

2008/09/16 15:50:05: Info: Import file: D:\Temp\sng hh\hh_0038.txt
2008/09/16 15:50:06: Info: - Tournament summary imported.
2008/09/16 15:50:07: Info: + Complete (33 hands, 0 errors, 0 duplicates)
2008/09/16 15:50:07: Info: Import file: D:\Temp\sng hh\hh_0039.txt
2008/09/16 15:50:07: Info: - Tournament summary imported.
2008/09/16 15:50:07: Info: + Complete (21 hands, 0 errors, 0 duplicates)
2008/09/16 15:50:07: Info: Import file: D:\Temp\sng hh\hh_0040.txt
2008/09/16 15:50:07: Info: - Tournament summary imported.

Stop button doesn't work and I cant exit PT3 because the import is active
After a long time I receive an error from my Windows XP SP2 about PT crash.

[WhiteRider]

Do you have hand history information for all these summaries already imported?

I don't *think* it's anything to do with the tourney already being imported.
If you try to import the next single file (D:\Temp\sng hh\hh_0041.txt, I assume?) does it hang?
If you go back and try D:\Temp\sng hh\hh_0039.txt again, does that work?
What about 42?
If it proves to be just 41 (or 40, or whatever) that causes the problem, please send it via the Support system , and link to this thread in the reference field of the ticket so that we can investigate.

If you can identify the hand history files for the tourneys being imported and send those too, that would really help.

[mixan]

In the example above hh_0039.txt and hh_0040.txt was identical (it is some bug in my e-mail soft or may be Party sends me duplicate e-mails)
After killing the pokertracker process i can find all 39 imported tourneys in the database.
If i try to import other tourneys 41 and so on - it's fine, if there are no more duplicates.
If i try to import any of the previously imported tourneys (from 1 to 39) - PT3 freezes up again.

[WhiteRider]

OK, that's interesting.
Please send a hand history file and summary file for a SNG via the Support system , and link to this thread in the reference field of the ticket so that we can investigate.

[mixan]

I'm sorry. I've tried it on my second computer and it work fine... It seems to me that the problem is in my postgresql or PT3. I'll reinstall both and if the problem persists I'll post the ticket.

[WhiteRider]

OK, thanks.

[mixan]

I have found out that this bug exist with PostgreSQL 8.3.1 and 8.3.4 (didn't try any other above 8.3.1). PostgreSQL 8.3.0 works fine.
I had upgraded my PC that worked OK with PT3 and tried to install newer version of Postgre, but got the same issue with duplicated HH's (FL cash this time).
Now I use 8.3.0 because it was only the one that works.

I'm sorry if somewhere the FAQ's it is told to use only 8.3.0... Didn't now that.

[WhiteRider]

Thanks for the information.