vorpal-buildbot
commented
5 years ago 500 error at /signup/
Failed to execute INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s) with [30658, 'Battlewise Hoplite', 4, False] because of (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Reported on decksite by logged_out
--------------------------------------------------------------------------------
Request Method: POST
Path: /signup/?
Cookies: {'_gid': 'GA1.2.807109645.1545180217', '_ga': 'GA1.2.1029774821.1545010414', '__cfduid': 'd7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408', '_gat_gtag_UA_109131120_1': '1'}
Endpoint: add_signup
View Args: {}
Person: logged_out
Referrer: https://pennydreadfulmagic.com/signup/
Request Data: {'mtgo_username': 'karnonthebcob', 'name': 'Herioc', 'decklist': "4 Battlewise Hoplite\r\n4 Favored Hoplite\r\n2 Fabled Hero\r\n2 Wingsteed Rider\r\n2 Triton Fortune Hunter\r\n2 Indestructibility\r\n2 Curiosity\r\n1 Eel Umbra\r\n2 Spectra Ward\r\n3 On Serra's Wings\r\n2 Defiant Strike\r\n4 Gods Willing\r\n3 Sheltering Light\r\n3 Aqueous Form\r\n3 Mystic Monastery\r\n10 Plains\r\n3 Evolving Wilds\r\n8 Island\r\n\r\n3 Demystify\r\n"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 108.4.108.102, 162.158.78.144
Cf-Ray: 48b63056ec26578f-IAD
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Referer: https://pennydreadfulmagic.com/signup/
Cache-Control: max-age=0
Content-Type: application/x-www-form-urlencoded
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/17.17134
Accept-Language: en-US,en;q=0.7,ja;q=0.3
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Upgrade-Insecure-Requests: 1
Cookie: _gid=GA1.2.807109645.1545180217; _ga=GA1.2.1029774821.1545010414; __cfduid=d7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408; _gat_gtag_UA_109131120_1=1
Cf-Connecting-Ip: 108.4.108.102
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 458DatabaseException
Failed to execute INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s) with [30658, 'Battlewise Hoplite', 4, False] because of (1213, 'Deadlock found when trying to get lock; 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/cache.py", line 79, in decorated_function
response = make_response(f(*args, **kwargs))
File "./decksite/main.py", line 307, in add_signup
d = lg.signup(form)
File "./decksite/league.py", line 180, in signup
return deck.add_deck(form)
File "./decksite/data/deck.py", line 356, in add_deck
add_cards(deck_id, params['cards'])
File "./decksite/data/deck.py", line 388, in add_cards
insert_deck_card(deck_id, name, n, False)
File "./decksite/data/deck.py", line 405, in insert_deck_card
db().execute(sql, [deck_id, name, n, in_sideboard])
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: cff506f44cb8946fe5cfc4de66287163ed2ebef0
Labels: decksite; DatabaseException
Failed to execute
INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s)with[30661, 'Battlewise Hoplite', 4, False]because of(1213, 'Deadlock found when trying to get lock; try restarting transaction')Reported on decksite by logged_out
DatabaseException Failed to execute
INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s)with[30661, 'Battlewise Hoplite', 4, False]because of(1213, 'Deadlock found when trying to get lock; try restarting transaction')Stack Trace:Exception_hash: cff506f44cb8946fe5cfc4de66287163ed2ebef0