[New LWP 7371] [New LWP 7323] [New LWP 7372] [New LWP 7324] [New LWP 7322] [New LWP 7336] [New LWP 7339] [New LWP 7334] [New LWP 7331] [New LWP 7326] [New LWP 7325] [New LWP 7348] [New LWP 7333] [New LWP 7337] [New LWP 7340] [New LWP 7343] [New LWP 7321] [New LWP 7328] [New LWP 7357] [New LWP 7338] [New LWP 7341] [New LWP 7346] [New LWP 7327] [New LWP 7329] [New LWP 7363] [New LWP 7342] [New LWP 7344] [New LWP 7365] [New LWP 7330] [New LWP 7369] [New LWP 7332] [New LWP 7347] [New LWP 7356] [New LWP 7345] [New LWP 7349] [New LWP 7352] [New LWP 7367] [New LWP 7351] [New LWP 7350] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". Core was generated by `/data/bld/10.3/bin/mysqld --no-defaults --basedir=/data/bld/10.3 --lc-messages-'. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 Thread 39 (Thread 0x7f14382f1700 (LWP 7350)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d679ce6ac3 in safe_cond_wait (cond=0x55d67a9c0bc8 , mp=0x55d67a9c0b18 , file=0x55d679f2cac0 "/data/src/10.3/include/mysql/psi/mysql_thread.h", line=1178) at /data/src/10.3/mysys/thr_mutex.c:492 #2 0x000055d67963a179 in inline_mysql_cond_wait (that=0x55d67a9c0bc8 , mutex=0x55d67a9c0b18 , src_file=0x55d679f2d214 "/data/src/10.3/sql/log.cc", src_line=9885) at /data/src/10.3/include/mysql/psi/mysql_thread.h:1178 #3 0x000055d679654ffc in binlog_background_thread (arg=0x0) at /data/src/10.3/sql/log.cc:9885 #4 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67ce58dc0) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #5 0x00007f1443b55494 in start_thread (arg=0x7f14382f1700) at pthread_create.c:333 #6 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 38 (Thread 0x7f14382a7700 (LWP 7351)): #0 do_sigwait (set=, set@entry=0x7f14382a6e30, sig=sig@entry=0x7f14382a6e00) at ../sysdeps/unix/sysv/linux/sigwait.c:64 #1 0x00007f1443b5eced in __sigwait (set=0x7f14382a6e30, sig=0x7f14382a6e00) at ../sysdeps/unix/sysv/linux/sigwait.c:96 #2 0x000055d679131545 in signal_hand (arg=0x0) at /data/src/10.3/sql/mysqld.cc:3550 #3 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67d97be20) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #4 0x00007f1443b55494 in start_thread (arg=0x7f14382a7700) at pthread_create.c:333 #5 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 37 (Thread 0x7f14380eb700 (LWP 7367)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d679ce6dcd in safe_cond_timedwait (cond=0x7f13bc000d00, mp=0x7f13bc000c50, abstime=0x7f14380e8f80, file=0x55d679de5dc0 "/data/src/10.3/include/mysql/psi/mysql_thread.h", line=1215) at /data/src/10.3/mysys/thr_mutex.c:546 #2 0x000055d6793b432b in inline_mysql_cond_timedwait (that=0x7f13bc000d00, mutex=0x7f13bc000c50, abstime=0x7f14380e8f80, src_file=0x55d679de606a "/data/src/10.3/sql/mdl.cc", src_line=1094) at /data/src/10.3/include/mysql/psi/mysql_thread.h:1215 #3 0x000055d6793b5743 in MDL_wait::timed_wait (this=0x7f13bc000c50, owner=0x7f13bc000be0, abs_timeout=0x7f14380e8f80, set_status_on_timeout=false, wait_state_name=0x55d67a7af2f0 ) at /data/src/10.3/sql/mdl.cc:1094 #4 0x000055d6793b71eb in MDL_context::acquire_lock (this=0x7f13bc000c50, mdl_request=0x7f13bc014068, lock_wait_timeout=86400) at /data/src/10.3/sql/mdl.cc:2148 #5 0x000055d6793b76a0 in MDL_context::acquire_locks (this=0x7f13bc000c50, mdl_requests=0x7f14380e90c0, lock_wait_timeout=86400) at /data/src/10.3/sql/mdl.cc:2268 #6 0x000055d6791c74c6 in lock_table_names (thd=0x7f13bc000b00, options=..., tables_start=0x7f13bc013c08, tables_end=0x0, lock_wait_timeout=86400, flags=0) at /data/src/10.3/sql/sql_base.cc:3782 #7 0x000055d67970180e in lock_table_names (thd=0x7f13bc000b00, table_list=0x7f13bc013c08, table_list_end=0x0, lock_wait_timeout=86400, flags=0) at /data/src/10.3/sql/sql_base.h:228 #8 0x000055d67970236c in Sql_cmd_truncate_table::lock_table (this=0x7f13bc014258, thd=0x7f13bc000b00, table_ref=0x7f13bc013c08, hton_can_recreate=0x7f14380e93ca) at /data/src/10.3/sql/sql_truncate.cc:316 #9 0x000055d6797026e4 in Sql_cmd_truncate_table::truncate_table (this=0x7f13bc014258, thd=0x7f13bc000b00, table_ref=0x7f13bc013c08) at /data/src/10.3/sql/sql_truncate.cc:419 #10 0x000055d679702920 in Sql_cmd_truncate_table::execute (this=0x7f13bc014258, thd=0x7f13bc000b00) at /data/src/10.3/sql/sql_truncate.cc:498 #11 0x000055d67925900b in mysql_execute_command (thd=0x7f13bc000b00) at /data/src/10.3/sql/sql_parse.cc:6282 #12 0x000055d67925dad8 in mysql_parse (thd=0x7f13bc000b00, rawbuf=0x7f13bc013a28 "TRUNCATE TABLE performance_schema.events_waits_summary_by_thread_by_event_name /* QNO 1232 CON_ID 19 */", length=103, parser_state=0x7f14380ea5d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8001 #13 0x000055d67924b2bb in dispatch_command (command=COM_QUERY, thd=0x7f13bc000b00, packet=0x7f13bc00b261 "TRUNCATE TABLE performance_schema.events_waits_summary_by_thread_by_event_name /* QNO 1232 CON_ID 19 */ ", packet_length=104, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846 #14 0x000055d679249cfa in do_command (thd=0x7f13bc000b00) at /data/src/10.3/sql/sql_parse.cc:1391 #15 0x000055d6793ac78b in do_handle_one_connection (connect=0x55d67d97bc00) at /data/src/10.3/sql/sql_connect.cc:1402 #16 0x000055d6793ac518 in handle_one_connection (arg=0x55d67d97bc00) at /data/src/10.3/sql/sql_connect.cc:1308 #17 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67d9d1ac0) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #18 0x00007f1443b55494 in start_thread (arg=0x7f14380eb700) at pthread_create.c:333 #19 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 36 (Thread 0x7f143825d700 (LWP 7352)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d679ce6ac3 in safe_cond_wait (cond=0x55d67a98abc0 , mp=0x55d67a98e000 , file=0x55d679d86080 "/data/src/10.3/include/mysql/psi/mysql_thread.h", line=1178) at /data/src/10.3/mysys/thr_mutex.c:492 #2 0x000055d67915d052 in inline_mysql_cond_wait (that=0x55d67a98abc0 , mutex=0x55d67a98e000 , src_file=0x55d679d86a85 "/data/src/10.3/sql/slave.cc", src_line=506) at /data/src/10.3/include/mysql/psi/mysql_thread.h:1178 #3 0x000055d67915e45b in handle_slave_background (arg=0x0) at /data/src/10.3/sql/slave.cc:506 #4 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67d97be20) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #5 0x00007f1443b55494 in start_thread (arg=0x7f143825d700) at pthread_create.c:333 #6 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 35 (Thread 0x7f13f27fc700 (LWP 7349)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d679ce6ac3 in safe_cond_wait (cond=0x7f13f27fbdc0, mp=0x7f13f27fbe00, file=0x55d679f8d580 "/data/src/10.3/include/mysql/psi/mysql_thread.h", line=1178) at /data/src/10.3/mysys/thr_mutex.c:492 #2 0x000055d67983dcb9 in inline_mysql_cond_wait (that=0x7f13f27fbdc0, mutex=0x7f13f27fbe00, src_file=0x55d679f8ead0 "/data/src/10.3/storage/innobase/handler/ha_innodb.cc", src_line=315) at /data/src/10.3/include/mysql/psi/mysql_thread.h:1178 #3 0x000055d6798427a4 in thd_destructor_proxy () at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:315 #4 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67d960f90) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #5 0x00007f1443b55494 in start_thread (arg=0x7f13f27fc700) at pthread_create.c:333 #6 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 34 (Thread 0x7f1408ff9700 (LWP 7345)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d67991a796 in os_event::wait (this=0x55d67cf4aa00) at /data/src/10.3/storage/innobase/os/os0event.cc:163 #2 0x000055d67991a199 in os_event::wait_low (this=0x55d67cf4aa00, reset_sig_count=147) at /data/src/10.3/storage/innobase/os/os0event.cc:333 #3 0x000055d67991a54b in os_event_wait_low (event=0x55d67cf4aa00, reset_sig_count=0) at /data/src/10.3/storage/innobase/os/os0event.cc:527 #4 0x000055d679a17e18 in srv_resume_thread (slot=0x55d67a7cc240 , sig_count=0, wait=true, timeout_usec=0) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:912 #5 0x000055d679a1bb06 in srv_worker_thread (arg=0x0) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2531 #6 0x00007f1443b55494 in start_thread (arg=0x7f1408ff9700) at pthread_create.c:333 #7 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 33 (Thread 0x7f1438213700 (LWP 7356)): #0 0x00007f1441f324ed in poll () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x000055d679d47962 in vio_io_wait (vio=0x55d67da3c220, event=VIO_IO_EVENT_READ, timeout=28800000) at /data/src/10.3/vio/viosocket.c:962 #2 0x000055d679d46065 in vio_socket_io_wait (vio=0x55d67da3c220, event=VIO_IO_EVENT_READ) at /data/src/10.3/vio/viosocket.c:119 #3 0x000055d679d4624f in vio_read (vio=0x55d67da3c220, buf=0x7f13c800b260 "\a", size=4) at /data/src/10.3/vio/viosocket.c:196 #4 0x000055d679142de3 in my_real_read (net=0x7f13c8000e18, complen=0x7f1438212d50, header=1 '\001') at /data/src/10.3/sql/net_serv.cc:956 #5 0x000055d679143652 in my_net_read_packet_reallen (net=0x7f13c8000e18, read_from_server=1 '\001', reallen=0x7f1438212db8) at /data/src/10.3/sql/net_serv.cc:1237 #6 0x000055d679143606 in my_net_read_packet (net=0x7f13c8000e18, read_from_server=1 '\001') at /data/src/10.3/sql/net_serv.cc:1221 #7 0x000055d6792497f2 in do_command (thd=0x7f13c8000b00) at /data/src/10.3/sql/sql_parse.cc:1266 #8 0x000055d6793ac78b in do_handle_one_connection (connect=0x55d67da352a0) at /data/src/10.3/sql/sql_connect.cc:1402 #9 0x000055d6793ac518 in handle_one_connection (arg=0x55d67da352a0) at /data/src/10.3/sql/sql_connect.cc:1308 #10 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67da3d6e0) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #11 0x00007f1443b55494 in start_thread (arg=0x7f1438213700) at pthread_create.c:333 #12 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 32 (Thread 0x7f13f37fe700 (LWP 7347)): #0 0x00007f1443b5e7dd in nanosleep () at ../sysdeps/unix/syscall-template.S:84 #1 0x000055d67991aabd in os_thread_sleep (tm=1000000) at /data/src/10.3/storage/innobase/os/os0thread.cc:230 #2 0x000055d679ad8c2b in btr_defragment_thread () at /data/src/10.3/storage/innobase/btr/btr0defragment.cc:756 #3 0x00007f1443b55494 in start_thread (arg=0x7f13f37fe700) at pthread_create.c:333 #4 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 31 (Thread 0x7f14131fa700 (LWP 7332)): #0 0x00007f144394c6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d67990ce2d in LinuxAIOHandler::collect (this=0x7f14131f9c40) at /data/src/10.3/storage/innobase/os/os0file.cc:1920 #2 0x000055d67990d35a in LinuxAIOHandler::poll (this=0x7f14131f9c40, m1=0x7f14131f9ce8, m2=0x7f14131f9cf0, request=0x7f14131f9d20) at /data/src/10.3/storage/innobase/os/os0file.cc:2065 #3 0x000055d67990d4ba in os_aio_linux_handler (global_segment=8, m1=0x7f14131f9ce8, m2=0x7f14131f9cf0, request=0x7f14131f9d20) at /data/src/10.3/storage/innobase/os/os0file.cc:2119 #4 0x000055d67991207a in os_aio_handler (segment=8, m1=0x7f14131f9ce8, m2=0x7f14131f9cf0, request=0x7f14131f9d20) at /data/src/10.3/storage/innobase/os/os0file.cc:5647 #5 0x000055d679b8208f in fil_aio_wait (segment=8) at /data/src/10.3/storage/innobase/fil/fil0fil.cc:4678 #6 0x000055d679a1e66e in io_handler_thread (arg=0x55d67b20f700 ) at /data/src/10.3/storage/innobase/srv/srv0start.cc:339 #7 0x00007f1443b55494 in start_thread (arg=0x7f14131fa700) at pthread_create.c:333 #8 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 30 (Thread 0x7f1438060700 (LWP 7369)): #0 0x00007f1442200e5a in ?? () from /lib/x86_64-linux-gnu/libgcc_s.so.1 #1 0x00007f14422016c8 in _Unwind_Backtrace () from /lib/x86_64-linux-gnu/libgcc_s.so.1 #2 0x00007f1441f48aaf in backtrace () from /lib/x86_64-linux-gnu/libc.so.6 #3 0x000055d679cedaed in sf_malloc (size=512, my_flags=80) at /data/src/10.3/mysys/safemalloc.c:141 #4 0x000055d679cedc5a in sf_realloc (ptr=0x7f13b0189b90, size=512, my_flags=80) at /data/src/10.3/mysys/safemalloc.c:182 #5 0x000055d679cdb022 in my_realloc (oldpoint=0x7f13b0189b90, size=512, my_flags=80) at /data/src/10.3/mysys/my_malloc.c:165 #6 0x000055d679cb0389 in alloc_dynamic (array=0x7f143805d560) at /data/src/10.3/mysys/array.c:145 #7 0x000055d679cb01f8 in insert_dynamic (array=0x7f143805d560, element=0x7f143805cf08) at /data/src/10.3/mysys/array.c:94 #8 0x000055d679304ef1 in Dynamic_array::append (this=0x7f143805d560, el=@0x7f143805cf08: 0x7f13b01ae5e8) at /data/src/10.3/sql/sql_array.h:175 #9 0x000055d67953dce3 in Discovered_table_list::add_table (this=0x7f143805d1d0, tname=0x55d679f81f77 "socket_summary_by_instance", tlen=26) at /data/src/10.3/sql/handler.cc:5380 #10 0x000055d67980292f in pfs_discover_table_names (hton=0x55d67ce52e10, db=0x7f13b01ad8f0, dir=0x0, result=0x7f143805d1d0) at /data/src/10.3/storage/perfschema/pfs_engine_table.cc:1383 #11 0x000055d67953e070 in discover_names (thd=0x7f13b0000b00, plugin=0x7f13b0162f70, arg=0x7f143805d120) at /data/src/10.3/sql/handler.cc:5448 #12 0x000055d67926b89e in plugin_foreach_with_mask (thd=0x7f13b0000b00, func=0x55d67953dfe2 , type=1, state_mask=8, arg=0x7f143805d120) at /data/src/10.3/sql/sql_plugin.cc:2436 #13 0x000055d67953e1a5 in ha_discover_table_names (thd=0x7f13b0000b00, db=0x7f13b01ad8f0, dirp=0x7f13b0081ab0, result=0x7f143805d1d0, reusable=false) at /data/src/10.3/sql/handler.cc:5488 #14 0x000055d6792e4d29 in find_files (thd=0x7f13b0000b00, files=0x7f143805d560, db=0x7f13b01ad8f0, path=0x7f143805d270 "./performance_schema/", wild=0x7f13b015f508) at /data/src/10.3/sql/sql_show.cc:1076 #15 0x000055d6792ef4af in make_table_name_list (thd=0x7f13b0000b00, table_names=0x7f143805d560, lex=0x7f13b0004880, lookup_field_vals=0x7f13b015f4f8, db_name=0x7f13b01ad8f0) at /data/src/10.3/sql/sql_show.cc:4415 #16 0x000055d6792f0d83 in get_all_tables (thd=0x7f13b0000b00, tables=0x7f13b0014e58, cond=0x7f13b00157a0) at /data/src/10.3/sql/sql_show.cc:5137 #17 0x000055d679302066 in get_schema_tables_result (join=0x7f13b013d098, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.3/sql/sql_show.cc:8801 #18 0x000055d67929bd90 in JOIN::exec_inner (this=0x7f13b013d098) at /data/src/10.3/sql/sql_select.cc:3916 #19 0x000055d67929b434 in JOIN::exec (this=0x7f13b013d098) at /data/src/10.3/sql/sql_select.cc:3747 #20 0x000055d679341f85 in st_select_lex_unit::exec (this=0x7f13b0004948) at /data/src/10.3/sql/sql_union.cc:1435 #21 0x000055d67933d136 in mysql_union (thd=0x7f13b0000b00, lex=0x7f13b0004880, result=0x7f13b013cf90, unit=0x7f13b0004948, setup_tables_done_option=0) at /data/src/10.3/sql/sql_union.cc:41 #22 0x000055d67928eb15 in handle_select (thd=0x7f13b0000b00, lex=0x7f13b0004880, result=0x7f13b013cf90, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:360 #23 0x000055d67925a0c7 in execute_sqlcom_select (thd=0x7f13b0000b00, all_tables=0x7f13b0014750) at /data/src/10.3/sql/sql_parse.cc:6539 #24 0x000055d679250828 in mysql_execute_command (thd=0x7f13b0000b00) at /data/src/10.3/sql/sql_parse.cc:3768 #25 0x000055d67925dad8 in mysql_parse (thd=0x7f13b0000b00, rawbuf=0x7f13b0013a28 "( SELECT * FROM (INFORMATION_SCHEMA.`PARAMETERS` AS table1 INNER JOIN INFORMATION_SCHEMA.`GEOMETRY_COLUMNS` AS table2 ON ( table2.`SRID` = table1.`PARAMETER_NAME` ) ) ORDER BY table2.`GEOMETRY_TYPE` "..., length=545, parser_state=0x7f143805f5d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8001 #26 0x000055d67924b2bb in dispatch_command (command=COM_QUERY, thd=0x7f13b0000b00, packet=0x7f13b000b261 "( SELECT * FROM (INFORMATION_SCHEMA.`PARAMETERS` AS table1 INNER JOIN INFORMATION_SCHEMA.`GEOMETRY_COLUMNS` AS table2 ON ( table2.`SRID` = table1.`PARAMETER_NAME` ) ) ORDER BY table2.`GEOMETRY_TYPE` "..., packet_length=546, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846 #27 0x000055d679249cfa in do_command (thd=0x7f13b0000b00) at /data/src/10.3/sql/sql_parse.cc:1391 #28 0x000055d6793ac78b in do_handle_one_connection (connect=0x55d67d9703f0) at /data/src/10.3/sql/sql_connect.cc:1402 #29 0x000055d6793ac518 in handle_one_connection (arg=0x55d67d9703f0) at /data/src/10.3/sql/sql_connect.cc:1308 #30 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67d9d1e80) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #31 0x00007f1443b55494 in start_thread (arg=0x7f1438060700) at pthread_create.c:333 #32 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 29 (Thread 0x7f14141fc700 (LWP 7330)): #0 0x00007f144394c6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d67990ce2d in LinuxAIOHandler::collect (this=0x7f14141fbc40) at /data/src/10.3/storage/innobase/os/os0file.cc:1920 #2 0x000055d67990d35a in LinuxAIOHandler::poll (this=0x7f14141fbc40, m1=0x7f14141fbce8, m2=0x7f14141fbcf0, request=0x7f14141fbd20) at /data/src/10.3/storage/innobase/os/os0file.cc:2065 #3 0x000055d67990d4ba in os_aio_linux_handler (global_segment=6, m1=0x7f14141fbce8, m2=0x7f14141fbcf0, request=0x7f14141fbd20) at /data/src/10.3/storage/innobase/os/os0file.cc:2119 #4 0x000055d67991207a in os_aio_handler (segment=6, m1=0x7f14141fbce8, m2=0x7f14141fbcf0, request=0x7f14141fbd20) at /data/src/10.3/storage/innobase/os/os0file.cc:5647 #5 0x000055d679b8208f in fil_aio_wait (segment=6) at /data/src/10.3/storage/innobase/fil/fil0fil.cc:4678 #6 0x000055d679a1e66e in io_handler_thread (arg=0x55d67b20f6f0 ) at /data/src/10.3/storage/innobase/srv/srv0start.cc:339 #7 0x00007f1443b55494 in start_thread (arg=0x7f14141fc700) at pthread_create.c:333 #8 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 28 (Thread 0x7f1438135700 (LWP 7365)): #0 0x000055d679d3d34f in get_length (fmt=0x55d67cde69a3 "8s'", length=0x7f1438132068, pre_zero=0x7f1438132058) at /data/src/10.3/strings/my_vsnprintf.c:72 #1 0x000055d679d3f2df in my_vsnprintf_ex (cs=0x55d67a878700 , to=0x7f14381322cb "wait/synch/mutex/innodb/purge_sys_pq_mutex'", n=512, fmt=0x55d67cde69a1 "128s'", ap=0x7f14381321a8) at /data/src/10.3/strings/my_vsnprintf.c:616 #2 0x000055d679d3fa5d in my_vsnprintf (to=0x7f14381322b0 "Incorrect datetime value: 'wait/synch/mutex/innodb/purge_sys_pq_mutex'", n=512, fmt=0x55d67cde6985 "Incorrect %-.32s value: '%-.128s'", ap=0x7f14381321a8) at /data/src/10.3/strings/my_vsnprintf.c:704 #3 0x000055d679d15529 in my_snprintf_8bit (cs=0x55d67a878700 , to=0x7f14381322b0 "Incorrect datetime value: 'wait/synch/mutex/innodb/purge_sys_pq_mutex'", n=512, fmt=0x55d67cde6985 "Incorrect %-.32s value: '%-.128s'") at /data/src/10.3/strings/ctype-simple.c:326 #4 0x000055d679373c96 in make_truncated_value_warning (thd=0x7f13b8000b00, level=Sql_state_errno_level::WARN_LEVEL_WARN, sval=0x7f1438132510, time_type=MYSQL_TIMESTAMP_NONE, field_name=0x0) at /data/src/10.3/sql/sql_time.cc:964 #5 0x000055d679371663 in make_truncated_value_warning (thd=0x7f13b8000b00, level=Sql_state_errno_level::WARN_LEVEL_WARN, str_val=0x7f13bc0d65a2 "wait/synch/mutex/innodb/purge_sys_pq_mutex", str_length=42, time_type=MYSQL_TIMESTAMP_NONE, field_name=0x0) at /data/src/10.3/sql/sql_time.h:128 #6 0x000055d67937282e in str_to_datetime_with_warn (cs=0x55d67a988180 , str=0x7f13bc0d65a2 "wait/synch/mutex/innodb/purge_sys_pq_mutex", length=42, l_time=0x7f1438132990, flags=33554433) at /data/src/10.3/sql/sql_time.cc:406 #7 0x000055d6794fab3d in Field::get_date (this=0x7f13bc0c4ab8, ltime=0x7f1438132990, fuzzydate=33554433) at /data/src/10.3/sql/field.cc:2262 #8 0x000055d6795517b8 in Item_field::get_date (this=0x7f13b8015330, ltime=0x7f1438132990, fuzzydate=33554433) at /data/src/10.3/sql/item.cc:3455 #9 0x000055d67942b5da in Temporal_with_date::make_from_item (this=0x7f1438132990, thd=0x7f13b8000b00, item=0x7f13b8015330, flags=33554433) at /data/src/10.3/sql/sql_type.cc:150 #10 0x000055d67914f406 in Temporal_with_date::Temporal_with_date (this=0x7f1438132990, thd=0x7f13b8000b00, item=0x7f13b8015330, flags=33554433) at /data/src/10.3/sql/sql_type.h:294 #11 0x000055d67914f4ca in Datetime::Datetime (this=0x7f1438132990, thd=0x7f13b8000b00, item=0x7f13b8015330, flags=33554433) at /data/src/10.3/sql/sql_type.h:369 #12 0x000055d67915010c in Item::val_datetime_packed (this=0x7f13b8015330) at /data/src/10.3/sql/item.h:1455 #13 0x000055d67957242f in Arg_comparator::compare_datetime (this=0x7f13b8015658) at /data/src/10.3/sql/item_cmpfunc.cc:738 #14 0x000055d679586486 in Arg_comparator::compare (this=0x7f13b8015658) at /data/src/10.3/sql/item_cmpfunc.h:102 #15 0x000055d679575649 in Item_func_eq::val_int (this=0x7f13b8015598) at /data/src/10.3/sql/item_cmpfunc.cc:1727 #16 0x000055d6792db3e7 in Item_func_trig_cond::val_int (this=0x7f13b81da5c8) at /data/src/10.3/sql/item_cmpfunc.h:640 #17 0x000055d67934ddf4 in SQL_SELECT::skip_record (this=0x7f13b81da3f8, thd=0x7f13b8000b00) at /data/src/10.3/sql/opt_range.h:1658 #18 0x000055d6793f6759 in JOIN_CACHE::check_match (this=0x7f13b81da690, rec_ptr=0x7f142401514b "") at /data/src/10.3/sql/sql_join_cache.cc:2450 #19 0x000055d6793f2228 in JOIN_CACHE::generate_full_extensions (this=0x7f13b81da690, rec_ptr=0x7f142401514b "") at /data/src/10.3/sql/sql_join_cache.cc:2393 #20 0x000055d6793f2008 in JOIN_CACHE::join_matching_records (this=0x7f13b81da690, skip_last=false) at /data/src/10.3/sql/sql_join_cache.cc:2293 #21 0x000055d6793f19d4 in JOIN_CACHE::join_records (this=0x7f13b81da690, skip_last=false) at /data/src/10.3/sql/sql_join_cache.cc:2088 #22 0x000055d6792c35aa in sub_select_cache (join=0x7f13b8016118, join_tab=0x7f13b81d9ac8, end_of_records=true) at /data/src/10.3/sql/sql_select.cc:18974 #23 0x000055d6792c37bc in sub_select (join=0x7f13b8016118, join_tab=0x7f13b81d9718, end_of_records=true) at /data/src/10.3/sql/sql_select.cc:19146 #24 0x000055d6792c2fa2 in do_select (join=0x7f13b8016118, procedure=0x0) at /data/src/10.3/sql/sql_select.cc:18737 #25 0x000055d67929bf9c in JOIN::exec_inner (this=0x7f13b8016118) at /data/src/10.3/sql/sql_select.cc:3953 #26 0x000055d67929b434 in JOIN::exec (this=0x7f13b8016118) at /data/src/10.3/sql/sql_select.cc:3747 #27 0x000055d67929c675 in mysql_select (thd=0x7f13b8000b00, tables=0x7f13b80144c8, wild_num=1, fields=..., conds=0x0, og_num=1, order=0x7f13b8015f48, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7f13b80160f8, unit=0x7f13b8004948, select_lex=0x7f13b80050c0) at /data/src/10.3/sql/sql_select.cc:4152 #28 0x000055d67928ebcf in handle_select (thd=0x7f13b8000b00, lex=0x7f13b8004880, result=0x7f13b80160f8, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:382 #29 0x000055d67925a0c7 in execute_sqlcom_select (thd=0x7f13b8000b00, all_tables=0x7f13b80144c8) at /data/src/10.3/sql/sql_parse.cc:6539 #30 0x000055d679250828 in mysql_execute_command (thd=0x7f13b8000b00) at /data/src/10.3/sql/sql_parse.cc:3768 #31 0x000055d67925dad8 in mysql_parse (thd=0x7f13b8000b00, rawbuf=0x7f13b8013a28 "SELECT * FROM (test.`C` AS table1 LEFT OUTER JOIN performance_schema.`events_waits_summary_by_thread_by_event_name` AS table2 ON ( table2.`EVENT_NAME` = table1.`col_date_nokey` ) ) ORDER BY table1.`co"..., length=245, parser_state=0x7f14381345d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8001 #32 0x000055d67924b2bb in dispatch_command (command=COM_QUERY, thd=0x7f13b8000b00, packet=0x7f13b800b261 "", packet_length=247, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846 #33 0x000055d679249cfa in do_command (thd=0x7f13b8000b00) at /data/src/10.3/sql/sql_parse.cc:1391 #34 0x000055d6793ac78b in do_handle_one_connection (connect=0x55d67da352a0) at /data/src/10.3/sql/sql_connect.cc:1402 #35 0x000055d6793ac518 in handle_one_connection (arg=0x55d67da352a0) at /data/src/10.3/sql/sql_connect.cc:1308 #36 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67d9d1700) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #37 0x00007f1443b55494 in start_thread (arg=0x7f1438135700) at pthread_create.c:333 #38 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 27 (Thread 0x7f14097fa700 (LWP 7344)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d67991a796 in os_event::wait (this=0x55d67cf4aa80) at /data/src/10.3/storage/innobase/os/os0event.cc:163 #2 0x000055d67991a199 in os_event::wait_low (this=0x55d67cf4aa80, reset_sig_count=136) at /data/src/10.3/storage/innobase/os/os0event.cc:333 #3 0x000055d67991a54b in os_event_wait_low (event=0x55d67cf4aa80, reset_sig_count=0) at /data/src/10.3/storage/innobase/os/os0event.cc:527 #4 0x000055d679a17e18 in srv_resume_thread (slot=0x55d67a7cc278 , sig_count=0, wait=true, timeout_usec=0) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:912 #5 0x000055d679a1bb06 in srv_worker_thread (arg=0x0) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2531 #6 0x00007f1443b55494 in start_thread (arg=0x7f14097fa700) at pthread_create.c:333 #7 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 26 (Thread 0x7f140a7fc700 (LWP 7342)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d67991a796 in os_event::wait (this=0x55d67cf4a980) at /data/src/10.3/storage/innobase/os/os0event.cc:163 #2 0x000055d67991a199 in os_event::wait_low (this=0x55d67cf4a980, reset_sig_count=112) at /data/src/10.3/storage/innobase/os/os0event.cc:333 #3 0x000055d67991a54b in os_event_wait_low (event=0x55d67cf4a980, reset_sig_count=112) at /data/src/10.3/storage/innobase/os/os0event.cc:527 #4 0x000055d679a17e18 in srv_resume_thread (slot=0x55d67a7cc208 , sig_count=112, wait=true, timeout_usec=0) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:912 #5 0x000055d679a1bfc8 in srv_purge_coordinator_suspend (slot=0x55d67a7cc208 , rseg_history_len=9) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2691 #6 0x000055d679a1c348 in srv_purge_coordinator_thread (arg=0x0) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2778 #7 0x00007f1443b55494 in start_thread (arg=0x7f140a7fc700) at pthread_create.c:333 #8 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 25 (Thread 0x7f143817f700 (LWP 7363)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d679ce6dcd in safe_cond_timedwait (cond=0x7f13c0000d00, mp=0x7f13c0000c50, abstime=0x7f143817a840, file=0x55d679de5dc0 "/data/src/10.3/include/mysql/psi/mysql_thread.h", line=1215) at /data/src/10.3/mysys/thr_mutex.c:546 #2 0x000055d6793b432b in inline_mysql_cond_timedwait (that=0x7f13c0000d00, mutex=0x7f13c0000c50, abstime=0x7f143817a840, src_file=0x55d679de606a "/data/src/10.3/sql/mdl.cc", src_line=1094) at /data/src/10.3/include/mysql/psi/mysql_thread.h:1215 #3 0x000055d6793b5743 in MDL_wait::timed_wait (this=0x7f13c0000c50, owner=0x7f13c0000be0, abs_timeout=0x7f143817a840, set_status_on_timeout=false, wait_state_name=0x55d67a7af2f0 ) at /data/src/10.3/sql/mdl.cc:1094 #4 0x000055d6793b71eb in MDL_context::acquire_lock (this=0x7f13c0000c50, mdl_request=0x7f13c0189820, lock_wait_timeout=86400) at /data/src/10.3/sql/mdl.cc:2148 #5 0x000055d6791c2a4d in open_table_get_mdl_lock (thd=0x7f13c0000b00, ot_ctx=0x7f143817af50, mdl_request=0x7f13c0189820, flags=0, mdl_ticket=0x7f143817ab30) at /data/src/10.3/sql/sql_base.cc:1464 #6 0x000055d6791c3384 in open_table (thd=0x7f13c0000b00, table_list=0x7f13c01893c0, ot_ctx=0x7f143817af50) at /data/src/10.3/sql/sql_base.cc:1747 #7 0x000055d6791c695e in open_and_process_table (thd=0x7f13c0000b00, lex=0x7f13c01829e8, tables=0x7f13c01893c0, counter=0x7f143817afe4, flags=0, prelocking_strategy=0x7f143817b060, has_prelocking_list=false, ot_ctx=0x7f143817af50) at /data/src/10.3/sql/sql_base.cc:3513 #8 0x000055d6791c7b29 in open_tables (thd=0x7f13c0000b00, options=..., start=0x7f143817afc8, counter=0x7f143817afe4, flags=0, prelocking_strategy=0x7f143817b060) at /data/src/10.3/sql/sql_base.cc:4033 #9 0x000055d6791c9880 in open_and_lock_tables (thd=0x7f13c0000b00, options=..., tables=0x7f13c01893c0, derived=true, flags=0, prelocking_strategy=0x7f143817b060) at /data/src/10.3/sql/sql_base.cc:4908 #10 0x000055d67918a493 in open_and_lock_tables (thd=0x7f13c0000b00, tables=0x7f13c01893c0, derived=true, flags=0) at /data/src/10.3/sql/sql_base.h:489 #11 0x000055d679259c0a in execute_sqlcom_select (thd=0x7f13c0000b00, all_tables=0x7f13c01893c0) at /data/src/10.3/sql/sql_parse.cc:6460 #12 0x000055d679250828 in mysql_execute_command (thd=0x7f13c0000b00) at /data/src/10.3/sql/sql_parse.cc:3768 #13 0x000055d67918085e in sp_instr_stmt::exec_core (this=0x7f13c0189ab8, thd=0x7f13c0000b00, nextp=0x7f143817c6fc) at /data/src/10.3/sql/sp_head.cc:3595 #14 0x000055d67917fc6e in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f13c0189b08, thd=0x7f13c0000b00, nextp=0x7f143817c6fc, open_tables=false, instr=0x7f13c0189ab8) at /data/src/10.3/sql/sp_head.cc:3311 #15 0x000055d679180417 in sp_instr_stmt::execute (this=0x7f13c0189ab8, thd=0x7f13c0000b00, nextp=0x7f143817c6fc) at /data/src/10.3/sql/sp_head.cc:3498 #16 0x000055d67917a1db in sp_head::execute (this=0x7f13c01880e8, thd=0x7f13c0000b00, merge_da_on_success=true) at /data/src/10.3/sql/sp_head.cc:1349 #17 0x000055d67917cb80 in sp_head::execute_procedure (this=0x7f13c01880e8, thd=0x7f13c0000b00, args=0x7f13c00056e0) at /data/src/10.3/sql/sp_head.cc:2287 #18 0x000055d67924e1ef in do_execute_sp (thd=0x7f13c0000b00, sp=0x7f13c01880e8) at /data/src/10.3/sql/sql_parse.cc:2944 #19 0x000055d67924ed6c in Sql_cmd_call::execute (this=0x7f13c0013b90, thd=0x7f13c0000b00) at /data/src/10.3/sql/sql_parse.cc:3186 #20 0x000055d67925900b in mysql_execute_command (thd=0x7f13c0000b00) at /data/src/10.3/sql/sql_parse.cc:6282 #21 0x000055d67925dad8 in mysql_parse (thd=0x7f13c0000b00, rawbuf=0x7f13c0013a28 "CALL stored_proc_7362 /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 1967 CON_ID 17 */", length=86, parser_state=0x7f143817e5d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8001 #22 0x000055d67924b2bb in dispatch_command (command=COM_QUERY, thd=0x7f13c0000b00, packet=0x7f13c000b261 "CALL stored_proc_7362 /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 1967 CON_ID 17 */ ", packet_length=87, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846 #23 0x000055d679249cfa in do_command (thd=0x7f13c0000b00) at /data/src/10.3/sql/sql_parse.cc:1391 #24 0x000055d6793ac78b in do_handle_one_connection (connect=0x55d67d9703f0) at /data/src/10.3/sql/sql_connect.cc:1402 #25 0x000055d6793ac518 in handle_one_connection (arg=0x55d67d9703f0) at /data/src/10.3/sql/sql_connect.cc:1308 #26 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67d9d79a0) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #27 0x00007f1443b55494 in start_thread (arg=0x7f143817f700) at pthread_create.c:333 #28 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 24 (Thread 0x7f14149fd700 (LWP 7329)): #0 0x00007f144394c6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d67990ce2d in LinuxAIOHandler::collect (this=0x7f14149fcc40) at /data/src/10.3/storage/innobase/os/os0file.cc:1920 #2 0x000055d67990d35a in LinuxAIOHandler::poll (this=0x7f14149fcc40, m1=0x7f14149fcce8, m2=0x7f14149fccf0, request=0x7f14149fcd20) at /data/src/10.3/storage/innobase/os/os0file.cc:2065 #3 0x000055d67990d4ba in os_aio_linux_handler (global_segment=5, m1=0x7f14149fcce8, m2=0x7f14149fccf0, request=0x7f14149fcd20) at /data/src/10.3/storage/innobase/os/os0file.cc:2119 #4 0x000055d67991207a in os_aio_handler (segment=5, m1=0x7f14149fcce8, m2=0x7f14149fccf0, request=0x7f14149fcd20) at /data/src/10.3/storage/innobase/os/os0file.cc:5647 #5 0x000055d679b8208f in fil_aio_wait (segment=5) at /data/src/10.3/storage/innobase/fil/fil0fil.cc:4678 #6 0x000055d679a1e66e in io_handler_thread (arg=0x55d67b20f6e8 ) at /data/src/10.3/storage/innobase/srv/srv0start.cc:339 #7 0x00007f1443b55494 in start_thread (arg=0x7f14149fd700) at pthread_create.c:333 #8 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 23 (Thread 0x7f14159ff700 (LWP 7327)): #0 0x00007f144394c6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d67990ce2d in LinuxAIOHandler::collect (this=0x7f14159fec40) at /data/src/10.3/storage/innobase/os/os0file.cc:1920 #2 0x000055d67990d35a in LinuxAIOHandler::poll (this=0x7f14159fec40, m1=0x7f14159fece8, m2=0x7f14159fecf0, request=0x7f14159fed20) at /data/src/10.3/storage/innobase/os/os0file.cc:2065 #3 0x000055d67990d4ba in os_aio_linux_handler (global_segment=3, m1=0x7f14159fece8, m2=0x7f14159fecf0, request=0x7f14159fed20) at /data/src/10.3/storage/innobase/os/os0file.cc:2119 #4 0x000055d67991207a in os_aio_handler (segment=3, m1=0x7f14159fece8, m2=0x7f14159fecf0, request=0x7f14159fed20) at /data/src/10.3/storage/innobase/os/os0file.cc:5647 #5 0x000055d679b8208f in fil_aio_wait (segment=3) at /data/src/10.3/storage/innobase/fil/fil0fil.cc:4678 #6 0x000055d679a1e66e in io_handler_thread (arg=0x55d67b20f6d8 ) at /data/src/10.3/storage/innobase/srv/srv0start.cc:339 #7 0x00007f1443b55494 in start_thread (arg=0x7f14159ff700) at pthread_create.c:333 #8 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 22 (Thread 0x7f13f3fff700 (LWP 7346)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d67991a796 in os_event::wait (this=0x55d67cf4ac80) at /data/src/10.3/storage/innobase/os/os0event.cc:163 #2 0x000055d67991a199 in os_event::wait_low (this=0x55d67cf4ac80, reset_sig_count=1) at /data/src/10.3/storage/innobase/os/os0event.cc:333 #3 0x000055d67991a54b in os_event_wait_low (event=0x55d67cf4ac80, reset_sig_count=0) at /data/src/10.3/storage/innobase/os/os0event.cc:527 #4 0x000055d679aff0a7 in buf_dump_thread () at /data/src/10.3/storage/innobase/buf/buf0dump.cc:837 #5 0x00007f1443b55494 in start_thread (arg=0x7f13f3fff700) at pthread_create.c:333 #6 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 21 (Thread 0x7f140affd700 (LWP 7341)): #0 0x00007f1443b5e7dd in nanosleep () at ../sysdeps/unix/syscall-template.S:84 #1 0x000055d67991aabd in os_thread_sleep (tm=1000000) at /data/src/10.3/storage/innobase/os/os0thread.cc:230 #2 0x000055d679a1b45f in srv_master_sleep () at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2364 #3 0x000055d679a1b5a1 in srv_master_thread (arg=0x0) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2409 #4 0x00007f1443b55494 in start_thread (arg=0x7f140affd700) at pthread_create.c:333 #5 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 20 (Thread 0x7f140bfff700 (LWP 7338)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d67991a02f in os_event::timed_wait (this=0x55d67cf4ac00, abstime=0x7f140bffee60) at /data/src/10.3/storage/innobase/os/os0event.cc:283 #2 0x000055d67991a345 in os_event::wait_time_low (this=0x55d67cf4ac00, time_in_usec=5000000, reset_sig_count=1) at /data/src/10.3/storage/innobase/os/os0event.cc:405 #3 0x000055d67991a526 in os_event_wait_time_low (event=0x55d67cf4ac00, time_in_usec=5000000, reset_sig_count=1) at /data/src/10.3/storage/innobase/os/os0event.cc:510 #4 0x000055d679a19bfa in srv_monitor_thread () at /data/src/10.3/storage/innobase/srv/srv0srv.cc:1711 #5 0x00007f1443b55494 in start_thread (arg=0x7f140bfff700) at pthread_create.c:333 #6 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 19 (Thread 0x7f14381c9700 (LWP 7357)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d679ce6dcd in safe_cond_timedwait (cond=0x7f13cc000da0, mp=0x7f13cc000cf0, abstime=0x7f14381c4fd0, file=0x55d679de5dc0 "/data/src/10.3/include/mysql/psi/mysql_thread.h", line=1215) at /data/src/10.3/mysys/thr_mutex.c:546 #2 0x000055d6793b432b in inline_mysql_cond_timedwait (that=0x7f13cc000da0, mutex=0x7f13cc000cf0, abstime=0x7f14381c4fd0, src_file=0x55d679de606a "/data/src/10.3/sql/mdl.cc", src_line=1094) at /data/src/10.3/include/mysql/psi/mysql_thread.h:1215 #3 0x000055d6793b5743 in MDL_wait::timed_wait (this=0x7f13cc000cf0, owner=0x7f13cc000c80, abs_timeout=0x7f14381c4fd0, set_status_on_timeout=false, wait_state_name=0x55d67a7af2f0 ) at /data/src/10.3/sql/mdl.cc:1094 #4 0x000055d6793b71eb in MDL_context::acquire_lock (this=0x7f13cc000cf0, mdl_request=0x7f14381c5090, lock_wait_timeout=86400) at /data/src/10.3/sql/mdl.cc:2148 #5 0x000055d6793b791f in MDL_context::upgrade_shared_lock (this=0x7f13cc000cf0, mdl_ticket=0x7f13cc105f30, new_type=MDL_EXCLUSIVE, lock_wait_timeout=86400) at /data/src/10.3/sql/mdl.cc:2336 #6 0x000055d6791c256e in wait_while_table_is_used (thd=0x7f13cc000ba0, table=0x7f13b025e990, function=HA_EXTRA_PREPARE_FOR_RENAME) at /data/src/10.3/sql/sql_base.cc:1228 #7 0x000055d67932d3ab in mysql_alter_table (thd=0x7f13cc000ba0, new_db=0x7f13cc0051f8, new_name=0x7f13cc0055a8, create_info=0x7f14381c6c50, table_list=0x7f13cc015f28, alter_info=0x7f14381c6b90, order_num=0, order=0x0, ignore=false) at /data/src/10.3/sql/sql_table.cc:9885 #8 0x000055d6793b1d98 in Sql_cmd_alter_table::execute (this=0x7f13cc016758, thd=0x7f13cc000ba0) at /data/src/10.3/sql/sql_alter.cc:334 #9 0x000055d67925900b in mysql_execute_command (thd=0x7f13cc000ba0) at /data/src/10.3/sql/sql_parse.cc:6282 #10 0x000055d67925dad8 in mysql_parse (thd=0x7f13cc000ba0, rawbuf=0x7f13cc015dd8 "ALTER TABLE `BB` ADD COLUMN v INTEGER DEFAULT NULL /* QNO 2535 CON_ID 16 */", length=75, parser_state=0x7f14381c85d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8001 #11 0x000055d67924b2bb in dispatch_command (command=COM_QUERY, thd=0x7f13cc000ba0, packet=0x7f13cc0af181 "ALTER TABLE `BB` ADD COLUMN v INTEGER DEFAULT NULL /* QNO 2535 CON_ID 16 */ ", packet_length=76, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846 #12 0x000055d679249cfa in do_command (thd=0x7f13cc000ba0) at /data/src/10.3/sql/sql_parse.cc:1391 #13 0x000055d6793ac78b in do_handle_one_connection (connect=0x55d67d97bc00) at /data/src/10.3/sql/sql_connect.cc:1402 #14 0x000055d6793ac518 in handle_one_connection (arg=0x55d67d97bc00) at /data/src/10.3/sql/sql_connect.cc:1308 #15 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67da3da90) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #16 0x00007f1443b55494 in start_thread (arg=0x7f14381c9700) at pthread_create.c:333 #17 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 18 (Thread 0x7f14151fe700 (LWP 7328)): #0 0x00007f144394c6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d67990ce2d in LinuxAIOHandler::collect (this=0x7f14151fdc40) at /data/src/10.3/storage/innobase/os/os0file.cc:1920 #2 0x000055d67990d35a in LinuxAIOHandler::poll (this=0x7f14151fdc40, m1=0x7f14151fdce8, m2=0x7f14151fdcf0, request=0x7f14151fdd20) at /data/src/10.3/storage/innobase/os/os0file.cc:2065 #3 0x000055d67990d4ba in os_aio_linux_handler (global_segment=4, m1=0x7f14151fdce8, m2=0x7f14151fdcf0, request=0x7f14151fdd20) at /data/src/10.3/storage/innobase/os/os0file.cc:2119 #4 0x000055d67991207a in os_aio_handler (segment=4, m1=0x7f14151fdce8, m2=0x7f14151fdcf0, request=0x7f14151fdd20) at /data/src/10.3/storage/innobase/os/os0file.cc:5647 #5 0x000055d679b8208f in fil_aio_wait (segment=4) at /data/src/10.3/storage/innobase/fil/fil0fil.cc:4678 #6 0x000055d679a1e66e in io_handler_thread (arg=0x55d67b20f6e0 ) at /data/src/10.3/storage/innobase/srv/srv0start.cc:339 #7 0x00007f1443b55494 in start_thread (arg=0x7f14151fe700) at pthread_create.c:333 #8 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 17 (Thread 0x7f1443f6eb80 (LWP 7321)): #0 0x00007f1441f324ed in poll () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x000055d679137642 in handle_connections_sockets () at /data/src/10.3/sql/mysqld.cc:6707 #2 0x000055d67913690e in mysqld_main (argc=22, argv=0x55d67ccfe038) at /data/src/10.3/sql/mysqld.cc:6176 #3 0x000055d67912aca0 in main (argc=22, argv=0x7fff74249bf8) at /data/src/10.3/sql/main.cc:25 Thread 16 (Thread 0x7f1409ffb700 (LWP 7343)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d67991a796 in os_event::wait (this=0x55d67cf4ab00) at /data/src/10.3/storage/innobase/os/os0event.cc:163 #2 0x000055d67991a199 in os_event::wait_low (this=0x55d67cf4ab00, reset_sig_count=137) at /data/src/10.3/storage/innobase/os/os0event.cc:333 #3 0x000055d67991a54b in os_event_wait_low (event=0x55d67cf4ab00, reset_sig_count=0) at /data/src/10.3/storage/innobase/os/os0event.cc:527 #4 0x000055d679a17e18 in srv_resume_thread (slot=0x55d67a7cc2b0 , sig_count=0, wait=true, timeout_usec=0) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:912 #5 0x000055d679a1bb06 in srv_worker_thread (arg=0x0) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2531 #6 0x00007f1443b55494 in start_thread (arg=0x7f1409ffb700) at pthread_create.c:333 #7 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 15 (Thread 0x7f140b7fe700 (LWP 7340)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d67991a02f in os_event::timed_wait (this=0x55d67d946220, abstime=0x7f140b7fdc90) at /data/src/10.3/storage/innobase/os/os0event.cc:283 #2 0x000055d67991a345 in os_event::wait_time_low (this=0x55d67d946220, time_in_usec=5000000, reset_sig_count=1) at /data/src/10.3/storage/innobase/os/os0event.cc:405 #3 0x000055d67991a526 in os_event_wait_time_low (event=0x55d67d946220, time_in_usec=5000000, reset_sig_count=1) at /data/src/10.3/storage/innobase/os/os0event.cc:510 #4 0x000055d679a814f5 in ib_wqueue_timedwait (wq=0x55d67d9417d0, wait_in_usecs=5000000) at /data/src/10.3/storage/innobase/ut/ut0wqueue.cc:163 #5 0x000055d679bca440 in fts_optimize_thread (arg=0x55d67d9417d0) at /data/src/10.3/storage/innobase/fts/fts0opt.cc:3035 #6 0x00007f1443b55494 in start_thread (arg=0x7f140b7fe700) at pthread_create.c:333 #7 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 14 (Thread 0x7f14109f5700 (LWP 7337)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d67991a02f in os_event::timed_wait (this=0x55d67cf4ab80, abstime=0x7f14109f4ce0) at /data/src/10.3/storage/innobase/os/os0event.cc:283 #2 0x000055d67991a345 in os_event::wait_time_low (this=0x55d67cf4ab80, time_in_usec=1000000, reset_sig_count=1) at /data/src/10.3/storage/innobase/os/os0event.cc:405 #3 0x000055d67991a526 in os_event_wait_time_low (event=0x55d67cf4ab80, time_in_usec=1000000, reset_sig_count=1) at /data/src/10.3/storage/innobase/os/os0event.cc:510 #4 0x000055d679a1a11a in srv_error_monitor_thread () at /data/src/10.3/storage/innobase/srv/srv0srv.cc:1875 #5 0x00007f1443b55494 in start_thread (arg=0x7f14109f5700) at pthread_create.c:333 #6 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 13 (Thread 0x7f14129f9700 (LWP 7333)): #0 0x00007f144394c6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d67990ce2d in LinuxAIOHandler::collect (this=0x7f14129f8c40) at /data/src/10.3/storage/innobase/os/os0file.cc:1920 #2 0x000055d67990d35a in LinuxAIOHandler::poll (this=0x7f14129f8c40, m1=0x7f14129f8ce8, m2=0x7f14129f8cf0, request=0x7f14129f8d20) at /data/src/10.3/storage/innobase/os/os0file.cc:2065 #3 0x000055d67990d4ba in os_aio_linux_handler (global_segment=9, m1=0x7f14129f8ce8, m2=0x7f14129f8cf0, request=0x7f14129f8d20) at /data/src/10.3/storage/innobase/os/os0file.cc:2119 #4 0x000055d67991207a in os_aio_handler (segment=9, m1=0x7f14129f8ce8, m2=0x7f14129f8cf0, request=0x7f14129f8d20) at /data/src/10.3/storage/innobase/os/os0file.cc:5647 #5 0x000055d679b8208f in fil_aio_wait (segment=9) at /data/src/10.3/storage/innobase/fil/fil0fil.cc:4678 #6 0x000055d679a1e66e in io_handler_thread (arg=0x55d67b20f708 ) at /data/src/10.3/storage/innobase/srv/srv0start.cc:339 #7 0x00007f1443b55494 in start_thread (arg=0x7f14129f9700) at pthread_create.c:333 #8 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 12 (Thread 0x7f13f2ffd700 (LWP 7348)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055d67991a796 in os_event::wait (this=0x55d67cf4ad80) at /data/src/10.3/storage/innobase/os/os0event.cc:163 #2 0x000055d67991a199 in os_event::wait_low (this=0x55d67cf4ad80, reset_sig_count=1) at /data/src/10.3/storage/innobase/os/os0event.cc:333 #3 0x000055d67991a54b in os_event_wait_low (event=0x55d67cf4ad80, reset_sig_count=0) at /data/src/10.3/storage/innobase/os/os0event.cc:527 #4 0x000055d679ae6f60 in buf_resize_thread () at /data/src/10.3/storage/innobase/buf/buf0buf.cc:3125 #5 0x00007f1443b55494 in start_thread (arg=0x7f13f2ffd700) at pthread_create.c:333 #6 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 11 (Thread 0x7f14252bf700 (LWP 7325)): #0 0x00007f144394c6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d67990ce2d in LinuxAIOHandler::collect (this=0x7f14252bec40) at /data/src/10.3/storage/innobase/os/os0file.cc:1920 #2 0x000055d67990d35a in LinuxAIOHandler::poll (this=0x7f14252bec40, m1=0x7f14252bece8, m2=0x7f14252becf0, request=0x7f14252bed20) at /data/src/10.3/storage/innobase/os/os0file.cc:2065 #3 0x000055d67990d4ba in os_aio_linux_handler (global_segment=1, m1=0x7f14252bece8, m2=0x7f14252becf0, request=0x7f14252bed20) at /data/src/10.3/storage/innobase/os/os0file.cc:2119 #4 0x000055d67991207a in os_aio_handler (segment=1, m1=0x7f14252bece8, m2=0x7f14252becf0, request=0x7f14252bed20) at /data/src/10.3/storage/innobase/os/os0file.cc:5647 #5 0x000055d679b8208f in fil_aio_wait (segment=1) at /data/src/10.3/storage/innobase/fil/fil0fil.cc:4678 #6 0x000055d679a1e66e in io_handler_thread (arg=0x55d67b20f6c8 ) at /data/src/10.3/storage/innobase/srv/srv0start.cc:339 #7 0x00007f1443b55494 in start_thread (arg=0x7f14252bf700) at pthread_create.c:333 #8 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 10 (Thread 0x7f1424abe700 (LWP 7326)): #0 0x00007f144394c6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d67990ce2d in LinuxAIOHandler::collect (this=0x7f1424abdc40) at /data/src/10.3/storage/innobase/os/os0file.cc:1920 #2 0x000055d67990d35a in LinuxAIOHandler::poll (this=0x7f1424abdc40, m1=0x7f1424abdce8, m2=0x7f1424abdcf0, request=0x7f1424abdd20) at /data/src/10.3/storage/innobase/os/os0file.cc:2065 #3 0x000055d67990d4ba in os_aio_linux_handler (global_segment=2, m1=0x7f1424abdce8, m2=0x7f1424abdcf0, request=0x7f1424abdd20) at /data/src/10.3/storage/innobase/os/os0file.cc:2119 #4 0x000055d67991207a in os_aio_handler (segment=2, m1=0x7f1424abdce8, m2=0x7f1424abdcf0, request=0x7f1424abdd20) at /data/src/10.3/storage/innobase/os/os0file.cc:5647 #5 0x000055d679b8208f in fil_aio_wait (segment=2) at /data/src/10.3/storage/innobase/fil/fil0fil.cc:4678 #6 0x000055d679a1e66e in io_handler_thread (arg=0x55d67b20f6d0 ) at /data/src/10.3/storage/innobase/srv/srv0start.cc:339 #7 0x00007f1443b55494 in start_thread (arg=0x7f1424abe700) at pthread_create.c:333 #8 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 9 (Thread 0x7f14139fb700 (LWP 7331)): #0 0x00007f144394c6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d67990ce2d in LinuxAIOHandler::collect (this=0x7f14139fac40) at /data/src/10.3/storage/innobase/os/os0file.cc:1920 #2 0x000055d67990d35a in LinuxAIOHandler::poll (this=0x7f14139fac40, m1=0x7f14139face8, m2=0x7f14139facf0, request=0x7f14139fad20) at /data/src/10.3/storage/innobase/os/os0file.cc:2065 #3 0x000055d67990d4ba in os_aio_linux_handler (global_segment=7, m1=0x7f14139face8, m2=0x7f14139facf0, request=0x7f14139fad20) at /data/src/10.3/storage/innobase/os/os0file.cc:2119 #4 0x000055d67991207a in os_aio_handler (segment=7, m1=0x7f14139face8, m2=0x7f14139facf0, request=0x7f14139fad20) at /data/src/10.3/storage/innobase/os/os0file.cc:5647 #5 0x000055d679b8208f in fil_aio_wait (segment=7) at /data/src/10.3/storage/innobase/fil/fil0fil.cc:4678 #6 0x000055d679a1e66e in io_handler_thread (arg=0x55d67b20f6f8 ) at /data/src/10.3/storage/innobase/srv/srv0start.cc:339 #7 0x00007f1443b55494 in start_thread (arg=0x7f14139fb700) at pthread_create.c:333 #8 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 8 (Thread 0x7f14121f8700 (LWP 7334)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d67991a02f in os_event::timed_wait (this=0x55d67cf4ad00, abstime=0x7f14121f7c30) at /data/src/10.3/storage/innobase/os/os0event.cc:283 #2 0x000055d67991a345 in os_event::wait_time_low (this=0x55d67cf4ad00, time_in_usec=1000000, reset_sig_count=2) at /data/src/10.3/storage/innobase/os/os0event.cc:405 #3 0x000055d67991a526 in os_event_wait_time_low (event=0x55d67cf4ad00, time_in_usec=1000000, reset_sig_count=2) at /data/src/10.3/storage/innobase/os/os0event.cc:510 #4 0x000055d679b093d3 in pc_sleep_if_needed (next_loop_time=1523933422215, sig_count=2, cur_time=1523933421215) at /data/src/10.3/storage/innobase/buf/buf0flu.cc:2688 #5 0x000055d679b0a317 in buf_flush_page_cleaner_coordinator () at /data/src/10.3/storage/innobase/buf/buf0flu.cc:3154 #6 0x00007f1443b55494 in start_thread (arg=0x7f14121f8700) at pthread_create.c:333 #7 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 7 (Thread 0x7f14119f7700 (LWP 7339)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d67991a02f in os_event::timed_wait (this=0x55d67d934700, abstime=0x7f14119f6ea0) at /data/src/10.3/storage/innobase/os/os0event.cc:283 #2 0x000055d67991a345 in os_event::wait_time_low (this=0x55d67d934700, time_in_usec=10000000, reset_sig_count=1) at /data/src/10.3/storage/innobase/os/os0event.cc:405 #3 0x000055d67991a526 in os_event_wait_time_low (event=0x55d67d934700, time_in_usec=10000000, reset_sig_count=0) at /data/src/10.3/storage/innobase/os/os0event.cc:510 #4 0x000055d679b6b0c8 in dict_stats_thread () at /data/src/10.3/storage/innobase/dict/dict0stats_bg.cc:451 #5 0x00007f1443b55494 in start_thread (arg=0x7f14119f7700) at pthread_create.c:333 #6 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 6 (Thread 0x7f14111f6700 (LWP 7336)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d67991a02f in os_event::timed_wait (this=0x55d67d81cf60, abstime=0x7f14111f5e80) at /data/src/10.3/storage/innobase/os/os0event.cc:283 #2 0x000055d67991a345 in os_event::wait_time_low (this=0x55d67d81cf60, time_in_usec=1000000, reset_sig_count=1) at /data/src/10.3/storage/innobase/os/os0event.cc:405 #3 0x000055d67991a526 in os_event_wait_time_low (event=0x55d67d81cf60, time_in_usec=1000000, reset_sig_count=1) at /data/src/10.3/storage/innobase/os/os0event.cc:510 #4 0x000055d6798e6604 in lock_wait_timeout_thread () at /data/src/10.3/storage/innobase/lock/lock0wait.cc:547 #5 0x00007f1443b55494 in start_thread (arg=0x7f14111f6700) at pthread_create.c:333 #6 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 5 (Thread 0x7f143b650700 (LWP 7322)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d679ce6dcd in safe_cond_timedwait (cond=0x55d67b228300 , mp=0x55d67b228240 , abstime=0x7f143b64feb0, file=0x55d67a106210 "/data/src/10.3/include/mysql/psi/mysql_thread.h", line=1215) at /data/src/10.3/mysys/thr_mutex.c:546 #2 0x000055d679ce7dbc in inline_mysql_cond_timedwait (that=0x55d67b228300 , mutex=0x55d67b228240 , abstime=0x7f143b64feb0, src_file=0x55d67a106240 "/data/src/10.3/mysys/thr_timer.c", src_line=292) at /data/src/10.3/include/mysql/psi/mysql_thread.h:1215 #3 0x000055d679ce88b9 in timer_handler (arg=0x0) at /data/src/10.3/mysys/thr_timer.c:292 #4 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67ce1c180) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #5 0x00007f1443b55494 in start_thread (arg=0x7f143b650700) at pthread_create.c:333 #6 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 4 (Thread 0x7f1425ac0700 (LWP 7324)): #0 0x00007f144394c6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055d67990ce2d in LinuxAIOHandler::collect (this=0x7f1425abfc40) at /data/src/10.3/storage/innobase/os/os0file.cc:1920 #2 0x000055d67990d35a in LinuxAIOHandler::poll (this=0x7f1425abfc40, m1=0x7f1425abfce8, m2=0x7f1425abfcf0, request=0x7f1425abfd20) at /data/src/10.3/storage/innobase/os/os0file.cc:2065 #3 0x000055d67990d4ba in os_aio_linux_handler (global_segment=0, m1=0x7f1425abfce8, m2=0x7f1425abfcf0, request=0x7f1425abfd20) at /data/src/10.3/storage/innobase/os/os0file.cc:2119 #4 0x000055d67991207a in os_aio_handler (segment=0, m1=0x7f1425abfce8, m2=0x7f1425abfcf0, request=0x7f1425abfd20) at /data/src/10.3/storage/innobase/os/os0file.cc:5647 #5 0x000055d679b8208f in fil_aio_wait (segment=0) at /data/src/10.3/storage/innobase/fil/fil0fil.cc:4678 #6 0x000055d679a1e66e in io_handler_thread (arg=0x55d67b20f6c0 ) at /data/src/10.3/storage/innobase/srv/srv0start.cc:339 #7 0x00007f1443b55494 in start_thread (arg=0x7f1425ac0700) at pthread_create.c:333 #8 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 3 (Thread 0x7f14101f4700 (LWP 7372)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d679ce6dcd in safe_cond_timedwait (cond=0x55d67a98ab80 , mp=0x55d67a98d580 , abstime=0x7f14101f3da0, file=0x55d679d76d40 "/data/src/10.3/include/mysql/psi/mysql_thread.h", line=1215) at /data/src/10.3/mysys/thr_mutex.c:546 #2 0x000055d67912b539 in inline_mysql_cond_timedwait (that=0x55d67a98ab80 , mutex=0x55d67a98d580 , abstime=0x7f14101f3da0, src_file=0x55d679d78c3e "/data/src/10.3/sql/mysqld.cc", src_line=3001) at /data/src/10.3/include/mysql/psi/mysql_thread.h:1215 #3 0x000055d6791305de in cache_thread (thd=0x7f13a8000b00) at /data/src/10.3/sql/mysqld.cc:3000 #4 0x000055d679130882 in one_thread_per_connection_end (thd=0x7f13a8000b00, put_in_cache=true) at /data/src/10.3/sql/mysqld.cc:3087 #5 0x000055d6793ac874 in do_handle_one_connection (connect=0x55d67d97bc00) at /data/src/10.3/sql/sql_connect.cc:1421 #6 0x000055d6793ac518 in handle_one_connection (arg=0x55d67d97bc00) at /data/src/10.3/sql/sql_connect.cc:1308 #7 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67ce5bd20) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #8 0x00007f1443b55494 in start_thread (arg=0x7f14101f4700) at pthread_create.c:333 #9 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 2 (Thread 0x7f1438f07700 (LWP 7323)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055d679ce6dcd in safe_cond_timedwait (cond=0x55d67b1c4100 , mp=0x55d67b1c4040 , abstime=0x7f1438f06e00, file=0x55d679f671b0 "/data/src/10.3/include/mysql/psi/mysql_thread.h", line=1215) at /data/src/10.3/mysys/thr_mutex.c:546 #2 0x000055d679779de5 in inline_mysql_cond_timedwait (that=0x55d67b1c4100 , mutex=0x55d67b1c4040 , abstime=0x7f1438f06e00, src_file=0x55d679f671e0 "/data/src/10.3/storage/maria/ma_servicethread.c", src_line=116) at /data/src/10.3/include/mysql/psi/mysql_thread.h:1215 #3 0x000055d67977a2a8 in my_service_thread_sleep (control=0x55d67a7bb700 , sleep_time=29000000000) at /data/src/10.3/storage/maria/ma_servicethread.c:115 #4 0x000055d67976eba6 in ma_checkpoint_background (arg=0x1e) at /data/src/10.3/storage/maria/ma_checkpoint.c:707 #5 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67ce30b80) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #6 0x00007f1443b55494 in start_thread (arg=0x7f1438f07700) at pthread_create.c:333 #7 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 1 (Thread 0x7f142409f700 (LWP 7371)): #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x000055d679ce14ed in my_write_core (sig=6) at /data/src/10.3/mysys/stacktrace.c:481 #2 0x000055d67952f734 in handle_fatal_signal (sig=6) at /data/src/10.3/sql/signal_handler.cc:305 #3 #4 0x00007f1441e85fcf in raise () from /lib/x86_64-linux-gnu/libc.so.6 #5 0x00007f1441e873fa in abort () from /lib/x86_64-linux-gnu/libc.so.6 #6 0x00007f1441e7ee37 in __assert_fail_base () from /lib/x86_64-linux-gnu/libc.so.6 #7 0x00007f1441e7eee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x000055d679832c8a in unlock_rwlock_v1 (rwlock=0x7f1443e9de55) at /data/src/10.3/storage/perfschema/pfs.cc:3214 #9 0x000055d679c5679d in inline_mysql_rwlock_unlock (that=0x7f13b0194d18) at /data/src/10.3/include/mysql/psi/mysql_thread.h:1082 #10 0x000055d679c56a7e in mi_records_in_range (info=0x7f13b0194f20, inx=1, min_key=0x7f142409b790, max_key=0x7f142409b7b0) at /data/src/10.3/storage/myisam/mi_range.c:110 #11 0x000055d679c215b5 in ha_myisam::records_in_range (this=0x7f13b014e648, inx=1, min_key=0x7f142409b790, max_key=0x7f142409b7b0) at /data/src/10.3/storage/myisam/ha_myisam.cc:2281 #12 0x000055d6793f9591 in handler::multi_range_read_info_const (this=0x7f13b014e648, keyno=1, seq=0x7f13b01985d0, seq_init_param=0x7f13b01429d8, n_ranges_arg=2, bufsz=0x7f142409b834, flags=0x7f142409b830, cost=0x7f142409c010) at /data/src/10.3/sql/multi_range_read.cc:95 #13 0x000055d6793fc9da in DsMrr_impl::dsmrr_info_const (this=0x7f13b014eab8, keyno=1, seq=0x7f13b01985d0, seq_init_param=0x7f13b01429d8, n_ranges=2, bufsz=0x7f13b01428f8, flags=0x7f142409b8e0, cost=0x7f142409c010) at /data/src/10.3/sql/multi_range_read.cc:1458 #14 0x000055d679c21e63 in ha_myisam::multi_range_read_info_const (this=0x7f13b014e648, keyno=1, seq=0x7f13b01985d0, seq_init_param=0x7f13b01429d8, n_ranges=2, bufsz=0x7f13b01428f8, flags=0x7f142409b8e0, cost=0x7f142409c010) at /data/src/10.3/storage/myisam/ha_myisam.cc:2506 #15 0x000055d679ca0508 in ha_partition::multi_range_read_info_const (this=0x7f13b0197de8, keyno=1, seq=0x7f142409b9e0, seq_init_param=0x7f142409ba10, n_ranges=0, bufsz=0x7f142409bfa0, mrr_mode=0x7f142409bf9c, cost=0x7f142409c010) at /data/src/10.3/sql/ha_partition.cc:6279 #16 0x000055d6796a0582 in check_quick_select (param=0x7f142409c1d0, idx=0, index_only=false, tree=0x7f13b41367b8, update_tbl_stats=true, mrr_flags=0x7f142409bf9c, bufsize=0x7f142409bfa0, cost=0x7f142409c010) at /data/src/10.3/sql/opt_range.cc:10370 #17 0x000055d679697cb6 in get_key_scans_params (param=0x7f142409c1d0, tree=0x7f13b4136730, index_read_must_be_used=false, update_tbl_stats=true, read_time=21.142968750000001) at /data/src/10.3/sql/opt_range.cc:6784 #18 0x000055d67968e531 in SQL_SELECT::test_quick_select (this=0x7f13b4017ff8, thd=0x7f13b4000b00, keys_to_use=..., prev_tables=0, limit=18446744073709551615, force_quick_range=false, ordered_output=false, remove_false_parts_of_where=true) at /data/src/10.3/sql/opt_range.cc:2591 #19 0x000055d67929c899 in get_quick_record_count (thd=0x7f13b4000b00, select=0x7f13b4017ff8, table=0x7f13b01971a0, keys=0x7f13b4016f30, limit=18446744073709551615) at /data/src/10.3/sql/sql_select.cc:4189 #20 0x000055d67929ed6f in make_join_statistics (join=0x7f13b4015570, tables_list=..., keyuse_array=0x7f13b4015860) at /data/src/10.3/sql/sql_select.cc:4816 #21 0x000055d6792945bd in JOIN::optimize_inner (this=0x7f13b4015570) at /data/src/10.3/sql/sql_select.cc:1846 #22 0x000055d679292e89 in JOIN::optimize (this=0x7f13b4015570) at /data/src/10.3/sql/sql_select.cc:1431 #23 0x000055d67929c5e2 in mysql_select (thd=0x7f13b4000b00, tables=0x7f13b4013de0, wild_num=1, fields=..., conds=0x7f13b4014d40, og_num=1, order=0x7f13b40153a0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7f13b4015550, unit=0x7f13b4004948, select_lex=0x7f13b40050c0) at /data/src/10.3/sql/sql_select.cc:4138 #24 0x000055d67928ebcf in handle_select (thd=0x7f13b4000b00, lex=0x7f13b4004880, result=0x7f13b4015550, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:382 #25 0x000055d67925a0c7 in execute_sqlcom_select (thd=0x7f13b4000b00, all_tables=0x7f13b4013de0) at /data/src/10.3/sql/sql_parse.cc:6539 #26 0x000055d679250828 in mysql_execute_command (thd=0x7f13b4000b00) at /data/src/10.3/sql/sql_parse.cc:3768 #27 0x000055d67925dad8 in mysql_parse (thd=0x7f13b4000b00, rawbuf=0x7f13b4013a28 "SELECT * FROM test.`BB` AS table1 WHERE ( ( table1.`col_int_key` IN ( 6, 5, 6 ) AND table1.`pk` <> table1.`col_varchar_nokey`) AND table1.`col_time_nokey` LIKE 'wait/synch%') ORDER BY table1.`pk` LIMI"..., length=229, parser_state=0x7f142409e5d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8001 #28 0x000055d67924b2bb in dispatch_command (command=COM_QUERY, thd=0x7f13b4000b00, packet=0x7f13b400b261 " SELECT * FROM test.`BB` AS table1 WHERE ( ( table1.`col_int_key` IN ( 6, 5, 6 ) AND table1.`pk` <> table1.`col_varchar_nokey`) AND table1.`col_time_nokey` LIKE 'wait/synch%') ORDER BY table1.`pk` LIM"..., packet_length=231, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846 #29 0x000055d679249cfa in do_command (thd=0x7f13b4000b00) at /data/src/10.3/sql/sql_parse.cc:1391 #30 0x000055d6793ac78b in do_handle_one_connection (connect=0x55d67da352a0) at /data/src/10.3/sql/sql_connect.cc:1402 #31 0x000055d6793ac518 in handle_one_connection (arg=0x55d67da352a0) at /data/src/10.3/sql/sql_connect.cc:1308 #32 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67d9d2240) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #33 0x00007f1443b55494 in start_thread (arg=0x7f142409f700) at pthread_create.c:333 #34 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6