It seems overnight mysql has broken i've tired to fix it but at a loss here's the log files if anyone can help it would be appreciated as a lot of my sites are down
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
2014-12-01 10:36:37 7f9655985720 InnoDB: File operation call: 'read' returned OS error 71.
2014-12-01 10:36:37 7f9655985720 InnoDB: Cannot continue operation.
141201 10:36:37 mysqld_safe mysqld from pid file /usr/local/mysql/data/host.pid ended
141201 16:29:08 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
2014-12-01 16:29:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-12-01 16:29:08 15728 [Note] Plugin 'FEDERATED' is disabled.
2014-12-01 16:29:08 15728 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-01 16:29:08 15728 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-12-01 16:29:08 15728 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-01 16:29:08 15728 [Note] InnoDB: Using Linux native AIO
2014-12-01 16:29:08 15728 [Note] InnoDB: Using CPU crc32 instructions
2014-12-01 16:29:08 15728 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-12-01 16:29:08 15728 [Note] InnoDB: Completed initialization of buffer pool
2014-12-01 16:29:08 15728 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-01 16:29:08 15728 [Note] InnoDB: The log sequence numbers 4920859673 and 4920859673 in ibdata files do not match the log sequence number 4921230973 in the ib_logfiles!
2014-12-01 16:29:08 15728 [Note] InnoDB: Database was not shutdown normally!
2014-12-01 16:29:08 15728 [Note] InnoDB: Starting crash recovery.
2014-12-01 16:29:08 15728 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-12-01 16:29:08 15728 [ERROR] InnoDB: Tried to read 16384 bytes at offset 0. Was only able to read 0.
2014-12-01 16:29:08 7f2f4c490720 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
2014-12-01 10:36:37 7f9655985720 InnoDB: File operation call: 'read' returned OS error 71.
2014-12-01 10:36:37 7f9655985720 InnoDB: Cannot continue operation.
141201 10:36:37 mysqld_safe mysqld from pid file /usr/local/mysql/data/host.pid ended
141201 16:29:08 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
2014-12-01 16:29:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-12-01 16:29:08 15728 [Note] Plugin 'FEDERATED' is disabled.
2014-12-01 16:29:08 15728 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-01 16:29:08 15728 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-12-01 16:29:08 15728 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-01 16:29:08 15728 [Note] InnoDB: Using Linux native AIO
2014-12-01 16:29:08 15728 [Note] InnoDB: Using CPU crc32 instructions
2014-12-01 16:29:08 15728 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-12-01 16:29:08 15728 [Note] InnoDB: Completed initialization of buffer pool
2014-12-01 16:29:08 15728 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-01 16:29:08 15728 [Note] InnoDB: The log sequence numbers 4920859673 and 4920859673 in ibdata files do not match the log sequence number 4921230973 in the ib_logfiles!
2014-12-01 16:29:08 15728 [Note] InnoDB: Database was not shutdown normally!
2014-12-01 16:29:08 15728 [Note] InnoDB: Starting crash recovery.
2014-12-01 16:29:08 15728 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-12-01 16:29:08 15728 [ERROR] InnoDB: Tried to read 16384 bytes at offset 0. Was only able to read 0.
2014-12-01 16:29:08 7f2f4c490720 InnoDB: Operating system error number 2 in a file operation.
MYSQL broken can't start
Aucun commentaire:
Enregistrer un commentaire