[mythtv-users] Unable to start mariadb after Debian system upgrade

[Paul Harrison]

On 22/01/2023 15:07, Mike Perkins wrote:

> On 22/01/2023 14:46, Jay Harbeston wrote:
>>>
>>> jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 
>>> [ERROR] InnoDB: Plugin initialization aborted with error Data 
>>> structure corruption
>>> jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] 
>>> InnoDB: Starting shutdown...
>>> jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 
>>> [ERROR] Plugin 'InnoDB' init function returned error.
>>> jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 
>>> [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
>>> jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] 
>>> Plugin 'FEEDBACK' is disabled.
>>> jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 
>>> [ERROR] Unknown/unsupported storage engine: InnoDB
>>> jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 
>>> [ERROR] Aborting
>>> jan 22 10:20:31 server systemd[1]: mariadb.service: Main process 
>>> exited, code=exited, status=1/FAILURE
>>> jan 22 10:20:31 server systemd[1]: mariadb.service: Failed with 
>>> result 'exit-code'.
>>> jan 22 10:20:31 server systemd[1]: Failed to start MariaDB 10.5.18 
>>> database server.
>>>
>>
>> The first line in the  above error is indicating that your database 
>> is messed up so that InnoDB cannot start. Looks like you need to fix 
>> the db first.
>>
> I think you missed the other erorr message:
>
> jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] 
> Unknown/unsupported storage engine: InnoDB
>
> If the db is Innodb and Innodb hasn't been installed, I could easily 
> see this error happening.
>

There is also this error

jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] 
Plugin 'InnoDB' init function returned error.


So it may be installed but failing to start?


One guess is maybe the on disk format has changed and Maria DB wants you 
to run an update to fix it? Although I would have expected something in 
the logs to say this is required though \0/


Paul H.