Arch Linux

massinealaver

Member

Registered: 2020-09-27

Posts: 1

[Solved] MariaDB down : InnoDB: Upgrade after a crash is not supported

Here is a crash I experienced while upgrading MariaDB from 10.4 to 10.5

● mariadb.service - MariaDB 10.5.5 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
     Active: failed (Result: exit-code) since Sun 2020-09-27 14:57:13 CEST; 12min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
   Main PID: 194683 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"

sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.12.
sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [Note] InnoDB: Starting shutdown...
sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] Plugin 'InnoDB' init function returned error.
sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] Unknown/unsupported storage engine: InnoDB
sept. 27 14:57:13 massine-pc mariadbd[194683]: 2020-09-27 14:57:13 0 [ERROR] Aborting
sept. 27 14:57:13 massine-pc systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
sept. 27 14:57:13 massine-pc systemd[1]: mariadb.service: Failed with result 'exit-code'.
sept. 27 14:57:13 massine-pc systemd[1]: Failed to start MariaDB 10.5.5 database server.

This note says

Redo log was unnecessarily split into multiple files. Limited to 1 from MariaDB 10.5.

So in /var/lib/mysql/ I renamed ib_logfile0 and ib_logfile1 to ib_logfile0.old and ib_logfile1.old.
I restarted mariadb and upgraded my sql tables.

sudo systemctl restart mariadb

sudo mysql_upgrade

And it worked fine for me.
More info here.

WorMzy

Forum Moderator

From: Scotland

Registered: 2010-06-16

Posts: 11,846

Website

Re: [Solved] MariaDB down : InnoDB: Upgrade after a crash is not supported

Please dot post pre-solved topics. If this is a common enough problem to warrant documenting, then please document it on the wiki.

---

Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.

greenman

Member

Registered: 2022-10-14

Posts: 1

Re: [Solved] MariaDB down : InnoDB: Upgrade after a crash is not supported

Note that this is dangerous advice. See https://lists.launchpad.net/maria-discuss/msg06361.html