{"action":"opened","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/19701","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/19701/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/19701/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/19701/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/19701","id":319054987,"number":19701,"title":"500 error at /people/1827/","user":{"login":"vorpal-buildbot","id":23072004,"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":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-30T22:17:52Z","updated_at":"2018-04-30T22:17:52Z","closed_at":null,"author_association":"NONE","body":" Failed to execute `\n        SELECT\n            card AS name\n        FROM\n            deck_card AS dc\n        INNER JOIN\n            deck AS d ON dc.deck_id = d.id\n        WHERE\n            deck_id\n        IN (\n            SELECT\n                DISTINCT deck_id\n            FROM\n                deck_match\n        ) -- Only include cards that actually got played competitively rather than just posted to Goldfish as \"new cards this season\" or similar.\n        GROUP BY\n            card\n        HAVING\n            COUNT(DISTINCT d.person_id) = 1\n        AND\n            MAX(d.person_id) = 1827 -- In MySQL 5.7+ this could/should be ANY_VALUE not MAX but this works with any version. The COUNT(DISTINCT  p.id) ensures this only has one possible value but MySQL can't work that out.-- In MySQL 5.7+ this could/should be ANY_VALUE not MAX but this works with any version. The COUNT(DISTINCT  p.id) ensures this only has one possible value but MySQL can't work that out.\n    ` with `[]` because of `(3, 'Error writing file \\'/tmp/MYPqaQrA\\' (Errcode: 28 \"No space left on device\")')`\n\nReported on decksite by logged_out\n--------------------------------------------------------------------------------\nRequest Method: GET\nPath: /people/1827/?\nCookies: {}\nEndpoint: person\nView Args: {'person_id': '1827'}\nPerson: logged_out\nReferrer: None\nRequest Data: {}\nHost: pennydreadfulmagic.com\nAccept-Encoding: gzip\nCf-Ipcountry: US\nX-Forwarded-For: 34.192.116.178, 172.68.65.224\nCf-Ray: 413d5e2fda4f5711-IAD\nX-Forwarded-Proto: https\nCf-Visitor: {\"scheme\":\"https\"}\nAccept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\nUser-Agent: Mozilla/5.0 (compatible; SMTBot/1.0; +http://www.similartech.com/smtbot)\nCf-Connecting-Ip: 34.192.116.178\nX-Forwarded-Host: pennydreadfulmagic.com\nX-Forwarded-Server: pennydreadfulmagic.com\nConnection: Keep-Alive--------------------------------------------------------------------------------\nDatabaseException\nStack Trace:\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 71, in decorated_function\n    response = make_response(f(*args, **kwargs))\n  File \"./decksite/main.py\", line 87, in person\n    view = Person(p)\n  File \"./decksite/views/person.py\", line 17, in __init__\n    self.only_played_cards = card.only_played_by(person.id)\n  File \"./decksite/data/card.py\", line 76, in only_played_by\n    return [cards[r['name']] for r in db().execute(sql)]\n  File \"./shared/database.py\", line 49, in execute\n    raise DatabaseException('Failed to execute `{sql}` with `{args}` because of `{e}`'.format(sql=sql, args=args, e=e))\n\n"}}
{"actor":{"display_login":"vorpal-buildbot"}}