Logging: /home/mleich/Server/10.4/mysql-test/mysql-test-run.pl --mem MDEV-20117 vardir: /home/mleich/Server/10.4/bld_debug/mysql-test/var Removing old var directory... Creating var directory '/home/mleich/Server/10.4/bld_debug/mysql-test/var'... - symlinking 'var' to '/dev/shm/var_auto_nVw5' Checking supported features... MariaDB Version 10.4.7-MariaDB-debug - SSL connections supported - binaries are debug compiled - binaries built with wsrep patch Collecting tests... Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 main.MDEV-20117 'innodb' [ fail ] Test ended at 2019-07-24 11:44:39 CURRENT_TEST: main.MDEV-20117 Server [mysqld.1 - pid: 11080, winpid: 11080, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2019-07-24 11:42:23 0 [Note] /home/mleich/Server/10.4/bld_debug/sql/mysqld (mysqld 10.4.7-MariaDB-debug-log) starting as process 11081 ... 2019-07-24 11:42:23 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4190) 2019-07-24 11:42:23 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) 2019-07-24 11:42:23 0 [Note] Plugin 'partition' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'SEQUENCE' is disabled. 2019-07-24 11:42:23 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-07-24 11:42:23 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-07-24 11:42:23 0 [Note] InnoDB: Uses event mutexes 2019-07-24 11:42:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-07-24 11:42:23 0 [Note] InnoDB: Number of pools: 1 2019-07-24 11:42:23 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-07-24 11:42:23 0 [Note] mysqld: O_TMPFILE is not supported on /home/mleich/Server/10.4/bld_debug/mysql-test/var/tmp/mysqld.1 (disabling future attempts) 2019-07-24 11:42:23 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M 2019-07-24 11:42:23 0 [Note] InnoDB: Completed initialization of buffer pool 2019-07-24 11:42:23 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-07-24 11:42:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-07-24 11:42:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-07-24 11:42:23 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-24 11:42:23 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-07-24 11:42:23 0 [Note] InnoDB: Waiting for purge to start 2019-07-24 11:42:23 0 [Note] InnoDB: 10.4.7 started; log sequence number 151269; transaction id 34 2019-07-24 11:42:23 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var_auto_nVw5/mysqld.1/data/ib_buffer_pool 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_CMP' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2019-07-24 11:42:23 0 [Note] InnoDB: Buffer pool(s) load completed at 190724 11:42:23 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'user_variables' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2019-07-24 11:42:23 0 [Note] Plugin 'unix_socket' is disabled. 2019-07-24 11:42:23 0 [Warning] /home/mleich/Server/10.4/bld_debug/sql/mysqld: unknown option '--loose-pam-debug' 2019-07-24 11:42:23 0 [Warning] /home/mleich/Server/10.4/bld_debug/sql/mysqld: unknown option '--loose-aria' 2019-07-24 11:42:23 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-07-24 11:42:23 0 [Note] Reading of all Master_info entries succeeded 2019-07-24 11:42:23 0 [Note] Added new Master_info '' to hash table 2019-07-24 11:42:23 0 [Note] /home/mleich/Server/10.4/bld_debug/sql/mysqld: ready for connections. Version: '10.4.7-MariaDB-debug-log' socket: '/home/mleich/Server/10.4/bld_debug/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution 2019-07-24 11:44:38 4 [ERROR] InnoDB: Trying to access update undo rec field 17 in index `PRIMARY` of table `test`.`t1` but index has only 8 fields Submit a detailed bug report to https://jira.mariadb.org/. Run also CHECK TABLE `test`.`t1`. n_fields = 3, i = 2 mysqld: /home/mleich/Server/10.4/storage/innobase/trx/trx0rec.cc:1682: byte* trx_undo_update_rec_get_update(const byte*, dict_index_t*, ulint, trx_id_t, roll_ptr_t, ulint, mem_heap_t*, upd_t**): Assertion `0' failed. 190724 11:44:38 [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.7-MariaDB-debug-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=6 max_threads=153 thread_count=12 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63616 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f8050000ce8 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 = 0x7f80697f9e88 thread_stack 0x49000 /home/mleich/Server/10.4/bld_debug/sql/mysqld(my_print_stacktrace+0x40)[0x556549851f45] mysys/stacktrace.c:269(my_print_stacktrace)[0x556548fd9b05] /lib/x86_64-linux-gnu/libpthread.so.0(+0x13150)[0x7f809e486150] linux/raise.c:51(__GI_raise)[0x7f809d5d30bb] stdlib/abort.c:92(__GI_abort)[0x7f809d5d4f5d] assert/assert.c:92(__assert_fail_base)[0x7f809d5caf17] /lib/x86_64-linux-gnu/libc.so.6(+0x2efc2)[0x7f809d5cafc2] /home/mleich/Server/10.4/bld_debug/sql/mysqld(+0xf6ca5d)[0x556549413a5d] trx/trx0rec.cc:1687(trx_undo_update_rec_get_update(unsigned char const*, dict_index_t*, unsigned long, unsigned long, unsigned long, unsigned long, mem_block_info_t*, upd_t**))[0x55654939c0bc] row/row0purge.cc:1147(row_purge_parse_undo_rec(purge_node_t*, unsigned char*, bool*, que_thr_t*))[0x55654939c637] row/row0purge.cc:1259(row_purge(purge_node_t*, unsigned char*, que_thr_t*))[0x55654939c854] row/row0purge.cc:1323(row_purge_step(que_thr_t*))[0x55654931fe2e] que/que0que.cc:1042(que_thr_step(que_thr_t*))[0x556549320062] que/que0que.cc:1104(que_run_threads_low(que_thr_t*))[0x556549320252] que/que0que.cc:1146(que_run_threads(que_thr_t*))[0x5565493daacc] srv/srv0srv.cc:2463(srv_task_execute())[0x5565493dac76] nptl/pthread_create.c:465(start_thread)[0x7f809e47a7fc] x86_64/clone.S:97(clone)[0x7f809d6b0b5f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x0): Connection ID (thread ID): 4 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=on,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,rowid_filter=on,condition_pushdown_from_having=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... Working directory at /dev/shm/var_auto_nVw5/mysqld.1/data Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 8388608 unlimited bytes Max core file size unlimited unlimited bytes Max resident set unlimited unlimited bytes Max processes 127733 127733 processes Max open files 1024 1024 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 127733 127733 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: core ----------SERVER LOG END------------- mysqltest failed but provided no output - found 'core' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace from coredump /home/mleich/Server/10.4/bld_debug/mysql-test/var/log/main.MDEV-20117-innodb/mysqld.1/data/core Core generated by '/home/mleich/Server/10.4/bld_debug/sql/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New LWP 11101] [New LWP 11087] [New LWP 11083] [New LWP 11082] [New LWP 11085] [New LWP 11088] [New LWP 11103] [New LWP 11095] [New LWP 11089] [New LWP 11092] [New LWP 11105] [New LWP 11090] [New LWP 11104] [New LWP 11094] [New LWP 11096] [New LWP 11093] [New LWP 11086] [New LWP 11084] [New LWP 11106] [New LWP 11081] [New LWP 11098] [New LWP 11102] [New LWP 11107] [New LWP 11097] [New LWP 12063] [New LWP 12065] [New LWP 11110] [New LWP 12066] [New LWP 11100] [New LWP 11099] [New LWP 12062] [New LWP 12064] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". Core was generated by `/home/mleich/Server/10.4/bld_debug/sql/mysqld --defaults-group-suffix=.1 --defa'. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 57 ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory. [Current thread is 1 (Thread 0x7f80697fa700 (LWP 11101))] #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x0000556549852037 in my_write_core (sig=6) at /home/mleich/Server/10.4/mysys/stacktrace.c:481 #2 0x0000556548fd9e8f in handle_fatal_signal (sig=6) at /home/mleich/Server/10.4/sql/signal_handler.cc:343 #3 #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51 #5 0x00007f809d5d4f5d in __GI_abort () at abort.c:90 #6 0x00007f809d5caf17 in __assert_fail_base (fmt=, assertion=assertion@entry=0x556549bca1b1 "0", file=file@entry=0x556549bcb7e8 "/home/mleich/Server/10.4/storage/innobase/trx/trx0rec.cc", line=line@entry=1682, function=function@entry=0x556549bcdd00 "byte* trx_undo_update_rec_get_update(const byte*, dict_index_t*, ulint, trx_id_t, roll_ptr_t, ulint, mem_heap_t*, upd_t**)") at assert.c:92 #7 0x00007f809d5cafc2 in __GI___assert_fail (assertion=0x556549bca1b1 "0", file=0x556549bcb7e8 "/home/mleich/Server/10.4/storage/innobase/trx/trx0rec.cc", line=1682, function=0x556549bcdd00 "byte* trx_undo_update_rec_get_update(const byte*, dict_index_t*, ulint, trx_id_t, roll_ptr_t, ulint, mem_heap_t*, upd_t**)") at assert.c:101 #8 0x0000556549413a5d in trx_undo_update_rec_get_update (ptr=0x55654befafae "\004\200", index=0x7f803412f668, type=13, trx_id=283649, roll_ptr=19421773415590343, info_bits=32, heap=0x55654befaef0, upd=0x55654befaa50) at /home/mleich/Server/10.4/storage/innobase/trx/trx0rec.cc:1682 #9 0x000055654939c0bc in row_purge_parse_undo_rec (node=0x55654befa9d8, undo_rec=0x55654befaf88 "", updated_extern=0x7f80697f9dde, thr=0x55654befa808) at /home/mleich/Server/10.4/storage/innobase/row/row0purge.cc:1147 #10 0x000055654939c637 in row_purge (node=0x55654befa9d8, undo_rec=0x55654befaf88 "", thr=0x55654befa808) at /home/mleich/Server/10.4/storage/innobase/row/row0purge.cc:1259 #11 0x000055654939c854 in row_purge_step (thr=0x55654befa808) at /home/mleich/Server/10.4/storage/innobase/row/row0purge.cc:1321 #12 0x000055654931fe2e in que_thr_step (thr=0x55654befa808) at /home/mleich/Server/10.4/storage/innobase/que/que0que.cc:1042 #13 0x0000556549320062 in que_run_threads_low (thr=0x55654befa808) at /home/mleich/Server/10.4/storage/innobase/que/que0que.cc:1104 #14 0x0000556549320252 in que_run_threads (thr=0x55654befa808) at /home/mleich/Server/10.4/storage/innobase/que/que0que.cc:1144 #15 0x00005565493daacc in srv_task_execute () at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:2462 #16 0x00005565493dac76 in srv_worker_thread (arg=0x0) at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:2510 #17 0x00007f809e47a7fc in start_thread (arg=0x7f80697fa700) at pthread_create.c:465 #18 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 32 (Thread 0x7f809288b700 (LWP 12064)): #0 0x00007f809e481786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f80928889a0, expected=0, futex_word=0x7f8020000ee0) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f80928889a0, mutex=0x7f8020000e30, cond=0x7f8020000eb8) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x7f8020000eb8, mutex=0x7f8020000e30, abstime=0x7f80928889a0) at pthread_cond_wait.c:667 #3 0x0000556549857b27 in safe_cond_timedwait (cond=0x7f8020000eb8, mp=0x7f8020000e08, abstime=0x7f80928889a0, file=0x556549963b80 "/home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h", line=1204) at /home/mleich/Server/10.4/mysys/thr_mutex.c:546 #4 0x0000556548e1f670 in inline_mysql_cond_timedwait (that=0x7f8020000eb8, mutex=0x7f8020000e08, abstime=0x7f80928889a0, src_file=0x5565499641c0 "/home/mleich/Server/10.4/sql/mdl.cc", src_line=1148) at /home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h:1204 #5 0x0000556548e20ab2 in MDL_wait::timed_wait (this=0x7f8020000e08, owner=0x7f8020000db8, abs_timeout=0x7f80928889a0, set_status_on_timeout=false, wait_state_name=0x55654a3bdef0 ) at /home/mleich/Server/10.4/sql/mdl.cc:1147 #6 0x0000556548e22736 in MDL_context::acquire_lock (this=0x7f8020000e08, mdl_request=0x7f8020011978, lock_wait_timeout=86400) at /home/mleich/Server/10.4/sql/mdl.cc:2325 #7 0x0000556548c03557 in open_table_get_mdl_lock (thd=0x7f8020000ce8, ot_ctx=0x7f8092889060, mdl_request=0x7f8020011978, flags=0, mdl_ticket=0x7f8092888c90) at /home/mleich/Server/10.4/sql/sql_base.cc:1648 #8 0x0000556548c03de8 in open_table (thd=0x7f8020000ce8, table_list=0x7f8020011538, ot_ctx=0x7f8092889060) at /home/mleich/Server/10.4/sql/sql_base.cc:1907 #9 0x0000556548c079f9 in open_and_process_table (thd=0x7f8020000ce8, tables=0x7f8020011538, counter=0x7f809288917c, flags=0, prelocking_strategy=0x7f80928890e8, has_prelocking_list=false, ot_ctx=0x7f8092889060) at /home/mleich/Server/10.4/sql/sql_base.cc:3841 #10 0x0000556548c08da4 in open_tables (thd=0x7f8020000ce8, options=..., start=0x7f8092889150, counter=0x7f809288917c, flags=0, prelocking_strategy=0x7f80928890e8) at /home/mleich/Server/10.4/sql/sql_base.cc:4339 #11 0x0000556548bf872a in open_tables (thd=0x7f8020000ce8, tables=0x7f8092889150, counter=0x7f809288917c, flags=0) at /home/mleich/Server/10.4/sql/sql_base.h:474 #12 0x0000556548da66a8 in mysql_update (thd=0x7f8020000ce8, table_list=0x7f8020011538, fields=..., values=..., conds=0x0, order_num=0, order=0x0, limit=2, ignore=false, found_return=0x7f8092889850, updated_return=0x7f8092889910) at /home/mleich/Server/10.4/sql/sql_update.cc:392 #13 0x0000556548ca3cbf in mysql_execute_command (thd=0x7f8020000ce8) at /home/mleich/Server/10.4/sql/sql_parse.cc:4369 #14 0x0000556548cb0321 in mysql_parse (thd=0x7f8020000ce8, rawbuf=0x7f8020011450 "UPDATE t1 SET col1 = 6 LIMIT 2", length=30, parser_state=0x7f809288a170, is_com_multi=false, is_next_command=false) at /home/mleich/Server/10.4/sql/sql_parse.cc:7908 #15 0x0000556548c9c5b5 in dispatch_command (command=COM_QUERY, thd=0x7f8020000ce8, packet=0x7f8020008119 "UPDATE t1 SET col1 = 6 LIMIT 2 ", packet_length=31, is_com_multi=false, is_next_command=false) at /home/mleich/Server/10.4/sql/sql_parse.cc:1842 #16 0x0000556548c9acfa in do_command (thd=0x7f8020000ce8) at /home/mleich/Server/10.4/sql/sql_parse.cc:1359 #17 0x0000556548e13d16 in do_handle_one_connection (connect=0x55654bf29fa8) at /home/mleich/Server/10.4/sql/sql_connect.cc:1404 #18 0x0000556548e13a65 in handle_one_connection (arg=0x55654bf29fa8) at /home/mleich/Server/10.4/sql/sql_connect.cc:1306 #19 0x000055654973d4e4 in pfs_spawn_thread (arg=0x55654bf2a208) at /home/mleich/Server/10.4/storage/perfschema/pfs.cc:1862 #20 0x00007f809e47a7fc in start_thread (arg=0x7f809288b700) at pthread_create.c:465 #21 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 31 (Thread 0x7f809291f700 (LWP 12062)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55654beed268) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55654beed218, cond=0x55654beed240) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55654beed240, mutex=0x55654beed218) at pthread_cond_wait.c:655 #3 0x00005565492ed226 in os_event::wait (this=0x55654beed200) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:159 #4 0x00005565492eccbe in os_event::wait_low (this=0x55654beed200, reset_sig_count=1545) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:326 #5 0x00005565492ed014 in os_event_wait_low (event=0x55654beed200, reset_sig_count=1545) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:515 #6 0x00005565493e5398 in sync_array_wait_event (arr=0x55654bcb3310, cell=@0x7f8092918958: 0x55654bcb3500) at /home/mleich/Server/10.4/storage/innobase/sync/sync0arr.cc:469 #7 0x00005565493e8398 in rw_lock_x_lock_wait_func (lock=0x55654a3d8270 , pass=0, threshold=0, file_name=0x556549c1ccd8 "/home/mleich/Server/10.4/storage/innobase/dict/dict0dict.cc", line=5553) at /home/mleich/Server/10.4/storage/innobase/sync/sync0rw.cc:448 #8 0x00005565493e84a9 in rw_lock_x_lock_low (lock=0x55654a3d8270 , pass=0, file_name=0x556549c1ccd8 "/home/mleich/Server/10.4/storage/innobase/dict/dict0dict.cc", line=5553) at /home/mleich/Server/10.4/storage/innobase/sync/sync0rw.cc:503 #9 0x00005565493e88c2 in rw_lock_x_lock_func (lock=0x55654a3d8270 , pass=0, file_name=0x556549c1ccd8 "/home/mleich/Server/10.4/storage/innobase/dict/dict0dict.cc", line=5553) at /home/mleich/Server/10.4/storage/innobase/sync/sync0rw.cc:662 #10 0x0000556549381b32 in dict_sys_t::lock (this=0x55654a3d81e0 , file=0x556549c1ccd8 "/home/mleich/Server/10.4/storage/innobase/dict/dict0dict.cc", line=5553) at /home/mleich/Server/10.4/storage/innobase/include/dict0dict.h:1573 #11 0x00005565494f5f1c in dict_index_set_merge_threshold (index=0x7f803412f668, merge_threshold=50) at /home/mleich/Server/10.4/storage/innobase/dict/dict0dict.cc:5553 #12 0x0000556549219f8e in innobase_parse_hint_from_comment (thd=0x7f8028000ce8, table=0x7f80341775f8, table_share=0x7f809291bbc0) at /home/mleich/Server/10.4/storage/innobase/handler/ha_innodb.cc:12179 #13 0x000055654925955d in ha_innobase::commit_inplace_alter_table (this=0x7f8024058f20, altered_table=0x7f809291a840, ha_alter_info=0x7f809291a7b0, commit=true) at /home/mleich/Server/10.4/storage/innobase/handler/handler0alter.cc:11370 #14 0x0000556548fe87fd in handler::ha_commit_inplace_alter_table (this=0x7f8024058f20, altered_table=0x7f809291a840, ha_alter_info=0x7f809291a7b0, commit=true) at /home/mleich/Server/10.4/sql/handler.cc:4575 #15 0x0000556548d84e9b in mysql_inplace_alter_table (thd=0x7f8028000ce8, table_list=0x7f8028011558, table=0x7f8024058128, altered_table=0x7f809291a840, ha_alter_info=0x7f809291a7b0, inplace_supported=HA_ALTER_INPLACE_INSTANT, target_mdl_request=0x7f809291b610, alter_ctx=0x7f809291c140) at /home/mleich/Server/10.4/sql/sql_table.cc:7717 #16 0x0000556548d8b716 in mysql_alter_table (thd=0x7f8028000ce8, new_db=0x7f8028005498, new_name=0x7f80280058a0, create_info=0x7f809291cd20, table_list=0x7f8028011558, alter_info=0x7f809291cc60, order_num=0, order=0x0, ignore=false) at /home/mleich/Server/10.4/sql/sql_table.cc:10028 #17 0x0000556548e1ceb6 in Sql_cmd_alter_table::execute (this=0x7f8028011d30, thd=0x7f8028000ce8) at /home/mleich/Server/10.4/sql/sql_alter.cc:502 #18 0x0000556548cab0b0 in mysql_execute_command (thd=0x7f8028000ce8) at /home/mleich/Server/10.4/sql/sql_parse.cc:6098 #19 0x0000556548cb0321 in mysql_parse (thd=0x7f8028000ce8, rawbuf=0x7f8028011450 "ALTER TABLE t1 ADD COLUMN col_int_copy INTEGER", length=46, parser_state=0x7f809291e170, is_com_multi=false, is_next_command=false) at /home/mleich/Server/10.4/sql/sql_parse.cc:7908 #20 0x0000556548c9c5b5 in dispatch_command (command=COM_QUERY, thd=0x7f8028000ce8, packet=0x7f8028008119 "ALTER TABLE t1 ADD COLUMN col_int_copy INTEGER ", packet_length=47, is_com_multi=false, is_next_command=false) at /home/mleich/Server/10.4/sql/sql_parse.cc:1842 #21 0x0000556548c9acfa in do_command (thd=0x7f8028000ce8) at /home/mleich/Server/10.4/sql/sql_parse.cc:1359 #22 0x0000556548e13d16 in do_handle_one_connection (connect=0x55654c01ec78) at /home/mleich/Server/10.4/sql/sql_connect.cc:1404 #23 0x0000556548e13a65 in handle_one_connection (arg=0x55654c01ec78) at /home/mleich/Server/10.4/sql/sql_connect.cc:1306 #24 0x000055654973d4e4 in pfs_spawn_thread (arg=0x55654bf29748) at /home/mleich/Server/10.4/storage/perfschema/pfs.cc:1862 #25 0x00007f809e47a7fc in start_thread (arg=0x7f809291f700) at pthread_create.c:465 #26 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 30 (Thread 0x7f806a7fc700 (LWP 11099)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55654bcdc128) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55654bcdc0d8, cond=0x55654bcdc100) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55654bcdc100, mutex=0x55654bcdc0d8) at pthread_cond_wait.c:655 #3 0x00005565492ed226 in os_event::wait (this=0x55654bcdc0c0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:159 #4 0x00005565492eccbe in os_event::wait_low (this=0x55654bcdc0c0, reset_sig_count=217645) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:326 #5 0x00005565492ed014 in os_event_wait_low (event=0x55654bcdc0c0, reset_sig_count=0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:515 #6 0x00005565493d7230 in srv_resume_thread (slot=0x55654a3d5bf0 , sig_count=0, wait=true, timeout_usec=0) at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:904 #7 0x00005565493dac71 in srv_worker_thread (arg=0x0) at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:2508 #8 0x00007f809e47a7fc in start_thread (arg=0x7f806a7fc700) at pthread_create.c:465 #9 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 29 (Thread 0x7f8069ffb700 (LWP 11100)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55654bcdc0ac) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55654bcdc058, cond=0x55654bcdc080) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55654bcdc080, mutex=0x55654bcdc058) at pthread_cond_wait.c:655 #3 0x00005565492ed226 in os_event::wait (this=0x55654bcdc040) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:159 #4 0x00005565492eccbe in os_event::wait_low (this=0x55654bcdc040, reset_sig_count=225531) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:326 #5 0x00005565492ed014 in os_event_wait_low (event=0x55654bcdc040, reset_sig_count=0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:515 #6 0x00005565493d7230 in srv_resume_thread (slot=0x55654a3d5bb8 , sig_count=0, wait=true, timeout_usec=0) at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:904 #7 0x00005565493dac71 in srv_worker_thread (arg=0x0) at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:2508 #8 0x00007f809e47a7fc in start_thread (arg=0x7f8069ffb700) at pthread_create.c:465 #9 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 28 (Thread 0x7f80905aa700 (LWP 12066)): #0 0x00007f809e481786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f80905a7b40, expected=0, futex_word=0x7f8018000ee0) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f80905a7b40, mutex=0x7f8018000e30, cond=0x7f8018000eb8) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x7f8018000eb8, mutex=0x7f8018000e30, abstime=0x7f80905a7b40) at pthread_cond_wait.c:667 #3 0x0000556549857b27 in safe_cond_timedwait (cond=0x7f8018000eb8, mp=0x7f8018000e08, abstime=0x7f80905a7b40, file=0x556549963b80 "/home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h", line=1204) at /home/mleich/Server/10.4/mysys/thr_mutex.c:546 #4 0x0000556548e1f670 in inline_mysql_cond_timedwait (that=0x7f8018000eb8, mutex=0x7f8018000e08, abstime=0x7f80905a7b40, src_file=0x5565499641c0 "/home/mleich/Server/10.4/sql/mdl.cc", src_line=1148) at /home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h:1204 #5 0x0000556548e20ab2 in MDL_wait::timed_wait (this=0x7f8018000e08, owner=0x7f8018000db8, abs_timeout=0x7f80905a7b40, set_status_on_timeout=false, wait_state_name=0x55654a3bdef0 ) at /home/mleich/Server/10.4/sql/mdl.cc:1147 #6 0x0000556548e22736 in MDL_context::acquire_lock (this=0x7f8018000e08, mdl_request=0x7f80180119e8, lock_wait_timeout=86400) at /home/mleich/Server/10.4/sql/mdl.cc:2325 #7 0x0000556548c03557 in open_table_get_mdl_lock (thd=0x7f8018000ce8, ot_ctx=0x7f80905a8200, mdl_request=0x7f80180119e8, flags=0, mdl_ticket=0x7f80905a7e30) at /home/mleich/Server/10.4/sql/sql_base.cc:1648 #8 0x0000556548c03de8 in open_table (thd=0x7f8018000ce8, table_list=0x7f80180115a8, ot_ctx=0x7f80905a8200) at /home/mleich/Server/10.4/sql/sql_base.cc:1907 #9 0x0000556548c079f9 in open_and_process_table (thd=0x7f8018000ce8, tables=0x7f80180115a8, counter=0x7f80905a8294, flags=0, prelocking_strategy=0x7f80905a8318, has_prelocking_list=false, ot_ctx=0x7f80905a8200) at /home/mleich/Server/10.4/sql/sql_base.cc:3841 #10 0x0000556548c08da4 in open_tables (thd=0x7f8018000ce8, options=..., start=0x7f80905a8278, counter=0x7f80905a8294, flags=0, prelocking_strategy=0x7f80905a8318) at /home/mleich/Server/10.4/sql/sql_base.cc:4339 #11 0x0000556548c0abc7 in open_and_lock_tables (thd=0x7f8018000ce8, options=..., tables=0x7f80180115a8, derived=true, flags=0, prelocking_strategy=0x7f80905a8318) at /home/mleich/Server/10.4/sql/sql_base.cc:5225 #12 0x0000556548bc7419 in open_and_lock_tables (thd=0x7f8018000ce8, tables=0x7f80180115a8, derived=true, flags=0) at /home/mleich/Server/10.4/sql/sql_base.h:505 #13 0x0000556548c58a6f in mysql_insert (thd=0x7f8018000ce8, table_list=0x7f80180115a8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /home/mleich/Server/10.4/sql/sql_insert.cc:764 #14 0x0000556548ca4465 in mysql_execute_command (thd=0x7f8018000ce8) at /home/mleich/Server/10.4/sql/sql_parse.cc:4528 #15 0x0000556548cb0321 in mysql_parse (thd=0x7f8018000ce8, rawbuf=0x7f8018011450 "INSERT INTO t1 (col1,col2, col_int, col_string, col_text) VALUES ( 8 , 7, 8, 8, NULL )", length=86, parser_state=0x7f80905a9170, is_com_multi=false, is_next_command=false) at /home/mleich/Server/10.4/sql/sql_parse.cc:7908 #16 0x0000556548c9c5b5 in dispatch_command (command=COM_QUERY, thd=0x7f8018000ce8, packet=0x7f8018008119 "INSERT INTO t1 (col1,col2, col_int, col_string, col_text) VALUES ( 8 , 7, 8, 8, NULL ) ", packet_length=87, is_com_multi=false, is_next_command=false) at /home/mleich/Server/10.4/sql/sql_parse.cc:1842 #17 0x0000556548c9acfa in do_command (thd=0x7f8018000ce8) at /home/mleich/Server/10.4/sql/sql_parse.cc:1359 #18 0x0000556548e13d16 in do_handle_one_connection (connect=0x55654bfdacb8) at /home/mleich/Server/10.4/sql/sql_connect.cc:1404 #19 0x0000556548e13a65 in handle_one_connection (arg=0x55654bfdacb8) at /home/mleich/Server/10.4/sql/sql_connect.cc:1306 #20 0x000055654973d4e4 in pfs_spawn_thread (arg=0x55654c04d6c8) at /home/mleich/Server/10.4/storage/perfschema/pfs.cc:1862 #21 0x00007f809e47a7fc in start_thread (arg=0x7f80905aa700) at pthread_create.c:465 #22 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 27 (Thread 0x7f8092969700 (LWP 11110)): #0 0x00007f809d6a4951 in __GI___poll (fds=0x7f8092968728, nfds=1, timeout=28800000) at ../sysdeps/unix/sysv/linux/poll.c:29 #1 0x00005565498c12a4 in vio_io_wait (vio=0x55654bf29348, event=VIO_IO_EVENT_READ, timeout=28800000) at /home/mleich/Server/10.4/vio/viosocket.c:976 #2 0x00005565498bf8c5 in vio_socket_io_wait (vio=0x55654bf29348, event=VIO_IO_EVENT_READ) at /home/mleich/Server/10.4/vio/viosocket.c:118 #3 0x00005565498bfaad in vio_read (vio=0x55654bf29348, buf=0x7f8034008118 "\001", size=4) at /home/mleich/Server/10.4/vio/viosocket.c:195 #4 0x0000556549142081 in my_real_read (net=0x7f8034000fe0, complen=0x7f8092968940, header=1 '\001') at /home/mleich/Server/10.4/sql/net_serv.cc:962 #5 0x00005565491428f8 in my_net_read_packet_reallen (net=0x7f8034000fe0, read_from_server=1 '\001', reallen=0x7f80929689a8) at /home/mleich/Server/10.4/sql/net_serv.cc:1243 #6 0x00005565491428ac in my_net_read_packet (net=0x7f8034000fe0, read_from_server=1 '\001') at /home/mleich/Server/10.4/sql/net_serv.cc:1227 #7 0x0000556548c9a626 in do_command (thd=0x7f8034000ce8) at /home/mleich/Server/10.4/sql/sql_parse.cc:1233 #8 0x0000556548e13d16 in do_handle_one_connection (connect=0x55654c003558) at /home/mleich/Server/10.4/sql/sql_connect.cc:1404 #9 0x0000556548e13a65 in handle_one_connection (arg=0x55654c003558) at /home/mleich/Server/10.4/sql/sql_connect.cc:1306 #10 0x000055654973d4e4 in pfs_spawn_thread (arg=0x55654bf29018) at /home/mleich/Server/10.4/storage/perfschema/pfs.cc:1862 #11 0x00007f809e47a7fc in start_thread (arg=0x7f8092969700) at pthread_create.c:465 #12 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 26 (Thread 0x7f80905f4700 (LWP 12065)): #0 0x00007f809e481786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f80905f1b40, expected=0, futex_word=0x7f8024000ee4) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f80905f1b40, mutex=0x7f8024000e30, cond=0x7f8024000eb8) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x7f8024000eb8, mutex=0x7f8024000e30, abstime=0x7f80905f1b40) at pthread_cond_wait.c:667 #3 0x0000556549857b27 in safe_cond_timedwait (cond=0x7f8024000eb8, mp=0x7f8024000e08, abstime=0x7f80905f1b40, file=0x556549963b80 "/home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h", line=1204) at /home/mleich/Server/10.4/mysys/thr_mutex.c:546 #4 0x0000556548e1f670 in inline_mysql_cond_timedwait (that=0x7f8024000eb8, mutex=0x7f8024000e08, abstime=0x7f80905f1b40, src_file=0x5565499641c0 "/home/mleich/Server/10.4/sql/mdl.cc", src_line=1148) at /home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h:1204 #5 0x0000556548e20ab2 in MDL_wait::timed_wait (this=0x7f8024000e08, owner=0x7f8024000db8, abs_timeout=0x7f80905f1b40, set_status_on_timeout=false, wait_state_name=0x55654a3bdef0 ) at /home/mleich/Server/10.4/sql/mdl.cc:1147 #6 0x0000556548e22736 in MDL_context::acquire_lock (this=0x7f8024000e08, mdl_request=0x7f80240119e8, lock_wait_timeout=86400) at /home/mleich/Server/10.4/sql/mdl.cc:2325 #7 0x0000556548c03557 in open_table_get_mdl_lock (thd=0x7f8024000ce8, ot_ctx=0x7f80905f2200, mdl_request=0x7f80240119e8, flags=0, mdl_ticket=0x7f80905f1e30) at /home/mleich/Server/10.4/sql/sql_base.cc:1648 #8 0x0000556548c03de8 in open_table (thd=0x7f8024000ce8, table_list=0x7f80240115a8, ot_ctx=0x7f80905f2200) at /home/mleich/Server/10.4/sql/sql_base.cc:1907 #9 0x0000556548c079f9 in open_and_process_table (thd=0x7f8024000ce8, tables=0x7f80240115a8, counter=0x7f80905f2294, flags=0, prelocking_strategy=0x7f80905f2318, has_prelocking_list=false, ot_ctx=0x7f80905f2200) at /home/mleich/Server/10.4/sql/sql_base.cc:3841 #10 0x0000556548c08da4 in open_tables (thd=0x7f8024000ce8, options=..., start=0x7f80905f2278, counter=0x7f80905f2294, flags=0, prelocking_strategy=0x7f80905f2318) at /home/mleich/Server/10.4/sql/sql_base.cc:4339 #11 0x0000556548c0abc7 in open_and_lock_tables (thd=0x7f8024000ce8, options=..., tables=0x7f80240115a8, derived=true, flags=0, prelocking_strategy=0x7f80905f2318) at /home/mleich/Server/10.4/sql/sql_base.cc:5225 #12 0x0000556548bc7419 in open_and_lock_tables (thd=0x7f8024000ce8, tables=0x7f80240115a8, derived=true, flags=0) at /home/mleich/Server/10.4/sql/sql_base.h:505 #13 0x0000556548c58a6f in mysql_insert (thd=0x7f8024000ce8, table_list=0x7f80240115a8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /home/mleich/Server/10.4/sql/sql_insert.cc:764 #14 0x0000556548ca4465 in mysql_execute_command (thd=0x7f8024000ce8) at /home/mleich/Server/10.4/sql/sql_parse.cc:4528 #15 0x0000556548cb0321 in mysql_parse (thd=0x7f8024000ce8, rawbuf=0x7f8024011450 "INSERT INTO t1 (col1,col2, col_int, col_string, col_text) VALUES ( 6 , 5, 6, 6, NULL )", length=86, parser_state=0x7f80905f3170, is_com_multi=false, is_next_command=false) at /home/mleich/Server/10.4/sql/sql_parse.cc:7908 #16 0x0000556548c9c5b5 in dispatch_command (command=COM_QUERY, thd=0x7f8024000ce8, packet=0x7f8024008119 "INSERT INTO t1 (col1,col2, col_int, col_string, col_text) VALUES ( 6 , 5, 6, 6, NULL ) ", packet_length=87, is_com_multi=false, is_next_command=false) at /home/mleich/Server/10.4/sql/sql_parse.cc:1842 #17 0x0000556548c9acfa in do_command (thd=0x7f8024000ce8) at /home/mleich/Server/10.4/sql/sql_parse.cc:1359 #18 0x0000556548e13d16 in do_handle_one_connection (connect=0x55654bf2a538) at /home/mleich/Server/10.4/sql/sql_connect.cc:1404 #19 0x0000556548e13a65 in handle_one_connection (arg=0x55654bf2a538) at /home/mleich/Server/10.4/sql/sql_connect.cc:1306 #20 0x000055654973d4e4 in pfs_spawn_thread (arg=0x55654c04d2c8) at /home/mleich/Server/10.4/storage/perfschema/pfs.cc:1862 #21 0x00007f809e47a7fc in start_thread (arg=0x7f80905f4700) at pthread_create.c:465 #22 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 25 (Thread 0x7f80928d5700 (LWP 12063)): #0 0x00007f809e481786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f80928d24e0, expected=0, futex_word=0x7f802c000ee0) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f80928d24e0, mutex=0x7f802c000e30, cond=0x7f802c000eb8) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x7f802c000eb8, mutex=0x7f802c000e30, abstime=0x7f80928d24e0) at pthread_cond_wait.c:667 #3 0x0000556549857b27 in safe_cond_timedwait (cond=0x7f802c000eb8, mp=0x7f802c000e08, abstime=0x7f80928d24e0, file=0x556549963b80 "/home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h", line=1204) at /home/mleich/Server/10.4/mysys/thr_mutex.c:546 #4 0x0000556548e1f670 in inline_mysql_cond_timedwait (that=0x7f802c000eb8, mutex=0x7f802c000e08, abstime=0x7f80928d24e0, src_file=0x5565499641c0 "/home/mleich/Server/10.4/sql/mdl.cc", src_line=1148) at /home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h:1204 #5 0x0000556548e20ab2 in MDL_wait::timed_wait (this=0x7f802c000e08, owner=0x7f802c000db8, abs_timeout=0x7f80928d24e0, set_status_on_timeout=false, wait_state_name=0x55654a3bdef0 ) at /home/mleich/Server/10.4/sql/mdl.cc:1147 #6 0x0000556548e22736 in MDL_context::acquire_lock (this=0x7f802c000e08, mdl_request=0x7f802c0119a8, lock_wait_timeout=86400) at /home/mleich/Server/10.4/sql/mdl.cc:2325 #7 0x0000556548c03557 in open_table_get_mdl_lock (thd=0x7f802c000ce8, ot_ctx=0x7f80928d2ba0, mdl_request=0x7f802c0119a8, flags=0, mdl_ticket=0x7f80928d27d0) at /home/mleich/Server/10.4/sql/sql_base.cc:1648 #8 0x0000556548c03de8 in open_table (thd=0x7f802c000ce8, table_list=0x7f802c011568, ot_ctx=0x7f80928d2ba0) at /home/mleich/Server/10.4/sql/sql_base.cc:1907 #9 0x0000556548c079f9 in open_and_process_table (thd=0x7f802c000ce8, tables=0x7f802c011568, counter=0x7f80928d2c34, flags=0, prelocking_strategy=0x7f80928d2cb8, has_prelocking_list=false, ot_ctx=0x7f80928d2ba0) at /home/mleich/Server/10.4/sql/sql_base.cc:3841 #10 0x0000556548c08da4 in open_tables (thd=0x7f802c000ce8, options=..., start=0x7f80928d2c18, counter=0x7f80928d2c34, flags=0, prelocking_strategy=0x7f80928d2cb8) at /home/mleich/Server/10.4/sql/sql_base.cc:4339 #11 0x0000556548c0abc7 in open_and_lock_tables (thd=0x7f802c000ce8, options=..., tables=0x7f802c011568, derived=true, flags=0, prelocking_strategy=0x7f80928d2cb8) at /home/mleich/Server/10.4/sql/sql_base.cc:5225 #12 0x0000556548bc7419 in open_and_lock_tables (thd=0x7f802c000ce8, tables=0x7f802c011568, derived=true, flags=0) at /home/mleich/Server/10.4/sql/sql_base.h:505 #13 0x0000556549190023 in mysql_delete (thd=0x7f802c000ce8, table_list=0x7f802c011568, conds=0x7f802c0121e8, order_list=0x7f802c005690, limit=18446744073709551615, options=0, result=0x0) at /home/mleich/Server/10.4/sql/sql_delete.cc:349 #14 0x0000556548ca5276 in mysql_execute_command (thd=0x7f802c000ce8) at /home/mleich/Server/10.4/sql/sql_parse.cc:4727 #15 0x0000556548cb0321 in mysql_parse (thd=0x7f802c000ce8, rawbuf=0x7f802c011450 "DELETE FROM t1 WHERE col_int = 6 OR col_int IS NULL", length=51, parser_state=0x7f80928d4170, is_com_multi=false, is_next_command=false) at /home/mleich/Server/10.4/sql/sql_parse.cc:7908 #16 0x0000556548c9c5b5 in dispatch_command (command=COM_QUERY, thd=0x7f802c000ce8, packet=0x7f802c008119 "DELETE FROM t1 WHERE col_int = 6 OR col_int IS NULL ", packet_length=52, is_com_multi=false, is_next_command=false) at /home/mleich/Server/10.4/sql/sql_parse.cc:1842 #17 0x0000556548c9acfa in do_command (thd=0x7f802c000ce8) at /home/mleich/Server/10.4/sql/sql_parse.cc:1359 #18 0x0000556548e13d16 in do_handle_one_connection (connect=0x55654c019a58) at /home/mleich/Server/10.4/sql/sql_connect.cc:1404 #19 0x0000556548e13a65 in handle_one_connection (arg=0x55654c019a58) at /home/mleich/Server/10.4/sql/sql_connect.cc:1306 #20 0x000055654973d4e4 in pfs_spawn_thread (arg=0x55654bf29c78) at /home/mleich/Server/10.4/storage/perfschema/pfs.cc:1862 #21 0x00007f809e47a7fc in start_thread (arg=0x7f80928d5700) at pthread_create.c:465 #22 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 24 (Thread 0x7f808a7fc700 (LWP 11097)): #0 0x00007f809e4855f8 in __GI___nanosleep (requested_time=0x7f808a7fbe70, remaining=0x0) at ../sysdeps/unix/sysv/linux/nanosleep.c:27 #1 0x00005565492ed529 in os_thread_sleep (tm=1000000) at /home/mleich/Server/10.4/storage/innobase/os/os0thread.cc:225 #2 0x00005565493da5fb in srv_master_sleep () at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:2334 #3 0x00005565493da739 in srv_master_thread (arg=0x0) at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:2375 #4 0x00007f809e47a7fc in start_thread (arg=0x7f808a7fc700) at pthread_create.c:465 #5 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 23 (Thread 0x7f80929b3700 (LWP 11107)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55654a59bdcc ) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55654a59f048 , cond=0x55654a59bda0 ) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55654a59bda0 , mutex=0x55654a59f048 ) at pthread_cond_wait.c:655 #3 0x0000556549857767 in safe_cond_wait (cond=0x55654a59bda0 , mp=0x55654a59f020 , file=0x5565498f7d38 "/home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h", line=1167) at /home/mleich/Server/10.4/mysys/thr_mutex.c:492 #4 0x0000556548b9819c in inline_mysql_cond_wait (that=0x55654a59bda0 , mutex=0x55654a59f020 , src_file=0x5565498f88d0 "/home/mleich/Server/10.4/sql/slave.cc", src_line=519) at /home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h:1167 #5 0x0000556548b99a06 in handle_slave_background (arg=0x0) at /home/mleich/Server/10.4/sql/slave.cc:519 #6 0x000055654973d4e4 in pfs_spawn_thread (arg=0x55654bfc91a8) at /home/mleich/Server/10.4/storage/perfschema/pfs.cc:1862 #7 0x00007f809e47a7fc in start_thread (arg=0x7f80929b3700) at pthread_create.c:465 #8 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 22 (Thread 0x7f8068ff9700 (LWP 11102)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55654bcdc2a8) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55654bcdc258, cond=0x55654bcdc280) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55654bcdc280, mutex=0x55654bcdc258) at pthread_cond_wait.c:655 #3 0x00005565492ed226 in os_event::wait (this=0x55654bcdc240) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:159 #4 0x00005565492eccbe in os_event::wait_low (this=0x55654bcdc240, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:326 #5 0x00005565492ed014 in os_event_wait_low (event=0x55654bcdc240, reset_sig_count=0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:515 #6 0x00005565494b868c in buf_dump_thread () at /home/mleich/Server/10.4/storage/innobase/buf/buf0dump.cc:833 #7 0x00007f809e47a7fc in start_thread (arg=0x7f8068ff9700) at pthread_create.c:465 #8 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 21 (Thread 0x7f806affd700 (LWP 11098)): #0 0x00007f809d693a37 in sched_yield () at ../sysdeps/unix/syscall-template.S:84 #1 0x00005565492ed4ba in os_thread_yield () at /home/mleich/Server/10.4/storage/innobase/os/os0thread.cc:206 #2 0x0000556549405025 in trx_purge_wait_for_workers_to_complete () at /home/mleich/Server/10.4/storage/innobase/trx/trx0purge.cc:1264 #3 0x0000556549405214 in trx_purge (n_purge_threads=4, truncate=false) at /home/mleich/Server/10.4/storage/innobase/trx/trx0purge.cc:1317 #4 0x00005565493daf4a in srv_do_purge (n_total_purged=0x7f806affcec8) at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:2599 #5 0x00005565493db381 in srv_purge_coordinator_thread (arg=0x0) at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:2725 #6 0x00007f809e47a7fc in start_thread (arg=0x7f806affd700) at pthread_create.c:465 #7 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 20 (Thread 0x7f809fbc8740 (LWP 11081)): #0 0x00007f809d6a4951 in __GI___poll (fds=0x7ffce2d9e1e0, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 #1 0x0000556548b74166 in handle_connections_sockets () at /home/mleich/Server/10.4/sql/mysqld.cc:6457 #2 0x0000556548b733ec in mysqld_main (argc=150, argv=0x55654baa62e8) at /home/mleich/Server/10.4/sql/mysqld.cc:5893 #3 0x0000556548b6774a in main (argc=26, argv=0x7ffce2d9e4e8) at /home/mleich/Server/10.4/sql/main.cc:25 Thread 19 (Thread 0x7f80929fd700 (LWP 11106)): #0 0x00007f809d5d499e in __GI___sigwaitinfo (set=, info=0x7f80929fcd40) at ../sysdeps/unix/sysv/linux/sigwaitinfo.c:56 #1 0x0000556548b677c8 in my_sigwait (set=0x7f80929fce20, sig=0x7f80929fcde4, code=0x7f80929fcde8) at /home/mleich/Server/10.4/include/my_pthread.h:198 #2 0x0000556548b6df33 in signal_hand (arg=0x0) at /home/mleich/Server/10.4/sql/mysqld.cc:3249 #3 0x000055654973d4e4 in pfs_spawn_thread (arg=0x55654bca2b18) at /home/mleich/Server/10.4/storage/perfschema/pfs.cc:1862 #4 0x00007f809e47a7fc in start_thread (arg=0x7f80929fd700) at pthread_create.c:465 #5 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 18 (Thread 0x7f80927fd700 (LWP 11084)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55654bd5e628) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55654bd5e5d8, cond=0x55654bd5e600) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55654bd5e600, mutex=0x55654bd5e5d8) at pthread_cond_wait.c:655 #3 0x00005565492ed226 in os_event::wait (this=0x55654bd5e5c0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:159 #4 0x00005565492eccbe in os_event::wait_low (this=0x55654bd5e5c0, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:326 #5 0x00005565492ed014 in os_event_wait_low (event=0x55654bd5e5c0, reset_sig_count=0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:515 #6 0x00005565492e6a23 in os_aio_simulated_handler (global_segment=0, m1=0x7f80927fccb8, m2=0x7f80927fccc0, type=0x7f80927fccf0) at /home/mleich/Server/10.4/storage/innobase/os/os0file.cc:7136 #7 0x00005565492e4996 in os_aio_handler (segment=0, m1=0x7f80927fccb8, m2=0x7f80927fccc0, request=0x7f80927fccf0) at /home/mleich/Server/10.4/storage/innobase/os/os0file.cc:5573 #8 0x0000556549535167 in fil_aio_wait (segment=0) at /home/mleich/Server/10.4/storage/innobase/fil/fil0fil.cc:4349 #9 0x00005565493dcd01 in io_handler_thread (arg=0x55654a619a80 ) at /home/mleich/Server/10.4/storage/innobase/srv/srv0start.cc:325 #10 0x00007f809e47a7fc in start_thread (arg=0x7f80927fd700) at pthread_create.c:465 #11 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 17 (Thread 0x7f80917fb700 (LWP 11086)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55654bd5e728) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55654bd5e6d8, cond=0x55654bd5e700) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55654bd5e700, mutex=0x55654bd5e6d8) at pthread_cond_wait.c:655 #3 0x00005565492ed226 in os_event::wait (this=0x55654bd5e6c0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:159 #4 0x00005565492eccbe in os_event::wait_low (this=0x55654bd5e6c0, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:326 #5 0x00005565492ed014 in os_event_wait_low (event=0x55654bd5e6c0, reset_sig_count=0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:515 #6 0x00005565492e6a23 in os_aio_simulated_handler (global_segment=2, m1=0x7f80917facb8, m2=0x7f80917facc0, type=0x7f80917facf0) at /home/mleich/Server/10.4/storage/innobase/os/os0file.cc:7136 #7 0x00005565492e4996 in os_aio_handler (segment=2, m1=0x7f80917facb8, m2=0x7f80917facc0, request=0x7f80917facf0) at /home/mleich/Server/10.4/storage/innobase/os/os0file.cc:5573 #8 0x0000556549535167 in fil_aio_wait (segment=2) at /home/mleich/Server/10.4/storage/innobase/fil/fil0fil.cc:4349 #9 0x00005565493dcd01 in io_handler_thread (arg=0x55654a619a90 ) at /home/mleich/Server/10.4/storage/innobase/srv/srv0start.cc:325 #10 0x00007f809e47a7fc in start_thread (arg=0x7f80917fb700) at pthread_create.c:465 #11 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 16 (Thread 0x7f80897fa700 (LWP 11093)): #0 0x00007f809e481786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f80897f9cb0, expected=0, futex_word=0x55654bcdc1a8) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f80897f9cb0, mutex=0x55654bcdc158, cond=0x55654bcdc180) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55654bcdc180, mutex=0x55654bcdc158, abstime=0x7f80897f9cb0) at pthread_cond_wait.c:667 #3 0x00005565492ecb24 in os_event::timed_wait (this=0x55654bcdc140, abstime=0x7f80897f9cb0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:276 #4 0x00005565492ece51 in os_event::wait_time_low (this=0x55654bcdc140, time_in_usec=1000000, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:398 #5 0x00005565492ecfef in os_event_wait_time_low (event=0x55654bcdc140, time_in_usec=1000000, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:498 #6 0x00005565493d94c8 in srv_error_monitor_thread () at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:1845 #7 0x00007f809e47a7fc in start_thread (arg=0x7f80897fa700) at pthread_create.c:465 #8 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 15 (Thread 0x7f806b7fe700 (LWP 11096)): #0 0x00007f809e481786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f806b7fdc70, expected=0, futex_word=0x55654be78818) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f806b7fdc70, mutex=0x55654be787c8, cond=0x55654be787f0) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55654be787f0, mutex=0x55654be787c8, abstime=0x7f806b7fdc70) at pthread_cond_wait.c:667 #3 0x00005565492ecb24 in os_event::timed_wait (this=0x55654be787b0, abstime=0x7f806b7fdc70) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:276 #4 0x00005565492ece51 in os_event::wait_time_low (this=0x55654be787b0, time_in_usec=5000000, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:398 #5 0x00005565492ecfef in os_event_wait_time_low (event=0x55654be787b0, time_in_usec=5000000, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:498 #6 0x0000556549439d33 in ib_wqueue_timedwait (wq=0x55654be78620, wait_in_usecs=5000000) at /home/mleich/Server/10.4/storage/innobase/ut/ut0wqueue.cc:161 #7 0x000055654957b614 in fts_optimize_thread (arg=0x55654be78620) at /home/mleich/Server/10.4/storage/innobase/fts/fts0opt.cc:2836 #8 0x00007f809e47a7fc in start_thread (arg=0x7f806b7fe700) at pthread_create.c:465 #9 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 14 (Thread 0x7f8088ff9700 (LWP 11094)): #0 0x00007f809e481786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f8088ff8e50, expected=0, futex_word=0x55654bcdc228) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f8088ff8e50, mutex=0x55654bcdc1d8, cond=0x55654bcdc200) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55654bcdc200, mutex=0x55654bcdc1d8, abstime=0x7f8088ff8e50) at pthread_cond_wait.c:667 #3 0x00005565492ecb24 in os_event::timed_wait (this=0x55654bcdc1c0, abstime=0x7f8088ff8e50) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:276 #4 0x00005565492ece51 in os_event::wait_time_low (this=0x55654bcdc1c0, time_in_usec=5000000, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:398 #5 0x00005565492ecfef in os_event_wait_time_low (event=0x55654bcdc1c0, time_in_usec=5000000, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:498 #6 0x00005565493d8f99 in srv_monitor_thread () at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:1681 #7 0x00007f809e47a7fc in start_thread (arg=0x7f8088ff9700) at pthread_create.c:465 #8 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 13 (Thread 0x7f804b7fe700 (LWP 11104)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55654bcdc3a8) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55654bcdc358, cond=0x55654bcdc380) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55654bcdc380, mutex=0x55654bcdc358) at pthread_cond_wait.c:655 #3 0x00005565492ed226 in os_event::wait (this=0x55654bcdc340) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:159 #4 0x00005565492eccbe in os_event::wait_low (this=0x55654bcdc340, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:326 #5 0x00005565492ed014 in os_event_wait_low (event=0x55654bcdc340, reset_sig_count=0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:515 #6 0x00005565494a064b in buf_resize_thread () at /home/mleich/Server/10.4/storage/innobase/buf/buf0buf.cc:3207 #7 0x00007f809e47a7fc in start_thread (arg=0x7f804b7fe700) at pthread_create.c:465 #8 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 12 (Thread 0x7f808affd700 (LWP 11090)): #0 0x00007f809e481786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f808affcc00, expected=0, futex_word=0x55654bcdc32c) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f808affcc00, mutex=0x55654bcdc2d8, cond=0x55654bcdc300) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55654bcdc300, mutex=0x55654bcdc2d8, abstime=0x7f808affcc00) at pthread_cond_wait.c:667 #3 0x00005565492ecb24 in os_event::timed_wait (this=0x55654bcdc2c0, abstime=0x7f808affcc00) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:276 #4 0x00005565492ece51 in os_event::wait_time_low (this=0x55654bcdc2c0, time_in_usec=985000, reset_sig_count=2) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:398 #5 0x00005565492ecfef in os_event_wait_time_low (event=0x55654bcdc2c0, time_in_usec=985000, reset_sig_count=2) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:498 #6 0x00005565494c23ed in pc_sleep_if_needed (next_loop_time=1563961478962, sig_count=2, cur_time=1563961477977) at /home/mleich/Server/10.4/storage/innobase/buf/buf0flu.cc:2641 #7 0x00005565494c3357 in buf_flush_page_cleaner_coordinator () at /home/mleich/Server/10.4/storage/innobase/buf/buf0flu.cc:3099 #8 0x00007f809e47a7fc in start_thread (arg=0x7f808affd700) at pthread_create.c:465 #9 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 11 (Thread 0x7f804affd700 (LWP 11105)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x7f804affcdd8) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7f804affce18, cond=0x7f804affcdb0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7f804affcdb0, mutex=0x7f804affce18) at pthread_cond_wait.c:655 #3 0x0000556549857767 in safe_cond_wait (cond=0x7f804affcdb0, mp=0x7f804affcdf0, file=0x556549b08d60 "/home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h", line=1178) at /home/mleich/Server/10.4/mysys/thr_mutex.c:492 #4 0x00005565491ff094 in inline_mysql_cond_wait (that=0x7f804affcdb0, mutex=0x7f804affcdf0, src_file=0x556549b0a878 "/home/mleich/Server/10.4/storage/innobase/handler/ha_innodb.cc", src_line=288) at /home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h:1178 #5 0x0000556549203734 in thd_destructor_proxy () at /home/mleich/Server/10.4/storage/innobase/handler/ha_innodb.cc:288 #6 0x000055654973d4e4 in pfs_spawn_thread (arg=0x55654bf1b658) at /home/mleich/Server/10.4/storage/perfschema/pfs.cc:1862 #7 0x00007f809e47a7fc in start_thread (arg=0x7f804affd700) at pthread_create.c:465 #8 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 10 (Thread 0x7f8089ffb700 (LWP 11092)): #0 0x00007f809e481786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f8089ffae70, expected=0, futex_word=0x55654beafdb8) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f8089ffae70, mutex=0x55654beafd68, cond=0x55654beafd90) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55654beafd90, mutex=0x55654beafd68, abstime=0x7f8089ffae70) at pthread_cond_wait.c:667 #3 0x00005565492ecb24 in os_event::timed_wait (this=0x55654beafd50, abstime=0x7f8089ffae70) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:276 #4 0x00005565492ece51 in os_event::wait_time_low (this=0x55654beafd50, time_in_usec=1000000, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:398 #5 0x00005565492ecfef in os_event_wait_time_low (event=0x55654beafd50, time_in_usec=1000000, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:498 #6 0x00005565492b635b in lock_wait_timeout_thread () at /home/mleich/Server/10.4/storage/innobase/lock/lock0wait.cc:543 #7 0x00007f809e47a7fc in start_thread (arg=0x7f8089ffb700) at pthread_create.c:465 #8 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 9 (Thread 0x7f808b7fe700 (LWP 11089)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55654bd5e8ac) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55654bd5e858, cond=0x55654bd5e880) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55654bd5e880, mutex=0x55654bd5e858) at pthread_cond_wait.c:655 #3 0x00005565492ed226 in os_event::wait (this=0x55654bd5e840) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:159 #4 0x00005565492eccbe in os_event::wait_low (this=0x55654bd5e840, reset_sig_count=817) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:326 #5 0x00005565492ed014 in os_event_wait_low (event=0x55654bd5e840, reset_sig_count=0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:515 #6 0x00005565492e6a23 in os_aio_simulated_handler (global_segment=5, m1=0x7f808b7fdcb8, m2=0x7f808b7fdcc0, type=0x7f808b7fdcf0) at /home/mleich/Server/10.4/storage/innobase/os/os0file.cc:7136 #7 0x00005565492e4996 in os_aio_handler (segment=5, m1=0x7f808b7fdcb8, m2=0x7f808b7fdcc0, request=0x7f808b7fdcf0) at /home/mleich/Server/10.4/storage/innobase/os/os0file.cc:5573 #8 0x0000556549535167 in fil_aio_wait (segment=5) at /home/mleich/Server/10.4/storage/innobase/fil/fil0fil.cc:4349 #9 0x00005565493dcd01 in io_handler_thread (arg=0x55654a619aa8 ) at /home/mleich/Server/10.4/storage/innobase/srv/srv0start.cc:325 #10 0x00007f809e47a7fc in start_thread (arg=0x7f808b7fe700) at pthread_create.c:465 #11 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 8 (Thread 0x7f806bfff700 (LWP 11095)): #0 0x00007f809e481786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f806bffee90, expected=0, futex_word=0x55654bee1298) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f806bffee90, mutex=0x55654bee1248, cond=0x55654bee1270) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55654bee1270, mutex=0x55654bee1248, abstime=0x7f806bffee90) at pthread_cond_wait.c:667 #3 0x00005565492ecb24 in os_event::timed_wait (this=0x55654bee1230, abstime=0x7f806bffee90) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:276 #4 0x00005565492ece51 in os_event::wait_time_low (this=0x55654bee1230, time_in_usec=10000000, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:398 #5 0x00005565492ecfef in os_event_wait_time_low (event=0x55654bee1230, time_in_usec=10000000, reset_sig_count=0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:498 #6 0x000055654951f2a6 in dict_stats_thread () at /home/mleich/Server/10.4/storage/innobase/dict/dict0stats_bg.cc:475 #7 0x00007f809e47a7fc in start_thread (arg=0x7f806bfff700) at pthread_create.c:465 #8 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 7 (Thread 0x7f804bfff700 (LWP 11103)): #0 0x00007f809e4855f8 in __GI___nanosleep (requested_time=0x7f804bffe7e0, remaining=0x0) at ../sysdeps/unix/sysv/linux/nanosleep.c:27 #1 0x00005565492ed529 in os_thread_sleep (tm=1000000) at /home/mleich/Server/10.4/storage/innobase/os/os0thread.cc:225 #2 0x0000556549491c6e in btr_defragment_thread () at /home/mleich/Server/10.4/storage/innobase/btr/btr0defragment.cc:707 #3 0x00007f809e47a7fc in start_thread (arg=0x7f804bfff700) at pthread_create.c:465 #4 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 6 (Thread 0x7f808bfff700 (LWP 11088)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55654bd5e82c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55654bd5e7d8, cond=0x55654bd5e800) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55654bd5e800, mutex=0x55654bd5e7d8) at pthread_cond_wait.c:655 #3 0x00005565492ed226 in os_event::wait (this=0x55654bd5e7c0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:159 #4 0x00005565492eccbe in os_event::wait_low (this=0x55654bd5e7c0, reset_sig_count=5499) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:326 #5 0x00005565492ed014 in os_event_wait_low (event=0x55654bd5e7c0, reset_sig_count=0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:515 #6 0x00005565492e6a23 in os_aio_simulated_handler (global_segment=4, m1=0x7f808bffecb8, m2=0x7f808bffecc0, type=0x7f808bffecf0) at /home/mleich/Server/10.4/storage/innobase/os/os0file.cc:7136 #7 0x00005565492e4996 in os_aio_handler (segment=4, m1=0x7f808bffecb8, m2=0x7f808bffecc0, request=0x7f808bffecf0) at /home/mleich/Server/10.4/storage/innobase/os/os0file.cc:5573 #8 0x0000556549535167 in fil_aio_wait (segment=4) at /home/mleich/Server/10.4/storage/innobase/fil/fil0fil.cc:4349 #9 0x00005565493dcd01 in io_handler_thread (arg=0x55654a619aa0 ) at /home/mleich/Server/10.4/storage/innobase/srv/srv0start.cc:325 #10 0x00007f809e47a7fc in start_thread (arg=0x7f808bfff700) at pthread_create.c:465 #11 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 5 (Thread 0x7f8091ffc700 (LWP 11085)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55654bd5e6ac) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55654bd5e658, cond=0x55654bd5e680) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55654bd5e680, mutex=0x55654bd5e658) at pthread_cond_wait.c:655 #3 0x00005565492ed226 in os_event::wait (this=0x55654bd5e640) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:159 #4 0x00005565492eccbe in os_event::wait_low (this=0x55654bd5e640, reset_sig_count=22) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:326 #5 0x00005565492ed014 in os_event_wait_low (event=0x55654bd5e640, reset_sig_count=0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:515 #6 0x00005565492e6a23 in os_aio_simulated_handler (global_segment=1, m1=0x7f8091ffbcb8, m2=0x7f8091ffbcc0, type=0x7f8091ffbcf0) at /home/mleich/Server/10.4/storage/innobase/os/os0file.cc:7136 #7 0x00005565492e4996 in os_aio_handler (segment=1, m1=0x7f8091ffbcb8, m2=0x7f8091ffbcc0, request=0x7f8091ffbcf0) at /home/mleich/Server/10.4/storage/innobase/os/os0file.cc:5573 #8 0x0000556549535167 in fil_aio_wait (segment=1) at /home/mleich/Server/10.4/storage/innobase/fil/fil0fil.cc:4349 #9 0x00005565493dcd01 in io_handler_thread (arg=0x55654a619a88 ) at /home/mleich/Server/10.4/storage/innobase/srv/srv0start.cc:325 #10 0x00007f809e47a7fc in start_thread (arg=0x7f8091ffc700) at pthread_create.c:465 #11 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 4 (Thread 0x7f809939b700 (LWP 11082)): #0 0x00007f809e481786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f809939aea0, expected=0, futex_word=0x55654ae40948 ) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f809939aea0, mutex=0x55654ae40888 , cond=0x55654ae40920 ) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55654ae40920 , mutex=0x55654ae40888 , abstime=0x7f809939aea0) at pthread_cond_wait.c:667 #3 0x0000556549857b27 in safe_cond_timedwait (cond=0x55654ae40920 , mp=0x55654ae40860 , abstime=0x7f809939aea0, file=0x556549ccfb70 "/home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h", line=1204) at /home/mleich/Server/10.4/mysys/thr_mutex.c:546 #4 0x0000556549858aee in inline_mysql_cond_timedwait (that=0x55654ae40920 , mutex=0x55654ae40860 , abstime=0x7f809939aea0, src_file=0x556549ccfbb0 "/home/mleich/Server/10.4/mysys/thr_timer.c", src_line=292) at /home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h:1204 #5 0x0000556549859653 in timer_handler (arg=0x0) at /home/mleich/Server/10.4/mysys/thr_timer.c:292 #6 0x000055654973d4e4 in pfs_spawn_thread (arg=0x55654bbe8018) at /home/mleich/Server/10.4/storage/perfschema/pfs.cc:1862 #7 0x00007f809e47a7fc in start_thread (arg=0x7f809939b700) at pthread_create.c:465 #8 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 3 (Thread 0x7f8093fff700 (LWP 11083)): #0 0x00007f809e481786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f8093ffedf0, expected=0, futex_word=0x55654ae2a728 ) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f8093ffedf0, mutex=0x55654ae2a668 , cond=0x55654ae2a700 ) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55654ae2a700 , mutex=0x55654ae2a668 , abstime=0x7f8093ffedf0) at pthread_cond_wait.c:667 #3 0x0000556549857b27 in safe_cond_timedwait (cond=0x55654ae2a700 , mp=0x55654ae2a640 , abstime=0x7f8093ffedf0, file=0x556549c7d740 "/home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h", line=1204) at /home/mleich/Server/10.4/mysys/thr_mutex.c:546 #4 0x0000556549613676 in inline_mysql_cond_timedwait (that=0x55654ae2a700 , mutex=0x55654ae2a640 , abstime=0x7f8093ffedf0, src_file=0x556549c7d780 "/home/mleich/Server/10.4/storage/maria/ma_servicethread.c", src_line=116) at /home/mleich/Server/10.4/include/mysql/psi/mysql_thread.h:1204 #5 0x0000556549613b9b in my_service_thread_sleep (control=0x55654a3dac20 , sleep_time=30000000000) at /home/mleich/Server/10.4/storage/maria/ma_servicethread.c:115 #6 0x0000556549607ff5 in ma_checkpoint_background (arg=0x1e) at /home/mleich/Server/10.4/storage/maria/ma_checkpoint.c:707 #7 0x000055654973d4e4 in pfs_spawn_thread (arg=0x55654bc93f38) at /home/mleich/Server/10.4/storage/perfschema/pfs.cc:1862 #8 0x00007f809e47a7fc in start_thread (arg=0x7f8093fff700) at pthread_create.c:465 #9 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 2 (Thread 0x7f8090ffa700 (LWP 11087)): #0 0x00007f809e481072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55654bd5e7a8) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55654bd5e758, cond=0x55654bd5e780) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55654bd5e780, mutex=0x55654bd5e758) at pthread_cond_wait.c:655 #3 0x00005565492ed226 in os_event::wait (this=0x55654bd5e740) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:159 #4 0x00005565492eccbe in os_event::wait_low (this=0x55654bd5e740, reset_sig_count=1) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:326 #5 0x00005565492ed014 in os_event_wait_low (event=0x55654bd5e740, reset_sig_count=0) at /home/mleich/Server/10.4/storage/innobase/os/os0event.cc:515 #6 0x00005565492e6a23 in os_aio_simulated_handler (global_segment=3, m1=0x7f8090ff9cb8, m2=0x7f8090ff9cc0, type=0x7f8090ff9cf0) at /home/mleich/Server/10.4/storage/innobase/os/os0file.cc:7136 #7 0x00005565492e4996 in os_aio_handler (segment=3, m1=0x7f8090ff9cb8, m2=0x7f8090ff9cc0, request=0x7f8090ff9cf0) at /home/mleich/Server/10.4/storage/innobase/os/os0file.cc:5573 #8 0x0000556549535167 in fil_aio_wait (segment=3) at /home/mleich/Server/10.4/storage/innobase/fil/fil0fil.cc:4349 #9 0x00005565493dcd01 in io_handler_thread (arg=0x55654a619a98 ) at /home/mleich/Server/10.4/storage/innobase/srv/srv0start.cc:325 #10 0x00007f809e47a7fc in start_thread (arg=0x7f8090ffa700) at pthread_create.c:465 #11 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 1 (Thread 0x7f80697fa700 (LWP 11101)): #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x0000556549852037 in my_write_core (sig=6) at /home/mleich/Server/10.4/mysys/stacktrace.c:481 #2 0x0000556548fd9e8f in handle_fatal_signal (sig=6) at /home/mleich/Server/10.4/sql/signal_handler.cc:343 #3 #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51 #5 0x00007f809d5d4f5d in __GI_abort () at abort.c:90 #6 0x00007f809d5caf17 in __assert_fail_base (fmt=, assertion=assertion@entry=0x556549bca1b1 "0", file=file@entry=0x556549bcb7e8 "/home/mleich/Server/10.4/storage/innobase/trx/trx0rec.cc", line=line@entry=1682, function=function@entry=0x556549bcdd00 "byte* trx_undo_update_rec_get_update(const byte*, dict_index_t*, ulint, trx_id_t, roll_ptr_t, ulint, mem_heap_t*, upd_t**)") at assert.c:92 #7 0x00007f809d5cafc2 in __GI___assert_fail (assertion=0x556549bca1b1 "0", file=0x556549bcb7e8 "/home/mleich/Server/10.4/storage/innobase/trx/trx0rec.cc", line=1682, function=0x556549bcdd00 "byte* trx_undo_update_rec_get_update(const byte*, dict_index_t*, ulint, trx_id_t, roll_ptr_t, ulint, mem_heap_t*, upd_t**)") at assert.c:101 #8 0x0000556549413a5d in trx_undo_update_rec_get_update (ptr=0x55654befafae "\004\200", index=0x7f803412f668, type=13, trx_id=283649, roll_ptr=19421773415590343, info_bits=32, heap=0x55654befaef0, upd=0x55654befaa50) at /home/mleich/Server/10.4/storage/innobase/trx/trx0rec.cc:1682 #9 0x000055654939c0bc in row_purge_parse_undo_rec (node=0x55654befa9d8, undo_rec=0x55654befaf88 "", updated_extern=0x7f80697f9dde, thr=0x55654befa808) at /home/mleich/Server/10.4/storage/innobase/row/row0purge.cc:1147 #10 0x000055654939c637 in row_purge (node=0x55654befa9d8, undo_rec=0x55654befaf88 "", thr=0x55654befa808) at /home/mleich/Server/10.4/storage/innobase/row/row0purge.cc:1259 #11 0x000055654939c854 in row_purge_step (thr=0x55654befa808) at /home/mleich/Server/10.4/storage/innobase/row/row0purge.cc:1321 #12 0x000055654931fe2e in que_thr_step (thr=0x55654befa808) at /home/mleich/Server/10.4/storage/innobase/que/que0que.cc:1042 #13 0x0000556549320062 in que_run_threads_low (thr=0x55654befa808) at /home/mleich/Server/10.4/storage/innobase/que/que0que.cc:1104 #14 0x0000556549320252 in que_run_threads (thr=0x55654befa808) at /home/mleich/Server/10.4/storage/innobase/que/que0que.cc:1144 #15 0x00005565493daacc in srv_task_execute () at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:2462 #16 0x00005565493dac76 in srv_worker_thread (arg=0x0) at /home/mleich/Server/10.4/storage/innobase/srv/srv0srv.cc:2510 #17 0x00007f809e47a7fc in start_thread (arg=0x7f80697fa700) at pthread_create.c:465 #18 0x00007f809d6b0b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 - saving '/home/mleich/Server/10.4/bld_debug/mysql-test/var/log/main.MDEV-20117-innodb/' to '/home/mleich/Server/10.4/bld_debug/mysql-test/var/log/main.MDEV-20117-innodb/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 149 seconds executing testcases Failure: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.MDEV-20117 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html