root@vteme:~# service mysql start
start: Job failed to start
вот такое происходит при старте.
Когда сайт запускаем выдает вот что:
Error! mysql_connect()
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
20
MySQL Query Error: SELECT * FROM dev_resizeman_settings[]
151005 6:27:13 [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.
151005 6:27:13 [Note] Plugin 'FEDERATED' is disabled.
151005 6:27:13 InnoDB: The InnoDB memory heap is disabled
151005 6:27:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 6:27:13 InnoDB: Compressed tables use zlib 1.2.8
151005 6:27:13 InnoDB: Using Linux native AIO
151005 6:27:13 InnoDB: Initializing buffer pool, size = 128.0M
151005 6:27:13 InnoDB: Completed initialization of buffer pool
151005 6:27:13 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 6:27:13 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 6:27:17 InnoDB: Waiting for the background threads to start
151005 6:27:18 InnoDB: 5.5.43 started; log sequence number 8839505906
151005 6:27:18 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 6:27:18 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 6:27:18 [Note] Server socket created on IP: '127.0.0.1'.
151005 6:27:18 [Note] Event Scheduler: Loaded 0 events
151005 6:27:18 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 10:22:02 [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.
151005 10:22:02 [Note] Plugin 'FEDERATED' is disabled.
151005 10:22:02 InnoDB: The InnoDB memory heap is disabled
151005 10:22:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 10:22:02 InnoDB: Compressed tables use zlib 1.2.8
151005 10:22:02 InnoDB: Using Linux native AIO
151005 10:22:02 InnoDB: Initializing buffer pool, size = 128.0M
151005 10:22:02 InnoDB: Completed initialization of buffer pool
151005 10:22:02 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 10:22:02 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 10:22:02 InnoDB: Waiting for the background threads to start
151005 10:22:03 InnoDB: 5.5.43 started; log sequence number 8840279370
151005 10:22:03 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 10:22:03 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 10:22:03 [Note] Server socket created on IP: '127.0.0.1'.
151005 10:22:03 [Note] Event Scheduler: Loaded 0 events
151005 10:22:03 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 11:48:24 [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.
151005 11:48:24 [Note] Plugin 'FEDERATED' is disabled.
151005 11:48:24 InnoDB: The InnoDB memory heap is disabled
151005 11:48:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 11:48:24 InnoDB: Compressed tables use zlib 1.2.8
151005 11:48:24 InnoDB: Using Linux native AIO
151005 11:48:24 InnoDB: Initializing buffer pool, size = 128.0M
151005 11:48:24 InnoDB: Completed initialization of buffer pool
151005 11:48:24 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 11:48:24 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 11:48:25 InnoDB: Waiting for the background threads to start
151005 11:48:26 InnoDB: 5.5.43 started; log sequence number 8840968909
151005 11:48:26 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 11:48:26 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 11:48:26 [Note] Server socket created on IP: '127.0.0.1'.
151005 11:48:26 [Note] Event Scheduler: Loaded 0 events
151005 11:48:26 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 11:49:33 [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.
151005 11:49:33 [Note] Plugin 'FEDERATED' is disabled.
151005 11:49:33 InnoDB: The InnoDB memory heap is disabled
151005 11:49:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 11:49:33 InnoDB: Compressed tables use zlib 1.2.8
151005 11:49:33 InnoDB: Using Linux native AIO
151005 11:49:33 InnoDB: Initializing buffer pool, size = 128.0M
151005 11:49:33 InnoDB: Completed initialization of buffer pool
151005 11:49:33 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 11:49:33 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 11:49:33 InnoDB: Waiting for the background threads to start
151005 11:49:34 InnoDB: 5.5.43 started; log sequence number 8840970165
151005 11:49:34 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 11:49:34 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 11:49:34 [Note] Server socket created on IP: '127.0.0.1'.
151005 11:49:34 [Note] Event Scheduler: Loaded 0 events
151005 11:49:34 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 11:52:05 [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.
151005 11:52:05 [Note] Plugin 'FEDERATED' is disabled.
151005 11:52:05 InnoDB: The InnoDB memory heap is disabled
151005 11:52:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 11:52:05 InnoDB: Compressed tables use zlib 1.2.8
151005 11:52:05 InnoDB: Using Linux native AIO
151005 11:52:05 InnoDB: Initializing buffer pool, size = 128.0M
151005 11:52:05 InnoDB: Completed initialization of buffer pool
151005 11:52:05 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 11:52:05 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 11:52:05 InnoDB: Waiting for the background threads to start
151005 11:52:06 InnoDB: 5.5.43 started; log sequence number 8841002246
151005 11:52:06 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 11:52:06 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 11:52:06 [Note] Server socket created on IP: '127.0.0.1'.
151005 11:52:07 [Note] Event Scheduler: Loaded 0 events
151005 11:52:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 12:00:45 [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.
151005 12:00:45 [Note] Plugin 'FEDERATED' is disabled.
151005 12:00:45 InnoDB: The InnoDB memory heap is disabled
151005 12:00:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 12:00:45 InnoDB: Compressed tables use zlib 1.2.8
151005 12:00:45 InnoDB: Using Linux native AIO
151005 12:00:46 InnoDB: Initializing buffer pool, size = 128.0M
151005 12:00:46 InnoDB: Completed initialization of buffer pool
151005 12:00:46 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 12:00:46 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 12:00:46 InnoDB: Waiting for the background threads to start
151005 12:00:47 InnoDB: 5.5.43 started; log sequence number 8841103767
151005 12:00:47 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 12:00:47 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 12:00:47 [Note] Server socket created on IP: '127.0.0.1'.
151005 12:00:47 [Note] Event Scheduler: Loaded 0 events
151005 12:00:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 12:10:58 [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.
151005 12:10:58 [Note] Plugin 'FEDERATED' is disabled.
151005 12:10:58 InnoDB: The InnoDB memory heap is disabled
151005 12:10:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 12:10:58 InnoDB: Compressed tables use zlib 1.2.8
151005 12:10:58 InnoDB: Using Linux native AIO
151005 12:10:59 InnoDB: Initializing buffer pool, size = 128.0M
151005 12:10:59 InnoDB: Completed initialization of buffer pool
151005 12:10:59 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 12:10:59 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 12:10:59 InnoDB: Waiting for the background threads to start
151005 12:11:00 InnoDB: 5.5.43 started; log sequence number 8841155404
151005 12:11:00 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 12:11:00 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 12:11:00 [Note] Server socket created on IP: '127.0.0.1'.
151005 12:11:00 [Note] Event Scheduler: Loaded 0 events
151005 12:11:00 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 12:13:07 [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.
151005 12:13:07 [Note] Plugin 'FEDERATED' is disabled.
151005 12:13:07 InnoDB: The InnoDB memory heap is disabled
151005 12:13:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 12:13:07 InnoDB: Compressed tables use zlib 1.2.8
151005 12:13:07 InnoDB: Using Linux native AIO
151005 12:13:07 InnoDB: Initializing buffer pool, size = 128.0M
151005 12:13:07 InnoDB: Completed initialization of buffer pool
151005 12:13:08 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 12:13:08 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 12:13:09 InnoDB: Waiting for the background threads to start
151005 12:13:10 InnoDB: 5.5.43 started; log sequence number 8841162723
151005 12:13:10 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 12:13:10 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 12:13:10 [Note] Server socket created on IP: '127.0.0.1'.
151005 12:13:10 [Note] Event Scheduler: Loaded 0 events
151005 12:13:10 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 12:15:39 [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.
151005 12:15:39 [Note] Plugin 'FEDERATED' is disabled.
151005 12:15:39 InnoDB: The InnoDB memory heap is disabled
151005 12:15:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 12:15:39 InnoDB: Compressed tables use zlib 1.2.8
151005 12:15:39 InnoDB: Using Linux native AIO
151005 12:15:39 InnoDB: Initializing buffer pool, size = 128.0M
151005 12:15:39 InnoDB: Completed initialization of buffer pool
151005 12:15:39 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 12:15:39 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 12:15:40 InnoDB: Waiting for the background threads to start
151005 12:15:41 InnoDB: 5.5.43 started; log sequence number 8841168800
151005 12:15:41 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 12:15:41 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 12:15:41 [Note] Server socket created on IP: '127.0.0.1'.
151005 12:15:41 [Note] Event Scheduler: Loaded 0 events
151005 12:15:41 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 12:16:35 [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.
151005 12:16:35 [Note] Plugin 'FEDERATED' is disabled.
151005 12:16:35 InnoDB: The InnoDB memory heap is disabled
151005 12:16:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 12:16:35 InnoDB: Compressed tables use zlib 1.2.8
151005 12:16:35 InnoDB: Using Linux native AIO
151005 12:16:35 InnoDB: Initializing buffer pool, size = 128.0M
151005 12:16:35 InnoDB: Completed initialization of buffer pool
151005 12:16:35 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 8841168820
151005 12:16:35 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 8841169396
151005 12:16:35 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
151005 12:16:35 InnoDB: Waiting for the background threads to start
151005 12:16:36 InnoDB: 5.5.43 started; log sequence number 8841169396
151005 12:16:37 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 12:16:37 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 12:16:37 [Note] Server socket created on IP: '127.0.0.1'.
151005 12:16:37 [Note] Event Scheduler: Loaded 0 events
151005 12:16:37 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 12:17:20 [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.
151005 12:17:20 [Note] Plugin 'FEDERATED' is disabled.
151005 12:17:20 InnoDB: The InnoDB memory heap is disabled
151005 12:17:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 12:17:20 InnoDB: Compressed tables use zlib 1.2.8
151005 12:17:20 InnoDB: Using Linux native AIO
151005 12:17:20 InnoDB: Initializing buffer pool, size = 128.0M
151005 12:17:20 InnoDB: Completed initialization of buffer pool
151005 12:17:20 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 12:17:20 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 12:17:21 InnoDB: Waiting for the background threads to start
151005 12:17:22 InnoDB: 5.5.43 started; log sequence number 8841170578
151005 12:17:22 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 12:17:22 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 12:17:22 [Note] Server socket created on IP: '127.0.0.1'.
151005 12:17:22 [Note] Event Scheduler: Loaded 0 events
151005 12:17:22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 12:18: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.
151005 12:18:12 [Note] Plugin 'FEDERATED' is disabled.
151005 12:18:12 InnoDB: The InnoDB memory heap is disabled
151005 12:18:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 12:18:12 InnoDB: Compressed tables use zlib 1.2.8
151005 12:18:12 InnoDB: Using Linux native AIO
151005 12:18:12 InnoDB: Initializing buffer pool, size = 128.0M
151005 12:18:12 InnoDB: Completed initialization of buffer pool
151005 12:18:12 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 12:18:12 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 12:18:12 InnoDB: Waiting for the background threads to start
151005 12:18:13 InnoDB: 5.5.43 started; log sequence number 8841173067
151005 12:18:13 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 12:18:13 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 12:18:13 [Note] Server socket created on IP: '127.0.0.1'.
151005 12:18:13 [Note] Event Scheduler: Loaded 0 events
151005 12:18:14 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 12:20:01 [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.
151005 12:20:01 [Note] Plugin 'FEDERATED' is disabled.
151005 12:20:01 InnoDB: The InnoDB memory heap is disabled
151005 12:20:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 12:20:01 InnoDB: Compressed tables use zlib 1.2.8
151005 12:20:01 InnoDB: Using Linux native AIO
151005 12:20:01 InnoDB: Initializing buffer pool, size = 128.0M
151005 12:20:02 InnoDB: Completed initialization of buffer pool
151005 12:20:02 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 8841177889
151005 12:20:02 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 8841179631
151005 12:20:02 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
151005 12:20:03 InnoDB: Waiting for the background threads to start
151005 12:20:04 InnoDB: 5.5.43 started; log sequence number 8841179631
151005 12:20:04 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 12:20:04 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 12:20:04 [Note] Server socket created on IP: '127.0.0.1'.
151005 12:20:05 [Note] Event Scheduler: Loaded 0 events
151005 12:20:05 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 12:22:08 [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.
151005 12:22:08 [Note] Plugin 'FEDERATED' is disabled.
151005 12:22:08 InnoDB: The InnoDB memory heap is disabled
151005 12:22:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 12:22:08 InnoDB: Compressed tables use zlib 1.2.8
151005 12:22:08 InnoDB: Using Linux native AIO
151005 12:22:08 InnoDB: Initializing buffer pool, size = 128.0M
151005 12:22:08 InnoDB: Completed initialization of buffer pool
151005 12:22:08 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 12:22:08 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 12:22:11 InnoDB: Waiting for the background threads to start
151005 12:22:12 InnoDB: 5.5.43 started; log sequence number 8841187454
151005 12:22:12 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 12:22:12 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 12:22:12 [Note] Server socket created on IP: '127.0.0.1'.
151005 12:22:12 [Note] Event Scheduler: Loaded 0 events
151005 12:22:12 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 12:24:37 [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.
151005 12:24:37 [Note] Plugin 'FEDERATED' is disabled.
151005 12:24:37 InnoDB: The InnoDB memory heap is disabled
151005 12:24:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 12:24:37 InnoDB: Compressed tables use zlib 1.2.8
151005 12:24:37 InnoDB: Using Linux native AIO
151005 12:24:37 InnoDB: Initializing buffer pool, size = 128.0M
151005 12:24:37 InnoDB: Completed initialization of buffer pool
151005 12:24:37 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 12:24:37 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 12:24:39 InnoDB: Waiting for the background threads to start
151005 12:24:40 InnoDB: 5.5.43 started; log sequence number 8841200162
151005 12:24:40 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 12:24:40 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 12:24:40 [Note] Server socket created on IP: '127.0.0.1'.
151005 12:24:40 [Note] Event Scheduler: Loaded 0 events
151005 12:24:40 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 12:25:35 [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.
151005 12:25:35 [Note] Plugin 'FEDERATED' is disabled.
151005 12:25:35 InnoDB: The InnoDB memory heap is disabled
151005 12:25:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 12:25:35 InnoDB: Compressed tables use zlib 1.2.8
151005 12:25:35 InnoDB: Using Linux native AIO
151005 12:25:35 InnoDB: Initializing buffer pool, size = 128.0M
151005 12:25:35 InnoDB: Completed initialization of buffer pool
151005 12:25:35 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 12:25:35 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 12:25:39 InnoDB: Waiting for the background threads to start
151005 12:25:40 InnoDB: 5.5.43 started; log sequence number 8841201334
151005 12:25:40 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 12:25:40 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 12:25:40 [Note] Server socket created on IP: '127.0.0.1'.
151005 12:25:41 [Note] Event Scheduler: Loaded 0 events
151005 12:25:41 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 12:26:34 [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.
151005 12:26:34 [Note] Plugin 'FEDERATED' is disabled.
151005 12:26:34 InnoDB: The InnoDB memory heap is disabled
151005 12:26:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 12:26:34 InnoDB: Compressed tables use zlib 1.2.8
151005 12:26:34 InnoDB: Using Linux native AIO
151005 12:26:34 InnoDB: Initializing buffer pool, size = 128.0M
151005 12:26:34 InnoDB: Completed initialization of buffer pool
151005 12:26:34 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 8841201344
151005 12:26:34 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 8841202507
151005 12:26:35 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
151005 12:26:35 InnoDB: Waiting for the background threads to start
151005 12:26:37 InnoDB: 5.5.43 started; log sequence number 8841202507
151005 12:26:37 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 12:26:37 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 12:26:37 [Note] Server socket created on IP: '127.0.0.1'.
151005 12:26:37 [Note] Event Scheduler: Loaded 0 events
151005 12:26:37 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 14:32:43 [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.
151005 14:32:43 [Note] Plugin 'FEDERATED' is disabled.
151005 14:32:43 InnoDB: The InnoDB memory heap is disabled
151005 14:32:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 14:32:43 InnoDB: Compressed tables use zlib 1.2.8
151005 14:32:43 InnoDB: Using Linux native AIO
151005 14:32:43 InnoDB: Initializing buffer pool, size = 128.0M
151005 14:32:43 InnoDB: Completed initialization of buffer pool
151005 14:32:43 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 14:32:43 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 14:32:43 InnoDB: Waiting for the background threads to start
151005 14:32:44 InnoDB: 5.5.43 started; log sequence number 8841228482
151005 14:32:44 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 14:32:44 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 14:32:44 [Note] Server socket created on IP: '127.0.0.1'.
151005 14:32:44 [Note] Event Scheduler: Loaded 0 events
151005 14:32:44 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 14:44:09 [Note] /usr/sbin/mysqld: Normal shutdown
151005 14:44:24 [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.
151005 14:44:24 [Note] Plugin 'FEDERATED' is disabled.
151005 14:44:24 InnoDB: The InnoDB memory heap is disabled
151005 14:44:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 14:44:24 InnoDB: Compressed tables use zlib 1.2.8
151005 14:44:24 InnoDB: Using Linux native AIO
151005 14:44:24 InnoDB: Initializing buffer pool, size = 128.0M
151005 14:44:24 InnoDB: Completed initialization of buffer pool
151005 14:44:24 InnoDB: highest supported file format is Barracuda.
151005 14:44:24 InnoDB: Waiting for the background threads to start
151005 14:44:25 InnoDB: 5.5.43 started; log sequence number 8841298360
151005 14:44:25 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 14:44:25 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 14:44:25 [Note] Server socket created on IP: '127.0.0.1'.
151005 14:44:25 [Note] Event Scheduler: Loaded 0 events
151005 14:44:25 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 15:32:16 [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.
151005 15:32:16 [Note] Plugin 'FEDERATED' is disabled.
151005 15:32:16 InnoDB: The InnoDB memory heap is disabled
151005 15:32:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 15:32:16 InnoDB: Compressed tables use zlib 1.2.8
151005 15:32:16 InnoDB: Using Linux native AIO
151005 15:32:16 InnoDB: Initializing buffer pool, size = 128.0M
151005 15:32:16 InnoDB: Completed initialization of buffer pool
151005 15:32:16 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 15:32:16 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 15:32:17 InnoDB: Waiting for the background threads to start
151005 15:32:18 InnoDB: 5.5.43 started; log sequence number 8841543787
151005 15:32:18 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 15:32:18 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 15:32:18 [Note] Server socket created on IP: '127.0.0.1'.
151005 15:32:18 [Note] Event Scheduler: Loaded 0 events
151005 15:32:18 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 16:04: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.
151005 16:04:19 [Note] Plugin 'FEDERATED' is disabled.
151005 16:04:19 InnoDB: The InnoDB memory heap is disabled
151005 16:04:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 16:04:19 InnoDB: Compressed tables use zlib 1.2.8
151005 16:04:19 InnoDB: Using Linux native AIO
151005 16:04:19 InnoDB: Initializing buffer pool, size = 128.0M
151005 16:04:19 InnoDB: Completed initialization of buffer pool
151005 16:04:19 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 16:04:19 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 16:04:19 InnoDB: Waiting for the background threads to start
151005 16:04:20 InnoDB: 5.5.43 started; log sequence number 8841672289
151005 16:04:20 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 16:04:20 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 16:04:20 [Note] Server socket created on IP: '127.0.0.1'.
151005 16:04:20 [Note] Event Scheduler: Loaded 0 events
151005 16:04:20 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 16:05:55 [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.
151005 16:05:55 [Note] Plugin 'FEDERATED' is disabled.
151005 16:05:55 InnoDB: The InnoDB memory heap is disabled
151005 16:05:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 16:05:55 InnoDB: Compressed tables use zlib 1.2.8
151005 16:05:55 InnoDB: Using Linux native AIO
151005 16:05:55 InnoDB: Initializing buffer pool, size = 128.0M
151005 16:05:55 InnoDB: Completed initialization of buffer pool
151005 16:05:55 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 16:05:55 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 16:05:55 InnoDB: Waiting for the background threads to start
151005 16:05:56 InnoDB: 5.5.43 started; log sequence number 8841675683
151005 16:05:57 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 16:05:57 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 16:05:57 [Note] Server socket created on IP: '127.0.0.1'.
151005 16:05:57 [Note] Event Scheduler: Loaded 0 events
151005 16:05:57 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 16:06:56 [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.
151005 16:06:56 [Note] Plugin 'FEDERATED' is disabled.
151005 16:06:56 InnoDB: The InnoDB memory heap is disabled
151005 16:06:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 16:06:56 InnoDB: Compressed tables use zlib 1.2.8
151005 16:06:56 InnoDB: Using Linux native AIO
151005 16:06:56 InnoDB: Initializing buffer pool, size = 128.0M
151005 16:06:56 InnoDB: Completed initialization of buffer pool
151005 16:06:56 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151005 16:06:56 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151005 16:06:56 InnoDB: Waiting for the background threads to start
151005 16:06:57 InnoDB: 5.5.43 started; log sequence number 8841675703
151005 16:06:57 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 16:06:57 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 16:06:57 [Note] Server socket created on IP: '127.0.0.1'.
151005 16:06:57 [Note] Event Scheduler: Loaded 0 events
151005 16:06:57 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 16:08:03 [Note] /usr/sbin/mysqld: Normal shutdown
151005 16:08:03 [Note] Event Scheduler: Purging the queue. 0 events
151005 16:08:03 InnoDB: Starting shutdown...
151005 16:08:04 InnoDB: Waiting for 6 pages to be flushed
151005 16:08:05 InnoDB: Shutdown completed; log sequence number 8841678044
151005 16:08:05 [Note] /usr/sbin/mysqld: Shutdown complete
151005 16:08:05 [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.
151005 16:08:05 [Note] Plugin 'FEDERATED' is disabled.
151005 16:08:05 InnoDB: The InnoDB memory heap is disabled
151005 16:08:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 16:08:05 InnoDB: Compressed tables use zlib 1.2.8
151005 16:08:05 InnoDB: Using Linux native AIO
151005 16:08:05 InnoDB: Initializing buffer pool, size = 128.0M
151005 16:08:05 InnoDB: Completed initialization of buffer pool
151005 16:08:05 InnoDB: highest supported file format is Barracuda.
151005 16:08:05 InnoDB: Waiting for the background threads to start
151005 16:08:06 InnoDB: 5.5.43 started; log sequence number 8841678044
151005 16:08:06 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
151005 16:08:06 [Note] - '127.0.0.1' resolves to '127.0.0.1';
151005 16:08:06 [Note] Server socket created on IP: '127.0.0.1'.
151005 16:08:06 [Note] Event Scheduler: Loaded 0 events
151005 16:08:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.43-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
151005 16:43:48 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_13eb_0.MYI'; try to repair it
151005 16:43:48 [ERROR] Got an error from unknown thread, /build/buildd/mysql-5.5-5.5.43/storage/myisam/mi_write.c:226
151005 16:43:51 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_13eb_0.MYI'; try to repair it
151005 16:43:51 [ERROR] Got an error from unknown thread, /build/buildd/mysql-5.5-5.5.43/storage/myisam/mi_write.c:226
151005 16:43:51 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_13eb_0.MYI'; try to repair it
151005 16:43:51 [ERROR] Got an error from unknown thread, /build/buildd/mysql-5.5-5.5.43/storage/myisam/mi_write.c:226
151005 16:43:53 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_13eb_0.MYI'; try to repair it
151005 16:43:53 [ERROR] Got an error from unknown thread, /build/buildd/mysql-5.5-5.5.43/storage/myisam/mi_write.c:226
151005 16:43:53 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_13eb_0.MYI'; try to repair it
151005 16:43:53 [ERROR] Got an error from unknown thread, /build/buildd/mysql-5.5-5.5.43/storage/myisam/mi_write.c:226
151005 16:43:58 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_13eb_0.MYI'; try to repair it
151005 16:43:58 [ERROR] Got an error from unknown thread, /build/buildd/mysql-5.5-5.5.43/storage/myisam/mi_write.c:226
151005 16:43:59 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_13eb_0.MYI'; try to repair it
151005 16151005 17:04:54 [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.
151005 17:04:54 [Note] Plugin 'FEDERATED' is disabled.
151005 17:04:54 InnoDB: The InnoDB memory heap is disabled
151005 17:04:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:04:54 InnoDB: Compressed tables use zlib 1.2.8
151005 17:04:54 InnoDB: Using Linux native AIO
151005 17:04:54 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:04:54 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:04:54 InnoDB: Could not open or create data files.
151005 17:04:54 InnoDB: If you tried to add new data files, and it failed here,
151005 17:04:54 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:04:54 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:04:54 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:04:54 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:04:54 InnoDB: remove old data files which contain your precious data!
151005 17:04:54 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:04:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151005 17:04:54 [ERROR] Unknown/unsupported storage engine: InnoDB
151005 17:04:54 [ERROR] Aborting
151005 17:04:55 [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.
151005 17:04:55 [Note] Plugin 'FEDERATED' is disabled.
151005 17:04:55 InnoDB: The InnoDB memory heap is disabled
151005 17:04:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:04:55 InnoDB: Compressed tables use zlib 1.2.8
151005 17:04:55 InnoDB: Using Linux native AIO
151005 17:04:55 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:04:55 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:04:55 InnoDB: Could not open or create data files.
151005 17:04:55 InnoDB: If you tried to add new data files, and it failed here,
151005 17:04:55 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:04:55 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:04:55 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:04:55 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:04:55 InnoDB: remove old data files which contain your precious data!
151005 17:04:55 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:04:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151005 17:04:55 [ERROR] Unknown/unsupported storage engine: InnoDB
151005 17:04:55 [ERROR] Aborting
151005 17:04:56 [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.
151005 17:04:56 [Note] Plugin 'FEDERATED' is disabled.
151005 17:04:56 InnoDB: The InnoDB memory heap is disabled
151005 17:04:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:04:56 InnoDB: Compressed tables use zlib 1.2.8
151005 17:04:56 InnoDB: Using Linux native AIO
151005 17:04:56 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:04:56 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:04:56 InnoDB: Could not open or create data files.
151005 17:04:56 InnoDB: If you tried to add new data files, and it failed here,
151005 17:04:56 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:04:56 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:04:56 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:04:56 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:04:56 InnoDB: remove old data files which contain your precious data!
151005 17:04:56 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:04:56 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151005 17:04:56 [ERROR] Unknown/unsupported storage engine: InnoDB
151005 17:04:56 [ERROR] Aborting
151005 17:09:47 [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.
151005 17:09:47 [Note] Plugin 'FEDERATED' is disabled.
151005 17:09:47 InnoDB: The InnoDB memory heap is disabled
151005 17:09:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:09:47 InnoDB: Compressed tables use zlib 1.2.8
151005 17:09:47 InnoDB: Using Linux native AIO
151005 17:09:47 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:09:47 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:09:47 InnoDB: Could not open or create data files.
151005 17:09:47 InnoDB: If you tried to add new data files, and it failed here,
151005 17:09:47 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:09:47 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:09:47 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:09:47 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:09:47 InnoDB: remove old data files which contain your precious data!
151005 17:09:47 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:09:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151005 17:09:47 [ERROR] Unknown/unsupported storage engine: InnoDB
151005 17:09:47 [ERROR] Aborting
151005 17:09:48 [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.
151005 17:09:48 [Note] Plugin 'FEDERATED' is disabled.
151005 17:09:48 InnoDB: The InnoDB memory heap is disabled
151005 17:09:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:09:48 InnoDB: Compressed tables use zlib 1.2.8
151005 17:09:48 InnoDB: Using Linux native AIO
151005 17:09:48 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:09:48 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:09:48 InnoDB: Could not open or create data files.
151005 17:09:48 InnoDB: If you tried to add new data files, and it failed here,
151005 17:09:48 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:09:48 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:09:48 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:09:48 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:09:48 InnoDB: remove old data files which contain your precious data!
151005 17:09:48 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:09:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151005 17:09:48 [ERROR] Unknown/unsupported storage engine: InnoDB
151005 17:09:48 [ERROR] Aborting
151005 17:09:49 [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.
151005 17:09:49 [Note] Plugin 'FEDERATED' is disabled.
151005 17:09:49 InnoDB: The InnoDB memory heap is disabled
151005 17:09:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:09:49 InnoDB: Compressed tables use zlib 1.2.8
151005 17:09:49 InnoDB: Using Linux native AIO
151005 17:09:49 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:09:49 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:09:49 InnoDB: Could not open or create data files.
151005 17:09:49 InnoDB: If you tried to add new data files, and it failed here,
151005 17:09:49 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:09:49 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:09:49 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:09:49 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:09:49 InnoDB: remove old data files which contain your precious data!
151005 17:09:49 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:09:49 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151005 17:09:49 [ERROR] Unknown/unsupported storage engine: InnoDB
151005 17:09:49 [ERROR] Aborting
151005 17:11:04 [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.
151005 17:11:04 [Note] Plugin 'FEDERATED' is disabled.
151005 17:11:04 InnoDB: The InnoDB memory heap is disabled
151005 17:11:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:11:04 InnoDB: Compressed tables use zlib 1.2.8
151005 17:11:04 InnoDB: Using Linux native AIO
151005 17:11:04 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:11:04 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:11:04 InnoDB: Could not open or create data files.
151005 17:11:04 InnoDB: If you tried to add new data files, and it failed here,
151005 17:11:04 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:11:04 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:11:04 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:11:04 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:11:04 InnoDB: remove old data files which contain your precious data!
151005 17:11:04 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:11:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151005 17:11:04 [ERROR] Unknown/unsupported storage engine: InnoDB
151005 17:11:04 [ERROR] Aborting
151005 17:11:05 [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.
151005 17:11:05 [Note] Plugin 'FEDERATED' is disabled.
151005 17:11:05 InnoDB: The InnoDB memory heap is disabled
151005 17:11:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:11:05 InnoDB: Compressed tables use zlib 1.2.8
151005 17:11:05 InnoDB: Using Linux native AIO
151005 17:11:05 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:11:05 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:11:05 InnoDB: Could not open or create data files.
151005 17:11:05 InnoDB: If you tried to add new data files, and it failed here,
151005 17:11:05 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:11:05 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:11:05 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:11:05 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:11:05 InnoDB: remove old data files which contain your precious data!
151005 17:11:05 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:11:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151005 17:11:05 [ERROR] Unknown/unsupported storage engine: InnoDB
151005 17:11:05 [ERROR] Aborting
151005 17:11:06 [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.
151005 17:11:06 [Note] Plugin 'FEDERATED' is disabled.
151005 17:11:06 InnoDB: The InnoDB memory heap is disabled
151005 17:11:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:11:06 InnoDB: Compressed tables use zlib 1.2.8
151005 17:11:06 InnoDB: Using Linux native AIO
151005 17:11:06 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:11:07 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:11:07 InnoDB: Could not open or create data files.
151005 17:11:07 InnoDB: If you tried to add new data files, and it failed here,
151005 17:11:07 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:11:07 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:11:07 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:11:07 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:11:07 InnoDB: remove old data files which contain your precious data!
151005 17:11:07 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:11:07 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151005 17:11:07 [ERROR] Unknown/unsupported storage engine: InnoDB
151005 17:11:07 [ERROR] Aborting
151005 17:14:55 [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.
151005 17:14:55 [Note] Plugin 'FEDERATED' is disabled.
151005 17:14:55 InnoDB: The InnoDB memory heap is disabled
151005 17:14:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:14:55 InnoDB: Compressed tables use zlib 1.2.8
151005 17:14:55 InnoDB: Using Linux native AIO
151005 17:14:55 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:14:55 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:14:55 InnoDB: Could not open or create data files.
151005 17:14:55 InnoDB: If you tried to add new data files, and it failed here,
151005 17:14:55 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:14:55 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:14:55 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:14:55 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:14:55 InnoDB: remove old data files which contain your precious data!
151005 17:14:55 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:14:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151005 17:14:55 [ERROR] Unknown/unsupported storage engine: InnoDB
151005 17:14:55 [ERROR] Aborting
151005 17:14:56 [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.
151005 17:14:56 [Note] Plugin 'FEDERATED' is disabled.
151005 17:14:56 InnoDB: The InnoDB memory heap is disabled
151005 17:14:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:14:56 InnoDB: Compressed tables use zlib 1.2.8
151005 17:14:56 InnoDB: Using Linux native AIO
151005 17:14:56 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:14:56 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:14:56 InnoDB: Could not open or create data files.
151005 17:14:56 InnoDB: If you tried to add new data files, and it failed here,
151005 17:14:56 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:14:56 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:14:56 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:14:56 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:14:56 InnoDB: remove old data files which contain your precious data!
151005 17:14:56 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:14:56 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151005 17:14:56 [ERROR] Unknown/unsupported storage engine: InnoDB
151005 17:14:56 [ERROR] Aborting
151005 17:14:57 [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.
151005 17:14:57 [Note] Plugin 'FEDERATED' is disabled.
151005 17:14:57 InnoDB: The InnoDB memory heap is disabled
151005 17:14:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:14:57 InnoDB: Compressed tables use zlib 1.2.8
151005 17:14:57 InnoDB: Using Linux native AIO
151005 17:14:57 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:14:57 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:14:57 InnoDB: Could not open or create data files.
151005 17:14:57 InnoDB: If you tried to add new data files, and it failed here,
151005 17:14:57 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:14:57 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:14:57 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:14:57 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:14:57 InnoDB: remove old data files which contain your precious data!
151005 17:14:57 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:14:57 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151005 17:14:57 [ERROR] Unknown/unsupported storage engine: InnoDB
151005 17:14:57 [ERROR] Aborting
151005 17:15:28 [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.
151005 17:15:28 [Note] Plugin 'FEDERATED' is disabled.
151005 17:15:28 InnoDB: The InnoDB memory heap is disabled
151005 17:15:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151005 17:15:28 InnoDB: Compressed tables use zlib 1.2.8
151005 17:15:28 InnoDB: Using Linux native AIO
151005 17:15:28 InnoDB: Initializing buffer pool, size = 128.0M
151005 17:15:28 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
151005 17:15:28 InnoDB: Could not open or create data files.
151005 17:15:28 InnoDB: If you tried to add new data files, and it failed here,
151005 17:15:28 InnoDB: you should now edit innodb_data_file_path in my.cnf back
151005 17:15:28 InnoDB: to what it was, and remove the new ibdata files InnoDB created
151005 17:15:28 InnoDB: in this failed attempt. InnoDB only wrote those files full of
151005 17:15:28 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
151005 17:15:28 InnoDB: remove old data files which contain your precious data!
151005 17:15:28 [ERROR] Plugin 'InnoDB' init function returned error.
151005 17:15:28 [ERROR] Plugin 'InnoDB' registration as a STORAGE
Макс: Нет такое строки: default-storage-engine = InnoDB в my.cfg
файл тут же лежит? /etc/mysql/
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# dev.mysql.com/doc/mysql/en/server-system-variables.html
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
log-error=/var/log/mysql.log
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
ну вот. На админа намекал я, а написали другому ;)
А вообще - если хочется разобраться - открываем лог, документацию, гугл. Все в соседних окнах. И вперед, разбираться. Там не сложно , на самом деле ;)
Руслан Федосеев: Вакансия открыта, могу вам тоже написать)))) В логах перекопал все. уже другую ошибка выдает.
Mysql query error: Unknown storage engine 'InnoDB' (400)
хочу предысторию - что случилось с сервером?
ВОт не поверю, что просто так отвалилось.
Он вам говорит, что поврежден заголовок ibdata файла. В худшем случаем - идем искать бекап. Так с чего все началось?
Руслан Федосеев: Руслан, а можно с вами в вк списаться?
В общем я не знаю в чем дело, у меня два варианта.
1) битрикс посоветовал какую-то штуку подключить для оптимизации. (так как не могу зайти, то уже не знаю что хотел установить). Эта штука начала много чего устанавливать. было что-то типа remove ispmanager. Потом я отменил эту штуку.
2) после неудачной установки этой штуки запустил бекап сайта. думаю сделаю бекап и установлю. бекап завершился с ошибкой, подумал что место кончилось. купил еще 5гб памяти. но ничего не поменялось. а потом эта вот ошибка вылезла.
Как запустить этот innodb?
