incorrect duplicates accessing DB from two instances of PT3

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

incorrect duplicates accessing DB from two instances of PT3

Postby scbrigad » Tue Jun 17, 2008 3:46 am

I am running Idleminer FT on two computers and tracking 6max SNG's on one and FR SNG's on the other at the same buyins. They are both getting thrown in to the same DB on the server, both using auto-import on the Full Tilt Program HHF Dir. with an instance of Idleminer and PT3 running on each machine. The remote PT3 auto-import will occasionally (happened 3 times today) start reporting the files as duplicates. When I stop auto-import and use the manual import it loads them in to the DB just fine, and restarting auto-import the glitch seems to go away at least temporarily...

More of an annoyance than anything but I figured I'd report it. Idleminer should have nothing to do with it since its using the main Full Tilt hand history files to auto-import.
scbrigad
 
Posts: 28
Joined: Fri Apr 04, 2008 9:49 pm
Location: Phoenix, AZ

Re: incorrect duplicates accessing DB from two instances of PT3

Postby WhiteRider » Tue Jun 17, 2008 4:42 am

It is not safe to import into the same database from two PT3 sources at once, so this could cause problems.
The safest ways to do this are to either have one PT3 instance access the other PC and import all the hands, or wait until after the session on one PC and do a manual import.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: incorrect duplicates accessing DB from two instances of PT3

Postby scbrigad » Tue Jun 17, 2008 5:06 pm

what have you heard/seen happen that is not safe beyond an occassional crash or this duplicates issue I mentioned? So far this setup has been working pretty well for me, but I don't know if I should be worried about corrupting my DB. Isn't the whole idea of SQL having simultaneous reads/writes hitting the same DB?
scbrigad
 
Posts: 28
Joined: Fri Apr 04, 2008 9:49 pm
Location: Phoenix, AZ

Re: incorrect duplicates accessing DB from two instances of PT3

Postby WhiteRider » Tue Jun 17, 2008 6:23 pm

I don't know what the details are, I'm afraid, but I'm sure I remember Josh saying that it's not guarenteed safe. I'm sure most of the time it will work fine, but you can't be sure what is happening in the background.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 9 guests