centos MariaDB备份是不可能的了，因为InnoDB是坏的，为什么呢？

版本：mysql版本15.1分配10.3.34-MariaDB
在尝试在我的mariadb服务器上做备份后，我得到：

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

我知道这是一个常见的错误。然后我研究了一下，决定删除这个表，然后重新创建它。（来源：（第10页）
Mariadb之后无法重新启动（这是我的问题，我正在努力修复）
下面是我已经尝试过的方法：
1.创建了一个新的mysql设备，并将transaction_registry复制到我的实际数据库中。不好。
1.删除ib_logfile*
其他信息：/var/log文件类型：

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

如果您需要任何其他信息，请告诉我。

好消息是，它没有损坏，并不是所有的innodb错误都是损坏的东西。有时它们是说什么就是什么“[错误] InnoDB：页面大小=16384需要缓冲池大小〉= 5MiB，当前为2MiB”。
服务器没有读取您的配置文件。某个地方的配置文件或命令行包含innodb_buffer_pool_size=4（或在以后的重新启动中为5）。由于此值太小，因此它使用2MiB，这只是页面大小为4k时的最小值。
“删除ib_logfile*”这肯定会破坏你当前的MariaDB。不要这样做。
看看mariadb是如何开始的：

sudo -u mysql mysqld --help --verbose | head -n 10

将包含一个输出：

Default options are read from the following files in the given order:
/etc/my.cnf ~/.my.cnf

请检查您的文件是否存在。请检查您的my.cnf文件的权限。

centos MariaDB备份是不可能的了，因为InnoDB是坏的，为什么呢？

1条答案

相关问题

热门标签

最新问答