maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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@xxxxxxxxxxx