Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved Board Closed to Repair a Crashed Table
#1
Not Solved
Hey Guys,

I upgraded from mybb 1.6.11 to the latest version within a month ago. This past week my board has closed twice due to mybb automatically repairing a crashed table. The only resource I could find was a 2009 thread back when Labrocca was active (crazy, right?). He suggested the sessions table was a likely culprit (but again, from 2009) and he suggested changing the table to HEAP/MEMORY instead of MYISAM. Is this still good advice or should I avoid doing this with the current mybb version?

Some background. We jumped hosts and upgraded mybb version because the mybb_posts table would crash almost weekly, causing users to be unable to access the board and make posts, and required host intervention to fix. This time around the board closes automatically as per trying to repair the crashed table, who's name is not mentioned, but nothing seems to be wrong with the actual forum. I am able to view threads, make new posts, etc, so I simply open the forum again manually. 

Can someone help me understand how to best address this issue?
What is the best known method for determining which table has crashed and determining the root cause of the issue?  

bb url
http://subliminal-talk.com/ 

Thank you,
Cyanide
Reply
#2
Not Solved
The first thing you need to do is make sure your settings specify your forum url to include https instead of http. This is done in the Admin CP->Config->Site Details. Right now stylesheets and javascripts are not loading because of this. I suspect your forum has plenty of other features that are broken due to this. I used inspect element in Chrome and manually changed the css files to use https and the theme showed up properly so that is how I know that is a big issue.

Sessions table is fine to be memory because it is primarily useful for showing who is online. I would also suggest changing the rest of the tables to Innodb. It locks tables on a row level basis rather than the entire table so you would have less problems.
Reply
#3
Not Solved
(03-16-2019, 01:04 AM)dragonexpert Wrote: The first thing you need to do is make sure your settings specify your forum url to include https instead of http.  This is done in the Admin CP->Config->Site Details.  Right now stylesheets and javascripts are not loading because of this.  I suspect your forum has plenty of other features that are broken due to this.  I used inspect element in Chrome and manually changed the css files to use https and the theme showed up properly so that is how I know that is a big issue.

Sessions table is fine to be memory because it is primarily useful for showing who is online.  I would also suggest changing the rest of the tables to Innodb.  It locks tables on a row level basis rather than the entire table so you would have less problems.

Hey Dragonexpert, Thanks for your reply. My site settings are already using https in the board url so I'm not sure what is going on there.
I'll have to look into Innodb, I see you offee this as a service so If its too much for me I'll PM you.
Reply
#4
Not Solved
It is working fine today. Not sure why it wasn't yesterday.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)