MySQL InnoDB disappeared, all InnoDB data cant be accessed

Posted by dogmatic69 on Server Fault See other posts from Server Fault or by dogmatic69
Published on 2014-06-04T22:44:51Z Indexed on 2014/06/05 3:28 UTC
Read the original article Hit count: 204

Filed under:

Mysql (including InnoDB) was working fine, after a restart the other day when mysql starts it says in the logs:

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

In the app it says:

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

Now, according to google this is a very simple fix, just remove the ib_logfile[0|1] files, which I have done and does not do anything.

I started by making a full copy of the data dir for testing various 'fixes'.

I have also uninstalled mysql and reinstalled it with no change, I just cant get it to run with innodb working anymore :/

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

I have also tried the innodb_force_recovery setting, 0 -> 6, Any time I run a command on an InnoDB table it says innodb_force_recovery

LOGS (from around the time it died)

was working here
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
does not work anymore
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.

© Server Fault or respective owner

Related posts about mysql