mirror of
https://github.com/BookStackApp/BookStack.git
synced 2026-02-23 19:07:16 +03:00
Tables corrupted after MySQL crash ... #5542
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @DoctorRetromaker on GitHub (Dec 10, 2025).
Attempted Debugging
Searched GitHub Issues
Describe the Scenario
After a MySQL crash, tables
permission_roleandrole_permissionsgot corrupted ... I tried to detach and re-attach the tablespace -some times, this correct the error if the problem is in the catalogues area-.Not the case, both tables are corrupted for MySQL. Dropped and recreated let BookStack restart again, but not in a correct way;
maintenancebutton doesn't appear, and accesing shelves or books areas end with aan unknown error occurred.Any help on restoring correct values for those tables?
Exact BookStack Version
last? .. no way to access to Settings ....
Log Content
Hosting Environment
Synology NAS DSM 7.3
BookStack Linuxserver.io Docker
MySQL CE 9.0.5-1
@DoctorRetromaker commented on GitHub (Dec 11, 2025):
Just found a full MySQL dump and recovered both tables; just deleted the corrupted and loaded the old ones.
App is running correctly again.
@ssddanbrown commented on GitHub (Dec 15, 2025):
Glad that you were able to recover those tables!
Rare to see MySQL curruption scenarios although docker-based environments do seem more susceptible to them.