You are not logged in.

#1 2020-09-27 13:49:59

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.

Offline

#2 2020-09-27 14:39:48

WorMzy
Forum Moderator
From: Scotland
Registered: 2010-06-16
Posts: 10,020
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 X299 TOMAHAWK ARCTIC // Processor: Intel Core i7-7820X 3.6GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 5x 1TB HDD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.

Offline

Board footer

Powered by FluxBB