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 [44765, 'Kjeldoran Outpost', 3, False] because of (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Reported on decksite by jenkin5630
Request Data
``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd718bb477bd1b89e959853a3fc5fbacb01540528458', 'session': '.eJx9UctugkAU_Ze7Js3wBneCXahRa0piY9OQKVxwEAY6M7Ra4793ILEmXXR5Hvd17gXSDkVDOXIFEyV6NIDmDeMwKWgtNcqxYU2b3zGTWSvylGkKrNAhrhWYjm9Zoevbpg0G_KPwtOxZnd8m1W1Ga9TuisKAyhLzYR_Z8rF_4IQGNKps016i4LQZvciPjLueTXRNS3t1sFKpqBo0v9o8x580-i5mPcZfO9x3XvDYPSVJ5UbR3a_aI-oTL0CzDKW8YQimU29l0WxWxbnp7jfnaL1cN9vTKtnv-ErX46ljAmVKdVqm65qe6Vi2_2ASOyDBXR7y84gTEGKAwEJTh98Z79X2NHfi5fwlWzR-Mpt-kEVIXvpkcVp2pp6h8-30Ma86SP0VVpw1N8Ym4c2AsU2qzoMFIqQCBVwN-JuaoqJEvSTv6_r6A1PBmok.D49k9g.cV1IkRc8Fdh4pLTvCMcsoFOWNp0'} Endpoint: add_signup View Args: {} Person: 294052814722957313 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'jenkin5630', 'name': 'RW Con', 'decklist': "3 Kjeldoran Outpost\r\n4 Desolation Giant\r\n4 Condemn\r\n1 Justice Strike\r\n2 Collective Effort\r\n1 Pulse of the Fields\r\n2 Decree of Justice\r\n3 Conqueror's Galleon\r\n4 Boros Guildgate\r\n4 Ancient Amphitheater\r\n2 Evolving Wilds\r\n2 Eternal Dragon\r\n13 Plains\r\n1 Mountain\r\n2 Plumeveil\r\n1 Slagstorm\r\n2 Planar Cleansing\r\n3 Chain Lightning\r\n1 Warleader's Helix\r\n1 Mizzium Mortars\r\n4 Goblin Assault\r\n\r\n3 Seal of Cleansing\r\n1 Imperial Mask\r\n2 Scrabbling Claws\r\n2 Jester's Cap\r\n1 Witchbane Orb\r\n2 Spellshock\r\n1 Sanctimony\r\n1 Pulse of the Fields\r\n2 Slagstorm\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: JP X-Forwarded-For: 153.193.102.178, 162.158.6.12 Cf-Ray: 4c54617368e5ae8d-KIX X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Origin: https://pennydreadfulmagic.com Upgrade-Insecure-Requests: 1 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/73.0.3683.103 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: ja,en-US;q=0.9,en;q=0.8 Cookie: __cfduid=d718bb477bd1b89e959853a3fc5fbacb01540528458; session=.eJx9UctugkAU_Ze7Js3wBneCXahRa0piY9OQKVxwEAY6M7Ra4793ILEmXXR5Hvd17gXSDkVDOXIFEyV6NIDmDeMwKWgtNcqxYU2b3zGTWSvylGkKrNAhrhWYjm9Zoevbpg0G_KPwtOxZnd8m1W1Ga9TuisKAyhLzYR_Z8rF_4IQGNKps016i4LQZvciPjLueTXRNS3t1sFKpqBo0v9o8x580-i5mPcZfO9x3XvDYPSVJ5UbR3a_aI-oTL0CzDKW8YQimU29l0WxWxbnp7jfnaL1cN9vTKtnv-ErX46ljAmVKdVqm65qe6Vi2_2ASOyDBXR7y84gTEGKAwEJTh98Z79X2NHfi5fwlWzR-Mpt-kEVIXvpkcVp2pp6h8-30Ma86SP0VVpw1N8Ym4c2AsU2qzoMFIqQCBVwN-JuaoqJEvSTv6_r6A1PBmok.D49k9g.cV1IkRc8Fdh4pLTvCMcsoFOWNp0 Cf-Connecting-Ip: 153.193.102.178 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 716 ```DatabaseException Failed to execute `INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s)` with `[44765, 'Kjeldoran Outpost', 3, False]` because of `(1213, 'Deadlock found when trying to get lock; try restarting transaction')`
Stack Trace: ``` Python traceback 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 393, 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 357, in add_deck add_cards(deck_id, params['cards']) File "./decksite/data/deck.py", line 389, in add_cards insert_deck_card(deck_id, name, n, False) File "./decksite/data/deck.py", line 406, 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: 4872ef465bf694399fb776cf72c3a5d1ace3ab83
Labels: decksite; DatabaseException
Failed to execute
INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s)with[43636, 'Channel the Suns', 1, False]because of(1213, 'Deadlock found when trying to get lock; try restarting transaction')Reported on decksite by mtgdavis
Request Data
``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd9d1887332dbaa73ec29cfaa30ea6c5a11553469324', '_ga': 'GA1.2.2121679503.1553469329', '_gid': 'GA1.2.450365089.1553469329', 'deck_id': '43602', 'session': '.eJx9UWFPwjAQ_S_3eTFbR2HyTXCJwRhBIQLGLHW9jcLaYtsNF8J_tyNBPpj4pcm7d33v7t0Rsj0ayRQqB0NnagyAcSkUDAtWWY84SiE1v2Jhc214JnwJ4ts4JDSKekkY9ikhSQIB_MOorKxFxS9OlS5L5N0EVquzYhxHcQDSlTqrLRrFJHoxjzlrhPUSmtVuQzLrmOuYLUkU_VrhxLULmb7ePQ4qJ0gjFb4hSa_9Tu_Q73QEludo7QVDNFs-HdJGT9JU9vrbVTzFdcPV6uUwX8yW_j9-74VBmzEfT0RpL-qe5IZQGpPB4Mp3ifXDbtsADBa-tPk1ef4cT9oil3R3rx4W5XqcoxnN66kqZ4e89SY-0b3f5t1H5-8giq52DsrCRwBnmcy1XQuMkBk0cArgT2qOmRL9mKquqtMP7luZSA.D4D_pA.WLsDhG649t8MmriinKf78UaszMQ'} Endpoint: add_signup View Args: {} Person: 393025114800652288 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'mtgdavis', 'name': 'Sunny Storm', 'decklist': "1 Channel the Suns\r\n3 Deep Analysis\r\n2 Evolving Wilds\r\n4 Frantic Search\r\n4 Goblin Electromancer\r\n4 Hazoret's Undying Fury\r\n3 Inaction Injunction\r\n6 Island\r\n4 Mountain\r\n3 Peer Through Depths\r\n4 Pirate's Pillage\r\n4 Primal Amulet\r\n4 Seething Song\r\n3 Shimmer of Possibility\r\n4 Sunken Hollow\r\n3 Tendrils of Agony\r\n4 Vivid Crag\r\n\r\nSideboard:\r\n3 Aether Spellbomb\r\n1 Deep Analysis\r\n1 Dual Shot\r\n4 Electrostatic Field\r\n1 Inaction Injunction\r\n2 Murmuring Mystic\r\n2 Pyrite Spellbomb\r\n1 Witchbane Orb"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: GB X-Forwarded-For: 138.251.218.43, 162.158.158.151 Cf-Ray: 4bfa699acc6cce49-LHR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Origin: https://pennydreadfulmagic.com Upgrade-Insecure-Requests: 1 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/73.0.3683.86 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-US,en;q=0.9 Cookie: __cfduid=d9d1887332dbaa73ec29cfaa30ea6c5a11553469324; _ga=GA1.2.2121679503.1553469329; _gid=GA1.2.450365089.1553469329; deck_id=43602; session=.eJx9UWFPwjAQ_S_3eTFbR2HyTXCJwRhBIQLGLHW9jcLaYtsNF8J_tyNBPpj4pcm7d33v7t0Rsj0ayRQqB0NnagyAcSkUDAtWWY84SiE1v2Jhc214JnwJ4ts4JDSKekkY9ikhSQIB_MOorKxFxS9OlS5L5N0EVquzYhxHcQDSlTqrLRrFJHoxjzlrhPUSmtVuQzLrmOuYLUkU_VrhxLULmb7ePQ4qJ0gjFb4hSa_9Tu_Q73QEludo7QVDNFs-HdJGT9JU9vrbVTzFdcPV6uUwX8yW_j9-74VBmzEfT0RpL-qe5IZQGpPB4Mp3ifXDbtsADBa-tPk1ef4cT9oil3R3rx4W5XqcoxnN66kqZ4e89SY-0b3f5t1H5-8giq52DsrCRwBnmcy1XQuMkBk0cArgT2qOmRL9mKquqtMP7luZSA.D4D_pA.WLsDhG649t8MmriinKf78UaszMQ Cf-Connecting-Ip: 138.251.218.43 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 647 ```DatabaseException Failed to execute `INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s)` with `[43636, 'Channel the Suns', 1, False]` because of `(1213, 'Deadlock found when trying to get lock; try restarting transaction')`
Stack Trace: ``` Python traceback 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 393, 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 357, in add_deck add_cards(deck_id, params['cards']) File "./decksite/data/deck.py", line 389, in add_cards insert_deck_card(deck_id, name, n, False) File "./decksite/data/deck.py", line 406, 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: 4872ef465bf694399fb776cf72c3a5d1ace3ab83