bakert
commented
6 years ago Closed bakert closed 5 years ago
bakert
commented
6 years ago bakert
commented
6 years ago These were both in quick succession.
Failed to execute INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s) with [27180, 'Bile Blight', 3, False] because of (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Reported on decksite by nanaiper```
--------------------------------------------------------------------------------
Request Method: POST
Path: /signup/?
Cookies: {'__cfduid': 'd50f337eea3b413c53f524814868fba151516340693', '_ga': 'GA1.2.1301695421.1516340709', '_gid': 'GA1.2.269370341.1516490989', 'session': '.eJx9kV9PwjAUxb_LfV5Mt1HYeFMRlCCi0WEwZrlu3ah07Wg75U_47nYkyIOJj-fec8_t_XUPac10hZJJC32rG-YB5hWX0C9QGKdybjKl85Tn0IewExAahJSQIIxpRIMIPPinI9Oy4SI_JQuVoWDO_YnQqrJkebvfKHnM94Mo9qCypUobw7TEqjVLlMidy40obOwySI1F23am35KqeJzNR5PnxXBQL0f03lwOpvPqCePd2W_VirmL9oBZxow5aUhQv_ZoMltvx0Vty900n5jFx-Caimp957t5tqm5ZiZFB8enIaVR1-_0LkhAfD_unfstry7pRIR4oFnhSsvfJRNffT0moV6V401xO5sNh00yUPxGPLxws3FLHN_aXfPmQLpf4MXW1Y7YDLx7cIxJ7ba1wBVD7UAcPPhDzaIumXumbIQ4_AAJ85eU.Dq6PEg.pOQ2wAhoB37_zQYQUHpm40lKlPY', '_gat_gtag_UA_109131120_1': '1'}
Endpoint: add_signup
View Args: {}
Person: 342052350023958528
Referrer: https://pennydreadfulmagic.com/signup/
Request Data: {'mtgo_username': 'nanaiper', 'name': 'Mizzet-Void', 'decklist': "3 Bile Blight\r\n2 Careful Consideration\r\n4 Choked Estuary\r\n3 Compulsive Research\r\n4 Crumbling Necropolis\r\n1 Elixir of Immortality\r\n4 Forbid\r\n2 Foreboding Ruins\r\n4 Island\r\n1 Izzet Guildgate\r\n2 Moment of Craving\r\n2 Mountain\r\n2 Niv-Mizzet, Dracogenius\r\n2 Perilous Voyage\r\n3 Power Sink\r\n1 Precognition Field\r\n2 Radiant Flames\r\n4 Swamp\r\n3 Thawing Glaciers\r\n1 Treasure Cruise\r\n2 Urza's Factory\r\n2 Void\r\n2 Wrecking Ball\r\n4 Wretched Banquet\r\n\r\nSideboard:\r\n2 Consume the Meek\r\n2 Detritivore\r\n2 Meltdown\r\n3 Memoricide\r\n2 Overwhelming Denial\r\n2 Scrabbling Claws\r\n2 Tribute to Hunger"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: JP
X-Forwarded-For: 180.63.227.138, 162.158.6.144
Cf-Ray: 46d728859994209c-KIX
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:62.0) Gecko/20100101 Firefox/62.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Accept-Language: ja,en-US;q=0.7,en;q=0.3
Referer: https://pennydreadfulmagic.com/signup/
Content-Type: application/x-www-form-urlencoded
Dnt: 1
Upgrade-Insecure-Requests: 1
Cookie: __cfduid=d50f337eea3b413c53f524814868fba151516340693; _ga=GA1.2.1301695421.1516340709; _gid=GA1.2.269370341.1516490989; session=.eJx9kV9PwjAUxb_LfV5Mt1HYeFMRlCCi0WEwZrlu3ah07Wg75U_47nYkyIOJj-fec8_t_XUPac10hZJJC32rG-YB5hWX0C9QGKdybjKl85Tn0IewExAahJSQIIxpRIMIPPinI9Oy4SI_JQuVoWDO_YnQqrJkebvfKHnM94Mo9qCypUobw7TEqjVLlMidy40obOwySI1F23am35KqeJzNR5PnxXBQL0f03lwOpvPqCePd2W_VirmL9oBZxow5aUhQv_ZoMltvx0Vty900n5jFx-Caimp957t5tqm5ZiZFB8enIaVR1-_0LkhAfD_unfstry7pRIR4oFnhSsvfJRNffT0moV6V401xO5sNh00yUPxGPLxws3FLHN_aXfPmQLpf4MXW1Y7YDLx7cIxJ7ba1wBVD7UAcPPhDzaIumXumbIQ4_AAJ85eU.Dq6PEg.pOQ2wAhoB37_zQYQUHpm40lKlPY; _gat_gtag_UA_109131120_1=1
Cf-Connecting-Ip: 180.63.227.138
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 753
--------------------------------------------------------------------------------
DatabaseException
Failed to execute `INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s)` with `[27180, 'Bile Blight', 3, 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_functionsrule.endpoint
File "./decksite/cache.py", line 79, in decorated_function
response = make_response(f(*args, **kwargs))
File "./decksite/main.py", line 290, 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 348, in add_deck
add_cards(deck_id, params['cards'])
File "./decksite/data/deck.py", line 379, in add_cards
insert_deck_card(deck_id, name, n, False)
File "./decksite/data/deck.py", line 392, 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))Failed to execute INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s) with [28518, 'Expedition Envoy', 4, False] because of (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Reported on decksite by gaiametris```
--------------------------------------------------------------------------------
Request Method: POST
Path: /signup/?
Cookies: {'__cfduid': 'd7b984f0352b2b15967b6b4794ed675d01523947022', '_ga': 'GA1.2.657619585.1523947026', 'hide_intro': 'True', '_gid': 'GA1.2.433847372.1541074511', 'deck_id': '28469', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UdFOwjAU_Zc-L2Zdu63yxiCoDySILCjGLGXrRnFrR9shaPh370h0Dya-9dxzc849p18oa4VpuBLKoZEznfAQLxqp0KjktQVUiEY2uhiwtLk2RSZhhAijUUApjhgNAx9TnyEP_cOorOpkPYjVuqpE0Z9gtbpK4pj5HmpcpbPOCqN4I0Ct4hIezkgLKpp3bhdk1nHXc5tUHUidlunLFrtkquZLPT6yp7JdEP9xPuw7_S4g1hfieS6s_cFof18syfHwsdARMZPkjqWTsUxCYgu8fej9xKmVRtiMQ0M4pDgmEY3ZDYZgMYsHvi8t8inzIYARJYx2vyaTczij_HNNSrGP82C2vt2q1ck8R9MVLzdgAqW2kOYV2oOvkOUZZteuLHrz0FUmc-d-BSWCG2HQxUN_enPcVALOVF1dX74B0ROYow.DsF3WA.mIKQGE-0SaMI0cO2LlqOVpjwM3I'}
Endpoint: add_signup
View Args: {}
Person: 384624416845201408
Referrer: https://pennydreadfulmagic.com/signup/
Request Data: {'mtgo_username': 'gaiametris', 'name': 'Boros Allies v4', 'decklist': '\r\n\r\n 0\r\n 0\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n'}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 2601:900:c100:400:7cd7:ddd9:ce11:21f4, 172.69.210.12
Cf-Ray: 474d54a4b876b72f-JAX
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/70.0.3538.77 Safari/537.36
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,/;q=0.8
Referer: https://pennydreadfulmagic.com/signup/
Accept-Language: en-US,en;q=0.9
Cookie: __cfduid=d7b984f0352b2b15967b6b4794ed675d01523947022; _ga=GA1.2.657619585.1523947026; hide_intro=True; _gid=GA1.2.433847372.1541074511; deck_id=28469; _gat_gtag_UA_109131120_1=1; session=.eJx9UdFOwjAU_Zc-L2Zdu63yxiCoDySILCjGLGXrRnFrR9shaPh370h0Dya-9dxzc849p18oa4VpuBLKoZEznfAQLxqp0KjktQVUiEY2uhiwtLk2RSZhhAijUUApjhgNAx9TnyEP_cOorOpkPYjVuqpE0Z9gtbpK4pj5HmpcpbPOCqN4I0Ct4hIezkgLKpp3bhdk1nHXc5tUHUidlunLFrtkquZLPT6yp7JdEP9xPuw7_S4g1hfieS6s_cFof18syfHwsdARMZPkjqWTsUxCYgu8fej9xKmVRtiMQ0M4pDgmEY3ZDYZgMYsHvi8t8inzIYARJYx2vyaTczij_HNNSrGP82C2vt2q1ck8R9MVLzdgAqW2kOYV2oOvkOUZZteuLHrz0FUmc-d-BSWCG2HQxUN_enPcVALOVF1dX74B0ROYow.DsF3WA.mIKQGE-0SaMI0cO2LlqOVpjwM3I
Cf-Connecting-Ip: 2601:900:c100:400:7cd7:ddd9:ce11:21f4
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 3535
--------------------------------------------------------------------------------
DatabaseException
Failed to execute `INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s)` with `[28518, 'Expedition Envoy', 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_functionsrule.endpoint
File "./decksite/cache.py", line 79, in decorated_function
response = make_response(f(*args, **kwargs))
File "./decksite/main.py", line 297, in add_signup
d = lg.signup(form)
File "./decksite/league.py", line 181, in signup
return deck.add_deck(form)
File "./decksite/data/deck.py", line 351, in add_deck
add_cards(deck_id, params['cards'])
File "./decksite/data/deck.py", line 383, in add_cards
insert_deck_card(deck_id, name, n, False)
File "./decksite/data/deck.py", line 400, 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: 7abaa601defb74737f8c5b01586f6c1289327f05With one episode in 25 days looks like the new connection closing stuff is doing work here. Closing.
bakert
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 [31119, 'Confirm Suspicions', 1, False] because of (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Reported on decksite by seven47
--------------------------------------------------------------------------------
Request Method: POST
Path: /signup/?
Cookies: {'__cfduid': 'd1351f73a7aeb3563975bb196471521cc1540423293', '_ga': 'GA1.2.1472614523.1540423296', '_gid': 'GA1.2.775017357.1546599152', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UV1Pg0AQ_C_7TAzg8dG-aayNEmv6kRo1hlxhoRfgoHeHhTb97y5Nah9MfLlkZ_dmZmePEDeoKi5RGhgb1aIFPK2EhHHGS01VipWo6vRaC53UKo0FQcB83_FHI-a5bhCE4a0TggX_dGSct6JML0plneeYDg50Lc-Mrh3YFlQmr-NWo5K8QiLT-I2SBcRQ89Zs3VgbboZGuV3MdnNnyvYf60qJp-Sl69v1a-FvosOyuM6bukBa6Qg8SVDrSw17Ge6afLLkDS66qb57dB60epOTpF2FUUT_sWuEQh1zSsfxmGP7AT03zPUYC7xrfwjMt1lok3uFGUHbX5FsjsWmY-G7XUZ9NlqlxUzl4vC87vrpZhChQBva5pOSozOIrCfsnJOGLwvONLHphxG4R65QwcmCP6EZrnIkm7Ity9MP53aZcQ.Dxbg3w.BMuCDfK86a_ROLxoqXG5YlgaUEA'}
Endpoint: add_signup
View Args: {}
Person: 466169945227788318
Referrer: https://pennydreadfulmagic.com/signup/
Request Data: {'mtgo_username': 'seven47', 'name': 'Mono Blue Control', 'decklist': "1 Confirm Suspicions\r\n2 Dreadship Reef\r\n1 Elixir of Immortality\r\n2 Engulf the Shore\r\n2 Forbid\r\n21 Island\r\n3 Jace's Ingenuity\r\n2 Masticore\r\n4 Nullify\r\n4 Plumeveil\r\n4 Power Sink\r\n2 anticipate\r\n2 Repeal\r\n1 Treasure Cruise\r\n2 Urza's Factory\r\n3 Void Shatter\r\n4 Whispers of the Muse\r\n\r\nSideboard:\r\n2 Encroaching Wastes\r\n2 Engulf the Shore\r\n4 Horribly Awry\r\n2 Invasive Surgery\r\n2 Overwhelming Denial\r\n2 Steel Sabotage\r\n1 Telemin Performance"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: AU
X-Forwarded-For: 203.30.93.5, 108.162.215.126
Cf-Ray: 496327f579457936-LAX
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/71.0.3578.98 Safari/537.36
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
Referer: https://pennydreadfulmagic.com/signup/
Accept-Language: en-US,en;q=0.9
Cookie: __cfduid=d1351f73a7aeb3563975bb196471521cc1540423293; _ga=GA1.2.1472614523.1540423296; _gid=GA1.2.775017357.1546599152; _gat_gtag_UA_109131120_1=1; session=.eJx9UV1Pg0AQ_C_7TAzg8dG-aayNEmv6kRo1hlxhoRfgoHeHhTb97y5Nah9MfLlkZ_dmZmePEDeoKi5RGhgb1aIFPK2EhHHGS01VipWo6vRaC53UKo0FQcB83_FHI-a5bhCE4a0TggX_dGSct6JML0plneeYDg50Lc-Mrh3YFlQmr-NWo5K8QiLT-I2SBcRQ89Zs3VgbboZGuV3MdnNnyvYf60qJp-Sl69v1a-FvosOyuM6bukBa6Qg8SVDrSw17Ge6afLLkDS66qb57dB60epOTpF2FUUT_sWuEQh1zSsfxmGP7AT03zPUYC7xrfwjMt1lok3uFGUHbX5FsjsWmY-G7XUZ9NlqlxUzl4vC87vrpZhChQBva5pOSozOIrCfsnJOGLwvONLHphxG4R65QwcmCP6EZrnIkm7Ity9MP53aZcQ.Dxbg3w.BMuCDfK86a_ROLxoqXG5YlgaUEA
Via: HTTPS/1.1 ausydclu20.au.kworld.kpmg.com 0A65B80E
Cf-Connecting-Ip: 203.30.93.5
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 593
DatabaseException
Failed to execute INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s) with [31119, 'Confirm Suspicions', 1, False] because of (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Stack Trace:
Labels: decksite; DatabaseException500 error at /signup/
Failed to execute INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s) with [31162, 'Court Homunculus', 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: {'__cfduid': 'df05fcdee203a0d8150f4491a36f946301542818278', '_ga': 'GA1.2.799752258.1542818280', '_gid': 'GA1.2.788110339.1547149134', '_gat_gtag_UA_109131120_1': '1'}
Endpoint: add_signup
View Args: {}
Person: logged_out
Referrer: https://pennydreadfulmagic.com/signup/
Request Data: {'mtgo_username': 'NASCA', 'name': 'Tempered Steel', 'decklist': '<?xml version="1.0" encoding="utf-8"?>\r\n<Deck xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">\r\n <NetDeckID>0</NetDeckID>\r\n <PreconstructedDeckID>0</PreconstructedDeckID>\r\n <Cards CatID="31819" Quantity="4" Sideboard="false" Name="Court Homunculus" />\r\n <Cards CatID="59878" Quantity="2" Sideboard="false" Name="Declaration in Stone" />\r\n <Cards CatID="61879" Quantity="4" Sideboard="false" Name="Toolcraft Exemplar" />\r\n <Cards CatID="61569" Quantity="4" Sideboard="false" Name="Chief of the Foundry" />\r\n <Cards CatID="39776" Quantity="4" Sideboard="false" Name="Spined Thopter" />\r\n <Cards CatID="37965" Quantity="4" Sideboard="false" Name="Glint Hawk Idol" />\r\n <Cards CatID="61891" Quantity="4" Sideboard="false" Name="Servo Exhibition" />\r\n <Cards CatID="38103" Quantity="4" Sideboard="false" Name="Tempered Steel" />\r\n <Cards CatID="62071" Quantity="3" Sideboard="false" Name="Fleetwheel Cruiser" />\r\n <Cards CatID="62609" Quantity="3" Sideboard="false" Name="Sram\'s Expertise" />\r\n <Cards CatID="35797" Quantity="3" Sideboard="false" Name="Dread Statuary" />\r\n <Cards CatID="64138" Quantity="2" Sideboard="false" Name="Watchers of the Dead" />\r\n <Cards CatID="69347" Quantity="19" Sideboard="false" Name="Plains" />\r\n <Cards CatID="39930" Quantity="1" Sideboard="true" Name="Marrow Shards" />\r\n <Cards CatID="65042" Quantity="1" Sideboard="true" Name="Inspiring Cleric" />\r\n <Cards CatID="26245" Quantity="2" Sideboard="true" Name="Sunlance" />\r\n <Cards CatID="59878" Quantity="2" Sideboard="true" Name="Declaration in Stone" />\r\n <Cards CatID="59493" Quantity="2" Sideboard="true" Name="Make a Stand" />\r\n <Cards CatID="64138" Quantity="2" Sideboard="true" Name="Watchers of the Dead" />\r\n <Cards CatID="57122" Quantity="3" Sideboard="true" Name="Celestial Purge" />\r\n <Cards CatID="63395" Quantity="2" Sideboard="true" Name="Sundering Growth" />\r\n</Deck>'}Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: JP X-Forwarded-For: 2403:7800:b481:d400:bc92:5832:a63c:a6e6, 162.158.6.48 Cf-Ray: 497febedac93ae99-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 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,/;q=0.8 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: ja,en-US;q=0.9,en;q=0.8 Cookie: __cfduid=df05fcdee203a0d8150f4491a36f946301542818278; _ga=GA1.2.799752258.1542818280; _gid=GA1.2.788110339.1547149134; _gat_gtag_UA_109131120_1=1 Cf-Connecting-Ip: 2403:7800:b481:d400:bc92:5832:a63c:a6e6 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 2805 DatabaseException Failed to execute INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s) with [31162, 'Court Homunculus', 4, False] because of (1213, 'Deadlock found when trying to get lock; try restarting transaction') Stack Trace:
Labels: decksite; DatabaseException
Failed to execute INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s) with [36222, 'Goblin Electromancer', 4, False] because of (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Reported on decksite by j_meka
--------------------------------------------------------------------------------
Request Method: POST
Path: /signup/?
Cookies: {'_ga': 'GA1.2.541409585.1509639551', 'hide_intro': 'True', '__cfduid': 'de588a43e0b97185ffc9a61cd790e91631541397138', '_gid': 'GA1.2.524131529.1549093322', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UctugzAQ_BefUQU2zx7TVKryVNSmrVJVlgsLoYAhtokgUf49G6QkUg89zqx3Zmd8JLwBVQkJ0pBHo1qwiEiqXF5BAlVe1ckN5jquVcJzZAh1ooAxLwyYbTMnoswlFvlnInnW5uVNq6yzDJKLv67loOjYvkUqk9W81aCkqAC1fnkFhcD9WrRmS7k2wlz4UdyWq1WYvKfw3NJx9LEZzYNuQ4tmvlge7u9NXQDGORIRx6D1FZOim3Td2gumT_Fk-7ZZvniqLN3e_2zGbrzAfeiaXIHmAptxPBZhIErtBxYy1wv9-_xSlm-7oW1bREGK1PZmMnF269nPrNmvZDrqguleUqcwu754zfRBownW2WCaL-wNvyBPe-SGljT5tsggw03fDIFBKFDkZJG_lRmhMsArZVuWpzP2i5cS.Dzqrlw.kU2MJOKcchcS07oEIqLYezE4dd0'}
Endpoint: add_signup
View Args: {}
Person: 219733587300319234
Referrer: https://pennydreadfulmagic.com/signup/
Request Data: {'mtgo_username': 'j_meka', 'name': 'Locket Storm', 'decklist': "4 Goblin Electromancer\r\n4 Seething Song\r\n4 Peer Through Depths\r\n4 Frantic Search\r\n4 Anticipate\r\n4 Locket of Yesterdays\r\n4 Nagging Thoughts\r\n4 Treasure Cruise\r\n2 Call to Mind\r\n2 Tendrils of Agony\r\n4 Pirate's Pillage\r\n2 Shrine of Piercing Vision\r\n4 Vivid Crag\r\n2 Mountain\r\n8 Island\r\n4 Sunken Hollow\r\n\r\n2 Blink of an Eye\r\n4 Curious Homunculus\r\n1 Temporal Fissure\r\n4 Lay Bare the Heart\r\n2 Snapback\r\n2 Pyroclasm\r\n"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 2601:880:c000:1a7d:ec41:a128:3013:48fe, 162.158.122.164
Cf-Ray: 4a42daeebf8dc885-MIA
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 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
Referer: https://pennydreadfulmagic.com/signup/
Accept-Language: en-US,en;q=0.9
Cookie: _ga=GA1.2.541409585.1509639551; hide_intro=True; __cfduid=de588a43e0b97185ffc9a61cd790e91631541397138; _gid=GA1.2.524131529.1549093322; _gat_gtag_UA_109131120_1=1; session=.eJx9UctugzAQ_BefUQU2zx7TVKryVNSmrVJVlgsLoYAhtokgUf49G6QkUg89zqx3Zmd8JLwBVQkJ0pBHo1qwiEiqXF5BAlVe1ckN5jquVcJzZAh1ooAxLwyYbTMnoswlFvlnInnW5uVNq6yzDJKLv67loOjYvkUqk9W81aCkqAC1fnkFhcD9WrRmS7k2wlz4UdyWq1WYvKfw3NJx9LEZzYNuQ4tmvlge7u9NXQDGORIRx6D1FZOim3Td2gumT_Fk-7ZZvniqLN3e_2zGbrzAfeiaXIHmAptxPBZhIErtBxYy1wv9-_xSlm-7oW1bREGK1PZmMnF269nPrNmvZDrqguleUqcwu754zfRBownW2WCaL-wNvyBPe-SGljT5tsggw03fDIFBKFDkZJG_lRmhMsArZVuWpzP2i5cS.Dzqrlw.kU2MJOKcchcS07oEIqLYezE4dd0
Cf-Connecting-Ip: 2601:880:c000:1a7d:ec41:a128:3013:48fe
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 550
DatabaseException
Failed to execute INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s) with [36222, 'Goblin Electromancer', 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 340, 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: 372d89344309463f6a06db740ae685279442422c
Really do have to diagnose and fix this at some point …
Failed to execute INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s) with [37922, 'Stromkirk Condemned', 4, False] because of (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Reported on decksite by 1peter1
--------------------------------------------------------------------------------
Request Method: POST
Path: /signup/?
Cookies: {'__cfduid': 'ddf1793d8b4ed3d76636de80517c9ec1d1542606885', '_ga': 'GA1.2.1013801208.1542606890', 'session': '.eJx9UWFPwjAQ_S_3eTEr3Rzlo7hgNBuCikFjlma9jcatHW1nBMJ_tyNBPpjYb-_eu3t3rwcoOjQtV6gcTJzpMQAuWqlgUvHGeiSwla0WFyxtqY0opC9BTFlMxlEcM5bENCSEQgD_MKqoe9mIs1OjS96gV0sHA6prFMM-VqvTfEoiGkDral30Fo3i7SAmHTo0xHdo3rvNqLCOu4GI87zfrvJdfbelEvNVplU2n5GvOlObNLzonf5Ef-ABeFmitWcMtyWZuoqLxZznW1be5yldV-nTaDrf68fG9-N3Jw3agvusSBwxSsKEsSs68i-50EN612E0DsMADFa-tPn1SN7Wy4fdWrwS4dLxinXMxos8n5mX53229B4-3c4f8-5j9H8iq52vnUKz8BHAaUzhdoMEbpAbNHAM4E9mjpsa_Zaqb5rjD5Xxmyg.D0FwBw.Q_F8ri5H-U6981ePxFcM8IV9Ro0', '_gid': 'GA1.2.2080251305.1549618721'}
Endpoint: add_signup
View Args: {}
Person: 539518455997530113
Referrer: https://pennydreadfulmagic.com/signup/
Request Data: {'mtgo_username': '1peter1', 'name': 'Noir - Vamp', 'decklist': '<?xml version="1.0" encoding="utf-8"?>\r\n<Deck xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">\r\n <NetDeckID>0</NetDeckID>\r\n <PreconstructedDeckID>0</PreconstructedDeckID>\r\n <Cards CatID="61172" Quantity="4" Sideboard="false" Name="Stromkirk Condemned" />\r\n <Cards CatID="34600" Quantity="3" Sideboard="false" Name="Malakir Bloodwitch" />\r\n <Cards CatID="65256" Quantity="3" Sideboard="false" Name="Sanctum Seeker" />\r\n <Cards CatID="42466" Quantity="3" Sideboard="false" Name="Bloodline Keeper" />\r\n <Cards CatID="61396" Quantity="3" Sideboard="false" Name="Voldaren Pariah" />\r\n <Cards CatID="45354" Quantity="4" Sideboard="false" Name="Vampire Nighthawk" />\r\n <Cards CatID="59960" Quantity="4" Sideboard="false" Name="Heir of Falkenrath" />\r\n <Cards CatID="60020" Quantity="4" Sideboard="false" Name="Indulgent Aristocrat" />\r\n <Cards CatID="60324" Quantity="4" Sideboard="false" Name="Asylum Visitor" />\r\n <Cards CatID="50408" Quantity="2" Sideboard="false" Name="Whip of Erebos" />\r\n <Cards CatID="58831" Quantity="8" Sideboard="false" Name="Swamp" />\r\n <Cards CatID="58837" Quantity="10" Sideboard="false" Name="Swamp" />\r\n <Cards CatID="58835" Quantity="4" Sideboard="false" Name="Swamp" />\r\n <Cards CatID="66581" Quantity="1" Sideboard="false" Name="Champion of Dusk" />\r\n <Cards CatID="66593" Quantity="3" Sideboard="false" Name="Dusk Legion Zealot" />\r\n <Cards CatID="66581" Quantity="2" Sideboard="true" Name="Champion of Dusk" />\r\n <Cards CatID="63794" Quantity="3" Sideboard="true" Name="Lay Bare the Heart" />\r\n <Cards CatID="58385" Quantity="2" Sideboard="true" Name="Transgress the Mind" />\r\n <Cards CatID="46603" Quantity="2" Sideboard="true" Name="Ultimate Price" />\r\n <Cards CatID="65276" Quantity="2" Sideboard="true" Name="Walk the Plank" />\r\n <Cards CatID="52737" Quantity="3" Sideboard="true" Name="Nature\'s Ruin" />\r\n <Cards CatID="61396" Quantity="1" Sideboard="true" Name="Voldaren Pariah" />\r\n</Deck>'}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: NL
X-Forwarded-For: 85.148.128.139, 162.158.111.75
Cf-Ray: 4a6d34f48b859ca7-AMS
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:65.0) Gecko/20100101 Firefox/65.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
Accept-Language: nl,en-US;q=0.7,en;q=0.3
Referer: https://pennydreadfulmagic.com/signup/
Content-Type: application/x-www-form-urlencoded
Dnt: 1
Cookie: __cfduid=ddf1793d8b4ed3d76636de80517c9ec1d1542606885; _ga=GA1.2.1013801208.1542606890; session=.eJx9UWFPwjAQ_S_3eTEr3Rzlo7hgNBuCikFjlma9jcatHW1nBMJ_tyNBPpjYb-_eu3t3rwcoOjQtV6gcTJzpMQAuWqlgUvHGeiSwla0WFyxtqY0opC9BTFlMxlEcM5bENCSEQgD_MKqoe9mIs1OjS96gV0sHA6prFMM-VqvTfEoiGkDral30Fo3i7SAmHTo0xHdo3rvNqLCOu4GI87zfrvJdfbelEvNVplU2n5GvOlObNLzonf5Ef-ABeFmitWcMtyWZuoqLxZznW1be5yldV-nTaDrf68fG9-N3Jw3agvusSBwxSsKEsSs68i-50EN612E0DsMADFa-tPn1SN7Wy4fdWrwS4dLxinXMxos8n5mX53229B4-3c4f8-5j9H8iq52vnUKz8BHAaUzhdoMEbpAbNHAM4E9mjpsa_Zaqb5rjD5Xxmyg.D0FwBw.Q_F8ri5H-U6981ePxFcM8IV9Ro0; _gid=GA1.2.2080251305.1549618721
Upgrade-Insecure-Requests: 1
Cf-Connecting-Ip: 85.148.128.139
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 2901
DatabaseException
Failed to execute INSERT INTO deck_card (deck_id, card, n, sideboard) VALUES (%s, %s, %s, %s) with [37922, 'Stromkirk Condemned', 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 341, 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: 611d2dd077689f01fe34de1ac4fcd33c3de52f9eFailed to execute INSERT INTO deck ( created_date, updated_date, person_id, source_id, url, identifier, name, competition_id, archetype_id, resource_uri, featured_card, score, thumbnail_url, small_thumbnail_url, finish, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE ) with [1550014925.945496, 143, 3, 'https://pennydreadfulmagic.com/competitions/848/', '["bakert99", 848, "1550014926"]', 'UB Mid', 848, None, None, None, None, None, None, None] because of (1213, 'Deadlock found when trying to get lock; try restarting transaction')
Reported on decksite by bakert99
--------------------------------------------------------------------------------
Request Method: POST
Path: /signup/?
Cookies: {'__cfduid': 'dbbaeaf004b46114da480ca1ea67b1fe41519487476', 'hide_intro': 'True', '_ga': 'GA1.2.336853490.1519750417', 'session': '.eJx1kNtuwjAQRP9ln6PKTpxAeGvpDQqiVxCtqsiNN8bCuch2Wiji3-sgUaRKfZyd2R377CBr0JS8wsrBwJkWA-CiVNVRCGXz2ohMCRgATeOEsZT2SJ8yRsIkhgD-d3Sdc43exeqgpETR1dm6OtyjLAqgdLLOWoum4mWX_eBrNC5N_UbNW7cKM-u465wmvp7fr75H00cqeKhuinEyuzyPWjXXxbw85V299oWDHfA8R2uPGoSdbtjLWGrFGjV5kKPnoS0mS_IaueXC-H3cNMqgzbhHQeMwpmGapNEZSdJe1Kcnv6OTENYnJACDhR-tfkvC5OnudjIbkofPq5EsvsajHInuLejMyM3Ql3icjf_Nm-fmmati62eyVVpYeA_gcCZz2y4CF8gNGtgH8Bea40aif2XVar3_Abpoj4o.D0TrRw.1Lf6KTtwY5PpMkL_wu5vhG6nadk', '_gid': 'GA1.2.1940173015.1548094837', 'deck_id': '38546', '_gat_gtag_UA_109131120_1': '1'}
Endpoint: add_signup
View Args: {}
Person: 195644917081440265
Referrer: https://pennydreadfulmagic.com/signup/
Request Data: {'mtgo_username': 'bakert99', 'name': 'UB Mid', 'decklist': "4 Thought Erasure\r\n2 Dimir Guildmage\r\n4 Sunken Hollow\r\n4 Choked Estuary\r\n10 Swamp\r\n6 Island\r\n4 Rune Snag\r\n4 Hypnotic Specter\r\n4 Nightveil Specter\r\n2 Bloodgift Demon\r\n4 Desecration Demon\r\n1 Agony Warp\r\n1 Ultimate Price\r\n2 Ulcerate\r\n2 Guul Draz Assassin\r\n1 Murder\r\n1 Smother\r\n1 Consuming Vapors\r\n1 Terror\r\n1 Cremate\r\n1 Bloodsoaked Champion\r\n\r\n3 Negate\r\n4 Lay Bare the Heart\r\n3 Nature's Ruin\r\n2 Wydwen, the Biting Gale\r\n2 Withered Wretch\r\n1 Steal Artifact\r\n"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 136.25.151.171, 172.68.141.246
Cf-Ray: 4a82e8e14c056d8a-SJC
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 (Macintosh; Intel Mac OS X 10_14_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.96 Safari/537.36
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
Referer: https://pennydreadfulmagic.com/signup/
Accept-Language: en-US,en;q=0.9,es;q=0.8
Cookie: __cfduid=dbbaeaf004b46114da480ca1ea67b1fe41519487476; hide_intro=True; _ga=GA1.2.336853490.1519750417; session=.eJx1UMtuwjAQ_Jc9R5WdOIFwa-krFETpA0SrKnLjjbEwSWQ7LRTx73WQWqRKPc7OzM7u7IGLjapg4EyLAQhli9qIXAkYAE3jhLGU9kifMkbCJIYA_md0XXCNnsXqiKREkTdobF0d91EWBbBxss5bi6bim077ztdoXJp6R81btwpz67jrmCa-nt-vvrLJAxU8VDflKJlenketmutyvjnpXb32gYM98KJAa38wCDvZsueR1Io1ajyT2dPQluMleYnccmG8H7eNMmhz7vxtcRjTME3S6IwkaS_q0xPftZMQ1ickAIOlH61-Q8Lk8e52PB2S2cdVJsvPUVYg0b0FnRq5HfoQX2fjv3n1vWHlVLnzM9kqLSy8BXBck7tdJ4EL5AYNHAL4W5rjRqK_smq1PnwDU6SI9w.Dfj1kQ.6zIYF2Bw9YqqBtAVtkhDIFSf-AA; _gid=GA1.2.1940173015.1548094837; deck_id=38546; _gat_gtag_UA_109131120_1=1; session=.eJx1kNtuwjAQRP9ln6PKTpxAeGvpDQqiVxCtqsiNN8bCuch2Wiji3-sgUaRKfZyd2R377CBr0JS8wsrBwJkWA-CiVNVRCGXz2ohMCRgATeOEsZT2SJ8yRsIkhgD-d3Sdc43exeqgpETR1dm6OtyjLAqgdLLOWoum4mWX_eBrNC5N_UbNW7cKM-u465wmvp7fr75H00cqeKhuinEyuzyPWjXXxbw85V299oWDHfA8R2uPGoSdbtjLWGrFGjV5kKPnoS0mS_IaueXC-H3cNMqgzbhHQeMwpmGapNEZSdJe1Kcnv6OTENYnJACDhR-tfkvC5OnudjIbkofPq5EsvsajHInuLejMyM3Ql3icjf_Nm-fmmati62eyVVpYeA_gcCZz2y4CF8gNGtgH8Bea40aif2XVar3_Abpoj4o.D0TrRw.1Lf6KTtwY5PpMkL_wu5vhG6nadk
Cf-Connecting-Ip: 136.25.151.171
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 614
DatabaseException
Failed to execute INSERT INTO deck ( created_date, updated_date, person_id, source_id, url, identifier, name, competition_id, archetype_id, resource_uri, featured_card, score, thumbnail_url, small_thumbnail_url, finish, reviewed ) VALUES ( IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE ) with [1550014925.945496, 143, 3, 'https://pennydreadfulmagic.com/competitions/848/', '["bakert99", 848, "1550014926"]', 'UB Mid', 848, None, None, None, None, None, None, None] 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 351, 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
deck_id = db().insert(sql, values)
File "./shared/database.py", line 89, in insert
self.execute(sql, args)
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: 1c84d9886ebe0b811fde3c14436118b5c0bfba14Hasn't happened (except in scraper, not in signup) since Aug 30. Maybe it fixed itself?
bakert
commented
5 years ago 
Still only happened in scraper and startup since Aug 30 which is nice. I guess it needs fixing in scraper and startup tho :)
bakert
commented
5 years ago DatabaseException Failed to execute `UPDATE deck SET decklist_hash = %s WHERE id = %s` with `['de703767d92f7fe8b707d080edd8f205293d9d3b', 63747]` because of `(1213, 'Deadlock found when trying to get lock; try restarting transaction')` Stack Trace:
File "run.py", line 126, in <module>
run()
File "run.py", line 70, in task
run_all_tasks(module)
File "run.py", line 113, in run_all_tasks
s.scrape() # type: ignore
File "/home/discord/decksite/decksite/scrapers/mtggoldfish.py", line 43, in scrape
deck.add_deck(d)
File "/home/discord/decksite/decksite/data/deck.py", line 337, in add_deck
add_cards(deck_id, params['cards'])
File "/home/discord/decksite/decksite/data/deck.py", line 416, in add_cards
db().execute('UPDATE deck SET decklist_hash = %s WHERE id = %s', [deckhash, deck_id])
File "/home/discord/decksite/shared/database.py", line 45, in execute
[n, _] = self.execute_anything(sql, args, False)
File "/home/discord/decksite/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: ee82db8095819114b6b95412d4e2b3b3e860c5aeI'm not really sure where to go with this. The main issue is cleared up, there's no frequent occurrence of anything. I'm gonna close it and reopen if we get more than a very small number of reoccurrences.