vorpal-buildbot
commented
5 years ago 500 error at /achievements/
Failed to execute SELECT LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person, SUM(tournament_entries) AS points, p.id AS person_id FROM person AS p JOIN _achievements ON p.id = _achievements.person_id WHERE season_id = 10 GROUP BY p.id HAVING points >= ( -- Work out the minimum score to make top N, counting ties SELECT MIN(s) FROM ( SELECT SUM(tournament_entries) AS s FROM _achievements WHERE season_id = 10 GROUP BY person_id HAVING s > 0 ORDER BY s DESC LIMIT 5 ) AS _ ) ORDER BY points DESC, name LIMIT 12 with [] because of (1021, 'Disk full (/tmp/#sql_4513_4.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: /achievements/?locale=es
Cookies: {}
Endpoint: achievements
View Args: {}
Person: logged_out
Referrer: None
Request Data: {}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: FR
X-Forwarded-For: 54.36.148.171, 172.69.55.30
Cf-Ray: 496fc0adeb37c861-AMS
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
User-Agent: Mozilla/5.0 (compatible; AhrefsBot/6.1; +http://ahrefs.com/robot/)
Accept: */*
Cf-Connecting-Ip: 54.36.148.171
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-AliveDatabaseException
Failed to execute SELECT LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person, SUM(tournament_entries) AS points, p.id AS person_id FROM person AS p JOIN _achievements ON p.id = _achievements.person_id WHERE season_id = 10 GROUP BY p.id HAVING points >= ( -- Work out the minimum score to make top N, counting ties SELECT MIN(s) FROM ( SELECT SUM(tournament_entries) AS s FROM _achievements WHERE season_id = 10 GROUP BY person_id HAVING s > 0 ORDER BY s DESC LIMIT 5 ) AS _ ) ORDER BY points DESC, name LIMIT 12 with [] because of (1021, 'Disk full (/tmp/#sql_4513_4.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/main.py", line 99, in achievements
view = Achievements(achs.load_achievements(p, season_id=get_season_id()))
File "./decksite/data/achievements.py", line 27, in load_achievements
desc.leaderboard = a.leaderboard(season_id=season_id)
File "./decksite/data/achievements.py", line 191, in leaderboard
leaderboard = [Container(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: 27183417133d63ddd742fd02d911e26fa2d31811
Labels: decksite; DatabaseException
Failed to execute
SELECT LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person, SUM(tournament_entries) AS points, p.id AS person_id FROM person AS p JOIN _achievements ON p.id = _achievements.person_id WHERE season_id = 10 GROUP BY p.id HAVING points >= ( -- Work out the minimum score to make top N, counting ties SELECT MIN(s) FROM ( SELECT SUM(tournament_entries) AS s FROM _achievements WHERE season_id = 10 GROUP BY person_id HAVING s > 0 ORDER BY s DESC LIMIT 5 ) AS _ ) ORDER BY points DESC, name LIMIT 12with[]because of(1021, 'Disk full (/tmp/#sql_4513_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")')Reported on decksite by logged_out
DatabaseException Failed to execute
SELECT LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person, SUM(tournament_entries) AS points, p.id AS person_id FROM person AS p JOIN _achievements ON p.id = _achievements.person_id WHERE season_id = 10 GROUP BY p.id HAVING points >= ( -- Work out the minimum score to make top N, counting ties SELECT MIN(s) FROM ( SELECT SUM(tournament_entries) AS s FROM _achievements WHERE season_id = 10 GROUP BY person_id HAVING s > 0 ORDER BY s DESC LIMIT 5 ) AS _ ) ORDER BY points DESC, name LIMIT 12with[]because of(1021, 'Disk full (/tmp/#sql_4513_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")')Stack Trace:Exception_hash: 27183417133d63ddd742fd02d911e26fa2d31811