bugpokersource - Bugs: bug #14628, pokerservice.tourneyCreateTable...

 
 
Show feedback again

You are not allowed to post comments on this tracker with your current authentification level.

bug #14628: pokerservice.tourneyCreateTable _mysql_exceptions.IntegrityError: (1062, "Duplicate entry 'Classic392' for key 2")

Submitted by:  Johan Euphrosine <proppy>
Submitted on:  Tue 27 Oct 2009 02:39:54 PM UTC  
 
Category: poker-networkSeverity: 3 - Normal
Priority: 7 - HighStatus: Confirmed
Privacy: PublicAssigned to: None
Open/Closed: Open

Wed 28 Oct 2009 12:31:36 PM UTC, comment #3:

Here is a log showing 37 _mysql_exceptions.IntegrityError: (1062, "Duplicate entry 'Classic392' for key 2") errors

(file #7155)

Johan Euphrosine <proppy>
Project Member
Tue 27 Oct 2009 02:53:06 PM UTC, comment #2:

We discussed the following workaround on #skypoker:

- Use next auto_increment, or a db counter instead of in memory/volatile pokerservice.tourney_table_serial
- drop unique constraint on pokertables.name

Johan Euphrosine <proppy>
Project Member
Tue 27 Oct 2009 02:50:24 PM UTC, comment #1:

Hi,

I believe the attached patch reproduce this issue.

(file #7138)

Johan Euphrosine <proppy>
Project Member
Tue 27 Oct 2009 02:39:54 PM UTC, original submission:

2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] PokerResource: ERROR (x-cluster-client-ip:84.100.63.136) Traceback (most recent call last):
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/twisted/internet/defer.py", line 185, in addCallbacks
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] self._runCallbacks()
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/twisted/internet/defer.py", line 323, in _runCallbacks
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] self.result = callback(self.result, args, *kw)
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/pokernetwork/pokersite.py", line 246, in <lambda>
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] deferred.addCallback(lambda result: self.deferRender(request, jsonp, packet))
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/pokernetwork/pokersite.py", line 257, in deferRender
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] d = defer.maybeDeferred(session.avatar.handlePacketDefer, packet)
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] --- <exception caught here> ---
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/twisted/internet/defer.py", line 105, in maybeDeferred
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] result = f(*args, **kw)
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/pokernetwork/pokeravatar.py", line 346, in handlePacketDefer
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] self.handlePacketLogic(packet)
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/pokernetwork/pokeravatar.py", line 547, in handlePacketLogic
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] self.service.tourneyRegister(packet)
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/pokernetwork/pokerservice.py", line 1343, in tourneyRegister
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] tourney.register(serial)
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/pokerengine/pokertournament.py", line 382, in register
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] self.updateRunning()
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/pokerengine/pokertournament.py", line 280, in updateRunning
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] self.changeState(TOURNAMENT_STATE_RUNNING)
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/pokerengine/pokertournament.py", line 345, in changeState
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] self.createGames()
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/pokerengine/pokertournament.py", line 441, in createGames
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] game = self.callback_create_game(self)
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/pokernetwork/pokerservice.py", line 982, in tourneyCreateTable
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] 'tourney': tourney,
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/pokernetwork/pokerservice.py", line 2567, in createTable
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] cursor.execute(sql)
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line 163, in execute
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] self.errorhandler(self, exc, value)
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] File "/usr/lib/python2.5/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] raise errorclass, errorvalue
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4] _mysql_exceptions.IntegrityError: (1062, "Duplicate entry 'Classic392' for key 2")
2009-10-27 05:54:29+0100 [HTTPChannel,9236399,172.18.21.4]

Johan Euphrosine <proppy>
Project Member

 

Attached Files
file #7155:  poker-network-server-skyrock3.log.1 added by proppy (977kB - application/octet-stream)

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -unavailable- added by proppy (Submitted the item)
  •  

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 3 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Wed 28 Oct 2009 12:31:36 PM UTCproppyAttached File-=>Added poker-network-server-skyrock3.log.1, #7155
    Tue 27 Oct 2009 05:37:55 PM UTCproppyStatusIn Progress=>Confirmed
    Tue 27 Oct 2009 02:50:24 PM UTCproppyAttached File-=>Added poker-network-test-duplicate-table-name.patch, #7138
    Show feedback again

    Back to the top


    Powered by Savane 3.1-cleanup