InnoDB error repeatedly causing MariaDB v10.11.6 to fail to startup.

[dweston]

Describe the issue you are experiencing

After a recent HA Core update to v 2024.5.4 I found the 'recorder' function had failed. Reviewing the logs I discovered that the community add-on 'MariaDB' [currrent version 10.11.6] is failing with the following log errors:

2024-05-29 15:05:32 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-29 15:05:32 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2024-05-29 15:05:32 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.6.8. You must start up and shut down MariaDB 10.7 or earlier.
2024-05-29 15:05:32 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-05-29 15:05:32 0 [Note] InnoDB: Starting shutdown...
2024-05-29 15:05:32 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-05-29 15:05:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-29 15:05:32 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-05-29 15:05:32 0 [ERROR] Aborting
[15:05:32] INFO: Service mariadb exited with code 1 (by signal 0)```

I've resorted to rebooting HA from system level in order to force MariaDB to restart from scratch. The same errors persisted.

### What type of installation are you running?

Home Assistant OS

### Which operating system are you running on?

Home Assistant Operating System

### Which add-on are you reporting an issue with?

MariaDB

### What is the version of the add-on?

2.7.1

### Steps to reproduce the issue

1. On start-up HA reports the 'recorder' function isn't able to be initiated.
`Logger: homeassistant.setup
Source: setup.py:248
First occurred: 15:48:49 (4 occurrences)
Last logged: 15:49:10

    Unable to set up dependencies of 'logbook'. Setup failed for dependencies: ['recorder']
    Unable to set up dependencies of 'history'. Setup failed for dependencies: ['recorder']
    Unable to set up dependencies of 'energy'. Setup failed for dependencies: ['history', 'recorder']
    Unable to set up dependencies of 'default_config'. Setup failed for dependencies: ['energy', 'history', 'logbook']
`
2. As I have been using MariaDB as the primary HA db for a number of years (due to the early dependency of the 'Nginx Proxy Manager' community add-on on this db), as mentioned above, I checked the MariaDB log and this add-on is repetitively starting, fails to in doing so due toa problem with 'InnoDB', exits and st
3.
...


### System Health information

## System Information

version | core-2024.5.4
-- | --
installation_type | Home Assistant OS
dev | false
hassio | true
docker | true
user | root
virtualenv | false
python_version | 3.12.2
os_name | Linux
os_version | 6.6.28-haos-raspi
arch | aarch64
timezone | Australia/Sydney
config_dir | /config

<details><summary>Home Assistant Community Store</summary>

GitHub API | ok
-- | --
GitHub Content | ok
GitHub Web | ok
GitHub API Calls Remaining | 5000
Installed Version | 1.34.0
Stage | running
Available Repositories | 1394
Downloaded Repositories | 57

</details>

<details><summary>AccuWeather</summary>

can_reach_server | ok
-- | --
remaining_requests | 38

</details>

<details><summary>Home Assistant Cloud</summary>

logged_in | false
-- | --
can_reach_cert_server | ok
can_reach_cloud_auth | ok
can_reach_cloud | ok

</details>

<details><summary>Home Assistant Supervisor</summary>

host_os | Home Assistant OS 12.3
-- | --
update_channel | stable
supervisor_version | supervisor-2024.05.1
agent_version | 1.6.0
docker_version | 25.0.5
disk_total | 28.6 GB
disk_used | 23.1 GB
healthy | true
supported | true
board | rpi4-64
supervisor_api | ok
version_api | ok
installed_addons | Genie (3.0.0), Log Viewer (0.17.0), Mosquitto broker (6.4.0), Network UPS Tools (0.13.0), Node-RED (17.0.12), WireGuard (0.10.2), phpMyAdmin (0.9.1), motionEye (0.20.0), MariaDB (2.7.1), Samba Backup (5.2.0), RPC Shutdown (2.5), VLC (0.3.0), TasmoAdmin (0.30.2), Samba share (12.3.1), Nginx Proxy Manager (1.0.1), chrony (3.0.1), Uptime Kuma (0.12.0), Vaultwarden (Bitwarden) (0.21.2), File editor (5.8.0), UniFi Network Application (3.0.5), HAOS-SBFspot (2023.7.1), Advanced SSH & Web Terminal (17.3.0), AppDaemon (0.16.5), ESPHome (2024.5.2), openWakeWord (1.10.0), Whisper (2.0.0), Piper (1.5.0), Studio Code Server (5.15.0)

</details>

<details><summary>Dashboards</summary>

dashboards | 3
-- | --
resources | 24
views | 7
mode | storage

</details>

<details><summary>Miele</summary>

component_version | 2024.1.0
-- | --
reach_miele_cloud | ok

</details>

### Anything in the Supervisor logs that might be useful for us?

```txt
2024-05-29 18:23:44.865 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret mariadb_pw
2024-05-29 18:23:44.865 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret mqtt_user
2024-05-29 18:23:44.865 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret mqtt_pass
2024-05-29 18:23:44.866 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret pvoSID
2024-05-29 18:23:44.866 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret pvoAPIkey
2024-05-29 18:28:44.786 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret red_username
2024-05-29 18:28:44.786 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret red_password
2024-05-29 18:28:44.786 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret red_username
2024-05-29 18:28:44.787 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret red_password
2024-05-29 18:28:44.787 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret red_credential_secret
2024-05-29 18:28:44.806 WARNING (MainThread) [supervisor.addons.options] Unknown option 'host' for MariaDB (core_mariadb)
2024-05-29 18:28:44.806 WARNING (MainThread) [supervisor.addons.options] Unknown option 'host' for MariaDB (core_mariadb)
2024-05-29 18:28:44.806 WARNING (MainThread) [supervisor.addons.options] Unknown option 'host' for MariaDB (core_mariadb)
2024-05-29 18:28:44.806 WARNING (MainThread) [supervisor.addons.options] Unknown option 'grant' for MariaDB (core_mariadb)
2024-05-29 18:28:44.807 WARNING (MainThread) [supervisor.addons.options] Unknown option 'host' for MariaDB (core_mariadb)
2024-05-29 18:28:44.807 WARNING (MainThread) [supervisor.addons.options] Unknown option 'grant' for MariaDB (core_mariadb)

Anything in the add-on logs that might be useful for us?

[15:05:31] INFO: Starting MariaDB
2024-05-29 15:05:32 0 [Note] Starting MariaDB 10.11.6-MariaDB source revision fecd78b83785d5ae96f2c6ff340375be803cd299 as process 3955297
2024-05-29 15:05:32 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
2024-05-29 15:05:32 0 [Note] InnoDB: Number of transaction pools: 1
2024-05-29 15:05:32 0 [Note] InnoDB: Using ARMv8 crc32 instructions
2024-05-29 15:05:32 0 [Note] mysqld: O_TMPFILE is not supported on /var/tmp (disabling future attempts)
2024-05-29 15:05:32 0 [Note] InnoDB: Using Linux native AIO
2024-05-29 15:05:32 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-05-29 15:05:32 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-29 15:05:32 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2024-05-29 15:05:32 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.6.8. You must start up and shut down MariaDB 10.7 or earlier.
2024-05-29 15:05:32 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-05-29 15:05:32 0 [Note] InnoDB: Starting shutdown...
2024-05-29 15:05:32 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-05-29 15:05:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-29 15:05:32 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-05-29 15:05:32 0 [ERROR] Aborting
[15:05:32] INFO: Service mariadb exited with code 1 (by signal 0)

Additional information

No response

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.