MySQL InnoDB消失了，所有InnoDB数据都无法访问

2024-5-29 • tag-icon

Mysql（包括数据库引擎InnoDB) 运行正常，前几天重新启动后，当 mysql 启动时，日志中显示：

140604 23:36:07 [Note] Plugin 'FEDERATED' is disabled.
140604 23:36:07 [Note] Plugin 'InnoDB' is disabled.

应用程序中显示：

SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown storage engine 'InnoDB'

现在，根据谷歌的说法，这是一个非常简单的修复，只需删除文件ib_logfile[0|1]，我已经这样做了，但没有任何效果。

我首先复制了数据目录以测试各种“修复”。

我也卸载了 mysql 并重新安装它，没有任何变化，我只是无法让它与 innodb 一起运行 :/

# mysql --version
mysql  Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.3

我也尝试过innodb_force_recovery设置，0 -> 6，每次我在 InnoDB 表上运行命令时都会显示innodb_force_recovery

日志（从它死亡时开始）

在这里工作

Version: '5.5.37-0ubuntu0.14.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
140530  1:24:22 [Note] /usr/sbin/mysqld: Normal shutdown

140530  1:24:22 [Note] Event Scheduler: Purging the queue. 0 events
140530  1:24:22  InnoDB: Starting shutdown...
140530  1:24:24  InnoDB: Shutdown completed; log sequence number 3345857316
140530  1:24:24 [Note] /usr/sbin/mysqld: Shutdown complete

140530 22:03:12 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140530 22:03:12 [Note] Plugin 'FEDERATED' is disabled.
140530 22:03:12 InnoDB: The InnoDB memory heap is disabled
140530 22:03:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140530 22:03:12 InnoDB: Compressed tables use zlib 1.2.8
140530 22:03:12 InnoDB: Using Linux native AIO
140530 22:03:12 InnoDB: Initializing buffer pool, size = 128.0M
140530 22:03:12 InnoDB: Completed initialization of buffer pool
140530 22:03:12 InnoDB: highest supported file format is Barracuda.
140530 22:03:15  InnoDB: Waiting for the background threads to start
140530 22:03:16 InnoDB: 5.5.37 started; log sequence number 3345857316
140530 22:03:16 [Note] Server hostname (bind-address): '192.168.1.20'; port: 3306
140530 22:03:16 [Note]   - '192.168.1.20' resolves to '192.168.1.20';
140530 22:03:16 [Note] Server socket created on IP: '192.168.1.20'.
140530 22:03:16 [Note] Event Scheduler: Loaded 0 events
140530 22:03:16 [Note] /usr/sbin/mysqld: ready for connections.

140602  0:58:39 [Note] Event Scheduler: Purging the queue. 0 events
140602  0:58:39  InnoDB: Starting shutdown...
140602  0:58:41  InnoDB: Shutdown completed; log sequence number 3345954467
140602  0:58:41 [Note] /usr/sbin/mysqld: Shutdown complete

不再起作用

140602 21:45:19 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140602 21:45:19 [Note] Plugin 'FEDERATED' is disabled.
140602 21:45:19 [Note] Plugin 'InnoDB' is disabled.
140602 21:45:19 [Note] Server hostname (bind-address): '192.168.1.20'; port: 3306
140602 21:45:19 [Note]   - '192.168.1.20' resolves to '192.168.1.20';
140602 21:45:19 [Note] Server socket created on IP: '192.168.1.20'.
140602 21:45:19 [Note] Event Scheduler: Loaded 0 events
140602 21:45:19 [Note] /usr/sbin/mysqld: ready for connections.

日志（从它死亡时开始）

相关内容