payload: {"action":"closed","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/43613","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/43613/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/43613/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/43613/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/43613","id":443000076,"node_id":"MDU6SXNzdWU0NDMwMDAwNzY=","number":43613,"title":"500 error at /signup/","user":{"login":"vorpal-buildbot","id":23072004,"node_id":"MDQ6VXNlcjIzMDcyMDA0","avatar_url":"https://avatars2.githubusercontent.com/u/23072004?v=4","gravatar_id":"","url":"https://api.github.com/users/vorpal-buildbot","html_url":"https://github.com/vorpal-buildbot","followers_url":"https://api.github.com/users/vorpal-buildbot/followers","following_url":"https://api.github.com/users/vorpal-buildbot/following{/other_user}","gists_url":"https://api.github.com/users/vorpal-buildbot/gists{/gist_id}","starred_url":"https://api.github.com/users/vorpal-buildbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vorpal-buildbot/subscriptions","organizations_url":"https://api.github.com/users/vorpal-buildbot/orgs","repos_url":"https://api.github.com/users/vorpal-buildbot/repos","events_url":"https://api.github.com/users/vorpal-buildbot/events{/privacy}","received_events_url":"https://api.github.com/users/vorpal-buildbot/received_events","type":"User","site_admin":false},"labels":[{"id":958792190,"node_id":"MDU6TGFiZWw5NTg3OTIxOTA=","url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/labels/DatabaseException","name":"DatabaseException","color":"b60205","default":false},{"id":958792189,"node_id":"MDU6TGFiZWw5NTg3OTIxODk=","url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/labels/decksite","name":"decksite","color":"bfd4f2","default":false},{"id":763867617,"node_id":"MDU6TGFiZWw3NjM4Njc2MTc=","url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/labels/wontfix","name":"wontfix","color":"ffffff","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2019-05-11T14:38:30Z","updated_at":"2019-08-02T04:37:10Z","closed_at":"2019-08-02T04:37:10Z","author_association":"NONE","body":" Failed to execute `INSERT INTO deck (\n        created_date,\n        updated_date,\n        person_id,\n        source_id,\n        url,\n        identifier,\n        name,\n        competition_id,\n        archetype_id,\n        resource_uri,\n        featured_card,\n        score,\n        thumbnail_url,\n        small_thumbnail_url,\n        finish,\n        reviewed\n    ) VALUES (\n         IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE\n    )` with `[1557585119.2268982, 2379, 3, 'https://pennydreadfulmagic.com/competitions/2186/', '[\"osubuckscolts\", 2186, \"1557585119\"]', 'Demonic Rising', 2186, None, None, None, None, None, None, None]` because of `(1213, 'Deadlock found when trying to get lock; try restarting transaction')`\n\nReported on decksite by osubuckscolts\n\n--------------------------------------------------------------------------------\n<details><summary><strong>Request Data</strong></summary>\n```\n\nRequest Method: POST\nPath: /signup/?\nCookies: {'__cfduid': 'd9c6d6f60f63ac89c4f6f96387401542e1546029478', '_ga': 'GA1.2.458073196.1546029485', '_gid': 'GA1.2.1370244061.1557584703', 'session': '.eJx9UctuwjAQ_BefIxTixIm58RIUpFKgRbRVFbmJE0ISO_jRliL-vQsVcKjUm2dnd2Z3fEBxw1XNBBcGdYyy3EEsrQuBOhmrNKCU10Ut0xsudCJVGhdQQtj1qB_6xKUu9gl1gxA56B9GxLktqvTiVMk85-lpAy3FWdHDIXVQbXIZW82VYDUHMantu01KMK6MBh3JrNl4sTbM_NKjj3Cixgs8GW6Gst8sl7ldkGhQ7mQZ3vqNLDkcdkAsSbjWF4x2eNTH-GusR7Pd7FvSwd1Lb_X0mZGmPZgnMM-_mkJxHTPIqB0EUTuiEcYtGnoUh-TGn2Ijrh-5roMUz6C0uZr0IjbdNt79Y5dM8lwtH1breUq662kQiWcXTOC6Bq55hfzgM4psD7VzWvr6aG0lWLw56Cwam_1pAPU4U1yho4P-BGmYyjksLWxVHX8ARfSeXw.D7huHw.GKAnnKxNuZ8n5e1QeTJ5AcR6QlU'}\nEndpoint: add_signup\nView Args: {}\nPerson: 302947460903469057\nReferrer: https://pennydreadfulmagic.com/signup/\nRequest Data: {'mtgo_username': 'osubuckscolts', 'name': 'Demonic Rising', 'decklist': \"3 Magister of Worth\\r\\n4 Wretched Banquet\\r\\n4 Distress\\r\\n4 Orzhov Signet\\r\\n4 Read the Bones\\r\\n4 Vindicate\\r\\n4 Haunted Plate Mail\\r\\n3 Yahenni's Expertise\\r\\n3 Demonic Rising\\r\\n1 Homicidal Seclusion\\r\\n2 Murderous Cut\\r\\n2 Dread Statuary\\r\\n2 Scoured Barrens\\r\\n4 Spawning Pool\\r\\n12 Swamp\\r\\n4 Temple of Silence\\r\\n\\r\\n4 Lost Legacy\\r\\n3 Tainted Remedy\\r\\n1 Muse Vessel\\r\\n4 Sphere of Law\\r\\n3 Beacon of Immortality\"}\nHost: pennydreadfulmagic.com\nAccept-Encoding: gzip\nCf-Ipcountry: US\nX-Forwarded-For: 50.4.238.143, 162.158.79.73\nCf-Ray: 4d54dbe78a3d956c-IAD\nX-Forwarded-Proto: https\nCf-Visitor: {\"scheme\":\"https\"}\nCache-Control: max-age=0\nOrigin: https://pennydreadfulmagic.com\nUpgrade-Insecure-Requests: 1\nContent-Type: application/x-www-form-urlencoded\nUser-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36\nAccept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3\nReferer: https://pennydreadfulmagic.com/signup/\nAccept-Language: en-US,en;q=0.9\nCookie: __cfduid=d9c6d6f60f63ac89c4f6f96387401542e1546029478; _ga=GA1.2.458073196.1546029485; _gid=GA1.2.1370244061.1557584703; session=.eJx9UctuwjAQ_BefIxTixIm58RIUpFKgRbRVFbmJE0ISO_jRliL-vQsVcKjUm2dnd2Z3fEBxw1XNBBcGdYyy3EEsrQuBOhmrNKCU10Ut0xsudCJVGhdQQtj1qB_6xKUu9gl1gxA56B9GxLktqvTiVMk85-lpAy3FWdHDIXVQbXIZW82VYDUHMantu01KMK6MBh3JrNl4sTbM_NKjj3Cixgs8GW6Gst8sl7ldkGhQ7mQZ3vqNLDkcdkAsSbjWF4x2eNTH-GusR7Pd7FvSwd1Lb_X0mZGmPZgnMM-_mkJxHTPIqB0EUTuiEcYtGnoUh-TGn2Ijrh-5roMUz6C0uZr0IjbdNt79Y5dM8lwtH1breUq662kQiWcXTOC6Bq55hfzgM4psD7VzWvr6aG0lWLw56Cwam_1pAPU4U1yho4P-BGmYyjksLWxVHX8ARfSeXw.D7huHw.GKAnnKxNuZ8n5e1QeTJ5AcR6QlU\nCf-Connecting-Ip: 50.4.238.143\nCdn-Loop: cloudflare\nX-Forwarded-Host: pennydreadfulmagic.com\nX-Forwarded-Server: pennydreadfulmagic.com\nConnection: Keep-Alive\nContent-Length: 522\n```\n</details>\n--------------------------------------------------------------------------------\n<details><summary>\nDatabaseException\nFailed to execute `INSERT INTO deck (\n        created_date,\n        updated_date,\n        person_id,\n        source_id,\n        url,\n        identifier,\n        name,\n        competition_id,\n        archetype_id,\n        resource_uri,\n        featured_card,\n        score,\n        thumbnail_url,\n        small_thumbnail_url,\n        finish,\n        reviewed\n    ) VALUES (\n         IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE\n    )` with `[1557585119.2268982, 2379, 3, 'https://pennydreadfulmagic.com/competitions/2186/', '[\"osubuckscolts\", 2186, \"1557585119\"]', 'Demonic Rising', 2186, None, None, None, None, None, None, None]` because of `(1213, 'Deadlock found when trying to get lock; try restarting transaction')`\n</summary>\nStack Trace:\n\n```Python traceback\n  File \"/home/discord/.local/lib/python3.6/site-packages/flask/app.py\", line 2309, in __call__\n    return self.wsgi_app(environ, start_response)\n  File \"/home/discord/.local/lib/python3.6/site-packages/flask/app.py\", line 2295, in wsgi_app\n    response = self.handle_exception(e)\n  File \"/home/discord/.local/lib/python3.6/site-packages/flask/app.py\", line 2292, in wsgi_app\n    response = self.full_dispatch_request()\n  File \"/home/discord/.local/lib/python3.6/site-packages/flask/app.py\", line 1815, in full_dispatch_request\n    rv = self.handle_user_exception(e)\n  File \"/home/discord/.local/lib/python3.6/site-packages/flask/app.py\", line 1718, in handle_user_exception\n    reraise(exc_type, exc_value, tb)\n  File \"/home/discord/.local/lib/python3.6/site-packages/flask/_compat.py\", line 35, in reraise\n    raise value\n  File \"/home/discord/.local/lib/python3.6/site-packages/flask/app.py\", line 1813, in full_dispatch_request\n    rv = self.dispatch_request()\n  File \"/home/discord/.local/lib/python3.6/site-packages/flask/app.py\", line 1799, in dispatch_request\n    return self.view_functions[rule.endpoint](**req.view_args)\n  File \"./decksite/cache.py\", line 79, in decorated_function\n    response = make_response(f(*args, **kwargs))\n  File \"./decksite/main.py\", line 394, in add_signup\n    d = lg.signup(form)\n  File \"./decksite/league.py\", line 180, in signup\n    return deck.add_deck(form)\n  File \"./decksite/data/deck.py\", line 356, in add_deck\n    deck_id = db().insert(sql, values)\n  File \"./shared/database.py\", line 89, in insert\n    self.execute(sql, args)\n  File \"./shared/database.py\", line 45, in execute\n    [n, _] = self.execute_anything(sql, args, False)\n  File \"./shared/database.py\", line 60, in execute_anything\n    raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e))\n\n```\n\n</details>\nException_hash: 135d62732d2bc096eeae698cd745b368fa94ba83\n"}}
other: {"actor":{"display_login":"stale"}}