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)
file #7138:  poker-network-test-duplicate-table-name.patch added by proppy (1kB - text/x-patch)

 

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


    Copyright (C) 2004-2006, the Gna! people. Posted items are owned by whoever posted them.
    Verbatim copying and distribution of this entire article is permitted in any medium, provided this notice is preserved.

    Powered by Savane 3.1-cleanup