{"action":"closed","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/40507","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/40507/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/40507/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/40507/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/40507","id":369356738,"node_id":"MDU6SXNzdWUzNjkzNTY3Mzg=","number":40507,"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":"2018-10-12T00:39:33Z","updated_at":"2018-12-18T09:39:15Z","closed_at":"2018-12-18T09:39:15Z","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 `[1539304722.7777543, 458, 3, '/competitions/?competition_id=694', '[\"martyvburen\", 694, \"1539304723\"]', 'Mono Red Burninator V2', 694, None, None, None, None, None, None, None]` because of `(1205, 'Lock wait timeout exceeded; try restarting transaction')`\n\nReported on decksite by martyvburen```\n            --------------------------------------------------------------------------------\n            Request Method: POST\n            Path: /signup/?\n            Cookies: {'__cfduid': 'd66c23b212e79506ff5bc133ab60074f51537999611', 'deck_id': '26192', 'session': '.eJx9UV1vgjAU_S_3mSwFCoJvLk6yuUynD3NZFlLhglXauraYEeN_XyFxJnvY4_m69_b0DPkRtWASpYWx1S16wErBJYwr1hiHShRcqPKGuSmULnPuKAj9OEmJn0ZkRFIaBjQED_5RZF63vCmvmxpVsAadGyX0qK6x7O8xSg7zaZR4IGyt8taglkz0XsG07U7bVg8hxVq7C3Jjme3F0-Rhyc3rlG4s3ZJuNdk9Lp8n8y_6FB9YevNbdXDx8RlYUaAxVwxvIopfpNxMky7br1f7bJZUPBN0-p4lfO3y-H3kGk3OXF1-FKZ-QiMa3IXJKIj99Kb3DcaEJoR4oLFy1O53Cd-qTVC9ETtbcr1IixYXGQ_KeaBkw41b4ho-utd8uCrdv_Cqc9xQnIFPD4Yxue16C9wj06jh4sHf3izTNborZds0lx_pjZz7.DqF-ig.Ax5g2TnGD291R0r6jML31A1EVhs'}\n            Endpoint: add_signup\n            View Args: {}\n            Person: 316890195070943243\n            Referrer: https://pennydreadfulmagic.com/signup/\n            Request Data: {'mtgo_username': 'martyvburen', 'name': 'Mono Red Burninator V2', 'decklist': '4 Falkenrath Gorger\\r\\n3 Firedrinker Satyr\\r\\n1 Landslide\\r\\n4 Village Messenger\\r\\n4 Slith Firewalker\\r\\n2 Sin Prodder\\r\\n3 Hellrider\\r\\n4 Pillar of Flame\\r\\n4 Incendiary Flow\\r\\n1 Browbeat\\r\\n2 Collective Defiance\\r\\n2 Desert of the Fervent\\r\\n21 Mountain\\r\\n4 Kindle\\r\\n1 Last-Ditch Effort\\r\\n\\r\\n4 Blood Knight\\r\\n1 Flamebreak\\r\\n3 Scrabbling Claws\\r\\n1 Hammer of Bogardan\\r\\n1 Pulse of the Forge\\r\\n2 Rack and Ruin\\r\\n1 Meltdown\\r\\n1 Echoing Ruin\\r\\n1 Release the Gremlins'}\nHost: pennydreadfulmagic.com\nAccept-Encoding: gzip\nCf-Ipcountry: US\nX-Forwarded-For: 66.26.141.185, 162.158.186.152\nCf-Ray: 46858154ba2f3816-ATL\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/69.0.3497.100 Safari/537.36\nAccept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8\nReferer: https://pennydreadfulmagic.com/signup/\nAccept-Language: en-US,en;q=0.9\nCookie: __cfduid=d66c23b212e79506ff5bc133ab60074f51537999611; deck_id=26192; session=.eJx9UV1vgjAU_S_3mSwFCoJvLk6yuUynD3NZFlLhglXauraYEeN_XyFxJnvY4_m69_b0DPkRtWASpYWx1S16wErBJYwr1hiHShRcqPKGuSmULnPuKAj9OEmJn0ZkRFIaBjQED_5RZF63vCmvmxpVsAadGyX0qK6x7O8xSg7zaZR4IGyt8taglkz0XsG07U7bVg8hxVq7C3Jjme3F0-Rhyc3rlG4s3ZJuNdk9Lp8n8y_6FB9YevNbdXDx8RlYUaAxVwxvIopfpNxMky7br1f7bJZUPBN0-p4lfO3y-H3kGk3OXF1-FKZ-QiMa3IXJKIj99Kb3DcaEJoR4oLFy1O53Cd-qTVC9ETtbcr1IixYXGQ_KeaBkw41b4ho-utd8uCrdv_Cqc9xQnIFPD4Yxue16C9wj06jh4sHf3izTNborZds0lx_pjZz7.DqF-ig.Ax5g2TnGD291R0r6jML31A1EVhs\nCf-Connecting-Ip: 66.26.141.185\nX-Forwarded-Host: pennydreadfulmagic.com\nX-Forwarded-Server: pennydreadfulmagic.com\nConnection: Keep-Alive\nContent-Length: 588\n```\n--------------------------------------------------------------------------------\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 `[1539304722.7777543, 458, 3, '/competitions/?competition_id=694', '[\"martyvburen\", 694, \"1539304723\"]', 'Mono Red Burninator V2', 694, None, None, None, None, None, None, None]` because of `(1205, 'Lock wait timeout exceeded; try restarting transaction')`\nStack Trace:\n```\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 289, in add_signup\n    d = lg.signup(form)\n  File \"./decksite/league.py\", line 181, in signup\n    return deck.add_deck(form)\n  File \"./decksite/data/deck.py\", line 347, 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"}}
{"actor":{"display_login":"stale"}}