bakert
commented
5 years ago (_mysql_exceptions.IntegrityError) (1062, "Duplicate entry '212783687' for key 'PRIMARY'") [SQL: 'INSERT INTO match (id, format_id, comment, start_time, end_time, has_unexpected_third_game, is_league, is_tournament) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)'] [parameters: (212783687, 1, 'PD League', None, None, None, None, None)] (Background on this error at: http://sqlalche.me/e/gkpj)
Reported on logsite by logged_out
--------------------------------------------------------------------------------
Request Method: POST
Path: /api/upload?
Cookies: {}
Endpoint: upload
View Args: {}
Person: logged_out
Referrer: None
Request Data: {'match_id': '212783687', 'lines': "PennyDreadful\r\nPD League\r\nBuggedCardObserver, LeagueObserver, PennyDreadfulLegality\r\nRareProducts,LasersDuFutur\r\n\r\n== Game 1 (654304018) ==\r\n[Time] 1544490931\r\n[12:15:31] PDBot has started watching.\r\n[12:15:31] RareProducts joined the game.\r\n[12:15:32] LasersDuFutur joined the game.\r\n[League] Goblin Midrange by rareproducts (30443) vs Beasties by lasersdufutur (30427)\r\n[12:15:36] [CHAT] PDBot: [sD] Good luck in your League match!\r\n[12:15:36] [CHAT] PDBot: [sD] Due to a Magic Online bug, PDBot is unable to tell which player is which. Please report this league match manually.\r\n[12:15:38] RareProducts chooses to play first.\r\n[12:15:45] RareProducts mulligans to 6 cards.\r\n[12:15:47] LasersDuFutur keeps this hand.\r\n[12:15:49] RareProducts mulligans to 5 cards.\r\n[12:15:56] RareProducts keeps this hand.\r\n[12:15:59] RareProducts puts 1 card on top of their library.\r\n[12:15:59] Turn 1: RareProducts\r\n[12:15:59] RareProducts skips their draw step.\r\n[12:16:03] RareProducts plays [Mountain].\r\n[12:16:06] Turn 1: LasersDuFutur\r\n[12:16:11] LasersDuFutur plays [Mountain Valley].\r\n[12:16:13] Turn 2: RareProducts\r\n[12:16:15] RareProducts plays [Swamp].\r\n[12:16:17] RareProducts casts [Frogtosser Banneret].\r\n[12:16:24] LasersDuFutur is being attacked by [Frogtosser Banneret].\r\n[12:16:26] Turn 2: LasersDuFutur\r\n[12:16:28] LasersDuFutur activates an ability of [Mountain Valley] ( Search your library for a Mountain or Forest card, put it onto the battlefield, then shuffle your...).\r\n[12:16:49] LasersDuFutur plays [Mountain Valley].\r\n[12:16:53] Turn 3: RareProducts\r\n[12:17:00] RareProducts casts [Mad Auntie].\r\n[12:17:07] LasersDuFutur is being attacked by [Frogtosser Banneret].\r\n[12:17:40] Turn 3: LasersDuFutur\r\n[12:17:41] LasersDuFutur activates an ability of [Mountain Valley] ( Search your library for a Mountain or Forest card, put it onto the battlefield, then shuffle your...).\r\n[12:17:41] LasersDuFutur plays [Mountain].\r\n[12:17:41] LasersDuFutur casts [Electrostatic Pummeler].\r\n[12:17:42] LasersDuFutur puts triggered ability from [Electrostatic Pummeler] onto the stack (When Electrostatic Pummeler enters the battlefield, you get {EEE}.).\r\n[12:17:42] LasersDuFutur gains 3 energy from [Electrostatic Pummeler]'s ability.\r\n[12:17:45] Turn 4: RareProducts\r\n[12:17:47] RareProducts plays [Cinder Barrens].\r\n[12:17:51] RareProducts casts [Mad Auntie].\r\n[12:18:07] LasersDuFutur is being attacked by [Frogtosser Banneret].\r\n[12:18:14] Turn 4: LasersDuFutur\r\n[12:18:18] LasersDuFutur plays [Forest].\r\n[12:18:35] LasersDuFutur casts [Fanatic of Xenagos].\r\n[12:18:41] The chosen player is RareProducts\r\n[12:18:43] RareProducts didn't pay the tribute for [Fanatic of Xenagos].\r\n[12:18:44] LasersDuFutur puts triggered ability from [Fanatic of Xenagos] onto the stack (When Fanatic of Xenagos enters the battlefield, if tribute wasn't paid, it gets +1/+1 and gains ha...).\r\n[12:19:05] RareProducts is being attacked by [Fanatic of Xenagos].\r\n[12:19:13] [Mad Auntie] blocks [Fanatic of Xenagos].\r\n[12:19:20] RareProducts activates an ability of [Mad Auntie] targeting [Mad Auntie] ( Regenerate another target Goblin.).\r\n[12:19:31] LasersDuFutur casts [Pillar of Flame] targeting RareProducts.\r\n[12:19:37] Turn 5: RareProducts\r\n[12:19:48] RareProducts casts [Frogtosser Banneret].\r\n[12:19:58] RareProducts casts [Goblin Warchief].\r\n[12:20:12] LasersDuFutur is being attacked by [Goblin Warchief], [Frogtosser Banneret], [Mad Auntie], [Mad Auntie], and [Frogtosser Banneret].\r\n[12:20:20] [Electrostatic Pummeler] blocks [Goblin Warchief].\r\n[12:20:39] Turn 5: LasersDuFutur\r\n[12:20:45] LasersDuFutur plays [Mountain].\r\n[12:20:48] LasersDuFutur has conceded from the game.\r\nWinner: RareProducts\r\nGame 1 Completed.\r\n[12:20:52] RareProducts has left the game.\r\n== Game 2 (654304684) ==\r\n[Time] 1544491290\r\n[12:21:30] PDBot has started watching.\r\n[12:21:39] LasersDuFutur chooses to play first.\r\n[12:21:43] LasersDuFutur keeps this hand.\r\n[12:21:46] RareProducts keeps this hand.\r\n[12:21:46] Turn 1: LasersDuFutur\r\n[12:21:52] LasersDuFutur skips their draw step.\r\n[12:21:53] LasersDuFutur plays [Forest].\r\n[12:21:56] LasersDuFutur casts [Attune with Aether].\r\n[12:21:59] LasersDuFutur reveals [Mountain].\r\n[12:21:59] LasersDuFutur gains 2 energy from [Attune with Aether]'s ability.\r\n[12:22:05] Turn 1: RareProducts\r\n[12:22:06] RareProducts plays [Cinder Barrens].\r\n[12:22:09] Turn 2: LasersDuFutur\r\n[12:22:22] LasersDuFutur plays [Rugged Highlands].\r\n[12:22:22] LasersDuFutur puts triggered ability from [Rugged Highlands] onto the stack (When Rugged Highlands enters the battlefield, you gain 1 life.).\r\n[12:22:31] LasersDuFutur casts [Attune with Aether].\r\n[12:22:34] LasersDuFutur reveals [Forest].\r\n[12:22:34] LasersDuFutur gains 2 energy from [Attune with Aether]'s ability.\r\n[12:22:39] Turn 2: RareProducts\r\n[12:22:41] RareProducts plays [Foreboding Ruins].\r\n[12:22:47] RareProducts casts [Frogtosser Banneret].\r\n[12:22:59] LasersDuFutur is being attacked by [Frogtosser Banneret].\r\n[12:23:02] Turn 3: LasersDuFutur\r\n[12:23:10] LasersDuFutur plays [Mountain].\r\n[12:23:24] LasersDuFutur casts [Fanatic of Xenagos].\r\n[12:23:26] The chosen player is RareProducts\r\n[12:23:31] RareProducts didn't pay the tribute for [Fanatic of Xenagos].\r\n[12:23:31] LasersDuFutur puts triggered ability from [Fanatic of Xenagos] onto the stack (When Fanatic of Xenagos enters the battlefield, if tribute wasn't paid, it gets +1/+1 and gains ha...).\r\n[12:23:39] RareProducts is being attacked by [Fanatic of Xenagos].\r\n[12:23:43] Turn 3: RareProducts\r\n[12:23:47] RareProducts plays [Mountain].\r\n[12:24:07] RareProducts casts [Goblin Warchief].\r\n[12:24:13] RareProducts casts [Goblin Cratermaker].\r\n[12:24:27] LasersDuFutur is being attacked by [Goblin Warchief] and [Frogtosser Banneret].\r\n[12:24:35] Turn 4: LasersDuFutur\r\n[12:24:41] LasersDuFutur plays [Forest].\r\n[12:25:23] LasersDuFutur casts [Electrostatic Pummeler].\r\n[12:25:28] LasersDuFutur puts triggered ability from [Electrostatic Pummeler] onto the stack (When Electrostatic Pummeler enters the battlefield, you get {EEE}.).\r\n[12:25:30] LasersDuFutur gains 3 energy from [Electrostatic Pummeler]'s ability.\r\n[12:25:37] Turn 4: RareProducts\r\n[12:25:45] RareProducts plays [Mountain].\r\n[12:25:52] RareProducts casts [Boggart Harbinger].\r\n[12:25:58] RareProducts puts triggered ability from [Boggart Harbinger] onto the stack (When Boggart Harbinger enters the battlefield, you may search your library for a Goblin card, reve...).\r\n[12:26:21] RareProducts reveals [Warren Weirding].\r\n[12:26:27] RareProducts casts [Goblin Ringleader].\r\n[12:26:34] RareProducts puts triggered ability from [Goblin Ringleader] onto the stack (When Goblin Ringleader enters the battlefield, reveal the top four cards of your library. Put all ...).\r\n[12:26:37] RareProducts reveals 4 cards with [Goblin Ringleader]'s ability: [Wort, Boggart Auntie], [Foreboding Ruins], [Warren Weirding], and [Warren Weirding].\r\n[12:26:41] RareProducts puts [Wort, Boggart Auntie], [Warren Weirding], and [Warren Weirding] into their hand with with [Goblin Ringleader]'s ability.\r\n[12:26:45] RareProducts casts [Warren Weirding] targeting LasersDuFutur.\r\n[12:27:04] LasersDuFutur sacrifices [Fanatic of Xenagos].\r\n[12:27:15] LasersDuFutur is being attacked by [Goblin Ringleader] and [Boggart Harbinger].\r\n[12:27:20] Turn 5: LasersDuFutur\r\n[12:27:39] LasersDuFutur casts [Voltaic Brawler].\r\n[12:27:43] LasersDuFutur puts triggered ability from [Voltaic Brawler] onto the stack (When Voltaic Brawler enters the battlefield, you get {EE}.).\r\n[12:27:52] LasersDuFutur gains 2 energy from [Voltaic Brawler]'s ability.\r\n[12:28:14] RareProducts is being attacked by [Electrostatic Pummeler].\r\n[12:28:23] [Goblin Cratermaker] blocks [Electrostatic Pummeler].\r\n[12:28:29] LasersDuFutur discards [Ghor-Clan Rampager].\r\n[12:28:29] LasersDuFutur activates an ability of [Ghor-Clan Rampager] targeting [Electrostatic Pummeler] ( Target attacking creature gets +4/+4 and gains trample until end of turn.).\r\n[12:28:42] LasersDuFutur activates an ability of [Electrostatic Pummeler] ( Electrostatic Pummeler gets +X/+X until end of turn, where X is Electrostatic Pummeler's power.).\r\n[12:28:45] RareProducts has conceded from the game.\r\nWinner: LasersDuFutur\r\nGame 2 Completed.\r\n[12:28:49] RareProducts has left the game.\r\n== Game 3 (654305616) ==\r\n[Time] 1544491760\r\n[12:29:20] PDBot has started watching.\r\n[12:29:28] RareProducts keeps this hand.\r\n[12:29:32] LasersDuFutur keeps this hand.\r\n[12:29:32] Turn 1: RareProducts\r\n[12:29:32] RareProducts skips their draw step.\r\n[12:29:33] RareProducts plays [Foreboding Ruins].\r\n[12:29:38] Turn 1: LasersDuFutur\r\n[12:29:41] LasersDuFutur plays [Mountain Valley].\r\n[12:29:44] Turn 2: RareProducts\r\n", 'start_time_utc': '1544490931', 'end_time_utc': '1544491784'}
Host: logs.pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: XX
X-Forwarded-For: 35.205.164.196, 141.101.69.23
Cf-Ray: 48742e9c781da8cf-CDG
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Content-Type: application/x-www-form-urlencoded
Cf-Connecting-Ip: 35.205.164.196
X-Forwarded-Host: logs.pennydreadfulmagic.com
X-Forwarded-Server: logs.pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 11115
IntegrityError
(_mysql_exceptions.IntegrityError) (1062, "Duplicate entry '212783687' for key 'PRIMARY'") [SQL: 'INSERT INTO match (id, format_id, comment, start_time, end_time, has_unexpected_third_game, is_league, is_tournament) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)'] [parameters: (212783687, 1, 'PD League', None, None, None, None, None)] (Background on this error at: http://sqlalche.me/e/gkpj)
Stack Trace:
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2309, in __call__
return self.wsgi_app(environ, start_response)
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2295, in wsgi_app
response = self.handle_exception(e)
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 2292, in wsgi_app
response = self.full_dispatch_request()
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1815, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1718, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/home/discord/.local/lib/python3.6/site-packages/flask/_compat.py", line 35, in reraise
raise value
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "/home/discord/.local/lib/python3.6/site-packages/flask/app.py", line 1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "./logsite/api.py", line 26, in upload
importing.import_log(lines.split('\n'), match_id)
File "./logsite/importing.py", line 30, in import_log
local = import_header(lines, match_id)
File "./logsite/importing.py", line 75, in import_header
local = match.create_match(match_id, format_name, comment, modules, players)
File "./logsite/data/match.py", line 81, in create_match
db.commit()
File "./logsite/db.py", line 52, in commit
return DB.session.commit()
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/orm/scoping.py", line 153, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 954, in commit
self.transaction.commit()
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 467, in commit
self._prepare_impl()
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 447, in _prepare_impl
self.session.flush()
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2313, in flush
self._flush(objects)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2440, in _flush
transaction.rollback(_capture_exception=True)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 249, in reraise
raise value
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2404, in _flush
flush_context.execute()
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 395, in execute
rec.execute(self)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 560, in execute
uow
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 181, in save_obj
mapper, table, insert)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 836, in _emit_insert_statements
execute(statement, multiparams)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 248, in reraise
raise value.with_traceback(tb)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/home/discord/.local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
cursor.execute(statement, parameters)
File "/home/discord/.local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 255, in execute
self.errorhandler(self, exc, value)
File "/home/discord/.local/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
raise errorvalue
File "/home/discord/.local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 252, in execute
res = self._query(query)
File "/home/discord/.local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 378, in _query
db.query(q)
File "/home/discord/.local/lib/python3.6/site-packages/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
Exception_hash: f357d481da0134eecd408416561d5c738dbdf1d5
silasary
https://github.com/PennyDreadfulMTG/perf-reports/issues/42385