{"action":"opened","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/19798","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/19798/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/19798/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/19798/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/19798","id":319160624,"number":19798,"title":"500 error at /error/HTTP_BAD_GATEWAY.html.var","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-05-01T09:59:52Z","updated_at":"2018-05-01T09:59:52Z","closed_at":null,"author_association":"NONE","body":" Failed to execute `\n        SELECT\n            d.id,\n            d.name AS original_name,\n            d.created_date,\n            d.updated_date,\n            SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS wins,\n            SUM(CASE WHEN dm.games < odm.games THEN 1 ELSE 0 END) AS losses,\n            SUM(CASE WHEN dm.games = odm.games THEN 1 ELSE 0 END) AS draws,\n            d.finish,\n            d.archetype_id,\n            d.url AS source_url,\n            d.competition_id,\n            c.name AS competition_name,\n            c.end_date AS competition_end_date,\n            c.top_n AS competition_top_n,\n            ct.name AS competition_type_name,\n            d.identifier,\n            LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person,\n            p.id AS person_id,\n            p.banned,\n            p.discord_id,\n            d.created_date AS `date`,\n            d.decklist_hash,\n            d.retired,\n            s.name AS source_name,\n            IFNULL(a.name, '') AS archetype_name,\n            cache.normalized_name AS name,\n            cache.colors,\n            cache.colored_symbols,\n            cache.legal_formats,\n            season.id AS season_id\n        FROM\n            deck AS d\n        LEFT JOIN\n            person AS p ON d.person_id = p.id\n        LEFT JOIN\n            source AS s ON d.source_id = s.id\n        LEFT JOIN\n            archetype AS a ON d.archetype_id = a.id\n        \n        LEFT JOIN\n            competition AS c ON d.competition_id = c.id\n        LEFT JOIN\n            competition_series AS cs ON cs.id = c.competition_series_id\n        LEFT JOIN\n            competition_type AS ct ON ct.id = cs.competition_type_id\n    \n        LEFT JOIN\n            deck_cache AS cache ON d.id = cache.deck_id\n        LEFT JOIN\n            deck_match AS dm ON d.id = dm.deck_id\n        LEFT JOIN\n            deck_match AS odm ON odm.deck_id <> d.id AND dm.match_id = odm.match_id\n        \n        LEFT JOIN\n            (\n        SELECT\n            `start`.id,\n            `start`.code,\n            `start`.start_date AS start_date,\n            `end`.start_date AS end_date\n        FROM\n            season AS `start`\n        LEFT JOIN\n            season AS `end` ON `end`.id = `start`.id + 1\n    ) AS season ON season.start_date <= d.created_date AND (season.end_date IS NULL OR season.end_date > d.created_date)\n    \n        WHERE (NOT d.reviewed) AND (TRUE)\n        GROUP BY\n            d.id,\n            season.id -- In theory this is not necessary as all decks are in a single season and we join on the date but MySQL cannot work that out so give it the hint it needs.\n        ORDER BY\n            d.created_date DESC, d.finish IS NULL, d.finish\n        \n    ` with `[]` because of `(1021, 'Disk full (/tmp/#sql_7d74_1.MAI); waiting for someone to free some space... (errno: 28 \"No space left on device\")')`\n\nReported on decksite by logged_out\n--------------------------------------------------------------------------------\nRequest Method: GET\nPath: /error/HTTP_BAD_GATEWAY.html.var?\nCookies: {'__cfduid': 'df7ead92b57251c59c4dacc0a9c9e709b1525155897'}\nEndpoint: None\nView Args: None\nPerson: logged_out\nReferrer: None\nRequest Data: {}\nHost: pennydreadfulmagic.com\nAccept-Encoding: gzip\nCf-Ipcountry: US\nX-Forwarded-For: 2600:3c01:0:0:f03c:91ff:fee4:537c, 162.158.255.24\nCf-Ray: 414165d5df3c9643-SJC\nX-Forwarded-Proto: https\nCf-Visitor: {\"scheme\":\"https\"}\nUser-Agent: python-requests/2.18.4\nAccept: */*\nCookie: __cfduid=df7ead92b57251c59c4dacc0a9c9e709b1525155897\nCf-Connecting-Ip: 2600:3c01:0:0:f03c:91ff:fee4:537c\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 1713, in handle_user_exception\n    return self.handle_http_exception(e)\n  File \"/home/discord/.local/lib/python3.6/site-packages/flask/app.py\", line 1644, in handle_http_exception\n    return handler(e)\n  File \"./decksite/main.py\", line 414, in not_found\n    return view.page(), 404\n  File \"./shared_web/base_view.py\", line 14, in page\n    return template.render_name('page', self)\n  File \"./shared_web/template.py\", line 29, in render_name\n    return renderer.render_name(template, *context)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/renderer.py\", line 378, in render_name\n    return self._render_string(template, *context, **kwargs)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/renderer.py\", line 402, in _render_string\n    return self._render_final(render_func, *context, **kwargs)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/renderer.py\", line 419, in _render_final\n    return render_func(engine, stack)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/renderer.py\", line 400, in <lambda>\n    render_func = lambda engine, stack: engine.render(template, stack)\n  File \"./shared_web/template.py\", line 68, in render\n    return self.parsed_templates[template].render(self, context_stack)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/parsed.py\", line 47, in render\n    parts = list(map(get_unicode, self._parse_tree))\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/parsed.py\", line 46, in get_unicode\n    return node.render(engine, context)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/parser.py\", line 152, in render\n    return engine.render(template, context)\n  File \"./shared_web/template.py\", line 68, in render\n    return self.parsed_templates[template].render(self, context_stack)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/parsed.py\", line 47, in render\n    parts = list(map(get_unicode, self._parse_tree))\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/parsed.py\", line 46, in get_unicode\n    return node.render(engine, context)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/parser.py\", line 152, in render\n    return engine.render(template, context)\n  File \"./shared_web/template.py\", line 68, in render\n    return self.parsed_templates[template].render(self, context_stack)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/parsed.py\", line 47, in render\n    parts = list(map(get_unicode, self._parse_tree))\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/parsed.py\", line 46, in get_unicode\n    return node.render(engine, context)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/parser.py\", line 192, in render\n    values = engine.fetch_section_data(context, self.key)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/renderengine.py\", line 121, in fetch_section_data\n    data = self.resolve_context(context, name)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/renderer.py\", line 317, in resolve_context\n    return context_get(stack, name)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/renderengine.py\", line 19, in context_get\n    return stack.get(name)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/context.py\", line 281, in get\n    result = self._get_simple(parts[0])\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/context.py\", line 310, in _get_simple\n    result = _get_value(item, name)\n  File \"/home/discord/.local/lib/python3.6/site-packages/pystache/context.py\", line 73, in _get_value\n    return attr()\n  File \"./decksite/view.py\", line 89, in menu\n    n = len(deck.load_decks('NOT d.reviewed'))\n  File \"./decksite/data/deck.py\", line 132, in load_decks\n    rows = 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"}}