search

PennyDreadfulMTG / perf-reports

2 stars 7 forks source link

500 error at /report/ #42343

Closed vorpal-buildbot closed 5 years ago

vorpal-buildbot commented 5 years ago

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 ['30204', '30204'] because of (1021, 'Disk full (/tmp/#sql_5dd_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")')

Reported on decksite by logged_out

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /report/?
            Cookies: {}
            Endpoint: add_report
            View Args: {}
            Person: logged_out
            Referrer: None
            Request Data: {'entry': '30204', 'opponent': '30206', 'result': '2–1', 'draws': '0', 'matchID': '212526676'}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: XX
X-Forwarded-For: 35.205.164.196, 172.69.226.37
Cf-Ray: 483a0a1a583da851-CDG
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Content-Type: application/x-www-form-urlencoded
Cf-Connecting-Ip: 35.205.164.196
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 114

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, round with ['30204', '30204'] because of (1021, 'Disk full (/tmp/#sql_5dd_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 332, in add_report
    if form.validate() and lg.report(form):
  File "./decksite/league.py", line 227, in report
    for m in match.get_matches(form):
  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: 0d28771504396abea75a7f043d22e163c96f6899

vorpal-buildbot commented 5 years ago

500 error at /report/

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 ['30204', '30204'] because of (1021, 'Disk full (/tmp/#sql_5dd_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")')

Reported on decksite by carmandor

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /report/?
            Cookies: {'__cfduid': 'dd5318220e6b5f452673ca9c96230918c1539425740', '_ga': 'GA1.2.2064621318.1539425807', '_gid': 'GA1.2.1132578404.1543266798', 'deck_id': '30204', 'session': '.eJx9kc1uwjAQhN9lz1GVQIgJNyjqn1CoqCglVRWZ2HEMsZ3aTihFvHsdJMqhUo8zu57d_XyErKZaYEmlhZHVDfUAE8EljApcGacIFVwoctXc5EqTjDsLwjgKg94wiBBCcT-KfQQe_FORGWt4RS6TKsUYJd0GRslzYg_1Yw-EZSprDNUSC-rCctytSJR2GQo3tuxlxmLblfbT20n-zUxKdmnStuPkKZCpasV-PFXN7Npv1Y66o46A85wac9FQr6td85hs6-WqLPPP9dZU8xf8vEj9ZEAL955-1VxTk2HHJxiEPorQEKEbd5WP4vBa75BFfjj0fQ80LZxV_g5JDju7YjPxsDCT1_TtfjNnm7bkdnPXX0YrN8Qhrd01746d-wheHJx3JmXgw4NzTGYPXQtMKNZUw8mDP9gs1oy6NWVTVacfRDqbLw.DudXGQ.PQq71yD7MpOnOD8_QjH7mn8LZ3I'}
            Endpoint: add_report
            View Args: {}
            Person: 496412816777936907
            Referrer: https://pennydreadfulmagic.com/report/
            Request Data: {'entry': '30204', 'opponent': '30206', 'result': '2–1', 'draws': '0'}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: IT
X-Forwarded-For: 93.36.184.227, 188.114.103.55
Cf-Ray: 483a0ad33ac43dcb-MXP
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Cache-Control: max-age=0
Origin: https://pennydreadfulmagic.com
Upgrade-Insecure-Requests: 1
Content-Type: application/x-www-form-urlencoded
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.110 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/report/
Accept-Language: it-IT,it;q=0.9,en-US;q=0.8,en;q=0.7
Cookie: __cfduid=dd5318220e6b5f452673ca9c96230918c1539425740; _ga=GA1.2.2064621318.1539425807; _gid=GA1.2.1132578404.1543266798; deck_id=30204; session=.eJx9kc1uwjAQhN9lz1GVQIgJNyjqn1CoqCglVRWZ2HEMsZ3aTihFvHsdJMqhUo8zu57d_XyErKZaYEmlhZHVDfUAE8EljApcGacIFVwoctXc5EqTjDsLwjgKg94wiBBCcT-KfQQe_FORGWt4RS6TKsUYJd0GRslzYg_1Yw-EZSprDNUSC-rCctytSJR2GQo3tuxlxmLblfbT20n-zUxKdmnStuPkKZCpasV-PFXN7Npv1Y66o46A85wac9FQr6td85hs6-WqLPPP9dZU8xf8vEj9ZEAL955-1VxTk2HHJxiEPorQEKEbd5WP4vBa75BFfjj0fQ80LZxV_g5JDju7YjPxsDCT1_TtfjNnm7bkdnPXX0YrN8Qhrd01746d-wheHJx3JmXgw4NzTGYPXQtMKNZUw8mDP9gs1oy6NWVTVacfRDqbLw.DudXGQ.PQq71yD7MpOnOD8_QjH7mn8LZ3I
Cf-Connecting-Ip: 93.36.184.227
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 53

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, round with ['30204', '30204'] because of (1021, 'Disk full (/tmp/#sql_5dd_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 332, in add_report
    if form.validate() and lg.report(form):
  File "./decksite/league.py", line 227, in report
    for m in match.get_matches(form):
  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: 0d28771504396abea75a7f043d22e163c96f6899

Labels: decksite; DatabaseException