General Server Error

  • Fusionftw
    8th Sep 2019 Member 0 Permalink

    I was getting HTTP 500 errors when trying to use the powder toy for the past hour.

    Was this just planned maintence on the host's part, or just an occasional error?

    8th Sep 2019 Member 0 Permalink

    @Fusionftw (View Post)

     I got the same error, so don't worry.  It usually means: A HTTP 500 Internal Server Error means your web server is experiencing problems, but it can't pinpoint the specific error or its root causes. When this happens, your website will serve up a general internal server error web page to your site's visitors.

    Edited once by NUCLEAR_FOX. Last: 8th Sep 2019
  • Lockheedmartin
    8th Sep 2019 Moderator 0 Permalink
    @Fusionftw (View Post)
    Apologies for the sudden issues earlier. There was an issue with the database side of things and it has been resolved.
  • jacob1
    11th Sep 2019 Developer 0 Permalink
    Just wanted to post another update on this, because it happened a 2nd time yesterday, and for much longer (8 hours instead of 5). I was able to add an in-game message the 2nd time the site went down, by editing the web server.

    We believe these two downtimes were both caused by a database table being locked by a bad query, this query used all the cpu usage and took a very long time to complete. While the database was locked up, the website stopped working entirely (since it couldn't access any data like the list of saves or whether or not you were logged in).

    In addition, we think this query was the cause of the persistent 502 / 504 errors that have been happening for the last year. Occasionally, the site would go down for around 5-15 minutes with those error code, before coming back up. Triggering the specific query was enough to reproduce the database lockup, so it was definitely that one.

    Simon found the bad query and it is fixed now, it won't happen again. The random 502 / 504 errors should go away, and the massively long downtimes will also not happen. We aren't sure why the short downtimes turned into extended downtimes, since the database usually recovers itself.

    Also, there is no need to worry about the database or saves being corrupted. I take backups about once a month, just in case :)
    Edited once by jacob1. Last: 11th Sep 2019