vorpal-buildbot
commented
5 years ago 500 error at /tournaments/leaderboards/
Failed to execute ` SELECT p.id AS person_id, LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person, cs.name AS competition_series_name, sp.name AS sponsor_name, COUNT(DISTINCT d.id) AS tournaments, SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS wins, COUNT(DISTINCT d.id) + SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS points FROM competition AS c INNER JOIN competition_series AS cs ON cs.id = c.competition_series_id LEFT JOIN sponsor AS sp ON sp.id = cs.sponsor_id INNER JOIN competition_type AS ct ON ct.id = cs.competition_type_id INNER JOIN deck AS d ON d.competition_id = c.id INNER JOIN person AS p ON d.person_id = p.id LEFT JOIN deck_match AS dm ON dm.deck_id = d.id LEFT JOIN deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> d.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
(ct.name = 'Gatherling') AND (season.id = 10)
GROUP BY
cs.id,
p.id
ORDER BY
cs.id,
points DESC,
wins DESC,
tournaments DESC,
person
` with `[]` because of `(1021, 'Disk full (/tmp/#sql_4513_5.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: /tournaments/leaderboards/?
Cookies: {'__cfduid': 'd38982ba57dee625ca760791b3fe4e2751546366633'}
Endpoint: tournament_leaderboards
View Args: {}
Person: logged_out
Referrer: https://pennydreadfulmagic.com/decks/
Request Data: {}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: PL
X-Forwarded-For: 79.184.88.26, 198.41.242.48
Cf-Ray: 4970ce124941c4c9-DUS
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Upgrade-Insecure-Requests: 1
Dnt: 1
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
Referer: https://pennydreadfulmagic.com/decks/
Accept-Language: pl-PL,pl;q=0.9,en-US;q=0.8,en;q=0.7,de;q=0.6
Cookie: __cfduid=d38982ba57dee625ca760791b3fe4e2751546366633
Cf-Connecting-Ip: 79.184.88.26
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-AliveDatabaseException Failed to execute ` SELECT p.id AS person_id, LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person, cs.name AS competition_series_name, sp.name AS sponsor_name, COUNT(DISTINCT d.id) AS tournaments, SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS wins, COUNT(DISTINCT d.id) + SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS points FROM competition AS c INNER JOIN competition_series AS cs ON cs.id = c.competition_series_id LEFT JOIN sponsor AS sp ON sp.id = cs.sponsor_id INNER JOIN competition_type AS ct ON ct.id = cs.competition_type_id INNER JOIN deck AS d ON d.competition_id = c.id INNER JOIN person AS p ON d.person_id = p.id LEFT JOIN deck_match AS dm ON dm.deck_id = d.id LEFT JOIN deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> d.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
(ct.name = 'Gatherling') AND (season.id = 10)
GROUP BY
cs.id,
p.id
ORDER BY
cs.id,
points DESC,
wins DESC,
tournaments DESC,
person
` with `[]` because of `(1021, 'Disk full (/tmp/#sql_4513_5.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 171, in tournament_leaderboards
leaderboards = comp.leaderboards(season_id=get_season_id())
File "./decksite/data/competition.py", line 165, in leaderboards
for row 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: f6aede4fa02014b2651531ffe9c8438c05208a1e
Labels: decksite; DatabaseException
Failed to execute ` SELECT p.id AS person_id, LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person, cs.name AS competition_series_name, sp.name AS sponsor_name, COUNT(DISTINCT d.id) AS tournaments, SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS wins, COUNT(DISTINCT d.id) + SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS points FROM competition AS c INNER JOIN competition_series AS cs ON cs.id = c.competition_series_id LEFT JOIN sponsor AS sp ON sp.id = cs.sponsor_id INNER JOIN competition_type AS ct ON ct.id = cs.competition_type_id INNER JOIN deck AS d ON d.competition_id = c.id INNER JOIN person AS p ON d.person_id = p.id LEFT JOIN deck_match AS dm ON dm.deck_id = d.id LEFT JOIN deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> d.id
Reported on decksite by logged_out
DatabaseException Failed to execute ` SELECT p.id AS person_id, LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person, cs.name AS competition_series_name, sp.name AS sponsor_name, COUNT(DISTINCT d.id) AS tournaments, SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS wins, COUNT(DISTINCT d.id) + SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS points FROM competition AS c INNER JOIN competition_series AS cs ON cs.id = c.competition_series_id LEFT JOIN sponsor AS sp ON sp.id = cs.sponsor_id INNER JOIN competition_type AS ct ON ct.id = cs.competition_type_id INNER JOIN deck AS d ON d.competition_id = c.id INNER JOIN person AS p ON d.person_id = p.id LEFT JOIN deck_match AS dm ON dm.deck_id = d.id LEFT JOIN deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> d.id
Stack Trace:
Exception_hash: f6aede4fa02014b2651531ffe9c8438c05208a1e