Skip to content

Instantly share code, notes, and snippets.

@malwador
Created July 5, 2018 16:19
Show Gist options
  • Save malwador/31d66d511fd27f5a75b899155eb2a9f5 to your computer and use it in GitHub Desktop.
Save malwador/31d66d511fd27f5a75b899155eb2a9f5 to your computer and use it in GitHub Desktop.
MySQL keeps crashing!
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