MaridaDB 错误并且无法启动

MaridaDB 错误并且无法启动

我无法启动 MariaDB。systemctl status mariadb.service出现以下信息:


● mariadb.service - MariaDB 10.3.25 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Sun 2020-11-01 17:59:48 EST; 9s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 1281 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
  Process: 1282 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 1284 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && syst
  Process: 1331 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
 Main PID: 1331 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Nov 01 17:59:43 raspberrypi systemd[1]: Starting MariaDB 10.3.25 database server...
Nov 01 17:59:45 raspberrypi mysqld[1331]: 2020-11-01 17:59:45 0 [Note] /usr/sbin/mysqld (mysqld 10.3.25-MariaDB-0+deb10u1) starting as process 1331 ...
Nov 01 17:59:48 raspberrypi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Nov 01 17:59:48 raspberrypi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Nov 01 17:59:48 raspberrypi systemd[1]: Failed to start MariaDB 10.3.25 database server.

我的 mysql 错误日志显示:

2020-11-01 19:26:50 0 [Note] InnoDB: Using Linux native AIO
2020-11-01 19:26:50 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-01 19:26:50 0 [Note] InnoDB: Uses event mutexes
2020-11-01 19:26:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-11-01 19:26:51 0 [Note] InnoDB: Number of pools: 1
2020-11-01 19:26:51 0 [Note] InnoDB: Using generic crc32 instructions
2020-11-01 19:26:51 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-11-01 19:26:51 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-01 19:26:51 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-11-01 19:26:51 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=77688449
2020-11-01 19:26:51 0 [ERROR] InnoDB: Tablespace 54 was not found at ./raspberrypints/log.ibd.
2020-11-01 19:26:51 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
2020-11-01 19:26:51 0 [ERROR] InnoDB: Plugin initialization aborted with error Tablespace not found
2020-11-01 19:26:51 0 [Note] InnoDB: Starting shutdown...
2020-11-01 19:26:51 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-11-01 19:26:51 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-11-01 19:26:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-11-01 19:26:51 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-11-01 19:26:51 0 [ERROR] Aborting

似乎它在 raspberrypints 中寻找 log.ibd,但该文件不存在。我不知道接下来该怎么做。

答案1

看起来您的数据库损坏了,数据存储在 InnoDB 引擎中。您可能仍然可以恢复,网络上有很多指南可供参考:示例 1示例 2

相关内容