MariaDB Can't init tc log
I ended up deleting the tc.log file in /var/lib/mysql. When I started mysql again, it created a new tc.log and started up.
sudo rm -f /var/lib/mysql/tc.log
Woohoo, I found it! For now, at least. Digging through the source suggests that this might have something to do with mmap()
calls, and lo and behold - VirtualBox has a bug in that area. Fortunately that same source hints at a workaround - the log_bin option. Enable this (either from the command line as --log_bin
or from the config file as log_bin=ON
) and things start to work again!
Update
They're saying they've fixed it in VirtualBox 6.0.6!
You can remove the tc.log
in the data directory and remove old entries from mysql-bin.index (it is a text file, along with a list of binary logs). If this is a development box, you can remove the index file (mysql-bin.index) to force its recreation.
Also it could be related to the user ids between mysql
user and the shared folder id owner, here is a snippet to do so.