search

PennyDreadfulMTG / Penny-Dreadful-Tools

A suite of tools for the Penny Dreadful MTGO community
https://pennydreadfulmagic.com
MIT License
41 stars 28 forks source link

500 error at /signup/ #7278

Closed bakert closed 4 years ago

bakert commented 4 years ago 
500 Internal Server Error: The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.

Reported on decksite by kalko

InternalServerError 500 Internal Server Error: The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.
Stack Trace:

Python traceback

  File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 2464, in __call__
    return self.wsgi_app(environ, start_response)
  File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 2450, in wsgi_app
    response = self.handle_exception(e)

Exception_hash: f6dd8402d1e448b6b5c43b94364ed2c834629e77

Request Data

Request Method: POST
Path: /signup/?
Cookies: ImmutableMultiDict([('__cfduid', 'de04079581b5403af9c945824ca6c969d1586096374'), ('_ga', 'GA1.2.1353020475.1586096378'), ('hide_intro', 'True'), ('_gid', 'GA1.2.556996220.1587913067'), ('page_size', '20'), ('session', '.eJx1UV1vgjAU_S99ZoYiWPRNnBvJdC7xI3HLQhqoWCmttGXMGP_7LibKkmVvPeee03N7ekbJkemSSiYtGlldMwfRrOQSjXZUGEAZK3mpsg5zkyqdJRwohH3cd4N-QDAOhiEOPR91CqFSKhiomHxYL2Hwv4XLJK-5yG4r_LKiFuU5y9pFjZLXYB8T30GlzVVSG6YlLVtxQUWhQK9obfdeYiy1Lb0sZkFFtlVaVXoVbQ6VGE_zA3m3ZkFyt9NbVUDc6IxomjJjbhjNIn8yfXnKVk3WNG-PYzsLvSi0Ig1V87wGP_s-cs1MQqFCHITEHeLAH_Q84pF-2I3bUgeuH7qugzTbAbW_Z9Tx5DSfq-FrE1R4tfmKtzGZy8V0thYx1pABlR7hMR9QInwV352Au1Zm7ofeQUHEp4Oulyb21BpQxKhmGl0c9Kc_S3XOYGdZC3H5Aag6p-k.XqbrWQ.zXY6UrBlQh0UVsyTJUHoSvoifWo')])
Endpoint: add_signup
View Args: {}
Person: 141305357115981824
Referrer: https://pennydreadfulmagic.com/signup/
Request Data: {'mtgo_username': 'kalko', 'name': 'UW Control Penny Dreadful S16', 'decklist': "3 Approach of the Second Sun\r\n3 Azorius Charm\r\n2 Calculated Dismissal\r\n4 Chemister's Insight\r\n4 Flood Plain\r\n4 Fumigate\r\n2 Gideon Jura\r\n8 Island\r\n4 Ixalan's Binding\r\n1 Lonely Sandbar\r\n4 Mana Leak\r\n4 Memory Lapse\r\n3 Mystic Sanctuary\r\n2 Phyrexian Rebirth\r\n4 Plains\r\n1 Prison Realm\r\n1 Pull from Tomorrow\r\n2 Secluded Steppe\r\n4 Tranquil Cove\r\n\r\n4 Dovin's Veto\r\n2 Magus of the Disk\r\n3 Purify\r\n3 Radiant's Judgment\r\n3 Soul-Guide Lantern"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: AR
X-Forwarded-For: 181.169.209.97, 162.158.255.102
Cf-Ray: 58a9381d9ba2e968-SJC
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Cache-Control: max-age=0
Origin: https://pennydreadfulmagic.com
Upgrade-Insecure-Requests: 1
Dnt: 1
Content-Type: application/x-www-form-urlencoded
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.122 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;q=0.9
Sec-Fetch-Site: same-origin
Sec-Fetch-Mode: navigate
Sec-Fetch-User: ?1
Sec-Fetch-Dest: document
Referer: https://pennydreadfulmagic.com/signup/
Accept-Language: es-419,es;q=0.9
Cookie: __cfduid=de04079581b5403af9c945824ca6c969d1586096374; _ga=GA1.2.1353020475.1586096378; hide_intro=True; _gid=GA1.2.556996220.1587913067; page_size=20; session=.eJx1UV1vgjAU_S99ZoYiWPRNnBvJdC7xI3HLQhqoWCmttGXMGP_7LibKkmVvPeee03N7ekbJkemSSiYtGlldMwfRrOQSjXZUGEAZK3mpsg5zkyqdJRwohH3cd4N-QDAOhiEOPR91CqFSKhiomHxYL2Hwv4XLJK-5yG4r_LKiFuU5y9pFjZLXYB8T30GlzVVSG6YlLVtxQUWhQK9obfdeYiy1Lb0sZkFFtlVaVXoVbQ6VGE_zA3m3ZkFyt9NbVUDc6IxomjJjbhjNIn8yfXnKVk3WNG-PYzsLvSi0Ig1V87wGP_s-cs1MQqFCHITEHeLAH_Q84pF-2I3bUgeuH7qugzTbAbW_Z9Tx5DSfq-FrE1R4tfmKtzGZy8V0thYx1pABlR7hMR9QInwV352Au1Zm7ofeQUHEp4Oulyb21BpQxKhmGl0c9Kc_S3XOYGdZC3H5Aag6p-k.XqbrWQ.zXY6UrBlQh0UVsyTJUHoSvoifWo
Cf-Request-Id: 025da1667f0000e968d12b7200000001
Cf-Connecting-Ip: 181.169.209.97
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Content-Length: 597
Connection: Keep-Alive
bakert commented 4 years ago 
Apr 28 00:46:12 katelyngigante uwsgi[28565]: [2020-04-28 00:46:12,579] ERROR in app: Exception on /signup/ [POST]
Apr 28 00:46:12 katelyngigante uwsgi[28565]: Traceback (most recent call last):
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "./shared/database.py", line 51, in execute_anything
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     return self.execute_with_reconnect(sql, args, fetch_rows)
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "./shared/database.py", line 81, in execute_with_reconnect
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     raise e
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "./shared/database.py", line 67, in execute_with_reconnect
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     n = self.cursor.execute(sql, args)
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "/home/discord/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 209, in execute
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     res = self._query(query)
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "/home/discord/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 315, in _query
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     db.query(q)
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "/home/discord/.local/lib/python3.8/site-packages/MySQLdb/connections.py", line 239, in query
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     _mysql.connection.query(self, query)
Apr 28 00:46:12 katelyngigante uwsgi[28565]: MySQLdb._exceptions.OperationalError: (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Apr 28 00:46:12 katelyngigante uwsgi[28565]: During handling of the above exception, another exception occurred:
Apr 28 00:46:12 katelyngigante uwsgi[28565]: Traceback (most recent call last):
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 2447, in wsgi_app
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     response = self.full_dispatch_request()
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 1952, in full_dispatch_request
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     rv = self.handle_user_exception(e)
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 1821, in handle_user_exception
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     reraise(exc_type, exc_value, tb)
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "/home/discord/.local/lib/python3.8/site-packages/flask/_compat.py", line 39, in reraise
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     raise value
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 1950, in full_dispatch_request
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     rv = self.dispatch_request()
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 1936, in dispatch_request
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     return self.view_functions[rule.endpoint](**req.view_args)
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "./decksite/cache.py", line 80, in decorated_function
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     response = make_response(f(*args, **kwargs))
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "./decksite/controllers/league.py", line 44, in add_signup
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     d = lg.signup(form)
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "./decksite/league.py", line 186, in signup
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     return deck.add_deck(form)
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "./decksite/data/deck.py", line 377, in add_deck
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     add_cards(deck_id, params['cards'])
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "./decksite/data/deck.py", line 407, in add_cards
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     db().execute('UPDATE deck SET decklist_hash = %s WHERE id = %s', [deckhash, deck_id])
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "./shared/database.py", line 44, in execute
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     [n, _] = self.execute_anything(sql, args, False)
Apr 28 00:46:12 katelyngigante uwsgi[28565]:   File "./shared/database.py", line 59, in execute_anything
Apr 28 00:46:12 katelyngigante uwsgi[28565]:     raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e))
Apr 28 00:46:12 katelyngigante uwsgi[28565]: shared.pd_exception.DatabaseException: Failed to execute `UPDATE deck SET decklist_hash = %s WHERE id = %s` with `['bff5333a7621ca88c858debcf59b99c09919a493', 73310]` because of `(1213, 'Deadlock found when trying to get lock; try restarting transaction')`
Apr 28 00:46:12 katelyngigante uwsgi[28565]: [2020-04-28 00:46:12,580] ERROR in logger: At request path: /signup/
Apr 28 00:46:12 katelyngigante uwsgi[28565]: werkzeug.exceptions.InternalServerError: 500 Internal Server Error: The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.
bakert commented 4 years ago

