vorpal-buildbot
commented
5 years ago 500 error at /people/
Failed to execute ` SELECT p.id, LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name, p.mtgo_username, p.tappedout_username, p.mtggoldfish_username, p.discord_id, p.elo, num_decks, wins, losses, draws, perfect_runs, tournament_wins, tournament_top8s, win_percent, num_competitions FROM person AS p LEFT JOIN ( SELECT d.person_id, COUNT(d.id) AS num_decks, SUM(wins) AS wins, SUM(losses) AS losses, SUM(draws) AS draws, SUM(CASE WHEN wins >= 5 AND losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs, SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins, SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s, IFNULL(ROUND((SUM(wins) / NULLIF(SUM(wins + losses), 0)) * 100, 1), '') AS win_percent, SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions FROM deck AS d LEFT JOIN deck_cache AS dc ON d.id = dc.deck_id
LEFT JOIN
(
SELECT
`start`.id,
`start`.code,
`start`.start_date AS start_date,
`end`.start_date AS end_date
FROM
season AS `start`
LEFT JOIN
season AS `end` ON `end`.id = `start`.id + 1
) AS season ON season.start_date <= d.created_date AND (season.end_date IS NULL OR season.end_date > d.created_date)
WHERE
season.id = 10
GROUP BY
d.person_id
) AS stats ON p.id = stats.person_id
WHERE
1 = 1
GROUP BY
p.id
ORDER BY
`num_decks` DESC, name
` with `[]` because of `(1021, 'Disk full (/tmp/#sql_4513_13.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")')`Reported on decksite by logged_out
--------------------------------------------------------------------------------
Request Method: GET
Path: /people/?
Cookies: {'__cfduid': 'da4d39ee856437dad3cec4ed0b06435e61547129227'}
Endpoint: people
View Args: {}
Person: logged_out
Referrer: None
Request Data: {}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 35.175.220.39, 162.158.78.222
Cf-Ray: 496fbf3329289574-IAD
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Accept-Language: en-us,en-gb,en;q=0.7,*;q=0.3
Accept-Charset: utf-8,iso-8859-1;q=0.7,*;q=0.7
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
User-Agent: elefent/1.4 (web crawler :: robots.txt exclude elefent; https://crawler.elefent.net; webmaster at elefent dot net)
Cookie: __cfduid=da4d39ee856437dad3cec4ed0b06435e61547129227
Cf-Connecting-Ip: 35.175.220.39
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-AliveDatabaseException Failed to execute ` SELECT p.id, LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name, p.mtgo_username, p.tappedout_username, p.mtggoldfish_username, p.discord_id, p.elo, num_decks, wins, losses, draws, perfect_runs, tournament_wins, tournament_top8s, win_percent, num_competitions FROM person AS p LEFT JOIN ( SELECT d.person_id, COUNT(d.id) AS num_decks, SUM(wins) AS wins, SUM(losses) AS losses, SUM(draws) AS draws, SUM(CASE WHEN wins >= 5 AND losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs, SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins, SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s, IFNULL(ROUND((SUM(wins) / NULLIF(SUM(wins + losses), 0)) * 100, 1), '') AS win_percent, SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions FROM deck AS d LEFT JOIN deck_cache AS dc ON d.id = dc.deck_id
LEFT JOIN
(
SELECT
`start`.id,
`start`.code,
`start`.start_date AS start_date,
`end`.start_date AS end_date
FROM
season AS `start`
LEFT JOIN
season AS `end` ON `end`.id = `start`.id + 1
) AS season ON season.start_date <= d.created_date AND (season.end_date IS NULL OR season.end_date > d.created_date)
WHERE
season.id = 10
GROUP BY
d.person_id
) AS stats ON p.id = stats.person_id
WHERE
1 = 1
GROUP BY
p.id
ORDER BY
`num_decks` DESC, name
` with `[]` because of `(1021, 'Disk full (/tmp/#sql_4513_13.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")')`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 79, in people
view = People(ps.load_people(season_id=get_season_id()))
File "./decksite/data/person.py", line 138, in load_people
people = [Person(r) for r in db().select(sql)]
File "./shared/database.py", line 41, in select
[_, rows] = self.execute_anything(sql, args)
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: 84a6f67b421632eadfedc4205346e44844db5a99
Labels: decksite; DatabaseException
Failed to execute ` SELECT p.id, LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name, p.mtgo_username, p.tappedout_username, p.mtggoldfish_username, p.discord_id, p.elo, num_decks, wins, losses, draws, perfect_runs, tournament_wins, tournament_top8s, win_percent, num_competitions FROM person AS p LEFT JOIN ( SELECT d.person_id, COUNT(d.id) AS num_decks, SUM(wins) AS wins, SUM(losses) AS losses, SUM(draws) AS draws, SUM(CASE WHEN wins >= 5 AND losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs, SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins, SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s, IFNULL(ROUND((SUM(wins) / NULLIF(SUM(wins + losses), 0)) * 100, 1), '') AS win_percent, SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions FROM deck AS d LEFT JOIN deck_cache AS dc ON d.id = dc.deck_id
Reported on decksite by logged_out
DatabaseException Failed to execute ` SELECT p.id, LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name, p.mtgo_username, p.tappedout_username, p.mtggoldfish_username, p.discord_id, p.elo, num_decks, wins, losses, draws, perfect_runs, tournament_wins, tournament_top8s, win_percent, num_competitions FROM person AS p LEFT JOIN ( SELECT d.person_id, COUNT(d.id) AS num_decks, SUM(wins) AS wins, SUM(losses) AS losses, SUM(draws) AS draws, SUM(CASE WHEN wins >= 5 AND losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs, SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins, SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s, IFNULL(ROUND((SUM(wins) / NULLIF(SUM(wins + losses), 0)) * 100, 1), '') AS win_percent, SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions FROM deck AS d LEFT JOIN deck_cache AS dc ON d.id = dc.deck_id
Stack Trace:
Exception_hash: 84a6f67b421632eadfedc4205346e44844db5a99