Re: Is Big Kev around???

Posted by BigKev On 2021/11/29 10:12:08
Sorry, I was away for the Holiday. There was some corruption in the Forum database and that triggered an automatic data restore back to last good backup point before the corruption occurred. So this is why some of the recent posts in that time frame disappeared.

Sadly, while this kind of occurrence is extremely rare, it does, and it's damned if you do, damned if you don't type scenario as far as recovery options.

The website backups everything near daily. But it cannot restore individual posts. It can only restore entire database tables.

When there are tables that have interdependencies/linked tables, it has to restore all of those as a set, or more corruption can occur. If it doesnt, then the problem can get worse with newer posts getting added and the indexing and table linkages all becoming askew.

Sorry for the disruption, sometimes these things happen, but everything should be fine now going forward as it's not a systemic issue.

Looking through the logs, it appears the server stack was rebooted (by the data center) shortly before the corruption was detected. So it's possible the forum database was in the middle of a reindexing operation when suddenly something went lights out. So we were a victim of bad timing.

This Post was from: https://packardinfo.com/xoops/html/modules/newbb/viewtopic.php?post_id=239077