Closed vorpal-buildbot closed 5 years ago
500 error at /report/
Failed to execute INSERT INTO deck_match (deck_id, match_id, games) VALUES (%s, %s, %s)
with ['31132', 53812, '2']
because of (1205, 'Lock wait timeout exceeded; try restarting transaction')
Reported on decksite by logged_out
--------------------------------------------------------------------------------
Request Method: POST
Path: /report/?
Cookies: {}
Endpoint: add_report
View Args: {}
Person: logged_out
Referrer: None
Request Data: {'entry': '31132', 'opponent': '31125', 'result': '2–0', 'draws': '0', 'matchID': '213890563'}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: XX
X-Forwarded-For: 35.205.164.196, 141.101.69.17
Cf-Ray: 496f7eebdb8bbd65-CDG
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Content-Type: application/x-www-form-urlencoded
Cf-Connecting-Ip: 35.205.164.196
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 114
DatabaseException
Failed to execute INSERT INTO deck_match (deck_id, match_id, games) VALUES (%s, %s, %s)
with ['31132', 53812, '2']
because of (1205, 'Lock wait timeout exceeded; try restarting transaction')
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 "./decksite/main.py", line 339, in add_report
if form.validate() and lg.report(form):
File "./decksite/league.py", line 244, in report
match.insert_match(dtutil.now(), form.entry, form.entry_games, form.opponent, form.opponent_games, None, None, mtgo_match_id)
File "./decksite/data/match.py", line 32, in insert_match
db().execute(sql, [left_id, match_id, left_games])
File "./shared/database.py", line 45, in execute
[n, _] = self.execute_anything(sql, args, False)
File "./shared/database.py", line 60, in execute_anything
raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e))
Exception_hash: f145376b73fca01a8ec3fcf31c34033489d3bd48
Labels: decksite; DatabaseException
Failed to execute
INSERT INTO deck_match (deck_id, match_id, games) VALUES (%s, %s, %s)
with['30437', 52836, '2']
because of(1213, 'Deadlock found when trying to get lock; try restarting transaction')
Reported on decksite by esqpoe
DatabaseException Failed to execute
INSERT INTO deck_match (deck_id, match_id, games) VALUES (%s, %s, %s)
with['30437', 52836, '2']
because of(1213, 'Deadlock found when trying to get lock; try restarting transaction')
Stack Trace:Exception_hash: f145376b73fca01a8ec3fcf31c34033489d3bd48