提问人: 提问时间:11/7/2023 更新时间:11/7/2023 访问量:45
如何修复“InnoDB 插件初始化中止并出现错误 Generic Error”
How do i fix "InnoDB Plugin initialization aborted with error Generic Error"
问:
我正在运行正常的 Ubuntu 20.04 上运行 Nextcloud 服务器。我之前想升级Nextcloud版本并进行备份。这是我所做的:
- 插入外部硬盘 (/dev/sdb)
- 执行了“sudo dd if=/dev/sda of=/dev/sdb”以复制整个硬盘
- 让它运行了一夜,第二天早上它就成功完成了
- 第二天,我将NextCloud从维护模式中移除,并重新启动了整个服务器
- MySQL不再启动。
systemctl status mysql.service 给出以下输出:
mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (start) since Tue 2023-11-07 09:31:10 CET; 989ms ago
Process: 11409 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 11417 (mysqld)
Status: "Server startup in progress"
Tasks: 2 (limit: 9244)
Memory: 243.5M
CGroup: /system.slice/mysql.service
└─11417 /usr/sbin/mysqld
/var/log/mysql 错误 .log 包含以下内容:
2023-11-07T06:58:13.444740Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-0ubuntu0.20.04.1) (Ubuntu).
2023-11-07T06:58:14.111726Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35-0ubuntu0.20.04.1) starting as process 1485
2023-11-07T06:58:14.133488Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-07T06:58:20.046018Z 1 [ERROR] [MY-013895] [InnoDB] Found redo log file ./#innodb_redo/#ib_redo70356 which has format (v0) and is stored inside #innodb_redo.
2023-11-07T06:58:20.046045Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-11-07T06:58:20.439303Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-11-07T06:58:20.439722Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-11-07T06:58:20.439778Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-11-07T06:58:20.441103Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-0ubuntu0.20.04.1) (Ubuntu).
2023-11-07T06:58:21.122634Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35-0ubuntu0.20.04.1) starting as process 1646
2023-11-07T06:58:21.131645Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-07T06:58:25.012944Z 1 [ERROR] [MY-013895] [InnoDB] Found redo log file ./#innodb_redo/#ib_redo70356 which has format (v0) and is stored inside #innodb_redo.
2023-11-07T06:58:25.012978Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-11-07T06:58:25.407755Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-11-07T06:58:25.408120Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-11-07T06:58:25.408177Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-11-07T06:58:25.409555Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-0ubuntu0.20.04.1) (Ubuntu).
2023-11-07T06:58:26.122984Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35-0ubuntu0.20.04.1) starting as process 1669
2023-11-07T06:58:26.129932Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-07T06:58:30.092052Z 1 [ERROR] [MY-013895] [InnoDB] Found redo log file ./#innodb_redo/#ib_redo70356 which has format (v0) and is stored inside #innodb_redo.
2023-11-07T06:58:30.092088Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-11-07T06:58:30.486290Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-11-07T06:58:30.486691Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-11-07T06:58:30.486746Z 0 [ERROR] [MY-010119] [Server] Aborting
我已经为/var/lib/mysql文件夹授予了mysql-user权限。几次重新启动。
答:
1赞
Ruben247
11/7/2023
#1
好吧,我现在觉得自己像个绝对的白痴,但也许将来有人偶然发现了同样的问题:
外部驱动器仍然插入,当我启动服务器时,它以某种方式从外部驱动器启动,这导致了错误。
评论