如何修复“InnoDB 插件初始化中止并出现错误 Generic Error”

How do i fix "InnoDB Plugin initialization aborted with error Generic Error"

提问人: 提问时间:11/7/2023 更新时间:11/7/2023 访问量:45

问:

此问题已从 Stack Overflow 迁移而来,因为可以在 Database Administrators Stack Exchange 上回答该问题。迁移 17 天前

我正在运行正常的 Ubuntu 20.04 上运行 Nextcloud 服务器。我之前想升级Nextcloud版本并进行备份。这是我所做的:

  1. 插入外部硬盘 (/dev/sdb)
  2. 执行了“sudo dd if=/dev/sda of=/dev/sdb”以复制整个硬盘
  3. 让它运行了一夜,第二天早上它就成功完成了
  4. 第二天,我将NextCloud从维护模式中移除,并重新启动了整个服务器
  5. 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权限。几次重新启动。

MySQL Linux Ubuntu innoDB

评论


答:

1赞 Ruben247 11/7/2023 #1

好吧,我现在觉得自己像个绝对的白痴,但也许将来有人偶然发现了同样的问题:

外部驱动器仍然插入,当我启动服务器时,它以某种方式从外部驱动器启动,这导致了错误。