After installing from ISO I was able to reproduce the issue. I'm not sure why I wasn't able to reproduce it in an LXC container and I still don't understand why/how it happens. But as you've reported, for some reason the MariaDB database becomes corrupted on reboot.
Thank you all for your persistence and patience. I will be re-releasing a new fixed Redmine appliance ASAP.
In the meantime, I have developed a script that will "fix" it (destroy all corrupted data and recreate it from scratch). Please be aware that it is destructive and will wipe all databases - irretrievably destroying all data and reconfiguring MariaDB as if it were a clean install. It does not affect the filesystem (beyond the MariaDB data files).
It will ask you to update the Redmine 'admin" password and email, as well as a password for the (new) 'mariadb_admin' "root like" MariaDB user- for use in Webmin. It reloads the default Redmine data and databases, but does not include the "helloworld" example data repos/projects that normally come by default.
I have tested it, but not extensively. I have logged into Redmine as well as Webmin. I've played around in both and rebooted my test server multiple times and it appears to be all good.
Ok I've reproduced it and a developed a dirty script to "fix" it
After installing from ISO I was able to reproduce the issue. I'm not sure why I wasn't able to reproduce it in an LXC container and I still don't understand why/how it happens. But as you've reported, for some reason the MariaDB database becomes corrupted on reboot.
Thank you all for your persistence and patience. I will be re-releasing a new fixed Redmine appliance ASAP.
In the meantime, I have developed a script that will "fix" it (destroy all corrupted data and recreate it from scratch). Please be aware that it is destructive and will wipe all databases - irretrievably destroying all data and reconfiguring MariaDB as if it were a clean install. It does not affect the filesystem (beyond the MariaDB data files).
It will ask you to update the Redmine 'admin" password and email, as well as a password for the (new) 'mariadb_admin' "root like" MariaDB user- for use in Webmin. It reloads the default Redmine data and databases, but does not include the "helloworld" example data repos/projects that normally come by default.
I have tested it, but not extensively. I have logged into Redmine as well as Webmin. I've played around in both and rebooted my test server multiple times and it appears to be all good.
Please do share any feedback you have.
To download and run the script:
PS Bug opened on the issue tracker.