Now the site is busier we are seeing more deadlocks. I wonder if there's any bugged logic we can do to free these up. Signing up should be essentially independent of anything else?

bakert commented 4 years ago 
500 error at /signup/

500 Internal Server Error: The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.

Reported on decksite by berikande

InternalServerError 500 Internal Server Error: The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.
Stack Trace:

Python traceback

  File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 2464, in __call__
    return self.wsgi_app(environ, start_response)
  File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 2450, in wsgi_app
    response = self.handle_exception(e)

Exception_hash: f6dd8402d1e448b6b5c43b94364ed2c834629e77

Request Data

Request Method: POST
Path: /signup/?
Cookies: ImmutableMultiDict([('_ga', 'GA1.2.602855395.1513711011'), ('__cfduid', 'daa65859db30acfb27805bb5392d1d9dd1586079231'), ('hide_intro', 'True'), ('_gid', 'GA1.2.1636340389.1587813513'), ('page_size', '20'), ('deck_id', '73383'), ('_gat_gtag_UA_109131120_1', '1'), ('session', '.eJx1UV1PwjAU_S99nmQfHZu8MWQGUTQMJMSYpayXUdi62XYRJPx370gQY-Jbz73n9JyeHklagyqZBGlIz6gGLMJ4KSTprVmhEXEoRVnxKxY6qxRPBY6I69ohpYHr-Z4XBDSkIbkyiipjBSAL5M08wcX_EiHTvBEFv0T4JSUtynPgbVBdybNx4FOLlCav0kaDkqxsuStQYsckB5RUrDEbN9WGmXblDOlYjOXuNVITPkgofMTD-8mUj0bZclBc-abaoWPvSFiWgdYXTCK1n84OhoInmmV_k8emuIueVknwEO8PFPWwr4UCnTJs0fHDbhi4zm3YsT3fsW33um-L7do0tG2LKFjjaPNjEs-Hie_Mstnia8Tr2XC814vty3P_s5aB94gmWGuNr3nDIvG7xPqAs3Nt-ufQ2VZo8W6R86WpObQCEgFToMjJIn87NEzlgJllUxSnb-BbqVA.Xqg6uA.hSpiwxQIVpqZC4VPRb3ktnKSuBA')])
Endpoint: add_signup
View Args: {}
Person: 220844723533774848
Referrer: https://pennydreadfulmagic.com/signup/
Request Data: {'mtgo_username': 'berikande', 'name': 'Aggressive Cycling Revolution', 'decklist': "4 Akroma's Blessing\r\n3 Benevolent Bodyguard\r\n3 Bonesplitter\r\n4 Djeru's Renunciation\r\n4 Drannith Healer\r\n4 Flourishing Fox\r\n3 Marshaling Cry\r\n16 Plains\r\n4 Secluded Steppe\r\n2 Sigil of the Nayan Gods\r\n3 Snare Tactician\r\n2 Splendor Mare\r\n4 Stoic Champion\r\n4 Valiant Rescuer\r\n\r\n4 Deafening Silence\r\n2 Gilded Light\r\n1 Radiant's Judgment\r\n3 Soul-Guide Lantern\r\n2 Splendor Mare\r\n3 Sundering Growth\r\n"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: SE
X-Forwarded-For: 85.230.150.213, 172.68.133.242
Cf-Ray: 58b167786d3d7251-SJC
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Cache-Control: max-age=0
Upgrade-Insecure-Requests: 1
Origin: https://pennydreadfulmagic.com
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/81.0.4044.122 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;q=0.9
Sec-Fetch-Site: same-origin
Sec-Fetch-Mode: navigate
Sec-Fetch-User: ?1
Sec-Fetch-Dest: document
Referer: https://pennydreadfulmagic.com/signup/
Accept-Language: sv,en-US;q=0.9,en;q=0.8,nb;q=0.7,da;q=0.6
Cookie: _ga=GA1.2.602855395.1513711011; __cfduid=daa65859db30acfb27805bb5392d1d9dd1586079231; hide_intro=True; _gid=GA1.2.1636340389.1587813513; page_size=20; deck_id=73383; _gat_gtag_UA_109131120_1=1; session=.eJx1UV1PwjAU_S99nmQfHZu8MWQGUTQMJMSYpayXUdi62XYRJPx370gQY-Jbz73n9JyeHklagyqZBGlIz6gGLMJ4KSTprVmhEXEoRVnxKxY6qxRPBY6I69ohpYHr-Z4XBDSkIbkyiipjBSAL5M08wcX_EiHTvBEFv0T4JSUtynPgbVBdybNx4FOLlCav0kaDkqxsuStQYsckB5RUrDEbN9WGmXblDOlYjOXuNVITPkgofMTD-8mUj0bZclBc-abaoWPvSFiWgdYXTCK1n84OhoInmmV_k8emuIueVknwEO8PFPWwr4UCnTJs0fHDbhi4zm3YsT3fsW33um-L7do0tG2LKFjjaPNjEs-Hie_Mstnia8Tr2XC814vty3P_s5aB94gmWGuNr3nDIvG7xPqAs3Nt-ufQ2VZo8W6R86WpObQCEgFToMjJIn87NEzlgJllUxSnb-BbqVA.Xqg6uA.hSpiwxQIVpqZC4VPRb3ktnKSuBA
Cf-Request-Id: 0262beff3f0000725100a5d200000001
Cf-Connecting-Ip: 85.230.150.213
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Content-Length: 549
Connection: Keep-Alive
bakert commented 4 years ago 
Apr 28 00:46:13 katelyngigante uwsgi[28563]: Before BEGIN (['add_deck'])
Apr 28 00:46:13 katelyngigante uwsgi[28563]: After BEGIN (['add_deck', 'add_cards'])
Apr 28 00:46:13 katelyngigante uwsgi[28563]: [2020-04-28 00:46:13,947] ERROR in app: Exception on /signup/ [POST]
Apr 28 00:46:13 katelyngigante uwsgi[28563]: Traceback (most recent call last):
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "./shared/database.py", line 51, in execute_anything
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     return self.execute_with_reconnect(sql, args, fetch_rows)
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "./shared/database.py", line 81, in execute_with_reconnect
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     raise e
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "./shared/database.py", line 67, in execute_with_reconnect
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     n = self.cursor.execute(sql, args)
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "/home/discord/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 209, in execute
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     res = self._query(query)
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "/home/discord/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 315, in _query
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     db.query(q)
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "/home/discord/.local/lib/python3.8/site-packages/MySQLdb/connections.py", line 239, in query
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     _mysql.connection.query(self, query)
Apr 28 00:46:13 katelyngigante uwsgi[28563]: MySQLdb._exceptions.OperationalError: (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Apr 28 00:46:13 katelyngigante uwsgi[28563]: During handling of the above exception, another exception occurred:
Apr 28 00:46:13 katelyngigante uwsgi[28563]: Traceback (most recent call last):
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 2447, in wsgi_app
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     response = self.full_dispatch_request()
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 1952, in full_dispatch_request
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     rv = self.handle_user_exception(e)
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 1821, in handle_user_exception
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     reraise(exc_type, exc_value, tb)
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "/home/discord/.local/lib/python3.8/site-packages/flask/_compat.py", line 39, in reraise
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     raise value
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 1950, in full_dispatch_request
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     rv = self.dispatch_request()
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "/home/discord/.local/lib/python3.8/site-packages/flask/app.py", line 1936, in dispatch_request
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     return self.view_functions[rule.endpoint](**req.view_args)
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "./decksite/cache.py", line 80, in decorated_function
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     response = make_response(f(*args, **kwargs))
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "./decksite/controllers/league.py", line 44, in add_signup
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     d = lg.signup(form)
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "./decksite/league.py", line 186, in signup
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     return deck.add_deck(form)
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "./decksite/data/deck.py", line 377, in add_deck
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     add_cards(deck_id, params['cards'])
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "./decksite/data/deck.py", line 407, in add_cards
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     db().execute('UPDATE deck SET decklist_hash = %s WHERE id = %s', [deckhash, deck_id])
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "./shared/database.py", line 44, in execute
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     [n, _] = self.execute_anything(sql, args, False)
Apr 28 00:46:13 katelyngigante uwsgi[28563]:   File "./shared/database.py", line 59, in execute_anything
Apr 28 00:46:13 katelyngigante uwsgi[28563]:     raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e))
Apr 28 00:46:13 katelyngigante uwsgi[28563]: shared.pd_exception.DatabaseException: Failed to execute `UPDATE deck SET decklist_hash = %s WHERE id = %s` with `['bff5333a7621ca88c858debcf59b99c09919a493', 73315]` because of `(1213, 'Deadlock found when trying to get lock; try restarting transaction')`
Apr 28 00:46:13 katelyngigante uwsgi[28563]: [2020-04-28 00:46:13,973] ERROR in logger: At request path: /signup/
Apr 28 00:46:13 katelyngigante uwsgi[28563]: werkzeug.exceptions.InternalServerError: 500 Internal Server Error: The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.
jgabrielygalan commented 4 years ago

Hopefully fixed by removing the DELETE statement from those transactions.