Hi,
Unfortunatly my home assistant host (a windows10 pc with VMbox) restarted or crashed yesterday. Not sure what happened, but I was able to start the virtual machine with Home Assistant. Now I run into the issue that MariaDB has an error on startup. Below the Log after startup and my configuration.
[s6-init] making user provided files available at /var/run/s6/etc...exited 0.
[s6-init] ensuring user provided files have correct perms...exited 0.
[fix-attrs.d] applying ownership & permissions fixes...
[fix-attrs.d] done.
[cont-init.d] executing container initialization scripts...
[cont-init.d] done.
[services.d] starting services
[services.d] done.
[10:24:58] INFO: Using existing mariadb initial system
[10:24:58] INFO: Starting MariaDB
220415 10:24:58 mysqld_safe Logging to '/data/databases/mariadb.err'.
220415 10:24:58 mysqld_safe Starting mysqld daemon with databases from /data/databases
220415 10:24:58 mysqld_safe Starting mysqld daemon with databases from /data/databases
2022-04-15 10:24:58 0 [Note] /usr/bin/mysqld (mysqld 10.4.19-MariaDB) starting as process 397 ...
2022-04-15 10:24:58 0 [Note] InnoDB: Using Linux native AIO
2022-04-15 10:24:58 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-04-15 10:24:58 0 [Note] InnoDB: Uses event mutexes
2022-04-15 10:24:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-15 10:24:58 0 [Note] InnoDB: Number of pools: 1
2022-04-15 10:24:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-04-15 10:24:58 0 [Note] mysqld: O_TMPFILE is not supported on /var/tmp (disabling future attempts)
2022-04-15 10:24:59 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-04-15 10:24:59 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-15 10:24:59 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-04-15 10:24:59 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 1090695858 between the checkpoint 1090695858 and the end 1090695680.
2022-04-15 10:24:59 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-04-15 10:24:59 0 [Note] InnoDB: Starting shutdown...
2022-04-15 10:25:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-04-15 10:25:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-04-15 10:25:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-15 10:25:00 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-04-15 10:25:00 0 [ERROR] Aborting
220415 10:25:00 mysqld_safe mysqld from pid file /data/databases/core-mariadb.pid ended```
Configuration:
databases:
- homeassistant
logins:
- password: *****
username: homeassistant
rights:
- database: homeassistant
username: homeassistant
I did find some other topics with this issue, but none of the suggestions worked for me. Any idea how I can solve this?