1Panel恢复快照后，MySQL异常

听闻 · 2024 年6 月 28 日 04:08

服务器A：

服务器B：

问题描述：
目前五个应用，只有MySQL状态是异常，尝试过重建，但是没有效果。

日志内容:
e[2K1Panel-mysql-bt3R | 2024-06-28 04:06:02+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
e[2K1Panel-mysql-bt3R | 2024-06-28 04:06:02+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
e[2K1Panel-mysql-bt3R | 2024-06-28 04:06:02+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
e[2K1Panel-mysql-bt3R | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:02.706653Z 0 [System] [MY-015015] [Server] MySQL Server - start.
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:03.167916Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:03.172400Z 0 [Warning] [MY-010918] [Server] ‘default_authentication_plugin’ is deprecated and will be removed in a future release. Please use authentication_policy instead.
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:03.172459Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.2.0) starting as process 1
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:03.175530Z 0 [Warning] [MY-013242] [Server] --character-set-server: ‘utf8’ is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:03.187358Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:03.357592Z 1 [ERROR] [MY-013879] [InnoDB] The redo log file ./#innodb_redo/#ib_redo14 comes from other data directory than redo log file ./#innodb_redo/#ib_redo10.
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:03.357695Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:03.732589Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:03.732929Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:03.732957Z 0 [ERROR] [MY-010119] [Server] Aborting
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:03.733892Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.2.0) MySQL Community Server - GPL.
e[2K1Panel-mysql-bt3R | 2024-06-28T04:06:03.737003Z 0 [System] [MY-015016] [Server] MySQL Server - end.

1Panel-huiwan · 2024 年6 月 28 日 04:36

鼠标移动到这看看为啥异常

听闻 · 2024 年6 月 28 日 04:38

只提示我查看日志，然后我尝试单独备份了一下数据库，然后上传恢复，现在正常了

1Panel-huiwan · 2024 年6 月 28 日 04:39

好的如果还有问题可以再贴一下日志啥的

听闻 · 2024 年6 月 28 日 04:40

好嘞，非常感谢

user-vtnxjmn6fkv · 2024 年9 月 24 日 10:06

user-vtnxjmn6fkv · 2024 年9 月 24 日 10:08

net/http：等待连接时请求已取消（等待标头时超出 Client.Timeout）

user-vtnxjmn6fkv · 2024 年9 月 24 日 11:19

user-epeidjvqtk6 · 2024 年10 月 14 日 06:05

每次恢复都会出这个mysql异常的问题而且无法解决只能重建恢复的问题很严重

Panel-mysql-1a9G | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
1Panel-mysql-1a9G | 2024-10-14T05:56:28.045859Z 0 [System] [MY-015015] [Server] MySQL Server - start.
1Panel-mysql-1a9G | 2024-10-14T05:56:28.284756Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
1Panel-mysql-1a9G | 2024-10-14T05:56:28.286680Z 0 [Warning] [MY-010918] [Server] ‘default_authentication_plugin’ is deprecated and will be removed in a future release. Please use authentication_policy instead.
1Panel-mysql-1a9G | 2024-10-14T05:56:28.286706Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.2.0) starting as process 1
1Panel-mysql-1a9G | 2024-10-14T05:56:28.288297Z 0 [Warning] [MY-013242] [Server] --character-set-server: ‘utf8’ is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1Panel-mysql-1a9G | 2024-10-14T05:56:28.293152Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
1Panel-mysql-1a9G | 2024-10-14T05:56:28.303473Z 1 [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID:
1Panel-mysql-1a9G | 2024-10-14T05:56:28.303504Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 2 = [‘halo_775jsm/extensions.ibd’, ‘halo_8dc6j4/extensions.ibd’]
1Panel-mysql-1a9G | 2024-10-14T05:56:28.303520Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
1Panel-mysql-1a9G | 2024-10-14T05:56:28.303535Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
1Panel-mysql-1a9G | 2024-10-14T05:56:28.303673Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
1Panel-mysql-1a9G | 2024-10-14T05:56:28.303696Z 0 [ERROR] [MY-010119] [Server] Aborting
1Panel-mysql-1a9G | 2024-10-14T05:56:28.304142Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.2.0) MySQL Community Server - GPL.
1Panel-mysql-1a9G | 2024-10-14T05:56:28.305165Z 0 [System] [MY-015016] [Server] MySQL Server - end.
1Panel-mysql-1a9G | 2024-10-14 13:56:54+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
1Panel-mysql-1a9G | 2024-10-14 13:56:54+08:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
1Panel-mysql-1a9G | 2024-10-14 13:56:54+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
1Panel-mysql-1a9G | ‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
1Panel-mysql-1a9G | 2024-10-14T05:56:54.709732Z 0 [System] [MY-015015] [Server] MySQL Server - start.
1Panel-mysql-1a9G | 2024-10-14T05:56:54.991417Z 0 [Warning] [MY-011068] [Server] The syntax ‘–skip-host-cache’ is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
1Panel-mysql-1a9G | 2024-10-14T05:56:54.993450Z 0 [Warning] [MY-010918] [Server] ‘default_authentication_plugin’ is deprecated and will be removed in a future release. Please use authentication_policy instead.
1Panel-mysql-1a9G | 2024-10-14T05:56:54.993477Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.2.0) starting as process 1
1Panel-mysql-1a9G | 2024-10-14T05:56:54.994998Z 0 [Warning] [MY-013242] [Server] --character-set-server: ‘utf8’ is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1Panel-mysql-1a9G | 2024-10-14T05:56:55.002570Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
1Panel-mysql-1a9G | 2024-10-14T05:56:55.013679Z 1 [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID:
1Panel-mysql-1a9G | 2024-10-14T05:56:55.013714Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 2 = [‘halo_775jsm/extensions.ibd’, ‘halo_8dc6j4/extensions.ibd’]
1Panel-mysql-1a9G | 2024-10-14T05:56:55.013731Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
1Panel-mysql-1a9G | 2024-10-14T05:56:55.013860Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
1Panel-mysql-1a9G | 2024-10-14T05:56:55.014007Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
1Panel-mysql-1a9G | 2024-10-14T05:56:55.014022Z 0 [ERROR] [MY-010119] [Server] Aborting
1Panel-mysql-1a9G | 2024-10-14T05:56:55.014498Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.2.0) MySQL Community Server - GPL.
1Panel-mysql-1a9G | 2024-10-14T05:56:55.015638Z 0 [System] [MY-015016] [Server] MySQL Server - end.

user-epeidjvqtk6 · 2024 年10 月 14 日 06:05

这已经是第3次遇到这个问题了，因为这个问题删除重装才能解决，这次忘备份数据丢失了真的很恶心