Hi, Jogchum, On Oct 12, Jogchum Reitsma wrote:
Hi,
I am on OpenSuse Tumbleweed, rolling distro.
Since some snapshots of Tumbleweed my mariadb does not start at system start. I don't use the mariadb databases a lot, so I didn't notice it immediately. Hence I'm unsure when the problem occurred first time.
When trying to start it manually, I got the message
[ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.5.8.
normally the correct fix for that would be to install 10.5.8, start the server, shut it down, then upgrade.
Searching that message, I saw a post on https://bbs.archlinux.org/viewtopic.php?id=259364
Like me, he had a non-default location for the databases configured in /etc/my.cnf.
The solution that worked for him was to change that to another location in my.cnf, starting the database (which now succeeded), and copy the existing databases to that new location.
That's not how I read it at all. It seems to be about innodb_log_files_in_group option. Are you sure the url is correct?
2022-10-02 21:27:17 0 [Warning] Can't create test file /home/jogchum/mysql_recover/linux-mkay.lower-test ... 2022-10-02 21:27:17 0 [ERROR] Aborting
Anyone an idea why /home/jogchum/mysql_recover/linux-mkay.lower-test can't be created and how to solve that?
permission problem, perhaps? it's not particularly important, as it's only a warning, and not a reason for the server failing to start. Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org