Forums are back online
Posted: Fri Dec 18, 2015 11:22 pm
What happened?
One of the neighborhood transformers blew up, and we had a 20 second power outage, which caused the servers to reboot, everything made it through okay, except for the forums.
The blog was fine as it uses MYISAM tables (Which can be repaired), except for the MyRatings module. The PHPBB forums on the other hand use InnoDB tables, which can not be repaired. To make matters worse, if mariadb detects table corruption on startup, it causes the entire database application to crash.
I was able to bring mariaDB up in recovery mode, which allowed the blog to function, however the forum and MyRating plugin would only operate in a read only mode.
After several hours of troubleshooting it was determined that it would be quicker to backup the blog database, and completely reinstall MariaDB, restore the blog and start the forums fresh.
I have now completed that task, and will be working on creating a script that will backup the forum software and database on a nightly basis.
Welcome back to the Forums!
Brent P Hendricks
Brent's World blog and forum administrator.
One of the neighborhood transformers blew up, and we had a 20 second power outage, which caused the servers to reboot, everything made it through okay, except for the forums.
The blog was fine as it uses MYISAM tables (Which can be repaired), except for the MyRatings module. The PHPBB forums on the other hand use InnoDB tables, which can not be repaired. To make matters worse, if mariadb detects table corruption on startup, it causes the entire database application to crash.
I was able to bring mariaDB up in recovery mode, which allowed the blog to function, however the forum and MyRating plugin would only operate in a read only mode.
After several hours of troubleshooting it was determined that it would be quicker to backup the blog database, and completely reinstall MariaDB, restore the blog and start the forums fresh.
I have now completed that task, and will be working on creating a script that will backup the forum software and database on a nightly basis.
Welcome back to the Forums!
Brent P Hendricks
Brent's World blog and forum administrator.