Created
July 5, 2018 16:19
-
-
Save malwador/31d66d511fd27f5a75b899155eb2a9f5 to your computer and use it in GitHub Desktop.
MySQL keeps crashing!
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Jul 5 07:34:39 KpF-honestbrew mysqld[109088]: 2018-07-05 7:34:39 139851464473344 [Warning] Aborted connection 6819 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 07:47:38 KpF-honestbrew mysqld[109088]: 2018-07-05 7:47:38 139851480406784 [Warning] Aborted connection 7478 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 09:50:46 KpF-honestbrew mysqld[109088]: 2018-07-05 9:50:46 139851533413120 [Warning] Aborted connection 16249 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 10:07:27 KpF-honestbrew mysqld[109088]: 2018-07-05 10:07:27 139851533413120 [Warning] Aborted connection 17923 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 10:08:53 KpF-honestbrew mysqld[109088]: 2018-07-05 10:08:53 139851480709888 [Warning] Aborted connection 18135 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 10:12:33 KpF-honestbrew mysqld[109088]: 2018-07-05 10:12:33 139851480103680 [Warning] Aborted connection 18618 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 10:36:47 KpF-honestbrew mysqld[109088]: 2018-07-05 10:36:47 139851185773312 [Warning] Aborted connection 20743 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 11:08:06 KpF-honestbrew mysqld[109088]: 2018-07-05 11:08:06 139851480709888 [Warning] Aborted connection 23364 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 11:14:19 KpF-honestbrew mysqld[109088]: 2018-07-05 11:14:19 139851479800576 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] /usr/sbin/mysqld (mysqld 10.1.32-MariaDB-1~xenial) starting as process 8887 ... | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] InnoDB: Using mutexes to ref count buffer pool pages | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] InnoDB: The InnoDB memory heap is disabled | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] InnoDB: Compressed tables use zlib 1.2.8 | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] InnoDB: Using SSE crc32 instructions | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] InnoDB: Initializing buffer pool, size = 6.0G | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] InnoDB: Completed initialization of buffer pool | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] InnoDB: Highest supported file format is Barracuda. | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] InnoDB: Starting crash recovery from checkpoint LSN=543620851095 | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer... | |
Jul 5 11:14:52 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:52 139776528795904 [Note] InnoDB: Starting final batch to recover 332 pages from redo log | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:55 139776528795904 [Note] InnoDB: 128 rollback segment(s) are active. | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:55 139776528795904 [Note] InnoDB: Waiting for purge to start | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:55 139776528795904 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.38-83.0 started; log sequence number 543622550331 | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:55 139768759289600 [Note] InnoDB: Dumping buffer pool(s) not yet started | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:55 139776528795904 [Note] Plugin 'FEEDBACK' is disabled. | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:55 139776528795904 [Note] Recovering after a crash using tc.log | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:55 139776528795904 [Note] Starting crash recovery... | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:55 139776528795904 [Note] Crash recovery finished. | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:55 139776528795904 [Note] Server socket created on IP: '127.0.0.1'. | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:55 139776528795904 [Note] Reading of all Master_info entries succeded | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:55 139776528795904 [Note] Added new Master_info '' to hash table | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: 2018-07-05 11:14:55 139776528795904 [Note] /usr/sbin/mysqld: ready for connections. | |
Jul 5 11:14:55 KpF-honestbrew mysqld[8887]: Version: '10.1.32-MariaDB-1~xenial' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution | |
Jul 5 11:15:01 KpF-honestbrew mysqld[8915]: Checking for corrupt, not cleanly closed and upgrade needing tables. | |
Jul 5 11:18:32 KpF-honestbrew mysqld[8887]: 2018-07-05 11:18:32 139776477305600 [Warning] Aborted connection 243 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 11:29:40 KpF-honestbrew mysqld[8887]: 2018-07-05 11:29:40 139776457370368 [Warning] Aborted connection 1186 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 12:18:36 KpF-honestbrew mysqld[8887]: 2018-07-05 12:18:36 139776458885888 [Warning] Aborted connection 4528 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 14:07:07 KpF-honestbrew mysqld[8887]: 2018-07-05 14:07:07 139776456461056 [Warning] Aborted connection 12178 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 14:07:10 KpF-honestbrew mysqld[8887]: 2018-07-05 14:07:10 139776457673472 [Warning] Aborted connection 12183 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 15:31:42 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:42 140279780096256 [Note] /usr/sbin/mysqld (mysqld 10.1.32-MariaDB-1~xenial) starting as process 33148 ... | |
Jul 5 15:31:42 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:42 140279780096256 [Note] InnoDB: Using mutexes to ref count buffer pool pages | |
Jul 5 15:31:42 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:42 140279780096256 [Note] InnoDB: The InnoDB memory heap is disabled | |
Jul 5 15:31:42 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:42 140279780096256 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
Jul 5 15:31:42 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:42 140279780096256 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
Jul 5 15:31:42 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:42 140279780096256 [Note] InnoDB: Compressed tables use zlib 1.2.8 | |
Jul 5 15:31:42 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:42 140279780096256 [Note] InnoDB: Using SSE crc32 instructions | |
Jul 5 15:31:42 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:42 140279780096256 [Note] InnoDB: Initializing buffer pool, size = 6.0G | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] InnoDB: Completed initialization of buffer pool | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] InnoDB: Highest supported file format is Barracuda. | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] InnoDB: The log sequence number 415576142419 in ibdata file do not match the log sequence number 544231417448 in the ib_logfiles! | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer... | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] InnoDB: 128 rollback segment(s) are active. | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] InnoDB: Waiting for purge to start | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.38-83.0 started; log sequence number 544231417448 | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140272029632256 [Note] InnoDB: Dumping buffer pool(s) not yet started | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] Plugin 'FEEDBACK' is disabled. | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] Recovering after a crash using tc.log | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] Starting crash recovery... | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] Crash recovery finished. | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] Server socket created on IP: '127.0.0.1'. | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] Reading of all Master_info entries succeded | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] Added new Master_info '' to hash table | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: 2018-07-05 15:31:43 140279780096256 [Note] /usr/sbin/mysqld: ready for connections. | |
Jul 5 15:31:43 KpF-honestbrew mysqld[33148]: Version: '10.1.32-MariaDB-1~xenial' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution | |
Jul 5 15:31:44 KpF-honestbrew mysqld[33176]: Checking for corrupt, not cleanly closed and upgrade needing tables. | |
Jul 5 15:52:50 KpF-honestbrew mysqld[33148]: 2018-07-05 15:52:50 140279779175168 [Warning] Aborted connection 990 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 16:05:59 KpF-honestbrew mysqld[33148]: 2018-07-05 16:05:59 140279779175168 [Warning] Aborted connection 1938 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) | |
Jul 5 16:14:53 KpF-honestbrew mysqld[33148]: 2018-07-05 16:14:53 140279710694144 [Warning] Aborted connection 2674 to db: 'honestbrew' user: 'honestbrew' host: 'localhost' (Got timeout reading communication packets) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment