2018-12-11 2:00:10 0 [Note] /data/bld/10.4/bin/mysqld (mysqld 10.4.1-MariaDB-debug-log) starting as process 27643 ... 2018-12-11 2:00:10 0 [Note] InnoDB: Using Linux native AIO 2018-12-11 2:00:10 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2018-12-11 2:00:10 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-12-11 2:00:10 0 [Note] InnoDB: Uses event mutexes 2018-12-11 2:00:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2018-12-11 2:00:10 0 [Note] InnoDB: Number of pools: 1 2018-12-11 2:00:10 0 [Note] InnoDB: Using SSE2 crc32 instructions 2018-12-11 2:00:10 0 [Note] mysqld: O_TMPFILE is not supported on /home/travis/logs/vardir/tmp (disabling future attempts) 2018-12-11 2:00:10 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-12-11 2:00:10 0 [Note] InnoDB: Completed initialization of buffer pool 2018-12-11 2:00:10 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-12-11 2:00:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-12-11 2:00:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-12-11 2:00:10 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-12-11 2:00:10 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-12-11 2:00:10 0 [Note] InnoDB: Waiting for purge to start 2018-12-11 2:00:10 0 [Note] InnoDB: 10.4.1 started; log sequence number 177463; transaction id 55 2018-12-11 2:00:10 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/vardir/data/ib_buffer_pool 2018-12-11 2:00:10 0 [Note] Plugin 'FEEDBACK' is disabled. 2018-12-11 2:00:10 0 [Note] InnoDB: Buffer pool(s) load completed at 181211 2:00:10 2018-12-11 2:00:10 0 [Note] Server socket created on IP: '::'. 2018-12-11 2:00:10 0 [Note] Reading of all Master_info entries succeded 2018-12-11 2:00:10 0 [Note] Added new Master_info '' to hash table 2018-12-11 2:00:10 0 [Note] /data/bld/10.4/bin/mysqld: ready for connections. Version: '10.4.1-MariaDB-debug-log' socket: '/home/travis/logs/vardir/mysql.sock' port: 19300 Source distribution 2018-12-11 2:00:11 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:11 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: DELETE FROM `CC` ORDER BY `col_date_nokey` LIMIT 1 /* QNO 125 CON_ID 13 */ 2018-12-11 2:00:11 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:11 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `C` SET `col_time_key` = 107 ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 152 CON_ID 13 */ 2018-12-11 2:00:12 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `A` SET `col_int_key` = 231 ORDER BY `col_time_nokey` LIMIT 1 /* QNO 83 CON_ID 15 */ 2018-12-11 2:00:12 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `BB` SET `col_int_key` = NULL ORDER BY `col_int_key` LIMIT 1 /* QNO 100 CON_ID 15 */ 2018-12-11 2:00:12 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `D` SET `pk` = 'ritual' ORDER BY `col_time_key` LIMIT 1 /* QNO 117 CON_ID 15 */ 2018-12-11 2:00:12 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `E` SET `col_varchar_key` = 'throughout' ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 325 CON_ID 13 */ 2018-12-11 2:00:12 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `DD` SET `col_datetime_key` = DEFAULT ORDER BY `col_date_nokey` LIMIT 1 /* QNO 168 CON_ID 15 */ 2018-12-11 2:00:12 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `C` SET `col_varchar_nokey` = 141 ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 109 CON_ID 16 */ 2018-12-11 2:00:12 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `E` SET `col_date_key` = 'solution' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 380 CON_ID 13 */ 2018-12-11 2:00:12 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `E` SET `col_date_key` = NULL ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 136 CON_ID 16 */ 2018-12-11 2:00:12 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `AA` SET `pk` = NULL ORDER BY `col_datetime_key` LIMIT 1 /* QNO 421 CON_ID 13 */ 2018-12-11 2:00:12 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `CC` SET `col_date_key` = 'j' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 353 CON_ID 15 */ 2018-12-11 2:00:12 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `E` SET `col_varchar_key` = 'frown' ORDER BY `col_varchar_key` LIMIT 1 /* QNO 368 CON_ID 15 */ 2018-12-11 2:00:12 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `E` SET `col_int_key` = 'c' ORDER BY `col_int_nokey` LIMIT 1 /* QNO 265 CON_ID 16 */ 2018-12-11 2:00:12 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `E` SET `col_datetime_nokey` = DEFAULT ORDER BY `col_date_nokey` LIMIT 1 /* QNO 538 CON_ID 13 */ 2018-12-11 2:00:12 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:12 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: DELETE FROM `E` ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 270 CON_ID 16 */ 2018-12-11 2:00:13 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `E` SET `col_int_key` = 123 ORDER BY `col_time_nokey` LIMIT 1 /* QNO 191 CON_ID 17 */ 2018-12-11 2:00:13 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `E` SET `col_time_key` = 'above' ORDER BY `col_time_key` LIMIT 1 /* QNO 400 CON_ID 14 */ 2018-12-11 2:00:13 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: DELETE FROM `D` ORDER BY `col_int_nokey` LIMIT 1 /* QNO 292 CON_ID 18 */ 2018-12-11 2:00:13 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `DD` SET `pk` = '' ORDER BY `col_time_key` LIMIT 1 /* QNO 617 CON_ID 13 */ 2018-12-11 2:00:13 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: DELETE FROM `DD` ORDER BY `col_time_nokey` LIMIT 1 /* QNO 407 CON_ID 15 */ 2018-12-11 2:00:13 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `DD` SET `col_datetime_key` = 'production' ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 416 CON_ID 14 */ 2018-12-11 2:00:13 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `DD` SET `col_time_key` = 70 ORDER BY `col_time_key` LIMIT 1 /* QNO 624 CON_ID 13 */ 2018-12-11 2:00:13 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `DD` SET `col_int_key` = 'usual' ORDER BY `col_int_key` LIMIT 1 /* QNO 335 CON_ID 18 */ 2018-12-11 2:00:13 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: DELETE FROM `D` ORDER BY `col_time_nokey` LIMIT 1 /* QNO 254 CON_ID 17 */ 2018-12-11 2:00:13 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `D` SET `col_varchar_nokey` = 173 ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 686 CON_ID 13 */ 2018-12-11 2:00:13 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `DD` SET `col_varchar_key` = NULL ORDER BY `col_time_nokey` LIMIT 1 /* QNO 258 CON_ID 17 */ 2018-12-11 2:00:13 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `C` SET `col_time_nokey` = 'p' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 467 CON_ID 14 */ 2018-12-11 2:00:13 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `B` SET `col_int_key` = NULL ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 473 CON_ID 14 */ 2018-12-11 2:00:13 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `C` SET `col_int_key` = DEFAULT ORDER BY `col_date_nokey` LIMIT 1 /* QNO 403 CON_ID 16 */ 2018-12-11 2:00:13 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `E` SET `col_varchar_key` = 'l' ORDER BY `col_int_nokey` LIMIT 1 /* QNO 506 CON_ID 15 */ 2018-12-11 2:00:13 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `C` SET `col_time_key` = '' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 416 CON_ID 16 */ 2018-12-11 2:00:13 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: DELETE FROM `BB` ORDER BY `col_int_nokey` LIMIT 1 /* QNO 520 CON_ID 15 */ 2018-12-11 2:00:13 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `BB` SET `col_datetime_key` = DEFAULT ORDER BY `col_time_nokey` LIMIT 1 /* QNO 439 CON_ID 18 */ 2018-12-11 2:00:13 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: DELETE FROM `E` ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 796 CON_ID 13 */ 2018-12-11 2:00:13 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `AA` SET `pk` = DEFAULT ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 464 CON_ID 16 */ 2018-12-11 2:00:13 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: DELETE FROM `E` ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 559 CON_ID 14 */ 2018-12-11 2:00:13 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `E` SET `col_time_key` = DEFAULT ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 325 CON_ID 17 */ 2018-12-11 2:00:13 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `E` SET `col_date_key` = DEFAULT ORDER BY `col_time_nokey` LIMIT 1 /* QNO 577 CON_ID 15 */ 2018-12-11 2:00:13 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: DELETE FROM `C` ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 583 CON_ID 15 */ 2018-12-11 2:00:13 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: DELETE FROM `B` ORDER BY `col_int_nokey` LIMIT 1 /* QNO 480 CON_ID 16 */ 2018-12-11 2:00:13 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `AA` SET `col_varchar_key` = '' ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 544 CON_ID 18 */ 2018-12-11 2:00:13 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: DELETE FROM `AA` ORDER BY `col_int_nokey` LIMIT 1 /* QNO 339 CON_ID 17 */ 2018-12-11 2:00:13 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:13 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: DELETE FROM `C` ORDER BY `col_date_nokey` LIMIT 1 /* QNO 568 CON_ID 14 */ 2018-12-11 2:00:14 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: DELETE FROM `C` ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 575 CON_ID 18 */ 2018-12-11 2:00:14 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: DELETE FROM `D` ORDER BY `col_date_nokey` LIMIT 1 /* QNO 752 CON_ID 15 */ 2018-12-11 2:00:14 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `D` SET `col_datetime_key` = NULL ORDER BY `col_time_nokey` LIMIT 1 /* QNO 631 CON_ID 16 */ 2018-12-11 2:00:14 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `B` SET `col_int_key` = 'z' ORDER BY `col_varchar_key` LIMIT 1 /* QNO 703 CON_ID 14 */ 2018-12-11 2:00:14 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `B` SET `col_int_key` = 'j' ORDER BY `col_int_key` LIMIT 1 /* QNO 974 CON_ID 13 */ 2018-12-11 2:00:14 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `B` SET `col_datetime_key` = '' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 664 CON_ID 18 */ 2018-12-11 2:00:14 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `E` SET `col_int_nokey` = DEFAULT ORDER BY `col_time_nokey` LIMIT 1 /* QNO 677 CON_ID 16 */ 2018-12-11 2:00:14 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `D` SET `col_datetime_key` = DEFAULT ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 775 CON_ID 15 */ 2018-12-11 2:00:14 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `BB` SET `col_time_nokey` = '' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 680 CON_ID 18 */ 2018-12-11 2:00:14 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: DELETE FROM `D` ORDER BY `col_int_nokey` LIMIT 1 /* QNO 743 CON_ID 16 */ 2018-12-11 2:00:14 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: DELETE FROM `E` ORDER BY `col_int_nokey` LIMIT 1 /* QNO 716 CON_ID 18 */ 2018-12-11 2:00:14 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `E` SET `pk` = 7 ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 847 CON_ID 14 */ 2018-12-11 2:00:14 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `E` SET `pk` = 'nervous' ORDER BY `col_date_key` LIMIT 1 /* QNO 1027 CON_ID 13 */ 2018-12-11 2:00:14 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:14 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `B` SET `col_date_key` = 'academic' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1040 CON_ID 13 */ 2018-12-11 2:00:15 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `C` SET `pk` = 114 ORDER BY `col_time_nokey` LIMIT 1 /* QNO 790 CON_ID 16 */ 2018-12-11 2:00:15 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `C` SET `col_datetime_key` = NULL ORDER BY `col_time_nokey` LIMIT 1 /* QNO 887 CON_ID 14 */ 2018-12-11 2:00:15 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: DELETE FROM `B` ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 898 CON_ID 14 */ 2018-12-11 2:00:15 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `C` SET `col_date_nokey` = DEFAULT ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1062 CON_ID 13 */ 2018-12-11 2:00:15 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `C` SET `col_varchar_key` = NULL ORDER BY `col_varchar_key` LIMIT 1 /* QNO 802 CON_ID 16 */ 2018-12-11 2:00:15 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `DD` SET `col_datetime_key` = 62 ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 561 CON_ID 17 */ 2018-12-11 2:00:15 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: DELETE FROM `DD` ORDER BY `col_date_nokey` LIMIT 1 /* QNO 914 CON_ID 14 */ 2018-12-11 2:00:15 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `DD` SET `col_time_nokey` = 'g' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 930 CON_ID 15 */ 2018-12-11 2:00:15 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `D` SET `col_time_nokey` = 'g' ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1112 CON_ID 13 */ 2018-12-11 2:00:15 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `D` SET `col_date_key` = DEFAULT ORDER BY `col_date_nokey` LIMIT 1 /* QNO 604 CON_ID 17 */ 2018-12-11 2:00:15 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: DELETE FROM `DD` ORDER BY `col_time_nokey` LIMIT 1 /* QNO 853 CON_ID 18 */ 2018-12-11 2:00:15 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `DD` SET `col_time_nokey` = 149 ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 950 CON_ID 14 */ 2018-12-11 2:00:15 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: DELETE FROM `DD` ORDER BY `col_date_nokey` LIMIT 1 /* QNO 853 CON_ID 16 */ 2018-12-11 2:00:15 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `E` SET `col_varchar_key` = 183 ORDER BY `col_varchar_key` LIMIT 1 /* QNO 961 CON_ID 14 */ 2018-12-11 2:00:15 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: DELETE FROM `E` ORDER BY `col_time_nokey` LIMIT 1 /* QNO 861 CON_ID 18 */ 2018-12-11 2:00:15 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `E` SET `col_time_nokey` = DEFAULT ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1054 CON_ID 15 */ 2018-12-11 2:00:15 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `E` SET `col_varchar_key` = NULL ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1182 CON_ID 13 */ 2018-12-11 2:00:15 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `A` SET `col_varchar_key` = NULL ORDER BY `col_time_nokey` LIMIT 1 /* QNO 667 CON_ID 17 */ 2018-12-11 2:00:15 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `A` SET `col_datetime_key` = 49 ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1237 CON_ID 13 */ 2018-12-11 2:00:15 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: DELETE FROM `D` ORDER BY `col_time_nokey` LIMIT 1 /* QNO 897 CON_ID 18 */ 2018-12-11 2:00:15 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `BB` SET `col_varchar_key` = 242 ORDER BY `col_time_nokey` LIMIT 1 /* QNO 912 CON_ID 18 */ 2018-12-11 2:00:15 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `D` SET `col_datetime_key` = 154 ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1012 CON_ID 14 */ 2018-12-11 2:00:15 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `BB` SET `col_date_key` = DEFAULT ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 924 CON_ID 18 */ 2018-12-11 2:00:15 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:15 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `E` SET `col_time_key` = 24 ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1258 CON_ID 13 */ 2018-12-11 2:00:16 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: DELETE FROM `AA` ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1006 CON_ID 16 */ 2018-12-11 2:00:16 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `A` SET `col_int_nokey` = 'h' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1011 CON_ID 16 */ 2018-12-11 2:00:16 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: DELETE FROM `A` ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1016 CON_ID 16 */ 2018-12-11 2:00:16 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `CC` SET `col_date_nokey` = 148 ORDER BY `col_date_nokey` LIMIT 1 /* QNO 737 CON_ID 17 */ 2018-12-11 2:00:16 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `AA` SET `col_time_key` = '' ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1057 CON_ID 14 */ 2018-12-11 2:00:16 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `C` SET `col_datetime_key` = 'a' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 775 CON_ID 17 */ 2018-12-11 2:00:16 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `CC` SET `col_date_key` = 'd' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1232 CON_ID 15 */ 2018-12-11 2:00:16 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `CC` SET `col_date_nokey` = DEFAULT ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1106 CON_ID 16 */ 2018-12-11 2:00:16 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `DD` SET `col_varchar_key` = 'pitcher' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1090 CON_ID 14 */ 2018-12-11 2:00:16 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `C` SET `col_int_key` = DEFAULT ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1240 CON_ID 15 */ 2018-12-11 2:00:16 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `D` SET `col_date_nokey` = NULL ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1357 CON_ID 13 */ 2018-12-11 2:00:16 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `DD` SET `col_int_key` = 224 ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1252 CON_ID 15 */ 2018-12-11 2:00:16 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `DD` SET `col_varchar_nokey` = '' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1170 CON_ID 14 */ 2018-12-11 2:00:16 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `DD` SET `col_time_nokey` = 209 ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 902 CON_ID 17 */ 2018-12-11 2:00:16 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `CC` SET `col_varchar_key` = NULL ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1290 CON_ID 15 */ 2018-12-11 2:00:16 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `CC` SET `pk` = 'k' ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1139 CON_ID 16 */ 2018-12-11 2:00:16 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `CC` SET `col_date_nokey` = 's' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1417 CON_ID 13 */ 2018-12-11 2:00:16 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `DD` SET `col_time_key` = 't' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1120 CON_ID 18 */ 2018-12-11 2:00:16 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `E` SET `col_int_key` = '' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1201 CON_ID 14 */ 2018-12-11 2:00:16 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `E` SET `pk` = DEFAULT ORDER BY `col_datetime_key` LIMIT 1 /* QNO 1334 CON_ID 15 */ 2018-12-11 2:00:16 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: DELETE FROM `E` ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1153 CON_ID 16 */ 2018-12-11 2:00:16 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `B` SET `col_varchar_nokey` = DEFAULT ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1208 CON_ID 14 */ 2018-12-11 2:00:16 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `D` SET `col_varchar_nokey` = 'online' ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1219 CON_ID 14 */ 2018-12-11 2:00:16 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `CC` SET `col_time_key` = 165 ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1163 CON_ID 18 */ 2018-12-11 2:00:16 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:16 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `B` SET `col_int_nokey` = '' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1173 CON_ID 16 */ 2018-12-11 2:00:17 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:17 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `BB` SET `col_datetime_nokey` = '' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1601 CON_ID 13 */ 2018-12-11 2:00:17 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:17 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `E` SET `col_int_key` = 'commander' ORDER BY `col_varchar_key` LIMIT 1 /* QNO 1222 CON_ID 18 */ 2018-12-11 2:00:17 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:17 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: DELETE FROM `BB` ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1624 CON_ID 13 */ 2018-12-11 2:00:17 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:17 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `C` SET `pk` = DEFAULT ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1243 CON_ID 16 */ 2018-12-11 2:00:17 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:17 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: DELETE FROM `E` ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1316 CON_ID 14 */ 2018-12-11 2:00:17 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:17 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: DELETE FROM `DD` ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1252 CON_ID 18 */ 2018-12-11 2:00:17 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:17 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `CC` SET `pk` = DEFAULT ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1448 CON_ID 15 */ 2018-12-11 2:00:17 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:17 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `D` SET `pk` = NULL ORDER BY `col_time_key` LIMIT 1 /* QNO 1677 CON_ID 13 */ 2018-12-11 2:00:17 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:17 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `BB` SET `col_int_nokey` = NULL ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1370 CON_ID 14 */ 2018-12-11 2:00:17 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:17 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `D` SET `col_int_key` = NULL ORDER BY `col_varchar_key` LIMIT 1 /* QNO 1300 CON_ID 18 */ 2018-12-11 2:00:17 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:17 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `AA` SET `col_varchar_key` = 141 ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1162 CON_ID 17 */ 2018-12-11 2:00:18 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: DELETE FROM `DD` ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1376 CON_ID 16 */ 2018-12-11 2:00:18 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `A` SET `col_date_nokey` = NULL ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1417 CON_ID 14 */ 2018-12-11 2:00:18 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `E` SET `col_date_nokey` = 'dangerous' ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1407 CON_ID 16 */ 2018-12-11 2:00:18 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `E` SET `col_varchar_nokey` = 'q' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1761 CON_ID 13 */ 2018-12-11 2:00:18 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `E` SET `pk` = NULL ORDER BY `col_date_key` LIMIT 1 /* QNO 1368 CON_ID 18 */ 2018-12-11 2:00:18 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `D` SET `col_date_nokey` = 'k' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1377 CON_ID 18 */ 2018-12-11 2:00:18 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `BB` SET `col_int_nokey` = 'p' ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1573 CON_ID 15 */ 2018-12-11 2:00:18 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `AA` SET `pk` = 'plus' ORDER BY `col_date_key` LIMIT 1 /* QNO 1247 CON_ID 17 */ 2018-12-11 2:00:18 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `AA` SET `col_int_key` = 'x' ORDER BY `col_varchar_key` LIMIT 1 /* QNO 1250 CON_ID 17 */ 2018-12-11 2:00:18 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `CC` SET `col_time_nokey` = 'cheese' ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1470 CON_ID 14 */ 2018-12-11 2:00:18 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `D` SET `col_int_nokey` = 'k' ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1396 CON_ID 18 */ 2018-12-11 2:00:18 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `D` SET `col_varchar_nokey` = 'butterfly' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1263 CON_ID 17 */ 2018-12-11 2:00:18 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `E` SET `col_time_nokey` = 't' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1490 CON_ID 14 */ 2018-12-11 2:00:18 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `CC` SET `col_varchar_key` = 'exotic' ORDER BY `col_varchar_key` LIMIT 1 /* QNO 1438 CON_ID 18 */ 2018-12-11 2:00:18 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: DELETE FROM `C` ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1478 CON_ID 16 */ 2018-12-11 2:00:18 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `CC` SET `col_datetime_key` = 'article' ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1493 CON_ID 14 */ 2018-12-11 2:00:18 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `E` SET `col_datetime_nokey` = '' ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1443 CON_ID 18 */ 2018-12-11 2:00:18 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `DD` SET `col_date_key` = DEFAULT ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1494 CON_ID 16 */ 2018-12-11 2:00:18 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `BB` SET `pk` = DEFAULT ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1310 CON_ID 17 */ 2018-12-11 2:00:18 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `AA` SET `col_datetime_key` = NULL ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1536 CON_ID 16 */ 2018-12-11 2:00:18 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `B` SET `pk` = '' ORDER BY `col_int_key` LIMIT 1 /* QNO 1665 CON_ID 15 */ 2018-12-11 2:00:18 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:18 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `A` SET `pk` = NULL ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1348 CON_ID 17 */ 2018-12-11 2:00:19 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `E` SET `col_datetime_nokey` = '' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1509 CON_ID 18 */ 2018-12-11 2:00:19 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `B` SET `col_time_key` = 80 ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1570 CON_ID 14 */ 2018-12-11 2:00:19 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: UPDATE IGNORE `A` SET `col_datetime_key` = NULL ORDER BY `col_time_nokey` LIMIT 1 /* QNO 1875 CON_ID 13 */ 2018-12-11 2:00:19 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `D` SET `col_time_key` = NULL ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1642 CON_ID 16 */ 2018-12-11 2:00:19 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `D` SET `pk` = DEFAULT ORDER BY `col_datetime_key` LIMIT 1 /* QNO 1645 CON_ID 16 */ 2018-12-11 2:00:19 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `DD` SET `col_datetime_key` = NULL ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1755 CON_ID 15 */ 2018-12-11 2:00:19 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE IGNORE `DD` SET `col_time_key` = DEFAULT ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1585 CON_ID 18 */ 2018-12-11 2:00:19 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 13 [Warning] Sort aborted, host: localhost, user: rqg, thread: 13, query: DELETE FROM `DD` ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1955 CON_ID 13 */ 2018-12-11 2:00:19 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `DD` SET `col_date_key` = DEFAULT ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1670 CON_ID 14 */ 2018-12-11 2:00:19 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `CC` SET `col_int_key` = 'j' ORDER BY `col_int_nokey` LIMIT 1 /* QNO 1679 CON_ID 14 */ 2018-12-11 2:00:19 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 14 [Warning] Sort aborted, host: localhost, user: rqg, thread: 14, query: UPDATE IGNORE `E` SET `pk` = 'z' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1696 CON_ID 14 */ 2018-12-11 2:00:19 15 [Warning] Sort aborted, host: localhost, user: rqg, thread: 15, query: UPDATE IGNORE `E` SET `col_datetime_nokey` = '' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1812 CON_ID 15 */ 2018-12-11 2:00:19 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `E` SET `col_datetime_nokey` = NULL ORDER BY `col_date_nokey` LIMIT 1 /* QNO 1433 CON_ID 17 */ 2018-12-11 2:00:19 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: UPDATE IGNORE `BB` SET `pk` = '' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 1450 CON_ID 17 */ 2018-12-11 2:00:19 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2018-12-11 2:00:19 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: UPDATE IGNORE `E` SET `col_varchar_nokey` = '' ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 1735 CON_ID 16 */ mysqld: /data/src/10.4/storage/innobase/lock/lock0lock.cc:5501: my_bool lock_rec_other_trx_holds_expl_callback(rw_trx_hash_element_t*, lock_rec_other_trx_holds_expl_arg*): Assertion `!expl_lock || expl_lock->trx == arg->impl_trx' failed. 181211 2:00:20 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.4.1-MariaDB-debug-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=7 max_threads=153 thread_count=13 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467560 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f2370000b00 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f23dcf66ec0 thread_stack 0x49000 mysys/stacktrace.c:269(my_print_stacktrace)[0x55b6f8cee9c9] sql/signal_handler.cc:168(handle_fatal_signal)[0x55b6f8539350] /lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f23f652b0c0] linux/raise.c:51(__GI_raise)[0x7f23f4a6cfcf] stdlib/abort.c:91(__GI_abort)[0x7f23f4a6e3fa] assert/assert.c:92(__assert_fail_base)[0x7f23f4a65e37] /lib/x86_64-linux-gnu/libc.so.6(+0x2bee2)[0x7f23f4a65ee2] lock/lock0lock.cc:5503(lock_rec_other_trx_holds_expl_callback(rw_trx_hash_element_t*, lock_rec_other_trx_holds_expl_arg*))[0x55b6f89020db] include/trx0sys.h:538(rw_trx_hash_t::debug_iterator(rw_trx_hash_element_t*, rw_trx_hash_t::debug_iterator_arg*))[0x55b6f8907a8f] mysys/lf_hash.c:126(l_find)[0x55b6f8cfa196] mysys/lf_hash.c:518(lf_hash_iterate)[0x55b6f8cfae3c] include/trx0sys.h:751(rw_trx_hash_t::iterate(trx_t*, char (*)(void*, void*), void*))[0x55b6f8907d1f] lock/lock0lock.cc:5536(lock_rec_other_trx_holds_expl(trx_t*, trx_t*, unsigned char const*, buf_block_t const*))[0x55b6f89021d1] lock/lock0lock.cc:5604(lock_rec_convert_impl_to_expl(trx_t*, buf_block_t const*, unsigned char const*, dict_index_t*, unsigned long const*))[0x55b6f8902510] lock/lock0lock.cc:5811(lock_sec_rec_read_check_and_lock(unsigned long, buf_block_t const*, unsigned char const*, dict_index_t*, unsigned long const*, lock_mode, unsigned long, que_thr_t*))[0x55b6f89030ff] row/row0sel.cc:1277(sel_set_rec_lock(btr_pcur_t*, unsigned char const*, dict_index_t*, unsigned long const*, unsigned long, unsigned long, que_thr_t*, mtr_t*))[0x55b6f8a04768] row/row0sel.cc:5005(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x55b6f8a0d571] handler/ha_innodb.cc:9273(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x55b6f886f843] handler/ha_innodb.cc:9650(ha_innobase::index_first(unsigned char*))[0x55b6f887069a] sql/handler.cc:2949(handler::ha_index_first(unsigned char*))[0x55b6f854207a] sql/records.cc:397(rr_index_first(READ_RECORD*))[0x55b6f86c7bbc] sql/records.h:73(READ_RECORD::read_record())[0x55b6f818d99d] sql/sql_delete.cc:731(mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List*, unsigned long long, unsigned long long, select_result*))[0x55b6f86e5aa9] sql/sql_parse.cc:4927(mysql_execute_command(THD*))[0x55b6f823139e] sql/sql_parse.cc:8103(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b6f823b3bc] sql/sql_parse.cc:1852(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55b6f82285e6] sql/sql_parse.cc:1395(do_command(THD*))[0x55b6f822700a] sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55b6f8392dd6] sql/sql_connect.cc:1309(handle_one_connection)[0x55b6f8392b5a] nptl/pthread_create.c:333(start_thread)[0x7f23f6521494] x86_64/clone.S:99(clone)[0x7f23f4b2293f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f23700139a8): DELETE FROM `BB` ORDER BY `col_datetime_key` LIMIT 1 /* QNO 1755 CON_ID 16 */ Connection ID (thread ID): 16 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file at /home/travis/logs/vardir/data/ Aborted (core dumped)