So in the end i found a solution to get around this error:
First make a backup of the database:
(it’s not necessary, but you never know )
mysqldump -p --single-transaction --routines kopano > <somewhere>/backup/kopano/mysql/kopano.sql
drop the database “kopano”:
mysql -u root -p
drop database kopano;
quit
If some error is shown like “ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./kopano’, errno: 39 “Directory not empty”)” you have to delete some files:
rm /var/lib/mysql/kopano/*
Now stop mariadb and remove ibdata1 and ib_logfiles
systemctl stop mariadb
mv /var/lib/mysql/ib_logfile* <somewhere>/backup/kopano/mysql/
mv /var/lib/mysql/ibdata1 <somewhere>/backup/kopano/mysql/
systemctl start mariadb
Create a new empty database “kopano”:
mysql -u root -p
create database kopano;
quit
Restore a backup of the database:
(this can take a long time)
mysql -u root -p kopano < <somewhere>/backup/kopano/mysql/kopano.sql
After the import the Kopano server was restarted correctly. Access is now possible again.
I give it a try to use a backup (mysqldump) that i made after the crash. It works also. So in my opinion the error lived in those (log)files of mariadb. Anyway: I’m glad to be back again. :-)
Never the less:
Be always sure to have a valid Backup!!
This sites where useful:
1.: Big Problem, Kopano server could not connect to MariaDB-Server
2.: Backup and restore mysql (innodb)
Excuse me for my funny English!
Regards
Enno
