Logging: mysql-test/mysql-test-run.pl --record bs_3.test vardir: bld_debug/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory 'bld_debug/mysql-test/var'... Checking supported features... MariaDB Version 10.4.3-MariaDB-debug - SSL connections supported - binaries are debug compiled Collecting tests... Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 main.bs_3 'innodb' [ fail ] Test ended at 2019-02-18 11:38:45 CURRENT_TEST: main.bs_3 mysqltest: At line 11: query 'DROP TABLE t1' failed: 2006: MySQL server has gone away The result from queries just before the failure was: CREATE TABLE t1 ( col_text TEXT , PRIMARY KEY (col_text(9)) ) ENGINE = InnoDB ROW_FORMAT = Redundant ; ALTER TABLE t1 ADD FULLTEXT INDEX `ftidx` ( col_text ) ; ALTER TABLE t1 DROP PRIMARY KEY ; ALTER TABLE t1 DROP INDEX `ftidx` ; ALTER TABLE t1 CHANGE COLUMN col_text col_text TEXT ; ERROR HY000: Lost connection to MySQL server during query DROP TABLE t1; Server [mysqld.1 - pid: 31065, winpid: 31065, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2019-02-18 11:38:42 0 [Note] bld_debug/sql/mysqld (mysqld 10.4.3-MariaDB-debug-log) starting as process 31066 ... 2019-02-18 11:38:42 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4190) 2019-02-18 11:38:42 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) 2019-02-18 11:38:42 0 [Note] Plugin 'partition' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'SEQUENCE' is disabled. 2019-02-18 11:38:42 0 [Note] InnoDB: Using Linux native AIO 2019-02-18 11:38:42 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-02-18 11:38:42 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-02-18 11:38:42 0 [Note] InnoDB: Uses event mutexes 2019-02-18 11:38:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-02-18 11:38:42 0 [Note] InnoDB: Number of pools: 1 2019-02-18 11:38:42 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-02-18 11:38:42 0 [Note] mysqld: O_TMPFILE is not supported on bld_debug/mysql-test/var/tmp/mysqld.1 (disabling future attempts) 2019-02-18 11:38:42 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M 2019-02-18 11:38:42 0 [Note] InnoDB: Completed initialization of buffer pool 2019-02-18 11:38:42 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-02-18 11:38:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-02-18 11:38:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-02-18 11:38:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-02-18 11:38:42 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-02-18 11:38:42 0 [Note] InnoDB: Waiting for purge to start 2019-02-18 11:38:42 0 [Note] InnoDB: 10.4.3 started; log sequence number 151263; transaction id 34 2019-02-18 11:38:42 0 [Note] InnoDB: Loading buffer pool(s) from bld_debug/mysql-test/var/mysqld.1/data/ib_buffer_pool 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_CMP' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2019-02-18 11:38:42 0 [Note] InnoDB: Buffer pool(s) load completed at 190218 11:38:42 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'user_variables' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2019-02-18 11:38:42 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2019-02-18 11:38:42 0 [Warning] bld_debug/sql/mysqld: unknown option '--loose-pam-debug' 2019-02-18 11:38:42 0 [Warning] bld_debug/sql/mysqld: unknown option '--loose-aria' 2019-02-18 11:38:42 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-02-18 11:38:42 0 [Note] Reading of all Master_info entries succeded 2019-02-18 11:38:42 0 [Note] Added new Master_info '' to hash table 2019-02-18 11:38:42 0 [Note] bld_debug/sql/mysqld: ready for connections. Version: '10.4.3-MariaDB-debug-log' socket: 'bld_debug/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution mysqld: storage/innobase/handler/handler0alter.cc:6431: bool prepare_inplace_alter_table_dict(Alter_inplace_info*, const TABLE*, const TABLE*, const char*, ulint, ulint, ulint, bool, bool): Assertion `ha_alter_info->key_count + (dict_table_get_first_index(ctx->new_table))->is_gen_clust() + (ctx->old_table->fts_doc_id_index && innobase_fts_check_doc_id_index_in_def( altered_table->s->keys, altered_table->key_info) != FTS_EXIST_DOC_ID_INDEX) == ctx->num_to_add_index' failed. 190218 11:38:43 [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.3-MariaDB-debug-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=1 max_threads=153 thread_count=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63476 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f8f44000ce8 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 = 0x7f8f98e8ae60 thread_stack 0x49000 bld_debug/sql/mysqld(my_print_stacktrace+0x40)[0x559036be6c56] mysys/stacktrace.c:269(my_print_stacktrace)[0x5590364174fe] /lib/x86_64-linux-gnu/libpthread.so.0(+0x13150)[0x7f8fa0a20150] linux/raise.c:51(__GI_raise)[0x7f8f9fb6d0bb] stdlib/abort.c:92(__GI_abort)[0x7f8f9fb6ef5d] assert/assert.c:92(__assert_fail_base)[0x7f8f9fb64f17] /lib/x86_64-linux-gnu/libc.so.6(+0x2efc2)[0x7f8f9fb64fc2] bld_debug/sql/mysqld(+0xd25f2c)[0x559036687f2c] handler/handler0alter.cc:6433(prepare_inplace_alter_table_dict(Alter_inplace_info*, TABLE const*, TABLE const*, char const*, unsigned long, unsigned long, unsigned long, bool, bool))[0x55903668d62f] handler/handler0alter.cc:8086(ha_innobase::prepare_inplace_alter_table(TABLE*, Alter_inplace_info*))[0x5590364260c3] sql/handler.cc:4654(handler::ha_prepare_inplace_alter_table(TABLE*, Alter_inplace_info*))[0x5590361c1115] sql/sql_table.cc:7520(mysql_inplace_alter_table(THD*, TABLE_LIST*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, MDL_request*, Alter_table_ctx*))[0x5590361c7359] sql/sql_table.cc:9703(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool))[0x559036252807] sql/sql_alter.cc:493(Sql_cmd_alter_table::execute(THD*))[0x5590360e95e1] sql/sql_parse.cc:6330(mysql_execute_command(THD*))[0x5590360eea34] sql/sql_parse.cc:8141(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5590360d9e40] sql/sql_parse.cc:1819(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5590360d8688] sql/sql_parse.cc:1357(do_command(THD*))[0x55903624c745] sql/sql_connect.cc:1399(do_handle_one_connection(CONNECT*))[0x55903624c4a9] sql/sql_connect.cc:1303(handle_one_connection)[0x559036b7ea4e] nptl/pthread_create.c:465(start_thread)[0x7f8fa0a147fc] x86_64/clone.S:97(clone)[0x7f8f9fc4ab5f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f8f440144d0): ALTER TABLE t1 CHANGE COLUMN col_text col_text TEXT Connection ID (thread ID): 9 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=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 bld_debug/mysql-test/var/mysqld.1/data/ ----------SERVER LOG END------------- - found 'core' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace from coredump bld_debug/mysql-test/var/log/main.bs_3-innodb/mysqld.1/data/core Core generated by '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 31095] [New LWP 31071] [New LWP 31075] [New LWP 31077] [New LWP 31080] [New LWP 31089] [New LWP 31087] [New LWP 31066] [New LWP 31083] [New LWP 31070] [New LWP 31073] [New LWP 31084] [New LWP 31085] [New LWP 31086] [New LWP 31068] [New LWP 31091] [New LWP 31067] [New LWP 31090] [New LWP 31078] [New LWP 31072] [New LWP 31079] [New LWP 31069] [New LWP 31088] [New LWP 31081] [New LWP 31082] [New LWP 31074] [New LWP 31092] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". Core was generated by `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 0x7f8f98e8b700 (LWP 31095))] #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x0000559036be6d48 in my_write_core (sig=6) at mysys/stacktrace.c:481 #2 0x0000559036417929 in handle_fatal_signal (sig=6) at sql/signal_handler.cc:305 #3 #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51 #5 0x00007f8f9fb6ef5d in __GI_abort () at abort.c:90 #6 0x00007f8f9fb64f17 in __assert_fail_base (fmt=, assertion=assertion@entry=0x559036ef7a98 "ha_alter_info->key_count + (dict_table_get_first_index(ctx->new_table))->is_gen_clust() + (ctx->old_table->fts_doc_id_index && innobase_fts_check_doc_id_index_in_def( altered_table->s->keys, altered_t"..., file=file@entry=0x559036ef4820 "storage/innobase/handler/handler0alter.cc", line=line@entry=6431, function=function@entry=0x559036efcbe0 "bool prepare_inplace_alter_table_dict(Alter_inplace_info*, const TABLE*, const TABLE*, const char*, ulint, ulint, ulint, bool, bool)") at assert.c:92 #7 0x00007f8f9fb64fc2 in __GI___assert_fail (assertion=0x559036ef7a98 "ha_alter_info->key_count + (dict_table_get_first_index(ctx->new_table))->is_gen_clust() + (ctx->old_table->fts_doc_id_index && innobase_fts_check_doc_id_index_in_def( altered_table->s->keys, altered_t"..., file=0x559036ef4820 "storage/innobase/handler/handler0alter.cc", line=6431, function=0x559036efcbe0 "bool prepare_inplace_alter_table_dict(Alter_inplace_info*, const TABLE*, const TABLE*, const char*, ulint, ulint, ulint, bool, bool)") at assert.c:101 #8 0x0000559036687f2c in prepare_inplace_alter_table_dict (ha_alter_info=0x7f8f98e87a90, altered_table=0x7f8f440dee58, old_table=0x7f8f4417eca8, table_name=0x7f8f44064ab5 "t1", flags=0, flags2=80, fts_doc_id_col=18446744073709551615, add_fts_doc_id=false, add_fts_doc_id_idx=false) at storage/innobase/handler/handler0alter.cc:6421 #9 0x000055903668d62f in ha_innobase::prepare_inplace_alter_table (this=0x7f8f440d4c40, altered_table=0x7f8f440dee58, ha_alter_info=0x7f8f98e87a90) at storage/innobase/handler/handler0alter.cc:8086 #10 0x00005590364260c3 in handler::ha_prepare_inplace_alter_table (this=0x7f8f440d4c40, altered_table=0x7f8f440dee58, ha_alter_info=0x7f8f98e87a90) at sql/handler.cc:4653 #11 0x00005590361c1115 in mysql_inplace_alter_table (thd=0x7f8f44000ce8, table_list=0x7f8f440145e8, table=0x7f8f4417eca8, altered_table=0x7f8f440dee58, ha_alter_info=0x7f8f98e87a90, inplace_supported=HA_ALTER_INPLACE_INSTANT, target_mdl_request=0x7f8f98e87cc0, alter_ctx=0x7f8f98e88270) at sql/sql_table.cc:7520 #12 0x00005590361c7359 in mysql_alter_table (thd=0x7f8f44000ce8, new_db=0x7f8f440053e0, new_name=0x7f8f440057c8, create_info=0x7f8f98e88e60, table_list=0x7f8f440145e8, alter_info=0x7f8f98e88da0, order_num=0, order=0x0, ignore=false) at sql/sql_table.cc:9703 #13 0x0000559036252807 in Sql_cmd_alter_table::execute (this=0x7f8f44014d50, thd=0x7f8f44000ce8) at sql/sql_alter.cc:493 #14 0x00005590360e95e1 in mysql_execute_command (thd=0x7f8f44000ce8) at sql/sql_parse.cc:6330 #15 0x00005590360eea34 in mysql_parse (thd=0x7f8f44000ce8, rawbuf=0x7f8f440144d0 "ALTER TABLE t1 CHANGE COLUMN col_text col_text TEXT", length=51, parser_state=0x7f8f98e8a1e0, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:8141 #16 0x00005590360d9e40 in dispatch_command (command=COM_QUERY, thd=0x7f8f44000ce8, packet=0x7f8f44009f39 "ALTER TABLE t1 CHANGE COLUMN col_text col_text TEXT ", packet_length=52, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:1819 #17 0x00005590360d8688 in do_command (thd=0x7f8f44000ce8) at sql/sql_parse.cc:1357 #18 0x000055903624c745 in do_handle_one_connection (connect=0x559038978db8) at sql/sql_connect.cc:1399 #19 0x000055903624c4a9 in handle_one_connection (arg=0x559038978db8) at sql/sql_connect.cc:1302 #20 0x0000559036b7ea4e in pfs_spawn_thread (arg=0x559038a9a488) at storage/perfschema/pfs.cc:1862 #21 0x00007f8fa0a147fc in start_thread (arg=0x7f8f98e8b700) at pthread_create.c:465 #22 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 27 (Thread 0x7f8f98ed5700 (LWP 31092)): #0 0x00007f8fa0a1b072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55903795534c ) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x559037958708 , cond=0x559037955320 ) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x559037955320 , mutex=0x559037958708 ) at pthread_cond_wait.c:655 #3 0x0000559036bec478 in safe_cond_wait (cond=0x559037955320 , mp=0x5590379586e0 , file=0x559036cdd618 "include/mysql/psi/mysql_thread.h", line=1167) at mysys/thr_mutex.c:492 #4 0x0000559035fd86dc in inline_mysql_cond_wait (that=0x559037955320 , mutex=0x5590379586e0 , src_file=0x559036cde1a8 "sql/slave.cc", src_line=519) at include/mysql/psi/mysql_thread.h:1167 #5 0x0000559035fd9f45 in handle_slave_background (arg=0x0) at sql/slave.cc:519 #6 0x0000559036b7ea4e in pfs_spawn_thread (arg=0x559038a7ce48) at storage/perfschema/pfs.cc:1862 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f98ed5700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 26 (Thread 0x7f8f91ffb700 (LWP 31074)): #0 0x00007f8fa12f363a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000559036719260 in LinuxAIOHandler::collect (this=0x7f8f91ffac10) at storage/innobase/os/os0file.cc:1915 #2 0x00005590367197b1 in LinuxAIOHandler::poll (this=0x7f8f91ffac10, m1=0x7f8f91ffacb8, m2=0x7f8f91ffacc0, request=0x7f8f91ffacf0) at storage/innobase/os/os0file.cc:2060 #3 0x0000559036719924 in os_aio_linux_handler (global_segment=5, m1=0x7f8f91ffacb8, m2=0x7f8f91ffacc0, request=0x7f8f91ffacf0) at storage/innobase/os/os0file.cc:2114 #4 0x000055903671e5ba in os_aio_handler (segment=5, m1=0x7f8f91ffacb8, m2=0x7f8f91ffacc0, request=0x7f8f91ffacf0) at storage/innobase/os/os0file.cc:5665 #5 0x0000559036976883 in fil_aio_wait (segment=5) at storage/innobase/fil/fil0fil.cc:4344 #6 0x00005590368196cc in io_handler_thread (arg=0x5590379cff48 ) at storage/innobase/srv/srv0start.cc:325 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f91ffb700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 25 (Thread 0x7f8f7dffb700 (LWP 31082)): #0 0x00007f8fa0a1f5f8 in __GI___nanosleep (requested_time=0x7f8f7dffae70, remaining=0x0) at ../sysdeps/unix/sysv/linux/nanosleep.c:27 #1 0x0000559036726611 in os_thread_sleep (tm=1000000) at storage/innobase/os/os0thread.cc:225 #2 0x00005590368172f7 in srv_master_sleep () at storage/innobase/srv/srv0srv.cc:2309 #3 0x0000559036817435 in srv_master_thread (arg=0x0) at storage/innobase/srv/srv0srv.cc:2350 #4 0x00007f8fa0a147fc in start_thread (arg=0x7f8f7dffb700) at pthread_create.c:465 #5 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 24 (Thread 0x7f8f7e7fc700 (LWP 31081)): #0 0x00007f8fa0a1b786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f8f7e7fbc70, expected=0, futex_word=0x5590388cb43c) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f8f7e7fbc70, mutex=0x5590388cb3e8, cond=0x5590388cb410) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x5590388cb410, mutex=0x5590388cb3e8, abstime=0x7f8f7e7fbc70) at pthread_cond_wait.c:667 #3 0x0000559036725c0c in os_event::timed_wait (this=0x5590388cb3d0, abstime=0x7f8f7e7fbc70) at storage/innobase/os/os0event.cc:276 #4 0x0000559036725f39 in os_event::wait_time_low (this=0x5590388cb3d0, time_in_usec=5000000, reset_sig_count=8) at storage/innobase/os/os0event.cc:398 #5 0x00005590367260d7 in os_event_wait_time_low (event=0x5590388cb3d0, time_in_usec=5000000, reset_sig_count=8) at storage/innobase/os/os0event.cc:498 #6 0x000055903687650a in ib_wqueue_timedwait (wq=0x5590388cb240, wait_in_usecs=5000000) at storage/innobase/ut/ut0wqueue.cc:161 #7 0x00005590369bb079 in fts_optimize_thread (arg=0x5590388cb240) at storage/innobase/fts/fts0opt.cc:2896 #8 0x00007f8fa0a147fc in start_thread (arg=0x7f8f7e7fc700) at pthread_create.c:465 #9 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 23 (Thread 0x7f8f767fc700 (LWP 31088)): #0 0x00007f8fa0a1f5f8 in __GI___nanosleep (requested_time=0x7f8f767fb7e0, remaining=0x0) at ../sysdeps/unix/sysv/linux/nanosleep.c:27 #1 0x0000559036726611 in os_thread_sleep (tm=1000000) at storage/innobase/os/os0thread.cc:225 #2 0x00005590368cfa28 in btr_defragment_thread () at storage/innobase/btr/btr0defragment.cc:702 #3 0x00007f8fa0a147fc in start_thread (arg=0x7f8f767fc700) at pthread_create.c:465 #4 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 22 (Thread 0x7f8f98d1f700 (LWP 31069)): #0 0x00007f8fa12f363a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000559036719260 in LinuxAIOHandler::collect (this=0x7f8f98d1ec10) at storage/innobase/os/os0file.cc:1915 #2 0x00005590367197b1 in LinuxAIOHandler::poll (this=0x7f8f98d1ec10, m1=0x7f8f98d1ecb8, m2=0x7f8f98d1ecc0, request=0x7f8f98d1ecf0) at storage/innobase/os/os0file.cc:2060 #3 0x0000559036719924 in os_aio_linux_handler (global_segment=0, m1=0x7f8f98d1ecb8, m2=0x7f8f98d1ecc0, request=0x7f8f98d1ecf0) at storage/innobase/os/os0file.cc:2114 #4 0x000055903671e5ba in os_aio_handler (segment=0, m1=0x7f8f98d1ecb8, m2=0x7f8f98d1ecc0, request=0x7f8f98d1ecf0) at storage/innobase/os/os0file.cc:5665 #5 0x0000559036976883 in fil_aio_wait (segment=0) at storage/innobase/fil/fil0fil.cc:4344 #6 0x00005590368196cc in io_handler_thread (arg=0x5590379cff20 ) at storage/innobase/srv/srv0start.cc:325 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f98d1f700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 21 (Thread 0x7f8f7effd700 (LWP 31079)): #0 0x00007f8fa0a1b786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f8f7effce50, expected=0, futex_word=0x55903872b698) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f8f7effce50, mutex=0x55903872b648, cond=0x55903872b670) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55903872b670, mutex=0x55903872b648, abstime=0x7f8f7effce50) at pthread_cond_wait.c:667 #3 0x0000559036725c0c in os_event::timed_wait (this=0x55903872b630, abstime=0x7f8f7effce50) at storage/innobase/os/os0event.cc:276 #4 0x0000559036725f39 in os_event::wait_time_low (this=0x55903872b630, time_in_usec=5000000, reset_sig_count=1) at storage/innobase/os/os0event.cc:398 #5 0x00005590367260d7 in os_event_wait_time_low (event=0x55903872b630, time_in_usec=5000000, reset_sig_count=1) at storage/innobase/os/os0event.cc:498 #6 0x0000559036815cad in srv_monitor_thread () at storage/innobase/srv/srv0srv.cc:1672 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f7effd700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 20 (Thread 0x7f8f92ffd700 (LWP 31072)): #0 0x00007f8fa12f363a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000559036719260 in LinuxAIOHandler::collect (this=0x7f8f92ffcc10) at storage/innobase/os/os0file.cc:1915 #2 0x00005590367197b1 in LinuxAIOHandler::poll (this=0x7f8f92ffcc10, m1=0x7f8f92ffccb8, m2=0x7f8f92ffccc0, request=0x7f8f92ffccf0) at storage/innobase/os/os0file.cc:2060 #3 0x0000559036719924 in os_aio_linux_handler (global_segment=3, m1=0x7f8f92ffccb8, m2=0x7f8f92ffccc0, request=0x7f8f92ffccf0) at storage/innobase/os/os0file.cc:2114 #4 0x000055903671e5ba in os_aio_handler (segment=3, m1=0x7f8f92ffccb8, m2=0x7f8f92ffccc0, request=0x7f8f92ffccf0) at storage/innobase/os/os0file.cc:5665 #5 0x0000559036976883 in fil_aio_wait (segment=3) at storage/innobase/fil/fil0fil.cc:4344 #6 0x00005590368196cc in io_handler_thread (arg=0x5590379cff38 ) at storage/innobase/srv/srv0start.cc:325 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f92ffd700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 19 (Thread 0x7f8f7f7fe700 (LWP 31078)): #0 0x00007f8fa0a1b786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f8f7f7fdcb0, expected=0, futex_word=0x55903872b618) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f8f7f7fdcb0, mutex=0x55903872b5c8, cond=0x55903872b5f0) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55903872b5f0, mutex=0x55903872b5c8, abstime=0x7f8f7f7fdcb0) at pthread_cond_wait.c:667 #3 0x0000559036725c0c in os_event::timed_wait (this=0x55903872b5b0, abstime=0x7f8f7f7fdcb0) at storage/innobase/os/os0event.cc:276 #4 0x0000559036725f39 in os_event::wait_time_low (this=0x55903872b5b0, time_in_usec=1000000, reset_sig_count=1) at storage/innobase/os/os0event.cc:398 #5 0x00005590367260d7 in os_event_wait_time_low (event=0x55903872b5b0, time_in_usec=1000000, reset_sig_count=1) at storage/innobase/os/os0event.cc:498 #6 0x00005590368161dc in srv_error_monitor_thread () at storage/innobase/srv/srv0srv.cc:1836 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f7f7fe700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 18 (Thread 0x7f8f757fa700 (LWP 31090)): #0 0x00007f8fa0a1b072 in futex_wait_cancelable (private=, expected=0, futex_word=0x7f8f757f9dd8) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7f8f757f9e18, cond=0x7f8f757f9db0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7f8f757f9db0, mutex=0x7f8f757f9e18) at pthread_cond_wait.c:655 #3 0x0000559036bec478 in safe_cond_wait (cond=0x7f8f757f9db0, mp=0x7f8f757f9df0, file=0x559036edf740 "include/mysql/psi/mysql_thread.h", line=1178) at mysys/thr_mutex.c:492 #4 0x0000559036639610 in inline_mysql_cond_wait (that=0x7f8f757f9db0, mutex=0x7f8f757f9df0, src_file=0x559036ee1188 "storage/innobase/handler/ha_innodb.cc", src_line=294) at include/mysql/psi/mysql_thread.h:1178 #5 0x000055903663e2cc in thd_destructor_proxy () at storage/innobase/handler/ha_innodb.cc:294 #6 0x0000559036b7ea4e in pfs_spawn_thread (arg=0x55903896a118) at storage/perfschema/pfs.cc:1862 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f757fa700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 17 (Thread 0x7f8f9b8db700 (LWP 31067)): #0 0x00007f8fa0a1b786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f8f9b8daea0, expected=0, futex_word=0x5590381f3fa8 ) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f8f9b8daea0, mutex=0x5590381f3ee8 , cond=0x5590381f3f80 ) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x5590381f3f80 , mutex=0x5590381f3ee8 , abstime=0x7f8f9b8daea0) at pthread_cond_wait.c:667 #3 0x0000559036bec838 in safe_cond_timedwait (cond=0x5590381f3f80 , mp=0x5590381f3ec0 , abstime=0x7f8f9b8daea0, file=0x559037095400 "include/mysql/psi/mysql_thread.h", line=1204) at mysys/thr_mutex.c:546 #4 0x0000559036bed7ff in inline_mysql_cond_timedwait (that=0x5590381f3f80 , mutex=0x5590381f3ec0 , abstime=0x7f8f9b8daea0, src_file=0x559037095440 "mysys/thr_timer.c", src_line=292) at include/mysql/psi/mysql_thread.h:1204 #5 0x0000559036bee364 in timer_handler (arg=0x0) at mysys/thr_timer.c:292 #6 0x0000559036b7ea4e in pfs_spawn_thread (arg=0x559038636da8) at storage/perfschema/pfs.cc:1862 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f9b8db700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 16 (Thread 0x7f8f98f1f700 (LWP 31091)): #0 0x00007f8f9fb6e99e in __GI___sigwaitinfo (set=, info=0x7f8f98f1ed40) at ../sysdeps/unix/sysv/linux/sigwaitinfo.c:56 #1 0x0000559035fa76c8 in my_sigwait (set=0x7f8f98f1ee20, sig=0x7f8f98f1ede4, code=0x7f8f98f1ede8) at include/my_pthread.h:196 #2 0x0000559035fadce7 in signal_hand (arg=0x0) at sql/mysqld.cc:3230 #3 0x0000559036b7ea4e in pfs_spawn_thread (arg=0x55903896f868) at storage/perfschema/pfs.cc:1862 #4 0x00007f8fa0a147fc in start_thread (arg=0x7f8f98f1f700) at pthread_create.c:465 #5 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 15 (Thread 0x7f8f9a571700 (LWP 31068)): #0 0x00007f8fa0a1b786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f8f9a570df0, expected=0, futex_word=0x5590381e17e8 ) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f8f9a570df0, mutex=0x5590381e1728 , cond=0x5590381e17c0 ) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x5590381e17c0 , mutex=0x5590381e1728 , abstime=0x7f8f9a570df0) at pthread_cond_wait.c:667 #3 0x0000559036bec838 in safe_cond_timedwait (cond=0x5590381e17c0 , mp=0x5590381e1700 , abstime=0x7f8f9a570df0, file=0x559037051ce0 "include/mysql/psi/mysql_thread.h", line=1204) at mysys/thr_mutex.c:546 #4 0x0000559036a54bb5 in inline_mysql_cond_timedwait (that=0x5590381e17c0 , mutex=0x5590381e1700 , abstime=0x7f8f9a570df0, src_file=0x559037051d20 "storage/maria/ma_servicethread.c", src_line=116) at include/mysql/psi/mysql_thread.h:1204 #5 0x0000559036a550da in my_service_thread_sleep (control=0x559037796d40 , sleep_time=29000000000) at storage/maria/ma_servicethread.c:115 #6 0x0000559036a4956a in ma_checkpoint_background (arg=0x1e) at storage/maria/ma_checkpoint.c:707 #7 0x0000559036b7ea4e in pfs_spawn_thread (arg=0x5590386e3488) at storage/perfschema/pfs.cc:1862 #8 0x00007f8fa0a147fc in start_thread (arg=0x7f8f9a571700) at pthread_create.c:465 #9 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 14 (Thread 0x7f8f777fe700 (LWP 31086)): #0 0x00007f8fa0a1b072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55903893e27c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55903893e228, cond=0x55903893e250) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55903893e250, mutex=0x55903893e228) at pthread_cond_wait.c:655 #3 0x000055903672630e in os_event::wait (this=0x55903893e210) at storage/innobase/os/os0event.cc:159 #4 0x0000559036725da6 in os_event::wait_low (this=0x55903893e210, reset_sig_count=10) at storage/innobase/os/os0event.cc:326 #5 0x00005590367260fc in os_event_wait_low (event=0x55903893e210, reset_sig_count=10) at storage/innobase/os/os0event.cc:515 #6 0x0000559036821abc in sync_array_wait_event (arr=0x559038702780, cell=@0x7f8f777fdc58: 0x5590387028f0) at storage/innobase/sync/sync0arr.cc:469 #7 0x00005590368248ff in rw_lock_s_lock_spin (lock=0x559038935090, pass=0, file_name=0x559036f729f0 "storage/innobase/row/row0purge.cc", line=1077) at storage/innobase/sync/sync0rw.cc:378 #8 0x00005590367d1b3d in rw_lock_s_lock_func (lock=0x559038935090, pass=0, file_name=0x559036f729f0 "storage/innobase/row/row0purge.cc", line=1077) at storage/innobase/include/sync0rw.ic:285 #9 0x00005590367d1f77 in pfs_rw_lock_s_lock_func (lock=0x559038935090, pass=0, file_name=0x559036f729f0 "storage/innobase/row/row0purge.cc", line=1077) at storage/innobase/include/sync0rw.ic:645 #10 0x00005590367d73ca in row_purge_parse_undo_rec (node=0x55903894c1c0, undo_rec=0x7f8f60012330 "", updated_extern=0x7f8f777fddde, thr=0x55903894c108) at storage/innobase/row/row0purge.cc:1077 #11 0x00005590367d7c30 in row_purge (node=0x55903894c1c0, undo_rec=0x7f8f60012330 "", thr=0x55903894c108) at storage/innobase/row/row0purge.cc:1258 #12 0x00005590367d7fe9 in row_purge_step (thr=0x55903894c108) at storage/innobase/row/row0purge.cc:1347 #13 0x00005590367592be in que_thr_step (thr=0x55903894c108) at storage/innobase/que/que0que.cc:1042 #14 0x00005590367594f4 in que_run_threads_low (thr=0x55903894c108) at storage/innobase/que/que0que.cc:1104 #15 0x00005590367596e6 in que_run_threads (thr=0x55903894c108) at storage/innobase/que/que0que.cc:1144 #16 0x00005590368177c8 in srv_task_execute () at storage/innobase/srv/srv0srv.cc:2437 #17 0x0000559036817972 in srv_worker_thread (arg=0x0) at storage/innobase/srv/srv0srv.cc:2485 #18 0x00007f8fa0a147fc in start_thread (arg=0x7f8f777fe700) at pthread_create.c:465 #19 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 13 (Thread 0x7f8f77fff700 (LWP 31085)): #0 0x00007f8fa0a1b072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55903893e27c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55903893e228, cond=0x55903893e250) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55903893e250, mutex=0x55903893e228) at pthread_cond_wait.c:655 #3 0x000055903672630e in os_event::wait (this=0x55903893e210) at storage/innobase/os/os0event.cc:159 #4 0x0000559036725da6 in os_event::wait_low (this=0x55903893e210, reset_sig_count=10) at storage/innobase/os/os0event.cc:326 #5 0x00005590367260fc in os_event_wait_low (event=0x55903893e210, reset_sig_count=10) at storage/innobase/os/os0event.cc:515 #6 0x0000559036821abc in sync_array_wait_event (arr=0x559038702780, cell=@0x7f8f77ffec58: 0x5590387028b0) at storage/innobase/sync/sync0arr.cc:469 #7 0x00005590368248ff in rw_lock_s_lock_spin (lock=0x559038935090, pass=0, file_name=0x559036f729f0 "storage/innobase/row/row0purge.cc", line=1077) at storage/innobase/sync/sync0rw.cc:378 #8 0x00005590367d1b3d in rw_lock_s_lock_func (lock=0x559038935090, pass=0, file_name=0x559036f729f0 "storage/innobase/row/row0purge.cc", line=1077) at storage/innobase/include/sync0rw.ic:285 #9 0x00005590367d1f77 in pfs_rw_lock_s_lock_func (lock=0x559038935090, pass=0, file_name=0x559036f729f0 "storage/innobase/row/row0purge.cc", line=1077) at storage/innobase/include/sync0rw.ic:645 #10 0x00005590367d73ca in row_purge_parse_undo_rec (node=0x55903894c818, undo_rec=0x7f8f600142b0 "", updated_extern=0x7f8f77ffedde, thr=0x55903894c370) at storage/innobase/row/row0purge.cc:1077 #11 0x00005590367d7c30 in row_purge (node=0x55903894c818, undo_rec=0x7f8f600142b0 "", thr=0x55903894c370) at storage/innobase/row/row0purge.cc:1258 #12 0x00005590367d7fe9 in row_purge_step (thr=0x55903894c370) at storage/innobase/row/row0purge.cc:1347 #13 0x00005590367592be in que_thr_step (thr=0x55903894c370) at storage/innobase/que/que0que.cc:1042 #14 0x00005590367594f4 in que_run_threads_low (thr=0x55903894c370) at storage/innobase/que/que0que.cc:1104 #15 0x00005590367596e6 in que_run_threads (thr=0x55903894c370) at storage/innobase/que/que0que.cc:1144 #16 0x00005590368177c8 in srv_task_execute () at storage/innobase/srv/srv0srv.cc:2437 #17 0x0000559036817972 in srv_worker_thread (arg=0x0) at storage/innobase/srv/srv0srv.cc:2485 #18 0x00007f8fa0a147fc in start_thread (arg=0x7f8f77fff700) at pthread_create.c:465 #19 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 12 (Thread 0x7f8f7cff9700 (LWP 31084)): #0 0x00007f8fa0a1b072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55903893e27c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55903893e228, cond=0x55903893e250) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55903893e250, mutex=0x55903893e228) at pthread_cond_wait.c:655 #3 0x000055903672630e in os_event::wait (this=0x55903893e210) at storage/innobase/os/os0event.cc:159 #4 0x0000559036725da6 in os_event::wait_low (this=0x55903893e210, reset_sig_count=10) at storage/innobase/os/os0event.cc:326 #5 0x00005590367260fc in os_event_wait_low (event=0x55903893e210, reset_sig_count=10) at storage/innobase/os/os0event.cc:515 #6 0x0000559036821abc in sync_array_wait_event (arr=0x559038702780, cell=@0x7f8f7cff8c58: 0x559038702930) at storage/innobase/sync/sync0arr.cc:469 #7 0x00005590368248ff in rw_lock_s_lock_spin (lock=0x559038935090, pass=0, file_name=0x559036f729f0 "storage/innobase/row/row0purge.cc", line=1077) at storage/innobase/sync/sync0rw.cc:378 #8 0x00005590367d1b3d in rw_lock_s_lock_func (lock=0x559038935090, pass=0, file_name=0x559036f729f0 "storage/innobase/row/row0purge.cc", line=1077) at storage/innobase/include/sync0rw.ic:285 #9 0x00005590367d1f77 in pfs_rw_lock_s_lock_func (lock=0x559038935090, pass=0, file_name=0x559036f729f0 "storage/innobase/row/row0purge.cc", line=1077) at storage/innobase/include/sync0rw.ic:645 #10 0x00005590367d73ca in row_purge_parse_undo_rec (node=0x55903894bf58, undo_rec=0x7f8f60010318 "", updated_extern=0x7f8f7cff8dde, thr=0x55903894bd88) at storage/innobase/row/row0purge.cc:1077 #11 0x00005590367d7c30 in row_purge (node=0x55903894bf58, undo_rec=0x7f8f60010318 "", thr=0x55903894bd88) at storage/innobase/row/row0purge.cc:1258 #12 0x00005590367d7fe9 in row_purge_step (thr=0x55903894bd88) at storage/innobase/row/row0purge.cc:1347 #13 0x00005590367592be in que_thr_step (thr=0x55903894bd88) at storage/innobase/que/que0que.cc:1042 #14 0x00005590367594f4 in que_run_threads_low (thr=0x55903894bd88) at storage/innobase/que/que0que.cc:1104 #15 0x00005590367596e6 in que_run_threads (thr=0x55903894bd88) at storage/innobase/que/que0que.cc:1144 #16 0x00005590368177c8 in srv_task_execute () at storage/innobase/srv/srv0srv.cc:2437 #17 0x0000559036817972 in srv_worker_thread (arg=0x0) at storage/innobase/srv/srv0srv.cc:2485 #18 0x00007f8fa0a147fc in start_thread (arg=0x7f8f7cff9700) at pthread_create.c:465 #19 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 11 (Thread 0x7f8f927fc700 (LWP 31073)): #0 0x00007f8fa12f363a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000559036719260 in LinuxAIOHandler::collect (this=0x7f8f927fbc10) at storage/innobase/os/os0file.cc:1915 #2 0x00005590367197b1 in LinuxAIOHandler::poll (this=0x7f8f927fbc10, m1=0x7f8f927fbcb8, m2=0x7f8f927fbcc0, request=0x7f8f927fbcf0) at storage/innobase/os/os0file.cc:2060 #3 0x0000559036719924 in os_aio_linux_handler (global_segment=4, m1=0x7f8f927fbcb8, m2=0x7f8f927fbcc0, request=0x7f8f927fbcf0) at storage/innobase/os/os0file.cc:2114 #4 0x000055903671e5ba in os_aio_handler (segment=4, m1=0x7f8f927fbcb8, m2=0x7f8f927fbcc0, request=0x7f8f927fbcf0) at storage/innobase/os/os0file.cc:5665 #5 0x0000559036976883 in fil_aio_wait (segment=4) at storage/innobase/fil/fil0fil.cc:4344 #6 0x00005590368196cc in io_handler_thread (arg=0x5590379cff40 ) at storage/innobase/srv/srv0start.cc:325 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f927fc700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 10 (Thread 0x7f8f93fff700 (LWP 31070)): #0 0x00007f8fa12f363a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000559036719260 in LinuxAIOHandler::collect (this=0x7f8f93ffec10) at storage/innobase/os/os0file.cc:1915 #2 0x00005590367197b1 in LinuxAIOHandler::poll (this=0x7f8f93ffec10, m1=0x7f8f93ffecb8, m2=0x7f8f93ffecc0, request=0x7f8f93ffecf0) at storage/innobase/os/os0file.cc:2060 #3 0x0000559036719924 in os_aio_linux_handler (global_segment=1, m1=0x7f8f93ffecb8, m2=0x7f8f93ffecc0, request=0x7f8f93ffecf0) at storage/innobase/os/os0file.cc:2114 #4 0x000055903671e5ba in os_aio_handler (segment=1, m1=0x7f8f93ffecb8, m2=0x7f8f93ffecc0, request=0x7f8f93ffecf0) at storage/innobase/os/os0file.cc:5665 #5 0x0000559036976883 in fil_aio_wait (segment=1) at storage/innobase/fil/fil0fil.cc:4344 #6 0x00005590368196cc in io_handler_thread (arg=0x5590379cff28 ) at storage/innobase/srv/srv0start.cc:325 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f93fff700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 9 (Thread 0x7f8f7d7fa700 (LWP 31083)): #0 0x00007f8fa0a1b072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55903893e27c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55903893e228, cond=0x55903893e250) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55903893e250, mutex=0x55903893e228) at pthread_cond_wait.c:655 #3 0x000055903672630e in os_event::wait (this=0x55903893e210) at storage/innobase/os/os0event.cc:159 #4 0x0000559036725da6 in os_event::wait_low (this=0x55903893e210, reset_sig_count=10) at storage/innobase/os/os0event.cc:326 #5 0x00005590367260fc in os_event_wait_low (event=0x55903893e210, reset_sig_count=10) at storage/innobase/os/os0event.cc:515 #6 0x0000559036821abc in sync_array_wait_event (arr=0x559038702780, cell=@0x7f8f7d7f9bc8: 0x559038702870) at storage/innobase/sync/sync0arr.cc:469 #7 0x00005590368248ff in rw_lock_s_lock_spin (lock=0x559038935090, pass=0, file_name=0x559036f729f0 "storage/innobase/row/row0purge.cc", line=1077) at storage/innobase/sync/sync0rw.cc:378 #8 0x00005590367d1b3d in rw_lock_s_lock_func (lock=0x559038935090, pass=0, file_name=0x559036f729f0 "storage/innobase/row/row0purge.cc", line=1077) at storage/innobase/include/sync0rw.ic:285 #9 0x00005590367d1f77 in pfs_rw_lock_s_lock_func (lock=0x559038935090, pass=0, file_name=0x559036f729f0 "storage/innobase/row/row0purge.cc", line=1077) at storage/innobase/include/sync0rw.ic:645 #10 0x00005590367d73ca in row_purge_parse_undo_rec (node=0x55903894ca80, undo_rec=0x7f8f60018190 "", updated_extern=0x7f8f7d7f9d4e, thr=0x55903894c9c8) at storage/innobase/row/row0purge.cc:1077 #11 0x00005590367d7c30 in row_purge (node=0x55903894ca80, undo_rec=0x7f8f60018190 "", thr=0x55903894c9c8) at storage/innobase/row/row0purge.cc:1258 #12 0x00005590367d7fe9 in row_purge_step (thr=0x55903894c9c8) at storage/innobase/row/row0purge.cc:1347 #13 0x00005590367592be in que_thr_step (thr=0x55903894c9c8) at storage/innobase/que/que0que.cc:1042 #14 0x00005590367594f4 in que_run_threads_low (thr=0x55903894c9c8) at storage/innobase/que/que0que.cc:1104 #15 0x00005590367596e6 in que_run_threads (thr=0x55903894c9c8) at storage/innobase/que/que0que.cc:1144 #16 0x0000559036841a28 in trx_purge (n_purge_threads=4, truncate=false) at storage/innobase/trx/trx0purge.cc:1325 #17 0x0000559036817c46 in srv_do_purge (n_total_purged=0x7f8f7d7f9ec8) at storage/innobase/srv/srv0srv.cc:2574 #18 0x000055903681807d in srv_purge_coordinator_thread (arg=0x0) at storage/innobase/srv/srv0srv.cc:2700 #19 0x00007f8fa0a147fc in start_thread (arg=0x7f8f7d7fa700) at pthread_create.c:465 #20 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 8 (Thread 0x7f8fa16ec740 (LWP 31066)): #0 0x00007f8f9fc3e951 in __GI___poll (fds=0x7fff86ee5620, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 #1 0x0000559035fb3f13 in handle_connections_sockets () at sql/mysqld.cc:6414 #2 0x0000559035fb3199 in mysqld_main (argc=146, argv=0x5590384f32e8) at sql/mysqld.cc:5850 #3 0x0000559035fa764a in main (argc=23, argv=0x7fff86ee5928) at sql/main.cc:25 Thread 7 (Thread 0x7f8f76ffd700 (LWP 31087)): #0 0x00007f8fa0a1b072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55903872b718) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55903872b6c8, cond=0x55903872b6f0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55903872b6f0, mutex=0x55903872b6c8) at pthread_cond_wait.c:655 #3 0x000055903672630e in os_event::wait (this=0x55903872b6b0) at storage/innobase/os/os0event.cc:159 #4 0x0000559036725da6 in os_event::wait_low (this=0x55903872b6b0, reset_sig_count=1) at storage/innobase/os/os0event.cc:326 #5 0x00005590367260fc in os_event_wait_low (event=0x55903872b6b0, reset_sig_count=0) at storage/innobase/os/os0event.cc:515 #6 0x00005590368f59f4 in buf_dump_thread () at storage/innobase/buf/buf0dump.cc:833 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f76ffd700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 6 (Thread 0x7f8f75ffb700 (LWP 31089)): #0 0x00007f8fa0a1b072 in futex_wait_cancelable (private=, expected=0, futex_word=0x55903872b818) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55903872b7c8, cond=0x55903872b7f0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55903872b7f0, mutex=0x55903872b7c8) at pthread_cond_wait.c:655 #3 0x000055903672630e in os_event::wait (this=0x55903872b7b0) at storage/innobase/os/os0event.cc:159 #4 0x0000559036725da6 in os_event::wait_low (this=0x55903872b7b0, reset_sig_count=1) at storage/innobase/os/os0event.cc:326 #5 0x00005590367260fc in os_event_wait_low (event=0x55903872b7b0, reset_sig_count=0) at storage/innobase/os/os0event.cc:515 #6 0x00005590368de06d in buf_resize_thread () at storage/innobase/buf/buf0buf.cc:3097 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f75ffb700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 5 (Thread 0x7f8f90ff9700 (LWP 31080)): #0 0x00007f8fa0a1b786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f8f90ff8e90, expected=0, futex_word=0x559038934b98) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f8f90ff8e90, mutex=0x559038934b48, cond=0x559038934b70) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x559038934b70, mutex=0x559038934b48, abstime=0x7f8f90ff8e90) at pthread_cond_wait.c:667 #3 0x0000559036725c0c in os_event::timed_wait (this=0x559038934b30, abstime=0x7f8f90ff8e90) at storage/innobase/os/os0event.cc:276 #4 0x0000559036725f39 in os_event::wait_time_low (this=0x559038934b30, time_in_usec=10000000, reset_sig_count=1) at storage/innobase/os/os0event.cc:398 #5 0x00005590367260d7 in os_event_wait_time_low (event=0x559038934b30, time_in_usec=10000000, reset_sig_count=0) at storage/innobase/os/os0event.cc:498 #6 0x000055903695fd48 in dict_stats_thread () at storage/innobase/dict/dict0stats_bg.cc:459 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f90ff9700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 4 (Thread 0x7f8f7ffff700 (LWP 31077)): #0 0x00007f8fa0a1b786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f8f7fffee70, expected=0, futex_word=0x5590389036b8) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f8f7fffee70, mutex=0x559038903668, cond=0x559038903690) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x559038903690, mutex=0x559038903668, abstime=0x7f8f7fffee70) at pthread_cond_wait.c:667 #3 0x0000559036725c0c in os_event::timed_wait (this=0x559038903650, abstime=0x7f8f7fffee70) at storage/innobase/os/os0event.cc:276 #4 0x0000559036725f39 in os_event::wait_time_low (this=0x559038903650, time_in_usec=1000000, reset_sig_count=1) at storage/innobase/os/os0event.cc:398 #5 0x00005590367260d7 in os_event_wait_time_low (event=0x559038903650, time_in_usec=1000000, reset_sig_count=1) at storage/innobase/os/os0event.cc:498 #6 0x00005590366f203c in lock_wait_timeout_thread () at storage/innobase/lock/lock0wait.cc:543 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f7ffff700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 3 (Thread 0x7f8f917fa700 (LWP 31075)): #0 0x00007f8fa0a1b786 in futex_abstimed_wait_cancelable (private=, abstime=0x7f8f917f9c00, expected=0, futex_word=0x55903872b79c) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f8f917f9c00, mutex=0x55903872b748, cond=0x55903872b770) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55903872b770, mutex=0x55903872b748, abstime=0x7f8f917f9c00) at pthread_cond_wait.c:667 #3 0x0000559036725c0c in os_event::timed_wait (this=0x55903872b730, abstime=0x7f8f917f9c00) at storage/innobase/os/os0event.cc:276 #4 0x0000559036725f39 in os_event::wait_time_low (this=0x55903872b730, time_in_usec=970000, reset_sig_count=2) at storage/innobase/os/os0event.cc:398 #5 0x00005590367260d7 in os_event_wait_time_low (event=0x55903872b730, time_in_usec=970000, reset_sig_count=2) at storage/innobase/os/os0event.cc:498 #6 0x00005590368ff498 in pc_sleep_if_needed (next_loop_time=1550486324805, sig_count=2, cur_time=1550486323835) at storage/innobase/buf/buf0flu.cc:2593 #7 0x0000559036900411 in buf_flush_page_cleaner_coordinator () at storage/innobase/buf/buf0flu.cc:3051 #8 0x00007f8fa0a147fc in start_thread (arg=0x7f8f917fa700) at pthread_create.c:465 #9 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 2 (Thread 0x7f8f937fe700 (LWP 31071)): #0 0x00007f8fa12f363a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000559036719260 in LinuxAIOHandler::collect (this=0x7f8f937fdc10) at storage/innobase/os/os0file.cc:1915 #2 0x00005590367197b1 in LinuxAIOHandler::poll (this=0x7f8f937fdc10, m1=0x7f8f937fdcb8, m2=0x7f8f937fdcc0, request=0x7f8f937fdcf0) at storage/innobase/os/os0file.cc:2060 #3 0x0000559036719924 in os_aio_linux_handler (global_segment=2, m1=0x7f8f937fdcb8, m2=0x7f8f937fdcc0, request=0x7f8f937fdcf0) at storage/innobase/os/os0file.cc:2114 #4 0x000055903671e5ba in os_aio_handler (segment=2, m1=0x7f8f937fdcb8, m2=0x7f8f937fdcc0, request=0x7f8f937fdcf0) at storage/innobase/os/os0file.cc:5665 #5 0x0000559036976883 in fil_aio_wait (segment=2) at storage/innobase/fil/fil0fil.cc:4344 #6 0x00005590368196cc in io_handler_thread (arg=0x5590379cff30 ) at storage/innobase/srv/srv0start.cc:325 #7 0x00007f8fa0a147fc in start_thread (arg=0x7f8f937fe700) at pthread_create.c:465 #8 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 1 (Thread 0x7f8f98e8b700 (LWP 31095)): #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x0000559036be6d48 in my_write_core (sig=6) at mysys/stacktrace.c:481 #2 0x0000559036417929 in handle_fatal_signal (sig=6) at sql/signal_handler.cc:305 #3 #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51 #5 0x00007f8f9fb6ef5d in __GI_abort () at abort.c:90 #6 0x00007f8f9fb64f17 in __assert_fail_base (fmt=, assertion=assertion@entry=0x559036ef7a98 "ha_alter_info->key_count + (dict_table_get_first_index(ctx->new_table))->is_gen_clust() + (ctx->old_table->fts_doc_id_index && innobase_fts_check_doc_id_index_in_def( altered_table->s->keys, altered_t"..., file=file@entry=0x559036ef4820 "storage/innobase/handler/handler0alter.cc", line=line@entry=6431, function=function@entry=0x559036efcbe0 "bool prepare_inplace_alter_table_dict(Alter_inplace_info*, const TABLE*, const TABLE*, const char*, ulint, ulint, ulint, bool, bool)") at assert.c:92 #7 0x00007f8f9fb64fc2 in __GI___assert_fail (assertion=0x559036ef7a98 "ha_alter_info->key_count + (dict_table_get_first_index(ctx->new_table))->is_gen_clust() + (ctx->old_table->fts_doc_id_index && innobase_fts_check_doc_id_index_in_def( altered_table->s->keys, altered_t"..., file=0x559036ef4820 "storage/innobase/handler/handler0alter.cc", line=6431, function=0x559036efcbe0 "bool prepare_inplace_alter_table_dict(Alter_inplace_info*, const TABLE*, const TABLE*, const char*, ulint, ulint, ulint, bool, bool)") at assert.c:101 #8 0x0000559036687f2c in prepare_inplace_alter_table_dict (ha_alter_info=0x7f8f98e87a90, altered_table=0x7f8f440dee58, old_table=0x7f8f4417eca8, table_name=0x7f8f44064ab5 "t1", flags=0, flags2=80, fts_doc_id_col=18446744073709551615, add_fts_doc_id=false, add_fts_doc_id_idx=false) at storage/innobase/handler/handler0alter.cc:6421 #9 0x000055903668d62f in ha_innobase::prepare_inplace_alter_table (this=0x7f8f440d4c40, altered_table=0x7f8f440dee58, ha_alter_info=0x7f8f98e87a90) at storage/innobase/handler/handler0alter.cc:8086 #10 0x00005590364260c3 in handler::ha_prepare_inplace_alter_table (this=0x7f8f440d4c40, altered_table=0x7f8f440dee58, ha_alter_info=0x7f8f98e87a90) at sql/handler.cc:4653 #11 0x00005590361c1115 in mysql_inplace_alter_table (thd=0x7f8f44000ce8, table_list=0x7f8f440145e8, table=0x7f8f4417eca8, altered_table=0x7f8f440dee58, ha_alter_info=0x7f8f98e87a90, inplace_supported=HA_ALTER_INPLACE_INSTANT, target_mdl_request=0x7f8f98e87cc0, alter_ctx=0x7f8f98e88270) at sql/sql_table.cc:7520 #12 0x00005590361c7359 in mysql_alter_table (thd=0x7f8f44000ce8, new_db=0x7f8f440053e0, new_name=0x7f8f440057c8, create_info=0x7f8f98e88e60, table_list=0x7f8f440145e8, alter_info=0x7f8f98e88da0, order_num=0, order=0x0, ignore=false) at sql/sql_table.cc:9703 #13 0x0000559036252807 in Sql_cmd_alter_table::execute (this=0x7f8f44014d50, thd=0x7f8f44000ce8) at sql/sql_alter.cc:493 #14 0x00005590360e95e1 in mysql_execute_command (thd=0x7f8f44000ce8) at sql/sql_parse.cc:6330 #15 0x00005590360eea34 in mysql_parse (thd=0x7f8f44000ce8, rawbuf=0x7f8f440144d0 "ALTER TABLE t1 CHANGE COLUMN col_text col_text TEXT", length=51, parser_state=0x7f8f98e8a1e0, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:8141 #16 0x00005590360d9e40 in dispatch_command (command=COM_QUERY, thd=0x7f8f44000ce8, packet=0x7f8f44009f39 "ALTER TABLE t1 CHANGE COLUMN col_text col_text TEXT ", packet_length=52, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:1819 #17 0x00005590360d8688 in do_command (thd=0x7f8f44000ce8) at sql/sql_parse.cc:1357 #18 0x000055903624c745 in do_handle_one_connection (connect=0x559038978db8) at sql/sql_connect.cc:1399 #19 0x000055903624c4a9 in handle_one_connection (arg=0x559038978db8) at sql/sql_connect.cc:1302 #20 0x0000559036b7ea4e in pfs_spawn_thread (arg=0x559038a9a488) at storage/perfschema/pfs.cc:1862 #21 0x00007f8fa0a147fc in start_thread (arg=0x7f8f98e8b700) at pthread_create.c:465 #22 0x00007f8f9fc4ab5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 - saving 'bld_debug/mysql-test/var/log/main.bs_3-innodb/' to 'bld_debug/mysql-test/var/log/main.bs_3-innodb/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 14 seconds executing testcases Failure: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.bs_3 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