1panel通过快照恢复(V2恢复到V2)后Mysql无限重启

从1panelV2.0.5 恢复到V2.0.4之后(通过1panel快照),mysql无限重启


我人都麻了,请各位大神支支招!
2025-07-28T21:48:34.536358Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2025-07-28T21:48:34.793189Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.5) starting as process 1
2025-07-28T21:48:34.799500Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-07-28T21:48:34.932156Z 1 [ERROR] [MY-013882] [InnoDB] Missing redo log file ./#innodb_redo/#ib_redo883 (with start_lsn = 2891614208).
2025-07-28T21:48:34.932217Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2025-07-28T21:48:35.329169Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2025-07-28T21:48:35.329548Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-07-28T21:48:35.329577Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-07-28T21:48:35.331351Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.5) MySQL Community Server - GPL.
2025-07-28T21:48:35.331378Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2025-07-29 05:48:37+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.5-1.el9 started.
2025-07-29 05:48:37+08:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
2025-07-29 05:48:37+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.5-1.el9 started.
‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
2025-07-28T21:48:37.981945Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2025-07-28T21:48:38.237249Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.5) starting as process 1
2025-07-28T21:48:38.244963Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-07-28T21:48:38.436749Z 1 [ERROR] [MY-013882] [InnoDB] Missing redo log file ./#innodb_redo/#ib_redo883 (with start_lsn = 2891614208).
2025-07-28T21:48:38.436886Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2025-07-28T21:48:38.777621Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2025-07-28T21:48:38.778473Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-07-28T21:48:38.778522Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-07-28T21:48:38.781382Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.5) MySQL Community Server - GPL.
2025-07-28T21:48:38.781415Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2025-07-29 05:48:42+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.5-1.el9 started.
2025-07-29 05:48:42+08:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
2025-07-29 05:48:42+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.5-1.el9 started.
‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
2025-07-28T21:48:43.082443Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2025-07-28T21:48:43.335193Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.5) starting as process 1
2025-07-28T21:48:43.354420Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-07-28T21:48:43.507184Z 1 [ERROR] [MY-013882] [InnoDB] Missing redo log file ./#innodb_redo/#ib_redo883 (with start_lsn = 2891614208).

MySQL无限报错重启。

数据库有很多内容…求帮助!

在 /opt (安装目录)下有一个 1panel_original 文件夹,里面存的是 1panel 快照恢复前备份文件

找到对应快照,下面会有 1panel/apps/mysql… ,找到 mysql 安装的目录,然后替换一下当前 mysql 的安装目录试试

记得替换前先做好当前 mysql 的安装目录

1 个赞

感谢兄弟,提了工单,技术大哥帮我远程看了下,没问题了~