版本:mysql版本15.1 Distrib 10.3.34-MariaDB
在尝试在我的mariadb服务器上备份后,我得到了:
mysqldump: Couldn't execute 'show create table `transaction_registry`': Table 'mysql.transaction_registry' doesn't exist in engine (1932)
我知道这是一个常见的错误。然后我研究了一下,决定放弃这个表,重新创建它。(来源:表';mysql.transaction_register';不存在于引擎中(1932((
Mariadb之后无法重新启动(这是我的问题,我正在努力解决(
以下是我已经尝试过的:
- 创建了一个新的mysql设备,并将transaction_register复制到我的实际数据库中。不好
- 删除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
如果您需要任何其他信息,请告诉我。
好消息,它没有被破坏,并不是所有的innodb错误都是被破坏的东西。有时,他们说什么就说什么;[错误]InnoDB:InnoDB_page_size=16384需要InnoDB_buffer_pool_size>=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
文件的权限。