maria-discuss team mailing list archive

[Daniel Black <daniel@xxxxxxxxxxx>]

> The log from this failure (/var/log/mysqld.log):
>
> 2022-11-10 20:22:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
> 2022-11-10 20:22:34 0 [Note] InnoDB: Number of transaction pools: 1
> 2022-11-10 20:22:34 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
> 2022-11-10 20:22:34 0 [Note] InnoDB: Using Linux native AIO
> 2022-11-10 20:22:34 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
> 2022-11-10 20:22:34 0 [Note] InnoDB: Completed initialization of buffer pool
> 2022-11-10 20:22:34 0 [ERROR] InnoDB: File ./ib_logfile0 was not found
> 2022-11-10 20:22:34 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
> 2022-11-10 20:22:34 0 [Note] InnoDB: Starting shutdown...
> 2022-11-10 20:22:35 0 [ERROR] Plugin 'InnoDB' init function returned error.
> 2022-11-10 20:22:35 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
> 2022-11-10 20:22:35 0 [Note] Plugin 'FEEDBACK' is disabled.
> 2022-11-10 20:22:35 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
> 2022-11-10 20:22:35 0 [ERROR] Unknown/unsupported storage engine: InnoDB
> 2022-11-10 20:22:35 0 [ERROR] Aborting
>
> ##############################################################################################################################
>
> No idea how to solve this, again...

Read Marko's email again.

10.8+ won't start without a ib_logfile0. This is what not starting looks like.

Start it with at 10.7 version which will recreate ib_logfile0, and if
you're lucky, you maybe won't have corrupted data because of this.
Then try 10.8+.

I just corrected https://wiki.archlinux.org/title/MariaDB.

If you see other sites saying delete ib_logfile0, please share your
experience with them