2 18:17:23,645 INFO [application.py:288] User g16423391690190087836 is resuming game 8
2017-01-22 18:17:23,649 INFO [application.py:303] Decided to resume game 8 after final resume from player g16423391690190087836
2017-01-22 18:17:23,649 INFO [models.py:217] Resuming round 0 for game 8 in state waiting_to_next_round. Starting next round.
2017-01-22 18:17:23,649 INFO [models.py:223] Starting round 1 for game 8 with 3 players
2017-01-22 18:17:23,707 DEBUG [application.py:93] Sending 'game_started' to room 'game_8', data={'players': [{'gamer_tag': u'bugfinder9000', 'status': u'active', 'google_i...
2017-01-22 18:17:23,719 DEBUG [application.py:66] Local send for user 3, event round_start
2017-01-22 18:17:23,720 DEBUG [application.py:93] Sending 'round_start' to room '4bd9174079e345e9a53f65a7d32cc5ee', data={'hole_cards': {0: 'Kh', 1: 'Kc', 2: '9d', 3: '5d', 4: 'Qs', 5: '6s', 6: '7...
2017-01-22 18:17:23,728 DEBUG [application.py:66] Local send for user 2, event round_start
2017-01-22 18:17:23,728 DEBUG [application.py:93] Sending 'round_start' to room '6b0be1d064b84e16a765615c6cc03518', data={'hole_cards': {0: '3c', 1: '6c', 2: '3s', 3: '6h', 4: 'Ks', 5: '9h', 6: '5...
2017-01-22 18:17:23,734 DEBUG [application.py:66] Local send for user 1, event round_start
2017-01-22 18:17:23,734 DEBUG [application.py:93] Sending 'round_start' to room '6f0e898c33804397b4d790b7cefb3f35', data={'hole_cards': {0: '2s', 1: 'Jh', 2: '4s', 3: '6d', 4: '4c', 5: 'Th', 6: 'A...
2017-01-22 18:17:46,097 DEBUG [application.py:456] Received event 'suspend_game'
2017-01-22 18:17:46,104 INFO [application.py:271] User g16423391690190087836 is suspending game 8
2017-01-22 18:17:46,113 DEBUG [application.py:93] Sending 'player_suspended' to room 'game_8', data={'gamer_tag': u'combatwombat32', 'game_id': 8, 'google_id': u'g164233916901...
2017-01-22 18:17:46,136 DEBUG [application.py:66] Local send for user 1, event user_info
2017-01-22 18:17:46,136 DEBUG [application.py:93] Sending 'user_info' to room '6f0e898c33804397b4d790b7cefb3f35', data={'games': [{'num_players': 3, 'current_round': 4, 'host': u'g12707494354730...
2017-01-22 18:17:46,255 DEBUG [application.py:456] Received event 'login'
2017-01-22 18:17:46,255 INFO [application.py:176] Client 6f0e898c33804397b4d790b7cefb3f35 is logging in
2017-01-22 18:17:46,258 INFO [application.py:180] Found existing account for google id g16423391690190087836
2017-01-22 18:17:46,279 DEBUG [application.py:66] Local send for user 1, event user_info
2017-01-22 18:17:46,279 DEBUG [application.py:93] Sending 'user_info' to room '6f0e898c33804397b4d790b7cefb3f35', data={'games': [{'num_players': 3, 'current_round': 4, 'host': u'g12707494354730...
2017-01-22 18:17:48,711 DEBUG [application.py:456] Received event 'suspend_game'
2017-01-22 18:17:48,715 INFO [application.py:271] User g07291301208965202879 is suspending game 8
2017-01-22 18:17:48,724 DEBUG [application.py:93] Sending 'player_suspended' to room 'game_8', data={'gamer_tag': u'HarveyTheDoggo', 'game_id': 8, 'google_id': u'g072913012089...
2017-01-22 18:17:48,751 DEBUG [application.py:66] Local send for user 2, event user_info
2017-01-22 18:17:48,751 DEBUG [application.py:93] Sending 'user_info' to room '6b0be1d064b84e16a765615c6cc03518', data={'games': [{'num_players': 3, 'current_round': 4, 'host': u'g12707494354730...
2017-01-22 18:17:48,957 DEBUG [application.py:456] Received event 'login'
2017-01-22 18:17:48,959 INFO [application.py:176] Client 6b0be1d064b84e16a765615c6cc03518 is logging in
2017-01-22 18:17:48,962 INFO [application.py:180] Found existing account for google id g07291301208965202879
2017-01-22 18:17:48,987 DEBUG [application.py:66] Local send for user 2, event user_info
2017-01-22 18:17:48,987 DEBUG [application.py:93] Sending 'user_info' to room '6b0be1d064b84e16a765615c6cc03518', data={'games': [{'num_players': 3, 'current_round': 4, 'host': u'g12707494354730...
2017-01-22 18:17:49,943 DEBUG [application.py:456] Received event 'suspend_game'
2017-01-22 18:17:49,947 INFO [application.py:271] User g12707494354730532094 is suspending game 8
2017-01-22 18:17:49,955 DEBUG [application.py:93] Sending 'player_suspended' to room 'game_8', data={'gamer_tag': u'bugfinder9000', 'game_id': 8, 'google_id': u'g1270749435473...
2017-01-22 18:17:49,978 DEBUG [application.py:66] Local send for user 3, event user_info
2017-01-22 18:17:49,979 DEBUG [application.py:93] Sending 'user_info' to room '4bd9174079e345e9a53f65a7d32cc5ee', data={'games': [{'num_players': 3, 'current_round': 4, 'host': u'g12707494354730...
2017-01-22 18:17:50,757 DEBUG [application.py:456] Received event 'login'
2017-01-22 18:17:50,759 INFO [application.py:176] Client 4bd9174079e345e9a53f65a7d32cc5ee is logging in
2017-01-22 18:17:50,762 INFO [application.py:180] Found existing account for google id g12707494354730532094
2017-01-22 18:17:50,794 DEBUG [application.py:66] Local send for user 3, event user_info
2017-01-22 18:17:50,794 DEBUG [application.py:93] Sending 'user_info' to room '4bd9174079e345e9a53f65a7d32cc5ee', data={'games': [{'num_players': 3, 'current_round': 4, 'host': u'g12707494354730...
2017-01-22 18:19:24,873 DEBUG [application.py:456] Received event 'host_game'
2017-01-22 18:19:24,876 INFO [models.py:142] Adding user 'g12707494354730532094' to game None
2017-01-22 18:19:24,877 INFO [application.py:204] User g12707494354730532094 is hosting a game
2017-01-22 18:19:24,892 DEBUG [application.py:66] Local send for user 3, event game_hosted
2017-01-22 18:19:24,892 DEBUG [application.py:93] Sending 'game_hosted' to room '4bd9174079e345e9a53f65a7d32cc5ee', data={'game_id': '9'}
2017-01-22 18:19:27,806 DEBUG [application.py:456] Received event 'join_game'
2017-01-22 18:19:27,814 INFO [application.py:220] User g07291301208965202879 is joining game 8
2017-01-22 18:19:27,814 INFO [models.py:142] Adding user 'g07291301208965202879' to game 8
2017-01-22 18:19:27,819 ERROR [application.py:448] Error from client 6b0be1d064b84e16a765615c6cc03518
Traceback (most recent call last):
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/flask_socketio/__init__.py", line 588, in _handle_event
    ret = handler(*args)
  File "application.py", line 223, in on_join_game
    db.session.commit()
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py", line 157, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 801, in commit
    self.transaction.commit()
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 392, in commit
    self._prepare_impl()
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl
    self.session.flush()
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2019, in flush
    self._flush(objects)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2137, in _flush
    transaction.rollback(_capture_exception=True)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2101, in _flush
    flush_context.execute()
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
    rec.execute(self)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
    uow
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
    mapper, table, insert)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements
    execute(statement, params)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: user_score.user_id, user_score.game_id [SQL: u'INSERT INTO user_score (user_id, game_id, score, player_state, ready_for_round) VALUES (?, ?, ?, ?, ?)'] [parameters: (2, 8, 0, 'active', 0)]
wsgi exiting
2017-01-22 18:19:27,961 DEBUG [application.py:456] Received event 'join_game'
2017-01-22 18:19:27,965 INFO [application.py:220] User g16423391690190087836 is joining game 8
2017-01-22 18:19:27,966 INFO [models.py:142] Adding user 'g16423391690190087836' to game 8
2017-01-22 18:19:27,971 ERROR [application.py:448] Error from client 6f0e898c33804397b4d790b7cefb3f35
Traceback (most recent call last):
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/flask_socketio/__init__.py", line 588, in _handle_event
    ret = handler(*args)
  File "application.py", line 223, in on_join_game
    db.session.commit()
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py", line 157, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 801, in commit
    self.transaction.commit()
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 392, in commit
    self._prepare_impl()
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl
    self.session.flush()
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2019, in flush
    self._flush(objects)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2137, in _flush
    transaction.rollback(_capture_exception=True)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2101, in _flush
    flush_context.execute()
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
    rec.execute(self)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
    uow
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
    mapper, table, insert)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements
    execute(statement, params)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/Users/CWins/.virtualenvs/pokergame/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: user_score.user_id, user_score.game_id [SQL: u'INSERT INTO user_score (user_id, game_id, score, player_state, ready_for_round) VALUES (?, ?, ?, ?, ?)'] [parameters: (1, 8, 0, 'active', 0)]