2019-01-16 1:16:03 0 [Note] /data/bld/10.3/bin/mysqld (mysqld 10.3.13-MariaDB-debug-log) starting as process 15327 ... 2019-01-16 1:16:03 0 [Note] InnoDB: Using Linux native AIO 2019-01-16 1:16:03 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-01-16 1:16:03 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-01-16 1:16:03 0 [Note] InnoDB: Uses event mutexes 2019-01-16 1:16:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-01-16 1:16:03 0 [Note] InnoDB: Number of pools: 1 2019-01-16 1:16:03 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-01-16 1:16:03 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-01-16 1:16:03 0 [Note] InnoDB: Completed initialization of buffer pool 2019-01-16 1:16:03 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-01-16 1:16:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-01-16 1:16:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-01-16 1:16:03 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-01-16 1:16:03 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-01-16 1:16:03 0 [Note] InnoDB: Waiting for purge to start 2019-01-16 1:16:03 0 [Note] InnoDB: 10.3.13 started; log sequence number 1630815; transaction id 21 2019-01-16 1:16:03 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/vardir/data/ib_buffer_pool 2019-01-16 1:16:03 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-01-16 1:16:03 0 [Note] InnoDB: Buffer pool(s) load completed at 190116 1:16:03 2019-01-16 1:16:03 0 [Note] Server socket created on IP: '::'. 2019-01-16 1:16:03 0 [Note] Reading of all Master_info entries succeded 2019-01-16 1:16:03 0 [Note] Added new Master_info '' to hash table 2019-01-16 1:16:03 0 [Note] /data/bld/10.3/bin/mysqld: ready for connections. Version: '10.3.13-MariaDB-debug-log' socket: '/dev/shm/vardir/mysql.sock' port: 19300 Source distribution 2019-01-16 1:16:04 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:04 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: UPDATE IGNORE `D` SET `col_datetime_key` = 20 ORDER BY `col_datetime_key` LIMIT 1 /* QNO 40 CON_ID 14 */ 2019-01-16 1:16:05 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 16 [Warning] Sort aborted, host: localhost, user: root, thread: 16, query: UPDATE IGNORE `C` SET `col_int_key` = '' ORDER BY `col_int_key` LIMIT 1 /* QNO 57 CON_ID 16 */ 2019-01-16 1:16:05 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 16 [Warning] Sort aborted, host: localhost, user: root, thread: 16, query: UPDATE IGNORE `CC` SET `pk` = '' ORDER BY `col_time_key` LIMIT 1 /* QNO 130 CON_ID 16 */ 2019-01-16 1:16:05 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: UPDATE IGNORE `D` SET `col_varchar_key` = '' ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 218 CON_ID 14 */ 2019-01-16 1:16:05 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: UPDATE IGNORE `B` SET `col_datetime_key` = 250 ORDER BY `col_int_nokey` LIMIT 1 /* QNO 269 CON_ID 14 */ 2019-01-16 1:16:05 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 18 [Warning] Sort aborted, host: localhost, user: root, thread: 18, query: UPDATE IGNORE `CC` SET `col_date_key` = NULL ORDER BY `col_date_nokey` LIMIT 1 /* QNO 57 CON_ID 18 */ 2019-01-16 1:16:05 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 16 [Warning] Sort aborted, host: localhost, user: root, thread: 16, query: UPDATE IGNORE `E` SET `col_int_nokey` = NULL ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 198 CON_ID 16 */ 2019-01-16 1:16:05 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 18 [Warning] Sort aborted, host: localhost, user: root, thread: 18, query: UPDATE IGNORE `E` SET `pk` = '' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 64 CON_ID 18 */ 2019-01-16 1:16:05 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: DELETE FROM `E` ORDER BY `col_time_nokey` LIMIT 1 /* QNO 425 CON_ID 13 */ 2019-01-16 1:16:05 17 [Warning] Sort aborted, host: localhost, user: root, thread: 17, query: UPDATE IGNORE `E` SET `col_varchar_key` = '' ORDER BY `col_varchar_key` LIMIT 1 /* QNO 129 CON_ID 17 */ 2019-01-16 1:16:05 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: UPDATE IGNORE `E` SET `pk` = 'b' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 314 CON_ID 14 */ 2019-01-16 1:16:05 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: UPDATE IGNORE `CC` SET `col_time_key` = '' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 442 CON_ID 13 */ 2019-01-16 1:16:05 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 17 [Warning] Sort aborted, host: localhost, user: root, thread: 17, query: DELETE FROM `B` ORDER BY `col_date_nokey` LIMIT 1 /* QNO 167 CON_ID 17 */ 2019-01-16 1:16:05 21 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 21 [Warning] Sort aborted, host: localhost, user: root, thread: 21, query: UPDATE IGNORE `CC` SET `col_varchar_key` = '' ORDER BY `col_varchar_key` LIMIT 1 /* QNO 40 CON_ID 21 */ 2019-01-16 1:16:05 20 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 20 [Warning] Sort aborted, host: localhost, user: root, thread: 20, query: UPDATE IGNORE `CC` SET `col_date_key` = '' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 88 CON_ID 20 */ 2019-01-16 1:16:05 19 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 19 [Warning] Sort aborted, host: localhost, user: root, thread: 19, query: UPDATE IGNORE `CC` SET `col_int_key` = NULL ORDER BY `col_date_nokey` LIMIT 1 /* QNO 113 CON_ID 19 */ 2019-01-16 1:16:05 22 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 22 [Warning] Sort aborted, host: localhost, user: root, thread: 22, query: UPDATE IGNORE `CC` SET `pk` = DEFAULT ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 57 CON_ID 22 */ 2019-01-16 1:16:05 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: UPDATE IGNORE `CC` SET `col_datetime_key` = 'k' ORDER BY `col_datetime_key` LIMIT 1 /* QNO 440 CON_ID 14 */ 2019-01-16 1:16:05 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 15 [Warning] Sort aborted, host: localhost, user: root, thread: 15, query: UPDATE IGNORE `CC` SET `col_date_key` = DEFAULT ORDER BY `col_date_key` LIMIT 1 /* QNO 243 CON_ID 15 */ 2019-01-16 1:16:05 22 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 22 [Warning] Sort aborted, host: localhost, user: root, thread: 22, query: UPDATE IGNORE `BB` SET `col_varchar_key` = '' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 61 CON_ID 22 */ 2019-01-16 1:16:05 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:05 18 [Warning] Sort aborted, host: localhost, user: root, thread: 18, query: UPDATE IGNORE `B` SET `col_datetime_key` = '' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 193 CON_ID 18 */ 2019-01-16 1:16:06 22 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 22 [Warning] Sort aborted, host: localhost, user: root, thread: 22, query: UPDATE IGNORE `E` SET `col_int_key` = 't' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 112 CON_ID 22 */ 2019-01-16 1:16:06 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 17 [Warning] Sort aborted, host: localhost, user: root, thread: 17, query: UPDATE IGNORE `E` SET `col_int_nokey` = 179 ORDER BY `col_int_nokey` LIMIT 1 /* QNO 209 CON_ID 17 */ 2019-01-16 1:16:06 19 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 19 [Warning] Sort aborted, host: localhost, user: root, thread: 19, query: UPDATE IGNORE `E` SET `col_datetime_nokey` = DEFAULT ORDER BY `col_time_nokey` LIMIT 1 /* QNO 174 CON_ID 19 */ 2019-01-16 1:16:06 20 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 20 [Warning] Sort aborted, host: localhost, user: root, thread: 20, query: UPDATE IGNORE `E` SET `col_int_nokey` = DEFAULT ORDER BY `col_date_nokey` LIMIT 1 /* QNO 137 CON_ID 20 */ 2019-01-16 1:16:06 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 20 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: UPDATE IGNORE `E` SET `pk` = '' ORDER BY `col_varchar_key` LIMIT 1 /* QNO 550 CON_ID 14 */ 2019-01-16 1:16:06 15 [Warning] Sort aborted, host: localhost, user: root, thread: 15, query: UPDATE IGNORE `E` SET `col_int_key` = NULL ORDER BY `col_time_nokey` LIMIT 1 /* QNO 332 CON_ID 15 */ 2019-01-16 1:16:06 20 [Warning] Sort aborted, host: localhost, user: root, thread: 20, query: DELETE FROM `E` ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 171 CON_ID 20 */ 2019-01-16 1:16:06 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 16 [Warning] Sort aborted, host: localhost, user: root, thread: 16, query: DELETE FROM `E` ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 391 CON_ID 16 */ 2019-01-16 1:16:06 22 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 22 [Warning] Sort aborted, host: localhost, user: root, thread: 22, query: UPDATE IGNORE `E` SET `col_int_key` = 'y' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 157 CON_ID 22 */ 2019-01-16 1:16:06 19 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 19 [Warning] Sort aborted, host: localhost, user: root, thread: 19, query: DELETE FROM `C` ORDER BY `col_int_nokey` LIMIT 1 /* QNO 275 CON_ID 19 */ 2019-01-16 1:16:06 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: UPDATE IGNORE `BB` SET `col_time_key` = 'm' ORDER BY `col_time_key` LIMIT 1 /* QNO 643 CON_ID 13 */ 2019-01-16 1:16:06 20 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 20 [Warning] Sort aborted, host: localhost, user: root, thread: 20, query: UPDATE IGNORE `CC` SET `col_int_key` = 'suit' ORDER BY `col_varchar_key` LIMIT 1 /* QNO 212 CON_ID 20 */ 2019-01-16 1:16:06 21 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 21 [Warning] Sort aborted, host: localhost, user: root, thread: 21, query: UPDATE IGNORE `AA` SET `col_time_nokey` = 84 ORDER BY `col_int_nokey` LIMIT 1 /* QNO 143 CON_ID 21 */ 2019-01-16 1:16:06 22 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:06 22 [Warning] Sort aborted, host: localhost, user: root, thread: 22, query: DELETE FROM `CC` ORDER BY `col_int_nokey` LIMIT 1 /* QNO 218 CON_ID 22 */ 2019-01-16 1:16:07 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 22 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: UPDATE IGNORE `B` SET `col_int_key` = 'o' ORDER BY `col_int_key` LIMIT 1 /* QNO 598 CON_ID 14 */ 2019-01-16 1:16:07 22 [Warning] Sort aborted, host: localhost, user: root, thread: 22, query: UPDATE IGNORE `B` SET `col_date_key` = 'x' ORDER BY `col_date_key` LIMIT 1 /* QNO 230 CON_ID 22 */ 2019-01-16 1:16:07 20 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: DELETE FROM `A` ORDER BY `col_date_nokey` LIMIT 1 /* QNO 676 CON_ID 13 */ 2019-01-16 1:16:07 20 [Warning] Sort aborted, host: localhost, user: root, thread: 20, query: UPDATE IGNORE `A` SET `col_date_nokey` = NULL ORDER BY `col_int_nokey` LIMIT 1 /* QNO 235 CON_ID 20 */ 2019-01-16 1:16:07 19 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 19 [Warning] Sort aborted, host: localhost, user: root, thread: 19, query: DELETE FROM `C` ORDER BY `col_time_nokey` LIMIT 1 /* QNO 329 CON_ID 19 */ 2019-01-16 1:16:07 22 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 22 [Warning] Sort aborted, host: localhost, user: root, thread: 22, query: UPDATE IGNORE `DD` SET `col_int_key` = DEFAULT ORDER BY `col_varchar_key` LIMIT 1 /* QNO 233 CON_ID 22 */ 2019-01-16 1:16:07 21 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 21 [Warning] Sort aborted, host: localhost, user: root, thread: 21, query: UPDATE IGNORE `B` SET `col_time_nokey` = 'versus' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 187 CON_ID 21 */ 2019-01-16 1:16:07 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: UPDATE IGNORE `A` SET `col_varchar_nokey` = DEFAULT ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 621 CON_ID 14 */ 2019-01-16 1:16:07 20 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 20 [Warning] Sort aborted, host: localhost, user: root, thread: 20, query: UPDATE IGNORE `B` SET `col_int_nokey` = 'j' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 282 CON_ID 20 */ 2019-01-16 1:16:07 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: UPDATE IGNORE `C` SET `col_int_nokey` = 93 ORDER BY `col_date_nokey` LIMIT 1 /* QNO 698 CON_ID 13 */ 2019-01-16 1:16:07 17 [Warning] Sort aborted, host: localhost, user: root, thread: 17, query: UPDATE IGNORE `C` SET `col_time_key` = 'f' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 359 CON_ID 17 */ 2019-01-16 1:16:07 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: UPDATE IGNORE `E` SET `col_date_key` = '' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 704 CON_ID 13 */ 2019-01-16 1:16:07 21 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 21 [Warning] Sort aborted, host: localhost, user: root, thread: 21, query: DELETE FROM `DD` ORDER BY `col_int_nokey` LIMIT 1 /* QNO 209 CON_ID 21 */ 2019-01-16 1:16:07 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: UPDATE IGNORE `DD` SET `col_varchar_key` = 'o' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 710 CON_ID 13 */ 2019-01-16 1:16:07 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: DELETE FROM `C` ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 649 CON_ID 14 */ 2019-01-16 1:16:07 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: UPDATE IGNORE `E` SET `col_datetime_key` = 'x' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 760 CON_ID 13 */ 2019-01-16 1:16:07 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: UPDATE IGNORE `E` SET `pk` = DEFAULT ORDER BY `col_date_nokey` LIMIT 1 /* QNO 650 CON_ID 14 */ 2019-01-16 1:16:07 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 15 [Warning] Sort aborted, host: localhost, user: root, thread: 15, query: UPDATE IGNORE `E` SET `col_varchar_nokey` = 245 ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 470 CON_ID 15 */ 2019-01-16 1:16:07 22 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 22 [Warning] Sort aborted, host: localhost, user: root, thread: 22, query: UPDATE IGNORE `E` SET `pk` = 'l' ORDER BY `col_time_key` LIMIT 1 /* QNO 269 CON_ID 22 */ 2019-01-16 1:16:07 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 16 [Warning] Sort aborted, host: localhost, user: root, thread: 16, query: UPDATE IGNORE `E` SET `col_date_key` = 'interest' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 510 CON_ID 16 */ 2019-01-16 1:16:07 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 18 [Warning] Sort aborted, host: localhost, user: root, thread: 18, query: UPDATE IGNORE `E` SET `col_time_key` = DEFAULT ORDER BY `col_time_nokey` LIMIT 1 /* QNO 351 CON_ID 18 */ 2019-01-16 1:16:07 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 17 [Warning] Sort aborted, host: localhost, user: root, thread: 17, query: UPDATE IGNORE `E` SET `col_date_key` = DEFAULT ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 378 CON_ID 17 */ 2019-01-16 1:16:07 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 17 [Warning] Sort aborted, host: localhost, user: root, thread: 17, query: UPDATE IGNORE `B` SET `col_datetime_key` = NULL ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 401 CON_ID 17 */ 2019-01-16 1:16:07 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: DELETE FROM `B` ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 675 CON_ID 14 */ 2019-01-16 1:16:07 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 18 [Warning] Sort aborted, host: localhost, user: root, thread: 18, query: UPDATE IGNORE `B` SET `col_date_key` = '' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 369 CON_ID 18 */ 2019-01-16 1:16:07 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 15 [Warning] Sort aborted, host: localhost, user: root, thread: 15, query: UPDATE IGNORE `B` SET `col_varchar_key` = 82 ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 492 CON_ID 15 */ 2019-01-16 1:16:07 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: DELETE FROM `AA` ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 794 CON_ID 13 */ 2019-01-16 1:16:07 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: UPDATE IGNORE `CC` SET `pk` = NULL ORDER BY `col_datetime_key` LIMIT 1 /* QNO 834 CON_ID 13 */ 2019-01-16 1:16:07 20 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:07 20 [Warning] Sort aborted, host: localhost, user: root, thread: 20, query: UPDATE IGNORE `C` SET `col_varchar_key` = '' ORDER BY `col_varchar_key` LIMIT 1 /* QNO 379 CON_ID 20 */ 2019-01-16 1:16:08 22 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 22 [Warning] Sort aborted, host: localhost, user: root, thread: 22, query: DELETE FROM `AA` ORDER BY `col_time_nokey` LIMIT 1 /* QNO 358 CON_ID 22 */ 2019-01-16 1:16:08 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: UPDATE IGNORE `DD` SET `col_datetime_key` = DEFAULT ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 846 CON_ID 13 */ 2019-01-16 1:16:08 20 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 20 [Warning] Sort aborted, host: localhost, user: root, thread: 20, query: UPDATE IGNORE `A` SET `col_datetime_nokey` = 13 ORDER BY `col_time_nokey` LIMIT 1 /* QNO 423 CON_ID 20 */ 2019-01-16 1:16:08 18 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 18 [Warning] Sort aborted, host: localhost, user: root, thread: 18, query: UPDATE IGNORE `DD` SET `col_int_key` = DEFAULT ORDER BY `col_int_key` LIMIT 1 /* QNO 436 CON_ID 18 */ 2019-01-16 1:16:08 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 15 [Warning] Sort aborted, host: localhost, user: root, thread: 15, query: UPDATE IGNORE `D` SET `col_varchar_nokey` = '' ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 600 CON_ID 15 */ 2019-01-16 1:16:08 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: UPDATE IGNORE `E` SET `col_date_nokey` = '' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 817 CON_ID 14 */ 2019-01-16 1:16:08 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: UPDATE IGNORE `E` SET `col_varchar_nokey` = 'vehicle' ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 862 CON_ID 13 */ 2019-01-16 1:16:08 20 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 20 [Warning] Sort aborted, host: localhost, user: root, thread: 20, query: DELETE FROM `CC` ORDER BY `col_int_nokey` LIMIT 1 /* QNO 432 CON_ID 20 */ 2019-01-16 1:16:08 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: UPDATE IGNORE `CC` SET `col_datetime_nokey` = 'h' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 831 CON_ID 14 */ 2019-01-16 1:16:08 19 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 19 [Warning] Sort aborted, host: localhost, user: root, thread: 19, query: UPDATE IGNORE `C` SET `col_int_key` = 'i' ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 544 CON_ID 19 */ 2019-01-16 1:16:08 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 15 [Warning] Sort aborted, host: localhost, user: root, thread: 15, query: UPDATE IGNORE `CC` SET `col_int_key` = 'apologize' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 628 CON_ID 15 */ 2019-01-16 1:16:08 20 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 20 [Warning] Sort aborted, host: localhost, user: root, thread: 20, query: UPDATE IGNORE `B` SET `col_varchar_key` = 'delivery' ORDER BY `col_date_nokey` LIMIT 1 /* QNO 441 CON_ID 20 */ 2019-01-16 1:16:08 21 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 21 [Warning] Sort aborted, host: localhost, user: root, thread: 21, query: UPDATE IGNORE `E` SET `col_date_nokey` = NULL ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 434 CON_ID 21 */ 2019-01-16 1:16:08 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: UPDATE IGNORE `E` SET `col_date_key` = 'm' ORDER BY `col_date_key` LIMIT 1 /* QNO 883 CON_ID 13 */ 2019-01-16 1:16:08 16 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 16 [Warning] Sort aborted, host: localhost, user: root, thread: 16, query: DELETE FROM `BB` ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 648 CON_ID 16 */ 2019-01-16 1:16:08 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:08 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: UPDATE IGNORE `D` SET `col_date_nokey` = 'a' ORDER BY `col_datetime_nokey` LIMIT 1 /* QNO 893 CON_ID 13 */ 2019-01-16 1:16:09 21 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:09 21 [Warning] Sort aborted, host: localhost, user: root, thread: 21, query: UPDATE IGNORE `DD` SET `col_int_nokey` = 'v' ORDER BY `col_int_nokey` LIMIT 1 /* QNO 503 CON_ID 21 */ 2019-01-16 1:16:09 17 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:09 17 [Warning] Sort aborted, host: localhost, user: root, thread: 17, query: UPDATE IGNORE `DD` SET `col_int_key` = 'professional' ORDER BY `col_varchar_key` LIMIT 1 /* QNO 638 CON_ID 17 */ 2019-01-16 1:16:09 14 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:09 14 [Warning] Sort aborted, host: localhost, user: root, thread: 14, query: UPDATE IGNORE `DD` SET `col_int_nokey` = 'treasure' ORDER BY `col_time_nokey` LIMIT 1 /* QNO 922 CON_ID 14 */ 2019-01-16 1:16:09 21 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:09 21 [Warning] Sort aborted, host: localhost, user: root, thread: 21, query: DELETE FROM `E` ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 506 CON_ID 21 */ 2019-01-16 1:16:09 13 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:09 13 [Warning] Sort aborted, host: localhost, user: root, thread: 13, query: DELETE FROM `E` ORDER BY `col_time_nokey` LIMIT 1 /* QNO 956 CON_ID 13 */ 2019-01-16 1:16:09 15 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction 2019-01-16 1:16:09 15 [Warning] Sort aborted, host: localhost, user: root, thread: 15, query: UPDATE IGNORE `E` SET `col_time_key` = 'up' ORDER BY `col_varchar_nokey` LIMIT 1 /* QNO 742 CON_ID 15 */ mysqld: /data/src/10.3/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. 190116 1:16:09 [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.3.13-MariaDB-debug-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=11 max_threads=153 thread_count=17 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467474 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f9020000b00 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 = 0x7f9084203ec0 thread_stack 0x49000 mysys/stacktrace.c:269(my_print_stacktrace)[0x55d2ded3bed9] sql/signal_handler.cc:168(handle_fatal_signal)[0x55d2de590eb4] /lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f90b0c1c0c0] linux/raise.c:51(__GI_raise)[0x7f90aef42fcf] stdlib/abort.c:91(__GI_abort)[0x7f90aef443fa] assert/assert.c:92(__assert_fail_base)[0x7f90aef3be37] /lib/x86_64-linux-gnu/libc.so.6(+0x2bee2)[0x7f90aef3bee2] lock/lock0lock.cc:5503(lock_rec_other_trx_holds_expl_callback(rw_trx_hash_element_t*, lock_rec_other_trx_holds_expl_arg*))[0x55d2de943066] include/trx0sys.h:538(rw_trx_hash_t::debug_iterator(rw_trx_hash_element_t*, rw_trx_hash_t::debug_iterator_arg*))[0x55d2de9488e1] mysys/lf_hash.c:126(l_find)[0x55d2ded476a6] mysys/lf_hash.c:518(lf_hash_iterate)[0x55d2ded4834c] include/trx0sys.h:751(rw_trx_hash_t::iterate(trx_t*, char (*)(void*, void*), void*))[0x55d2de948b71] lock/lock0lock.cc:5536(lock_rec_other_trx_holds_expl(trx_t*, trx_t*, unsigned char const*, buf_block_t const*))[0x55d2de94315c] 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*))[0x55d2de9434a1] 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*))[0x55d2de9440a2] 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*))[0x55d2dea43fb4] row/row0sel.cc:5043(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x55d2dea4d091] handler/ha_innodb.cc:9268(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x55d2de8ba24d] handler/ha_innodb.cc:9643(ha_innobase::index_first(unsigned char*))[0x55d2de8bb0ae] sql/handler.cc:2914(handler::ha_index_first(unsigned char*))[0x55d2de599984] sql/records.cc:397(rr_index_first(READ_RECORD*))[0x55d2de719976] sql/records.h:73(READ_RECORD::read_record())[0x55d2de20174d] sql/sql_update.cc:739(mysql_update(THD*, TABLE_LIST*, List&, List&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*))[0x55d2de395017] sql/sql_parse.cc:4581(mysql_execute_command(THD*))[0x55d2de29d24d] sql/sql_parse.cc:8092(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55d2de2a8669] sql/sql_parse.cc:1853(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55d2de29581d] sql/sql_parse.cc:1396(do_command(THD*))[0x55d2de294241] sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55d2de3fc256] sql/sql_connect.cc:1309(handle_one_connection)[0x55d2de3fbfda] nptl/pthread_create.c:333(start_thread)[0x7f90b0c12494] x86_64/clone.S:99(clone)[0x7f90aeff893f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f90200138a8): UPDATE IGNORE `B` SET `col_varchar_key` = 'answer' ORDER BY `col_date_key` LIMIT 1 /* QNO 754 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 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 /dev/shm/vardir/data/ Aborted (core dumped)