vorpal-buildbot
commented
5 years ago 500 error at /signup/
Failed to execute UPDATE deck SET decklist_hash = %s WHERE id = %s with ['4697d04a13544498c33e5fea7aa32abca7cb598b', 42473] because of (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Reported on decksite by swahili
Request Data
``` Request Method: POST Path: /signup/? Cookies: {'deck_id': '42464', 'session': '.eJx9UclugzAQ_Zc5o4rNQHJr0iZphapuSkKrClnYEAfbINvQLMq_10RKI_XQ41s8b-b5CHlLlcCSSgNjozrqACaCSRiXmGuLCBVMNOSKmS4aRXJmKQgiF8VJHAXBCEWjMHJ9cOAfReZVxzi5JPGmwJxaN5UwoKqiZNhHN_I8P0gcEKZq8k5TJbEYrPobbxhn1t_gzmz8XBtsBiEN2lXWxe8TtSK1niXz2_Wiisj2uQ6oWF79pqlt3PgIuCio1hcMtyFKk-3HEvX1a98jj2feW7p8WIinNZq_2Pd01zJFdY5tUx5CboKC0PdvPNf3Rii-6kN5kRsmruuAoqWlNr8h_W6mV7WO78rUz6adXx8OB_l4zyTJpojYEFtua6_5tC3aL2Hl3nLnzjR8OXAek5v9YIEJxYoqODnwpzKDVUXtkrLj_PQDRLmbJA.D2P_XA.M2ZC4ttoiL-G49Y_DbZTqTMzEfs', '_gid': 'GA1.2.719072670.1551742267', '_ga': 'GA1.2.183867235.1550239646', '__cfduid': 'd40c2e4c54c86862476cc1a56e03e70341550239648', '_gat_gtag_UA_109131120_1': '1'} Endpoint: add_signup View Args: {} Person: 360578763395694602 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'swahili', 'name': 'Dimir Vat', 'decklist': "3 Braids, Cabal Minion\r\n4 Choked Estuary\r\n4 Man-o'-War\r\n4 Elder Deep-Fiend\r\n3 Mimic Vat\r\n4 Burglar Rat\r\n2 Nevermaker\r\n4 Phyrexian Rager\r\n3 Liliana's Specter\r\n2 Arcane Sanctum\r\n4 Sunken Hollow\r\n4 Thought Erasure\r\n5 Island\r\n4 Dusk Legion Zealot\r\n8 Swamp\r\n2 Nekrataal\r\n\r\n2 Distended Mindbender\r\n2 Bile Blight\r\n2 Qarsi Sadist\r\n3 Moment of Craving\r\n2 Negate\r\n2 Consuming Vapors\r\n2 Knight of Infamy\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: GB X-Forwarded-For: 2a02:c7d:3310:0:956f:b5b3:6e1d:e0ee, 162.158.90.62 Cf-Ray: 4b452671de0a26ea-FRA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: text/html, application/xhtml+xml, image/jxr, */* Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-GB User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 Edge/16.16299 Content-Type: application/x-www-form-urlencoded Cache-Control: no-cache Cookie: deck_id=42464; session=.eJx9UclugzAQ_Zc5o4rNQHJr0iZphapuSkKrClnYEAfbINvQLMq_10RKI_XQ41s8b-b5CHlLlcCSSgNjozrqACaCSRiXmGuLCBVMNOSKmS4aRXJmKQgiF8VJHAXBCEWjMHJ9cOAfReZVxzi5JPGmwJxaN5UwoKqiZNhHN_I8P0gcEKZq8k5TJbEYrPobbxhn1t_gzmz8XBtsBiEN2lXWxe8TtSK1niXz2_Wiisj2uQ6oWF79pqlt3PgIuCio1hcMtyFKk-3HEvX1a98jj2feW7p8WIinNZq_2Pd01zJFdY5tUx5CboKC0PdvPNf3Rii-6kN5kRsmruuAoqWlNr8h_W6mV7WO78rUz6adXx8OB_l4zyTJpojYEFtua6_5tC3aL2Hl3nLnzjR8OXAek5v9YIEJxYoqODnwpzKDVUXtkrLj_PQDRLmbJA.D2P_XA.M2ZC4ttoiL-G49Y_DbZTqTMzEfs; _gid=GA1.2.719072670.1551742267; _ga=GA1.2.183867235.1550239646; __cfduid=d40c2e4c54c86862476cc1a56e03e70341550239648; _gat_gtag_UA_109131120_1=1 Cf-Connecting-Ip: 2a02:c7d:3310:0:956f:b5b3:6e1d:e0ee Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 542 ```DatabaseException Failed to execute `UPDATE deck SET decklist_hash = %s WHERE id = %s` with `['4697d04a13544498c33e5fea7aa32abca7cb598b', 42473]` 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 370, 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 386, in add_cards db().execute('UPDATE deck SET decklist_hash = %s WHERE id = %s', [deckhash, deck_id]) 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: dd0dc933992ace6da48c2496b247724b62dbddb7
Labels: decksite; DatabaseException
Failed to execute
UPDATE deck SET decklist_hash = %s WHERE id = %swith['4697d04a13544498c33e5fea7aa32abca7cb598b', 42467]because of(1213, 'Deadlock found when trying to get lock; try restarting transaction')Reported on decksite by swahili
Request Data
``` Request Method: POST Path: /signup/? Cookies: {'deck_id': '42464', 'session': '.eJx9UclugzAQ_Zc5o4rNQHJr0iZphapuSkKrClnYEAfbINvQLMq_10RKI_XQ41s8b-b5CHlLlcCSSgNjozrqACaCSRiXmGuLCBVMNOSKmS4aRXJmKQgiF8VJHAXBCEWjMHJ9cOAfReZVxzi5JPGmwJxaN5UwoKqiZNhHN_I8P0gcEKZq8k5TJbEYrPobbxhn1t_gzmz8XBtsBiEN2lXWxe8TtSK1niXz2_Wiisj2uQ6oWF79pqlt3PgIuCio1hcMtyFKk-3HEvX1a98jj2feW7p8WIinNZq_2Pd01zJFdY5tUx5CboKC0PdvPNf3Rii-6kN5kRsmruuAoqWlNr8h_W6mV7WO78rUz6adXx8OB_l4zyTJpojYEFtua6_5tC3aL2Hl3nLnzjR8OXAek5v9YIEJxYoqODnwpzKDVUXtkrLj_PQDRLmbJA.D2P_CQ.OuRp7_ZrCa4oTdSvzBM1o6tmmPI', '_gid': 'GA1.2.719072670.1551742267', '_ga': 'GA1.2.183867235.1550239646', '__cfduid': 'd40c2e4c54c86862476cc1a56e03e70341550239648', 'cf_use_ob': '0'} Endpoint: add_signup View Args: {} Person: 360578763395694602 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'swahili', 'name': 'Dimir Vat', 'decklist': "3 Braids, Cabal Minion\r\n4 Choked Estuary\r\n4 Man-o'-War\r\n4 Elder Deep-Fiend\r\n3 Mimic Vat\r\n4 Burglar Rat\r\n2 Nevermaker\r\n4 Phyrexian Rager\r\n3 Liliana's Specter\r\n2 Arcane Sanctum\r\n4 Sunken Hollow\r\n4 Thought Erasure\r\n5 Island\r\n4 Dusk Legion Zealot\r\n8 Swamp\r\n2 Nekrataal\r\n\r\n2 Distended Mindbender\r\n2 Bile Blight\r\n2 Qarsi Sadist\r\n3 Moment of Craving\r\n2 Negate\r\n2 Consuming Vapors\r\n2 Knight of Infamy\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: GB X-Forwarded-For: 2a02:c7d:3310:0:956f:b5b3:6e1d:e0ee, 162.158.90.62 Cf-Ray: 4b452497de2b26ea-FRA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: text/html, application/xhtml+xml, image/jxr, */* Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-GB User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 Edge/16.16299 Content-Type: application/x-www-form-urlencoded Cache-Control: no-cache Cookie: deck_id=42464; session=.eJx9UclugzAQ_Zc5o4rNQHJr0iZphapuSkKrClnYEAfbINvQLMq_10RKI_XQ41s8b-b5CHlLlcCSSgNjozrqACaCSRiXmGuLCBVMNOSKmS4aRXJmKQgiF8VJHAXBCEWjMHJ9cOAfReZVxzi5JPGmwJxaN5UwoKqiZNhHN_I8P0gcEKZq8k5TJbEYrPobbxhn1t_gzmz8XBtsBiEN2lXWxe8TtSK1niXz2_Wiisj2uQ6oWF79pqlt3PgIuCio1hcMtyFKk-3HEvX1a98jj2feW7p8WIinNZq_2Pd01zJFdY5tUx5CboKC0PdvPNf3Rii-6kN5kRsmruuAoqWlNr8h_W6mV7WO78rUz6adXx8OB_l4zyTJpojYEFtua6_5tC3aL2Hl3nLnzjR8OXAek5v9YIEJxYoqODnwpzKDVUXtkrLj_PQDRLmbJA.D2P_CQ.OuRp7_ZrCa4oTdSvzBM1o6tmmPI; _gid=GA1.2.719072670.1551742267; _ga=GA1.2.183867235.1550239646; __cfduid=d40c2e4c54c86862476cc1a56e03e70341550239648; cf_use_ob=0 Cf-Connecting-Ip: 2a02:c7d:3310:0:956f:b5b3:6e1d:e0ee Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 542 ```DatabaseException Failed to execute `UPDATE deck SET decklist_hash = %s WHERE id = %s` with `['4697d04a13544498c33e5fea7aa32abca7cb598b', 42467]` 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 370, 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 386, in add_cards db().execute('UPDATE deck SET decklist_hash = %s WHERE id = %s', [deckhash, deck_id]) 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: dd0dc933992ace6da48c2496b247724b62dbddb7