cloudy cloudy

Author Topic: Forum unstable  (Read 934 times)

0 Members and 1 Guest are viewing this topic.

Offline administrator

  • Administrator
  • Posts: 10,882
  • Get answers to your questions - use Forum SEARCH!
  • Blackpool, UK
  • OS/Browser:
  • Android 9
  • Chrome 73.0.3683.47
    • Weather-Watch.com
Forum unstable
« on: February 25, 2019, 06:23:00 PM »
The database that the forum runs on keeps on stalling. I'm investigating but not being helped because there aren't any log entries associated with the problem.

I've tweaked some settings to see if that helps but need to wait a few hours to see if it's made a difference. Unfortunately bed time is approaching around the time the next stall is due and I have a very busy day planned for work tomorrow. Which is another way of saying that I'll try to keep the database running but I can't guarantee that at the moment.
Chris
Weather Forum Administrator

Offline administrator

  • Administrator
  • Posts: 10,882
  • Get answers to your questions - use Forum SEARCH!
  • Blackpool, UK
  • OS/Browser:
  • Win NT 10.0
  • Chrome 72.0.3626.109
    • Weather-Watch.com
Re: Forum unstable
« Reply #1 on: February 25, 2019, 08:26:58 PM »
There's been another stall  :(

I've tweaked some more database config variables to try to better tune things but it's a slow process to debug things. Hopefully things will be stable overnight. I'll try to check before I go to work but probably won't have time to do more tweaking, probably at best a restart of the server database process.
Chris
Weather Forum Administrator

Offline administrator

  • Administrator
  • Posts: 10,882
  • Get answers to your questions - use Forum SEARCH!
  • Blackpool, UK
  • OS/Browser:
  • Win NT 10.0
  • Chrome 72.0.3626.109
    • Weather-Watch.com
Re: Forum unstable
« Reply #2 on: February 25, 2019, 09:14:15 PM »
I think I may have fixed the problem. I found a table that wouldn't open properly and couldn't even be repaired initially. I hit it with a big hammer and it's now opening and allowing me to query it. The vital signs from the database process look a whole lot healthier now too which is a good sign.

I won't be sure if the problem is fixed until the database has run for a while, so I'm hoping it's still running in the morning. Ideally I'd like to see it survive >24  hours but I'll live with 10 hours uptime from now which takes me to breakfast time tomorrow morning ;-)

Fingers crossed!
Chris
Weather Forum Administrator

Offline administrator

  • Administrator
  • Posts: 10,882
  • Get answers to your questions - use Forum SEARCH!
  • Blackpool, UK
  • OS/Browser:
  • Win NT 10.0
  • Chrome 72.0.3626.109
    • Weather-Watch.com
Re: Forum unstable
« Reply #3 on: February 26, 2019, 07:19:02 AM »
The database survived overnight so I'm feeling more confident that it's fixed. It was hanging up every 2-4 hours yesterday so a 10 hour run seems good. The table that was causing problems is also opening quickly today so that's also a good sign  :D
Chris
Weather Forum Administrator

 

cumulus