Here is a crash I experienced while upgrading MariaDB from 10.4 to 10.5
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
● 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. |
In previous versions 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.
|
1 |
sudo systemctl restart mariadb |
|
1 |
sudo mysql_upgrade |
And it worked fine for me.
