vorpal-buildbot
commented
5 years ago 500 error at /decks/6391/
Failed to execute SELECT m.date, m.id, m.round, m.elimination, dm1.games AS game_wins, dm2.deck_id AS opponent_deck_id, IFNULL(dm2.games, 0) AS game_losses, d2.name AS opponent_deck_name, LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS opponent FROMmatchAS m INNER JOIN deck_match AS dm1 ON m.id = dm1.match_id AND dm1.deck_id = %s LEFT JOIN deck_match AS dm2 ON m.id = dm2.match_id AND dm2.deck_id <> %s INNER JOIN deck AS d1 ON dm1.deck_id = d1.id LEFT JOIN deck AS d2 ON dm2.deck_id = d2.id LEFT JOIN person AS p ON p.id = d2.person_id ORDER BY m.date, round with [6391, 6391] because of (1021, 'Disk full (/tmp/#sql_5dd_0.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: /decks/6391/?
Cookies: {}
Endpoint: deck
View Args: {'deck_id': 6391}
Person: logged_out
Referrer: None
Request Data: {}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 40.77.167.124, 162.158.79.229
Cf-Ray: 481282a6fba5569f-IAD
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Cache-Control: no-cache
Pragma: no-cache
Accept: */*
From: bingbot(at)microsoft.com
User-Agent: Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)
Cf-Connecting-Ip: 40.77.167.124
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-AliveDatabaseException
Failed to execute SELECT m.date, m.id, m.round, m.elimination, dm1.games AS game_wins, dm2.deck_id AS opponent_deck_id, IFNULL(dm2.games, 0) AS game_losses, d2.name AS opponent_deck_name, LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS opponent FROMmatchAS m INNER JOIN deck_match AS dm1 ON m.id = dm1.match_id AND dm1.deck_id = %s LEFT JOIN deck_match AS dm2 ON m.id = dm2.match_id AND dm2.deck_id <> %s INNER JOIN deck AS d1 ON dm1.deck_id = d1.id LEFT JOIN deck AS d2 ON dm2.deck_id = d2.id LEFT JOIN person AS p ON p.id = d2.person_id ORDER BY m.date, round with [6391, 6391] because of (1021, 'Disk full (/tmp/#sql_5dd_0.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/auth.py", line 62, in decorated_function
return f(*args, **kwargs)
File "./decksite/main.py", line 56, in deck
view = Deck(d, auth.person_id(), auth.discord_id())
File "./decksite/views/deck.py", line 29, in __init__
self.matches = match.get_matches(d, True)
File "./decksite/data/match.py", line 58, in get_matches
matches = [Container(m) for m in db().select(sql, [d.id, d.id])]
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: bc6fb47711221cb7ec4ced4bf9a21e6f8d446c82
Labels: Search Engine; decksite; DatabaseException
Failed to execute
SELECT m.date, m.id, m.round, m.elimination, dm1.games AS game_wins, dm2.deck_id AS opponent_deck_id, IFNULL(dm2.games, 0) AS game_losses, d2.name AS opponent_deck_name, LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS opponent FROMmatchAS m INNER JOIN deck_match AS dm1 ON m.id = dm1.match_id AND dm1.deck_id = %s LEFT JOIN deck_match AS dm2 ON m.id = dm2.match_id AND dm2.deck_id <> %s INNER JOIN deck AS d1 ON dm1.deck_id = d1.id LEFT JOIN deck AS d2 ON dm2.deck_id = d2.id LEFT JOIN person AS p ON p.id = d2.person_id ORDER BY m.date, roundwith[29232, 29232]because of(14, 'Can\'t change size of file (Errcode: 28 "No space left on device")')Reported on decksite by logged_out
DatabaseException Failed to execute
SELECT m.date, m.id, m.round, m.elimination, dm1.games AS game_wins, dm2.deck_id AS opponent_deck_id, IFNULL(dm2.games, 0) AS game_losses, d2.name AS opponent_deck_name, LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS opponent FROMmatchAS m INNER JOIN deck_match AS dm1 ON m.id = dm1.match_id AND dm1.deck_id = %s LEFT JOIN deck_match AS dm2 ON m.id = dm2.match_id AND dm2.deck_id <> %s INNER JOIN deck AS d1 ON dm1.deck_id = d1.id LEFT JOIN deck AS d2 ON dm2.deck_id = d2.id LEFT JOIN person AS p ON p.id = d2.person_id ORDER BY m.date, roundwith[29232, 29232]because of(14, 'Can\'t change size of file (Errcode: 28 "No space left on device")')Stack Trace:Exception_hash: bc6fb47711221cb7ec4ced4bf9a21e6f8d446c82