Author Topic: Failed site update and DB failure 1/18-1/19/20  (Read 9152 times)

0 Members and 1 Guest are viewing this topic.

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2856
  • Last Login:Yesterday at 10:17:44 pm
Failed site update and DB failure 1/18-1/19/20
« on: January 19, 2020, 07:13:07 am »
TM's mysql database got into an unusable state overnight on 1/18, fixed at 7 AM EST on 1/19.  I launched the site update, but did not notice that the "User Sleep" mysql processes were stacking up, which seems to be the cause of this kind of thing.  Left in that state with a hanging site update and TM and SMF queries coming in, the DB got into a bad state that required a hard restart of the process.  The forum's back, the site is back, and last night's site update is being rerun right now.