MariaDB因InnoDB故障无法备份且重启失败求助

数据库版本：mysql Ver 15.1 Distrib 10.3.34-MariaDB

初始备份错误 #

执行备份时触发如下错误：

mysqldump: Couldn't execute 'show create table `transaction_registry`': Table 'mysql.transaction_registry' doesn't exist in engine (1932)

当前核心问题 #

已知该表缺失为常见问题，尝试删除并重建transaction_registry表后，MariaDB无法正常重启。

已尝试的操作 #

• 新建MySQL实例，将transaction_registry表复制到目标数据库，无效
• 删除ib_logfile*日志文件

错误日志信息（/var/log/mysql/mariadb.err） #

2022-10-28 10:06:45 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-10-28 10:06:45 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-10-28 10:06:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-28 10:06:45 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-10-28 10:06:45 0 [ERROR] Aborting

2022-10-28 10:13:17 0 [Note] Initializing built-in plugins
2022-10-28 10:13:17 0 [Note] Initializing plugins specified on the command line
2022-10-28 10:13:17 0 [Note] Initializing installed plugins
2022-10-28 10:13:17 0 [Warning] option 'innodb-buffer-pool-size': unsigned value 4 adjusted to 2097152
2022-10-28 10:13:17 0 [ERROR] InnoDB: innodb_page_size=16384 requires innodb_buffer_pool_size >= 5MiB current 2MiB
2022-10-28 10:13:17 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-10-28 10:13:17 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-10-28 10:13:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-28 10:13:17 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-10-28 10:13:17 0 [ERROR] Aborting

2022-10-28 10:13:44 0 [Note] Initializing built-in plugins
2022-10-28 10:13:44 0 [Note] Initializing plugins specified on the command line
2022-10-28 10:13:44 0 [Note] Initializing installed plugins
2022-10-28 10:13:44 0 [Warning] option 'innodb-buffer-pool-size': unsigned value 4 adjusted to 2097152
2022-10-28 10:13:44 0 [ERROR] InnoDB: innodb_page_size=16384 requires innodb_buffer_pool_size >= 5MiB current 2MiB
2022-10-28 10:13:44 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-10-28 10:13:44 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-10-28 10:13:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-28 10:13:44 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-10-28 10:13:44 0 [ERROR] Aborting

2022-10-28 10:16:00 0 [Note] Initializing built-in plugins
2022-10-28 10:16:00 0 [Note] Initializing plugins specified on the command line
2022-10-28 10:16:00 0 [Note] Initializing installed plugins
2022-10-28 10:16:00 0 [Warning] option 'innodb-buffer-pool-size': unsigned value 5 adjusted to 2097152
2022-10-28 10:16:00 0 [ERROR] InnoDB: innodb_page_size=16384 requires innodb_buffer_pool_size >= 5MiB current 2MiB
2022-10-28 10:16:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-10-28 10:16:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-10-28 10:16:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-28 10:16:00 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-10-28 10:16:00 0 [ERROR] Aborting

2022-10-28 11:24:32 0 [Note] Initializing built-in plugins
2022-10-28 11:24:32 0 [Note] Initializing plugins specified on the command line
2022-10-28 11:24:32 0 [Note] Initializing installed plugins
2022-10-28 11:24:32 0 [Warning] option 'innodb-buffer-pool-size': unsigned value 5 adjusted to 2097152
2022-10-28 11:24:32 0 [ERROR] InnoDB: innodb_page_size=16384 requires innodb_buffer_pool_size >= 5MiB current 2MiB
2022-10-28 11:24:32 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-10-28 11:24:32 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-10-28 11:24:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-28 11:24:32 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-10-28 11:24:32 0 [ERROR] Aborting

2022-10-28 11:43:17 0 [Note] Initializing built-in plugins
2022-10-28 11:43:17 0 [Note] Initializing plugins specified on the command line
2022-10-28 11:43:17 0 [Note] Initializing installed plugins
2022-10-28 11:43:17 0 [Warning] option 'innodb-buffer-pool-size': unsigned value 5 adjusted to 2097152
2022-10-28 11:43:17 0 [ERROR] InnoDB: innodb_page_size=16384 requires innodb_buffer_pool_size >= 5MiB current 2MiB
2022-10-28 11:43:17 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-10-28 11:43:17 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-10-28 11:43:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-28 11:43:17 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-10-28 11:43:17 0 [ERROR] Aborting

my.cnf配置文件内容 #

[client-server]
[mysqld]
pid-file = "/var/run/mysqld/mysql.pid"
innodb_buffer_pool_size=4G
innodb_log_file_size=1G
socket=/var/lib/mysql/mysql.sock

如需更多信息，请告知。

内容的提问来源于stack exchange，提问作者user12742406