[New LWP 2628393] [New LWP 2628394] [New LWP 2628395] [New LWP 2628396] [New LWP 2628400] [New LWP 2628407] [New LWP 2628411] [New LWP 2628421] [New LWP 2628423] [New LWP 2628425] [New LWP 2628427] [New LWP 2629624] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". 0x00007f5fb3d1b1df in __GI___poll (fds=0x55d2ee31bf08, nfds=4, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 Thread 13 (Thread 0x7f5f7ffff6c0 (LWP 2629624) "mysqld"): #0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f5f7fffeae0, op=137, expected=0, futex_word=0x55d2edd6dbe8) at ./nptl/futex-internal.c:57 #1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x55d2edd6dbe8, expected=expected@entry=0, clockid=clockid@entry=1, abstime=abstime@entry=0x7f5f7fffeae0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87 #2 0x00007f5fb3ca4f7b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x55d2edd6dbe8, expected=expected@entry=0, clockid=clockid@entry=1, abstime=abstime@entry=0x7f5f7fffeae0, private=private@entry=0) at ./nptl/futex-internal.c:139 #3 0x00007f5fb3ca7baf in __pthread_cond_wait_common (abstime=, clockid=1, mutex=0x55d2ed9138b0, cond=0x55d2edd6dbc0) at ./nptl/pthread_cond_wait.c:503 #4 ___pthread_cond_clockwait64 (abstime=, clockid=1, mutex=0x55d2ed9138b0, cond=0x55d2edd6dbc0) at ./nptl/pthread_cond_wait.c:682 #5 ___pthread_cond_clockwait64 (cond=0x55d2edd6dbc0, mutex=0x55d2ed9138b0, clockid=1, abstime=) at ./nptl/pthread_cond_wait.c:670 #6 0x000055d2c9567ab9 in std::__condvar::wait_until (this=0x55d2edd6dbc0, __m=..., __clock=1, __abs_time=...) at /usr/include/c++/12/bits/std_mutex.h:169 #7 0x000055d2c956cd95 in std::condition_variable::__wait_until_impl > > (this=0x55d2edd6dbc0, __lock=..., __atime=...) at /usr/include/c++/12/condition_variable:200 #8 0x000055d2c956b30d in std::condition_variable::wait_until > > (this=0x55d2edd6dbc0, __lock=..., __atime=...) at /usr/include/c++/12/condition_variable:110 #9 0x000055d2c95698cb in std::condition_variable::wait_for > (this=0x55d2edd6dbc0, __lock=..., __rtime=...) at /usr/include/c++/12/condition_variable:162 #10 0x000055d2c9564295 in tpool::thread_pool_generic::wait_for_tasks (this=0x55d2ed9136b0, lk=..., thread_data=0x55d2edd6dbc0) at /data/bld/bb-MDEV-24-monty-gcov/tpool/tpool_generic.cc:474 #11 0x000055d2c9564680 in tpool::thread_pool_generic::get_task (this=0x55d2ed9136b0, thread_var=0x55d2edd6dbc0, t=0x7f5f7fffec30) at /data/bld/bb-MDEV-24-monty-gcov/tpool/tpool_generic.cc:527 #12 0x000055d2c9564e6e in tpool::thread_pool_generic::worker_main (this=0x55d2ed9136b0, thread_var=0x55d2edd6dbc0) at /data/bld/bb-MDEV-24-monty-gcov/tpool/tpool_generic.cc:572 #13 0x000055d2c9574296 in std::__invoke_impl (__f=@0x7f5fa8005808: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x55d2c9564b60 , __t=@0x7f5fa8005800: 0x55d2ed9136b0) at /usr/include/c++/12/bits/invoke.h:74 #14 0x000055d2c95740d5 in std::__invoke (__fn=@0x7f5fa8005808: (void (tpool::thread_pool_generic::*)(tpool::thread_pool_generic * const, tpool::worker_data *)) 0x55d2c9564b60 ) at /usr/include/c++/12/bits/invoke.h:96 #15 0x000055d2c9573ef7 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7f5fa80057f8) at /usr/include/c++/12/bits/std_thread.h:252 #16 0x000055d2c9573e04 in std::thread::_Invoker >::operator() (this=0x7f5fa80057f8) at /usr/include/c++/12/bits/std_thread.h:259 #17 0x000055d2c9573dc4 in std::thread::_State_impl > >::_M_run (this=0x7f5fa80057f0) at /usr/include/c++/12/bits/std_thread.h:210 #18 0x00007f5fb3ed44a3 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6 #19 0x00007f5fb3ca81c4 in start_thread (arg=) at ./nptl/pthread_create.c:442 #20 0x00007f5fb3d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Thread 12 (Thread 0x7f5f7ea3a6c0 (LWP 2628427) "mysqld"): #0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x7f5f40000ba4) at ./nptl/futex-internal.c:57 #1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7f5f40000ba4, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87 #2 0x00007f5fb3ca4f7b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7f5f40000ba4, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139 #3 0x00007f5fb3ca75d8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55d2edacab78, cond=0x7f5f40000b78) at ./nptl/pthread_cond_wait.c:503 #4 ___pthread_cond_wait (cond=0x7f5f40000b78, mutex=0x55d2edacab78) at ./nptl/pthread_cond_wait.c:618 #5 0x000055d2c96810d8 in safe_cond_wait (cond=0x7f5f40000b78, mp=0x55d2edacab50, file=0x55d2c9decd68 "/data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c", line=598) at /data/bld/bb-MDEV-24-monty-gcov/mysys/thr_mutex.c:489 #6 0x000055d2c9677983 in psi_cond_wait (that=0x7f5f40000b78, mutex=0x55d2edacab50, file=0x55d2c9b50f48 "/data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c", line=2154) at /data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c:598 #7 0x000055d2c895fe9e in inline_mysql_cond_wait (that=0x7f5f40000b78, mutex=0x55d2edacab50, src_file=0x55d2c9b50f48 "/data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c", src_line=2154) at /data/bld/bb-MDEV-24-monty-gcov/include/mysql/psi/mysql_thread.h:1070 #8 0x000055d2c8966c1a in find_block (pagecache=0x55d2edacaa88, file=0x7f5f40171e08, pageno=18, init_hits_left=0, wrmode=1 '\001', block_is_copied=0 '\000', reg_req=1 '\001', fast=0 '\000', page_st=0x7f5f7ea37110) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c:2154 #9 0x000055d2c89749ae in pagecache_write_part (pagecache=0x55d2edacaa88, file=0x7f5f40171e08, pageno=18, level=0, buff=0x7f5f401742b0 "", type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_READ, pin=PAGECACHE_PIN, write_mode=PAGECACHE_WRITE_DELAY, page_link=0x7f5f7ea37280, first_REDO_LSN_for_page=0, offset=0, size=8192) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c:4437 #10 0x000055d2c89cbd61 in write_tail (info=0x7f5f40171978, block=0x7f5f40024180, row_part=0x7f5f401ae1ed "'bxfciylyvlaomjvtexuhgrtudaqspwskcdeotigpdcrfqesujobpitdekbyedetqwhxkpocsctsvihpmrwjzlzzvsquqrswptcmbqbplbgheulkatjgxjebeubcbjprdcjbpahkuybddqvarzslrtnwckjoxvyerfkffodphnladdtenfpszxauhsbptqwiiwiewyws"..., org_length=354) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:2072 #11 0x000055d2c89cf696 in write_block_record (info=0x7f5f40171978, old_record=0x0, record=0x7f5f4014b3e0 "", row=0x7f5f401719f8, bitmap_blocks=0x7f5f401719f8, head_block_is_read=1 '\001', row_pos=0x7f5f7ea379d0, undo_lsn=1, old_record_checksum=0) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:2944 #12 0x000055d2c89d20b6 in allocate_and_write_block_record (info=0x7f5f40171978, record=0x7f5f4014b3e0 "", row=0x7f5f401719f8, undo_lsn=1) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:3579 #13 0x000055d2c89d22cf in _ma_write_init_block_record (info=0x7f5f40171978, record=0x7f5f4014b3e0 "") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:3619 #14 0x000055d2c89f0111 in maria_write (info=0x7f5f40171978, record=0x7f5f4014b3e0 "") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_write.c:157 #15 0x000055d2c8919391 in ha_maria::write_row (this=0x7f5f4014abd0, buf=0x7f5f4014b3e0 "") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ha_maria.cc:1302 #16 0x000055d2c7ed285f in handler::ha_write_tmp_row (this=0x7f5f4014abd0, buf=0x7f5f4014b3e0 "") at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_class.h:7890 #17 0x000055d2c7e9d187 in end_write (join=0x7f5f4007f7e8, join_tab=0x7f5f4015ed40, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:25820 #18 0x000055d2c7ec4b04 in AGGR_OP::put_record (this=0x7f5f4015ffa8, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:33323 #19 0x000055d2c7ed42b1 in AGGR_OP::put_record (this=0x7f5f4015ffa8) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.h:1186 #20 0x000055d2c7e94526 in sub_select_postjoin_aggr (join=0x7f5f4007f7e8, join_tab=0x7f5f4015ed40, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:23920 #21 0x000055d2c7e9663b in evaluate_join_record (join=0x7f5f4007f7e8, join_tab=0x7f5f4015e8d0, error=0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24469 #22 0x000055d2c7e959e8 in sub_select (join=0x7f5f4007f7e8, join_tab=0x7f5f4015e8d0, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24273 #23 0x000055d2c7e9663b in evaluate_join_record (join=0x7f5f4007f7e8, join_tab=0x7f5f4015e460, error=0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24469 #24 0x000055d2c7e9566c in sub_select (join=0x7f5f4007f7e8, join_tab=0x7f5f4015e460, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24236 #25 0x000055d2c7e93740 in do_select (join=0x7f5f4007f7e8, procedure=0x0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:23747 #26 0x000055d2c7e35671 in JOIN::exec_inner (this=0x7f5f4007f7e8) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:5052 #27 0x000055d2c7e33a0d in JOIN::exec (this=0x7f5f4007f7e8) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:4838 #28 0x000055d2c7e36d39 in mysql_select (thd=0x7f5f40000dc8, tables=0x7f5f40014e78, fields=..., conds=0x0, og_num=3, order=0x7f5f40017510, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x7f5f4007f7c0, unit=0x7f5f40005270, select_lex=0x7f5f40014758) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:5368 #29 0x000055d2c7e15567 in handle_select (thd=0x7f5f40000dc8, lex=0x7f5f40005190, result=0x7f5f4007f7c0, setup_tables_done_option=0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:642 #30 0x000055d2c7d616e1 in execute_sqlcom_select (thd=0x7f5f40000dc8, all_tables=0x7f5f40014e78) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:6183 #31 0x000055d2c7d4f609 in mysql_execute_command (thd=0x7f5f40000dc8, is_called_from_prepared_stmt=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:3975 #32 0x000055d2c7d6ade0 in mysql_parse (thd=0x7f5f40000dc8, rawbuf=0x7f5f40014440 "/* WRK-4 QNO 161 */ SELECT * FROM (`optimizer_db`.`view_table10_aria_int_autoinc_temptable` AS table1 INNER JOIN `optimizer_db`.`view_table100_aria_int_autoinc_merge` AS table2 ON ( table2.`col_text_"..., length=347, parser_state=0x7f5f7ea39370) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:7907 #33 0x000055d2c7d4203f in dispatch_command (command=COM_QUERY, thd=0x7f5f40000dc8, packet=0x7f5f4000bcb9 "", packet_length=347, blocking=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:1904 #34 0x000055d2c7d3f160 in do_command (thd=0x7f5f40000dc8, blocking=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:1417 #35 0x000055d2c80f4601 in do_handle_one_connection (connect=0x55d2ee2f52b8, put_in_cache=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_connect.cc:1408 #36 0x000055d2c80f40ff in handle_one_connection (arg=0x55d2ee2f52b8) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_connect.cc:1320 #37 0x000055d2c8aa4707 in pfs_spawn_thread (arg=0x55d2ee2f5398) at /data/bld/bb-MDEV-24-monty-gcov/storage/perfschema/pfs.cc:2201 #38 0x00007f5fb3ca81c4 in start_thread (arg=) at ./nptl/pthread_create.c:442 #39 0x00007f5fb3d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Thread 11 (Thread 0x7f5f7ea856c0 (LWP 2628425) "mysqld"): #0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x7f5f3c000ba4) at ./nptl/futex-internal.c:57 #1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7f5f3c000ba4, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87 #2 0x00007f5fb3ca4f7b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7f5f3c000ba4, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139 #3 0x00007f5fb3ca75d8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55d2edad22c8, cond=0x7f5f3c000b78) at ./nptl/pthread_cond_wait.c:503 #4 ___pthread_cond_wait (cond=0x7f5f3c000b78, mutex=0x55d2edad22c8) at ./nptl/pthread_cond_wait.c:618 #5 0x000055d2c96810d8 in safe_cond_wait (cond=0x7f5f3c000b78, mp=0x55d2edad22a0, file=0x55d2c9decd68 "/data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c", line=598) at /data/bld/bb-MDEV-24-monty-gcov/mysys/thr_mutex.c:489 #6 0x000055d2c9677983 in psi_cond_wait (that=0x7f5f3c000b78, mutex=0x55d2edad22a0, file=0x55d2c9b50f48 "/data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c", line=2154) at /data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c:598 #7 0x000055d2c895fe9e in inline_mysql_cond_wait (that=0x7f5f3c000b78, mutex=0x55d2edad22a0, src_file=0x55d2c9b50f48 "/data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c", src_line=2154) at /data/bld/bb-MDEV-24-monty-gcov/include/mysql/psi/mysql_thread.h:1070 #8 0x000055d2c8966c1a in find_block (pagecache=0x55d2edad21d8, file=0x7f5f3c180478, pageno=59, init_hits_left=0, wrmode=1 '\001', block_is_copied=0 '\000', reg_req=1 '\001', fast=0 '\000', page_st=0x7f5f7ea82180) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c:2154 #9 0x000055d2c89749ae in pagecache_write_part (pagecache=0x55d2edad21d8, file=0x7f5f3c180478, pageno=59, level=0, buff=0x7f5f3c182920 "", type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_READ, pin=PAGECACHE_PIN, write_mode=PAGECACHE_WRITE_DELAY, page_link=0x7f5f7ea822f0, first_REDO_LSN_for_page=0, offset=0, size=8192) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c:4437 #10 0x000055d2c89cbd61 in write_tail (info=0x7f5f3c17ffe8, block=0x7f5f3c131720, row_part=0x7f5f3c1d3640 "'htvuxgqrswjdbamlqchmpwxnbwlbdgkuecxjsthvktxfiuieytbuopgotrvzytdpovjpqdthpnblnbyszmhjmwbdctcezyfqniuhexqbfmogycjftduhplazejzjkdhcjvrxnxeqejoojqjamzahthbrpfyrrzdjpplrsytyclxkoxsojzcswjfpmqpsetnqrwklvmc"..., org_length=802) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:2072 #11 0x000055d2c89cf696 in write_block_record (info=0x7f5f3c17ffe8, old_record=0x0, record=0x7f5f3c0b8ef0 "", row=0x7f5f3c180068, bitmap_blocks=0x7f5f3c180068, head_block_is_read=1 '\001', row_pos=0x7f5f7ea82a40, undo_lsn=1, old_record_checksum=0) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:2944 #12 0x000055d2c89d20b6 in allocate_and_write_block_record (info=0x7f5f3c17ffe8, record=0x7f5f3c0b8ef0 "", row=0x7f5f3c180068, undo_lsn=1) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:3579 #13 0x000055d2c89d22cf in _ma_write_init_block_record (info=0x7f5f3c17ffe8, record=0x7f5f3c0b8ef0 "") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:3619 #14 0x000055d2c89f0111 in maria_write (info=0x7f5f3c17ffe8, record=0x7f5f3c0b8ef0 "") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_write.c:157 #15 0x000055d2c8919391 in ha_maria::write_row (this=0x7f5f3c0b86e0, buf=0x7f5f3c0b8ef0 "") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ha_maria.cc:1302 #16 0x000055d2c7ed285f in handler::ha_write_tmp_row (this=0x7f5f3c0b86e0, buf=0x7f5f3c0b8ef0 "") at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_class.h:7890 #17 0x000055d2c7e9d187 in end_write (join=0x7f5f3c19ee90, join_tab=0x7f5f3c160728, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:25820 #18 0x000055d2c7ec4b04 in AGGR_OP::put_record (this=0x7f5f3c1616c0, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:33323 #19 0x000055d2c7ed42b1 in AGGR_OP::put_record (this=0x7f5f3c1616c0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.h:1186 #20 0x000055d2c7e94526 in sub_select_postjoin_aggr (join=0x7f5f3c19ee90, join_tab=0x7f5f3c160728, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:23920 #21 0x000055d2c81aad35 in JOIN_CACHE::generate_full_extensions (this=0x7f5f3c1614f8, rec_ptr=0x7f5f3c1a8505 "\001") at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_join_cache.cc:2541 #22 0x000055d2c81aa6ee in JOIN_CACHE::join_matching_records (this=0x7f5f3c1614f8, skip_last=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_join_cache.cc:2433 #23 0x000055d2c81a94c3 in JOIN_CACHE::join_records (this=0x7f5f3c1614f8, skip_last=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_join_cache.cc:2183 #24 0x000055d2c7e947aa in sub_select_cache (join=0x7f5f3c19ee90, join_tab=0x7f5f3c1602b8, end_of_records=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:23979 #25 0x000055d2c7e94db3 in sub_select (join=0x7f5f3c19ee90, join_tab=0x7f5f3c15fe48, end_of_records=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24169 #26 0x000055d2c7e9380e in do_select (join=0x7f5f3c19ee90, procedure=0x0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:23749 #27 0x000055d2c7e35671 in JOIN::exec_inner (this=0x7f5f3c19ee90) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:5052 #28 0x000055d2c7e33a0d in JOIN::exec (this=0x7f5f3c19ee90) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:4838 #29 0x000055d2c7e36d39 in mysql_select (thd=0x7f5f3c000dc8, tables=0x7f5f3c014e58, fields=..., conds=0x0, og_num=2, order=0x7f5f3c017538, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x7f5f3c19ee68, unit=0x7f5f3c005270, select_lex=0x7f5f3c014740) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:5368 #30 0x000055d2c7e15567 in handle_select (thd=0x7f5f3c000dc8, lex=0x7f5f3c005190, result=0x7f5f3c19ee68, setup_tables_done_option=0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:642 #31 0x000055d2c7d616e1 in execute_sqlcom_select (thd=0x7f5f3c000dc8, all_tables=0x7f5f3c014e58) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:6183 #32 0x000055d2c7d4f609 in mysql_execute_command (thd=0x7f5f3c000dc8, is_called_from_prepared_stmt=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:3975 #33 0x000055d2c7d6ade0 in mysql_parse (thd=0x7f5f3c000dc8, rawbuf=0x7f5f3c014440 "/* WRK-3 QNO 293 */ SELECT * FROM (`optimizer_db`.`view_table20_aria_int_autoinc_merge` AS table1 LEFT OUTER JOIN `optimizer_db`.`view_table10_aria_int_autoinc_temptable` AS table2 ON ( table2.`col_v"..., length=333, parser_state=0x7f5f7ea84370) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:7907 #34 0x000055d2c7d4203f in dispatch_command (command=COM_QUERY, thd=0x7f5f3c000dc8, packet=0x7f5f3c00bcb9 "", packet_length=333, blocking=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:1904 #35 0x000055d2c7d3f160 in do_command (thd=0x7f5f3c000dc8, blocking=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:1417 #36 0x000055d2c80f4601 in do_handle_one_connection (connect=0x55d2ee2f4d48, put_in_cache=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_connect.cc:1408 #37 0x000055d2c80f40ff in handle_one_connection (arg=0x55d2ee2f4d48) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_connect.cc:1320 #38 0x000055d2c8aa4707 in pfs_spawn_thread (arg=0x55d2ee2f4e28) at /data/bld/bb-MDEV-24-monty-gcov/storage/perfschema/pfs.cc:2201 #39 0x00007f5fb3ca81c4 in start_thread (arg=) at ./nptl/pthread_create.c:442 #40 0x00007f5fb3d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Thread 10 (Thread 0x7f5f7ead06c0 (LWP 2628423) "mysqld"): #0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x7f5f48000ba4) at ./nptl/futex-internal.c:57 #1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7f5f48000ba4, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87 #2 0x00007f5fb3ca4f7b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7f5f48000ba4, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139 #3 0x00007f5fb3ca75d8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55d2edad7af8, cond=0x7f5f48000b78) at ./nptl/pthread_cond_wait.c:503 #4 ___pthread_cond_wait (cond=0x7f5f48000b78, mutex=0x55d2edad7af8) at ./nptl/pthread_cond_wait.c:618 #5 0x000055d2c96810d8 in safe_cond_wait (cond=0x7f5f48000b78, mp=0x55d2edad7ad0, file=0x55d2c9decd68 "/data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c", line=598) at /data/bld/bb-MDEV-24-monty-gcov/mysys/thr_mutex.c:489 #6 0x000055d2c9677983 in psi_cond_wait (that=0x7f5f48000b78, mutex=0x55d2edad7ad0, file=0x55d2c9b50f48 "/data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c", line=2154) at /data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c:598 #7 0x000055d2c895fe9e in inline_mysql_cond_wait (that=0x7f5f48000b78, mutex=0x55d2edad7ad0, src_file=0x55d2c9b50f48 "/data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c", src_line=2154) at /data/bld/bb-MDEV-24-monty-gcov/include/mysql/psi/mysql_thread.h:1070 #8 0x000055d2c8966c1a in find_block (pagecache=0x55d2edad7a08, file=0x7f5f480e2fb8, pageno=1, init_hits_left=0, wrmode=1 '\001', block_is_copied=0 '\000', reg_req=1 '\001', fast=0 '\000', page_st=0x7f5f7eacc090) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c:2154 #9 0x000055d2c89749ae in pagecache_write_part (pagecache=0x55d2edad7a08, file=0x7f5f480e2fb8, pageno=1, level=0, buff=0x7f5f480e33a0 "", type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_READ, pin=PAGECACHE_PIN, write_mode=PAGECACHE_WRITE_DELAY, page_link=0x7f5f7eacc3a0, first_REDO_LSN_for_page=0, offset=0, size=8192) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c:4437 #10 0x000055d2c89d09be in write_block_record (info=0x7f5f480e2b28, old_record=0x0, record=0x7f5f480ab930 "", row=0x7f5f480e2ba8, bitmap_blocks=0x7f5f480e2ba8, head_block_is_read=0 '\000', row_pos=0x7f5f7eacc820, undo_lsn=1, old_record_checksum=0) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:3202 #11 0x000055d2c89d20b6 in allocate_and_write_block_record (info=0x7f5f480e2b28, record=0x7f5f480ab930 "", row=0x7f5f480e2ba8, undo_lsn=1) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:3579 #12 0x000055d2c89d22cf in _ma_write_init_block_record (info=0x7f5f480e2b28, record=0x7f5f480ab930 "") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:3619 #13 0x000055d2c89f0111 in maria_write (info=0x7f5f480e2b28, record=0x7f5f480ab930 "") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_write.c:157 #14 0x000055d2c8919391 in ha_maria::write_row (this=0x7f5f480ab120, buf=0x7f5f480ab930 "") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ha_maria.cc:1302 #15 0x000055d2c7ed285f in handler::ha_write_tmp_row (this=0x7f5f480ab120, buf=0x7f5f480ab930 "") at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_class.h:7890 #16 0x000055d2c7fd6df1 in select_unit::write_record (this=0x7f5f48015b70) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_union.cc:416 #17 0x000055d2c7fd599d in select_unit::send_data (this=0x7f5f48015b70, values=...) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_union.cc:160 #18 0x000055d2c7ed225d in select_result_sink::send_data_with_check (this=0x7f5f48015b70, items=..., u=0x7f5f4805e5a8, sent=0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_class.h:6099 #19 0x000055d2c7e9b70a in end_send (join=0x7f5f48015c60, join_tab=0x7f5f480ccfb0, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:25543 #20 0x000055d2c7e9663b in evaluate_join_record (join=0x7f5f48015c60, join_tab=0x7f5f480ccb40, error=0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24469 #21 0x000055d2c7e9566c in sub_select (join=0x7f5f48015c60, join_tab=0x7f5f480ccb40, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24236 #22 0x000055d2c7e93740 in do_select (join=0x7f5f48015c60, procedure=0x0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:23747 #23 0x000055d2c7e35671 in JOIN::exec_inner (this=0x7f5f48015c60) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:5052 #24 0x000055d2c7e33a0d in JOIN::exec (this=0x7f5f48015c60) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:4838 #25 0x000055d2c7e36d39 in mysql_select (thd=0x7f5f48000dc8, tables=0x7f5f48068648, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201187781376, result=0x7f5f48015b70, unit=0x7f5f4805e5a8, select_lex=0x7f5f48061058) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:5368 #26 0x000055d2c7c94f43 in mysql_derived_fill (thd=0x7f5f48000dc8, lex=0x7f5f48034638, derived=0x7f5f48037078) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_derived.cc:1283 #27 0x000055d2c7c8e9f2 in mysql_handle_single_derived (lex=0x7f5f48034638, derived=0x7f5f48037078, phases=96) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_derived.cc:200 #28 0x000055d2c7e6ee38 in st_join_table::preread_init (this=0x7f5f480d0b68) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:16757 #29 0x000055d2c7e94eb9 in sub_select (join=0x7f5f480153b0, join_tab=0x7f5f480d0b68, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24183 #30 0x000055d2c7e9663b in evaluate_join_record (join=0x7f5f480153b0, join_tab=0x7f5f480d06f8, error=0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24469 #31 0x000055d2c7e9566c in sub_select (join=0x7f5f480153b0, join_tab=0x7f5f480d06f8, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24236 #32 0x000055d2c7e93740 in do_select (join=0x7f5f480153b0, procedure=0x0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:23747 #33 0x000055d2c7e35671 in JOIN::exec_inner (this=0x7f5f480153b0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:5052 #34 0x000055d2c7e33a0d in JOIN::exec (this=0x7f5f480153b0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:4838 #35 0x000055d2c7e36d39 in mysql_select (thd=0x7f5f48000dc8, tables=0x7f5f48037078, fields=..., conds=0x7f5f48014db8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201187781376, result=0x7f5f4805c760, unit=0x7f5f48034718, select_lex=0x7f5f48036958) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:5368 #36 0x000055d2c7e15567 in handle_select (thd=0x7f5f48000dc8, lex=0x7f5f48034638, result=0x7f5f4805c760, setup_tables_done_option=0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:642 #37 0x000055d2c7d616e1 in execute_sqlcom_select (thd=0x7f5f48000dc8, all_tables=0x7f5f48037078) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:6183 #38 0x000055d2c7d4f609 in mysql_execute_command (thd=0x7f5f48000dc8, is_called_from_prepared_stmt=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:3975 #39 0x000055d2c7de0e9d in Prepared_statement::execute (this=0x7f5f4802dbb8, expanded_query=0x7f5f7eacea90, open_cursor=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_prepare.cc:5084 #40 0x000055d2c7ddd088 in Prepared_statement::execute_loop (this=0x7f5f4802dbb8, expanded_query=0x7f5f7eacea90, open_cursor=false, packet=0x0, packet_end=0x0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_prepare.cc:4469 #41 0x000055d2c7dd806d in mysql_sql_stmt_execute (thd=0x7f5f48000dc8) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_prepare.cc:3494 #42 0x000055d2c7d4f70c in mysql_execute_command (thd=0x7f5f48000dc8, is_called_from_prepared_stmt=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:3991 #43 0x000055d2c7d6ade0 in mysql_parse (thd=0x7f5f48000dc8, rawbuf=0x7f5f48014440 "/* WRK-2 QNO 91 */ EXECUTE stmt_ExecuteAsPS_2628422 USING @var1,@var2,@var3,@var4,@var5", length=88, parser_state=0x7f5f7eacf370) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:7907 #44 0x000055d2c7d4203f in dispatch_command (command=COM_QUERY, thd=0x7f5f48000dc8, packet=0x7f5f4800bcb9 "", packet_length=88, blocking=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:1904 #45 0x000055d2c7d3f160 in do_command (thd=0x7f5f48000dc8, blocking=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:1417 #46 0x000055d2c80f4601 in do_handle_one_connection (connect=0x55d2edf52ee8, put_in_cache=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_connect.cc:1408 #47 0x000055d2c80f40ff in handle_one_connection (arg=0x55d2edf52ee8) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_connect.cc:1320 #48 0x000055d2c8aa4707 in pfs_spawn_thread (arg=0x55d2ee2f48b8) at /data/bld/bb-MDEV-24-monty-gcov/storage/perfschema/pfs.cc:2201 #49 0x00007f5fb3ca81c4 in start_thread (arg=) at ./nptl/pthread_create.c:442 #50 0x00007f5fb3d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Thread 9 (Thread 0x7f5f7eb1b6c0 (LWP 2628421) "mysqld"): #0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x7f5f44000ba0) at ./nptl/futex-internal.c:57 #1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7f5f44000ba0, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87 #2 0x00007f5fb3ca4f7b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7f5f44000ba0, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139 #3 0x00007f5fb3ca75d8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55d2edad7af8, cond=0x7f5f44000b78) at ./nptl/pthread_cond_wait.c:503 #4 ___pthread_cond_wait (cond=0x7f5f44000b78, mutex=0x55d2edad7af8) at ./nptl/pthread_cond_wait.c:618 #5 0x000055d2c96810d8 in safe_cond_wait (cond=0x7f5f44000b78, mp=0x55d2edad7ad0, file=0x55d2c9decd68 "/data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c", line=598) at /data/bld/bb-MDEV-24-monty-gcov/mysys/thr_mutex.c:489 #6 0x000055d2c9677983 in psi_cond_wait (that=0x7f5f44000b78, mutex=0x55d2edad7ad0, file=0x55d2c9b50f48 "/data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c", line=2154) at /data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c:598 #7 0x000055d2c895fe9e in inline_mysql_cond_wait (that=0x7f5f44000b78, mutex=0x55d2edad7ad0, src_file=0x55d2c9b50f48 "/data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c", src_line=2154) at /data/bld/bb-MDEV-24-monty-gcov/include/mysql/psi/mysql_thread.h:1070 #8 0x000055d2c8966c1a in find_block (pagecache=0x55d2edad7a08, file=0x7f5f44125098, pageno=40, init_hits_left=0, wrmode=1 '\001', block_is_copied=0 '\000', reg_req=1 '\001', fast=0 '\000', page_st=0x7f5f7eb17740) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c:2154 #9 0x000055d2c89749ae in pagecache_write_part (pagecache=0x55d2edad7a08, file=0x7f5f44125098, pageno=40, level=0, buff=0x7f5f44127540 "", type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_READ, pin=PAGECACHE_PIN, write_mode=PAGECACHE_WRITE_DELAY, page_link=0x7f5f7eb178b0, first_REDO_LSN_for_page=0, offset=0, size=8192) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c:4437 #10 0x000055d2c89cbd61 in write_tail (info=0x7f5f44124c08, block=0x7f5f44130380, row_part=0x7f5f44133508 "'chmpwxnbwlbdgkuecxjsthvktxfiuieytbuopgotrvzytdpovjpqdthpnblnbyszmhjmwbdctcezyfqniuhexqbfmogycjftduhplazejzjkdhcjvrxnxeqejoojqjamzahthbrpfyrrzdjpplrsytyclxkoxsojzcswjfpmqpset'\245h4z\025", '\217' , "\205\020", org_length=175) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:2072 #11 0x000055d2c89cf696 in write_block_record (info=0x7f5f44124c08, old_record=0x0, record=0x7f5f440e5fe0 "", row=0x7f5f44124c88, bitmap_blocks=0x7f5f44124c88, head_block_is_read=1 '\001', row_pos=0x7f5f7eb18000, undo_lsn=1, old_record_checksum=0) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:2944 #12 0x000055d2c89d20b6 in allocate_and_write_block_record (info=0x7f5f44124c08, record=0x7f5f440e5fe0 "", row=0x7f5f44124c88, undo_lsn=1) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:3579 #13 0x000055d2c89d22cf in _ma_write_init_block_record (info=0x7f5f44124c08, record=0x7f5f440e5fe0 "") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:3619 #14 0x000055d2c89f0111 in maria_write (info=0x7f5f44124c08, record=0x7f5f440e5fe0 "") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_write.c:157 #15 0x000055d2c8919391 in ha_maria::write_row (this=0x7f5f440e57d0, buf=0x7f5f440e5fe0 "") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ha_maria.cc:1302 #16 0x000055d2c7ed285f in handler::ha_write_tmp_row (this=0x7f5f440e57d0, buf=0x7f5f440e5fe0 "") at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_class.h:7890 #17 0x000055d2c7e9d187 in end_write (join=0x7f5f44014c48, join_tab=0x7f5f440d3768, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:25820 #18 0x000055d2c7ec4b04 in AGGR_OP::put_record (this=0x7f5f440d46e8, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:33323 #19 0x000055d2c7ed42b1 in AGGR_OP::put_record (this=0x7f5f440d46e8) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.h:1186 #20 0x000055d2c7e94526 in sub_select_postjoin_aggr (join=0x7f5f44014c48, join_tab=0x7f5f440d3768, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:23920 #21 0x000055d2c7e9663b in evaluate_join_record (join=0x7f5f44014c48, join_tab=0x7f5f440d32f8, error=0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24469 #22 0x000055d2c7e959e8 in sub_select (join=0x7f5f44014c48, join_tab=0x7f5f440d32f8, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24273 #23 0x000055d2c7e9663b in evaluate_join_record (join=0x7f5f44014c48, join_tab=0x7f5f440d2e88, error=0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24469 #24 0x000055d2c7e959e8 in sub_select (join=0x7f5f44014c48, join_tab=0x7f5f440d2e88, end_of_records=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:24273 #25 0x000055d2c7e93740 in do_select (join=0x7f5f44014c48, procedure=0x0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:23747 #26 0x000055d2c7e35671 in JOIN::exec_inner (this=0x7f5f44014c48) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:5052 #27 0x000055d2c7e33a0d in JOIN::exec (this=0x7f5f44014c48) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:4838 #28 0x000055d2c7e36d39 in mysql_select (thd=0x7f5f44000dc8, tables=0x7f5f4408e540, fields=..., conds=0x0, og_num=6, order=0x7f5f440917a0, group=0x0, having=0x7f5f44014ac8, proc_param=0x0, select_options=2201187781376, result=0x7f5f44092388, unit=0x7f5f4408bd58, select_lex=0x7f5f4408de20) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:5368 #29 0x000055d2c7e15567 in handle_select (thd=0x7f5f44000dc8, lex=0x7f5f4408bc78, result=0x7f5f44092388, setup_tables_done_option=0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:642 #30 0x000055d2c7d616e1 in execute_sqlcom_select (thd=0x7f5f44000dc8, all_tables=0x7f5f4408e540) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:6183 #31 0x000055d2c7d4f609 in mysql_execute_command (thd=0x7f5f44000dc8, is_called_from_prepared_stmt=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:3975 #32 0x000055d2c7de0e9d in Prepared_statement::execute (this=0x7f5f4402fd08, expanded_query=0x7f5f7eb19a90, open_cursor=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_prepare.cc:5084 #33 0x000055d2c7ddd088 in Prepared_statement::execute_loop (this=0x7f5f4402fd08, expanded_query=0x7f5f7eb19a90, open_cursor=false, packet=0x0, packet_end=0x0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_prepare.cc:4469 #34 0x000055d2c7dd806d in mysql_sql_stmt_execute (thd=0x7f5f44000dc8) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_prepare.cc:3494 #35 0x000055d2c7d4f70c in mysql_execute_command (thd=0x7f5f44000dc8, is_called_from_prepared_stmt=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:3991 #36 0x000055d2c7d6ade0 in mysql_parse (thd=0x7f5f44000dc8, rawbuf=0x7f5f44014440 "/* WRK-1 QNO 70 */ EXECUTE stmt_ExecuteAsPS_2628420 USING @var1,@var2,@var3", length=76, parser_state=0x7f5f7eb1a370) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:7907 #37 0x000055d2c7d4203f in dispatch_command (command=COM_QUERY, thd=0x7f5f44000dc8, packet=0x7f5f4400bcb9 "", packet_length=76, blocking=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:1904 #38 0x000055d2c7d3f160 in do_command (thd=0x7f5f44000dc8, blocking=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:1417 #39 0x000055d2c80f4601 in do_handle_one_connection (connect=0x55d2ee20ea28, put_in_cache=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_connect.cc:1408 #40 0x000055d2c80f40ff in handle_one_connection (arg=0x55d2ee20ea28) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_connect.cc:1320 #41 0x000055d2c8aa4707 in pfs_spawn_thread (arg=0x55d2edf52a58) at /data/bld/bb-MDEV-24-monty-gcov/storage/perfschema/pfs.cc:2201 #42 0x00007f5fb3ca81c4 in start_thread (arg=) at ./nptl/pthread_create.c:442 #43 0x00007f5fb3d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Thread 8 (Thread 0x7f5f8c0e66c0 (LWP 2628411) "mysqld"): #0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x7f5f68000c60) at ./nptl/futex-internal.c:57 #1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7f5f68000c60, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87 #2 0x00007f5fb3ca4f7b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7f5f68000c60, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139 #3 0x00007f5fb3ca75d8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55d2edacab78, cond=0x7f5f68000c38) at ./nptl/pthread_cond_wait.c:503 #4 ___pthread_cond_wait (cond=0x7f5f68000c38, mutex=0x55d2edacab78) at ./nptl/pthread_cond_wait.c:618 #5 0x000055d2c96810d8 in safe_cond_wait (cond=0x7f5f68000c38, mp=0x55d2edacab50, file=0x55d2c9decd68 "/data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c", line=598) at /data/bld/bb-MDEV-24-monty-gcov/mysys/thr_mutex.c:489 #6 0x000055d2c9677983 in psi_cond_wait (that=0x7f5f68000c38, mutex=0x55d2edacab50, file=0x55d2c9b50f48 "/data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c", line=2154) at /data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c:598 #7 0x000055d2c895fe9e in inline_mysql_cond_wait (that=0x7f5f68000c38, mutex=0x55d2edacab50, src_file=0x55d2c9b50f48 "/data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c", src_line=2154) at /data/bld/bb-MDEV-24-monty-gcov/include/mysql/psi/mysql_thread.h:1070 #8 0x000055d2c8966c1a in find_block (pagecache=0x55d2edacaa88, file=0x7f5f691d5648, pageno=1, init_hits_left=0, wrmode=1 '\001', block_is_copied=0 '\000', reg_req=1 '\001', fast=0 '\000', page_st=0x7f5f8c0e0830) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c:2154 #9 0x000055d2c89749ae in pagecache_write_part (pagecache=0x55d2edacaa88, file=0x7f5f691d5648, pageno=1, level=0, buff=0x7f5f691d5970 "", type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_READ, pin=PAGECACHE_PIN, write_mode=PAGECACHE_WRITE_DELAY, page_link=0x7f5f8c0e0b40, first_REDO_LSN_for_page=0, offset=0, size=8192) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_pagecache.c:4437 #10 0x000055d2c89d09be in write_block_record (info=0x7f5f691d51b8, old_record=0x0, record=0x7f5f6920bee0 "9\377\005NEVER", row=0x7f5f691d5238, bitmap_blocks=0x7f5f691d5238, head_block_is_read=0 '\000', row_pos=0x7f5f8c0e0fc0, undo_lsn=1, old_record_checksum=0) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:3202 #11 0x000055d2c89d20b6 in allocate_and_write_block_record (info=0x7f5f691d51b8, record=0x7f5f6920bee0 "9\377\005NEVER", row=0x7f5f691d5238, undo_lsn=1) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:3579 #12 0x000055d2c89d22cf in _ma_write_init_block_record (info=0x7f5f691d51b8, record=0x7f5f6920bee0 "9\377\005NEVER") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_blockrec.c:3619 #13 0x000055d2c89f0111 in maria_write (info=0x7f5f691d51b8, record=0x7f5f6920bee0 "9\377\005NEVER") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_write.c:157 #14 0x000055d2c8919391 in ha_maria::write_row (this=0x7f5f692ae978, buf=0x7f5f6920bee0 "9\377\005NEVER") at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ha_maria.cc:1302 #15 0x000055d2c7ed285f in handler::ha_write_tmp_row (this=0x7f5f692ae978, buf=0x7f5f6920bee0 "9\377\005NEVER") at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_class.h:7890 #16 0x000055d2c7ef5ced in schema_table_store_record (thd=0x7f5f68000e88, table=0x7f5f692ab9b0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_show.cc:4039 #17 0x000055d2c7f068af in get_schema_column_record (thd=0x7f5f68000e88, tables=0x7f5f68fbdec0, table=0x7f5f692ab9b0, res=false, db_name=0x7f5f6801bcd8, table_name=0x7f5f6801bde8) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_show.cc:6515 #18 0x000055d2c7ef9c2b in fill_schema_table_by_open (thd=0x7f5f68000e88, mem_root=0x7f5f8c0e37f0, is_show_fields_or_keys=false, table=0x7f5f692ab9b0, schema_table=0x55d2ca711f20 , orig_db_name=0x7f5f6801bcd8, orig_table_name=0x7f5f6801bde8, open_tables_state_backup=0x7f5f8c0e3830, can_deadlock=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_show.cc:4838 #19 0x000055d2c7efd921 in get_all_tables (thd=0x7f5f68000e88, tables=0x7f5f68014f60, cond=0x7f5f68015860) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_show.cc:5587 #20 0x000055d2c7f1eed4 in get_schema_tables_result (join=0x7f5f68016fa8, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_show.cc:9445 #21 0x000055d2c7e350cd in JOIN::exec_inner (this=0x7f5f68016fa8) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:5016 #22 0x000055d2c7e33a0d in JOIN::exec (this=0x7f5f68016fa8) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:4838 #23 0x000055d2c7e36d39 in mysql_select (thd=0x7f5f68000e88, tables=0x7f5f68014f60, fields=..., conds=0x7f5f68015860, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2701396736, result=0x7f5f68016f80, unit=0x7f5f68005330, select_lex=0x7f5f68014850) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:5368 #24 0x000055d2c7e15567 in handle_select (thd=0x7f5f68000e88, lex=0x7f5f68005250, result=0x7f5f68016f80, setup_tables_done_option=0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_select.cc:642 #25 0x000055d2c7d616e1 in execute_sqlcom_select (thd=0x7f5f68000e88, all_tables=0x7f5f68014f60) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:6183 #26 0x000055d2c7d4f609 in mysql_execute_command (thd=0x7f5f68000e88, is_called_from_prepared_stmt=false) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:3975 #27 0x000055d2c7d6ade0 in mysql_parse (thd=0x7f5f68000e88, rawbuf=0x7f5f68014740 "/* RPT QNO 361 */ SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE IS_GENERATED='ALWAYS'", length=93, parser_state=0x7f5f8c0e5370) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:7907 #28 0x000055d2c7d4203f in dispatch_command (command=COM_QUERY, thd=0x7f5f68000e88, packet=0x7f5f68e058b9 "/* RPT QNO 361 */ SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE IS_GENERATED='ALWAYS'", packet_length=93, blocking=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:1904 #29 0x000055d2c7d3f160 in do_command (thd=0x7f5f68000e88, blocking=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_parse.cc:1417 #30 0x000055d2c80f4601 in do_handle_one_connection (connect=0x55d2ee20e868, put_in_cache=true) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_connect.cc:1408 #31 0x000055d2c80f40ff in handle_one_connection (arg=0x55d2ee277f18) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_connect.cc:1320 #32 0x000055d2c8aa4707 in pfs_spawn_thread (arg=0x55d2ee2a7c88) at /data/bld/bb-MDEV-24-monty-gcov/storage/perfschema/pfs.cc:2201 #33 0x00007f5fb3ca81c4 in start_thread (arg=) at ./nptl/pthread_create.c:442 #34 0x00007f5fb3d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Thread 7 (Thread 0x7f5fa00856c0 (LWP 2628407) "mysqld"): #0 0x00007f5fb3c5bc82 in __GI___sigtimedwait (set=0x7f5fa0084c80, info=0x7f5fa0084bc0, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:31 #1 0x000055d2c7a13a8e in my_sigwait (set=0x7f5fa0084c80, sig=0x7f5fa0084c68, code=0x7f5fa0084c6c) at /data/bld/bb-MDEV-24-monty-gcov/include/my_pthread.h:191 #2 0x000055d2c7a20e1f in signal_hand () at /data/bld/bb-MDEV-24-monty-gcov/sql/mysqld.cc:3271 #3 0x000055d2c8aa4707 in pfs_spawn_thread (arg=0x55d2ee206f58) at /data/bld/bb-MDEV-24-monty-gcov/storage/perfschema/pfs.cc:2201 #4 0x00007f5fb3ca81c4 in start_thread (arg=) at ./nptl/pthread_create.c:442 #5 0x00007f5fb3d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Thread 6 (Thread 0x7f5fa00d06c0 (LWP 2628400) "mysqld"): #0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x55d2cb32d388 ) at ./nptl/futex-internal.c:57 #1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x55d2cb32d388 , expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87 #2 0x00007f5fb3ca4f7b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x55d2cb32d388 , expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139 #3 0x00007f5fb3ca75d8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55d2cb32d2c8 , cond=0x55d2cb32d360 ) at ./nptl/pthread_cond_wait.c:503 #4 ___pthread_cond_wait (cond=0x55d2cb32d360 , mutex=0x55d2cb32d2c8 ) at ./nptl/pthread_cond_wait.c:618 #5 0x000055d2c96810d8 in safe_cond_wait (cond=0x55d2cb32d360 , mp=0x55d2cb32d2a0 , file=0x55d2c9decd68 "/data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c", line=598) at /data/bld/bb-MDEV-24-monty-gcov/mysys/thr_mutex.c:489 #6 0x000055d2c9677983 in psi_cond_wait (that=0x55d2cb32d360 , mutex=0x55d2cb32d2a0 , file=0x55d2c98cb428 "/data/bld/bb-MDEV-24-monty-gcov/sql/sql_manager.cc", line=109) at /data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c:598 #7 0x000055d2c7d354d7 in inline_mysql_cond_wait (that=0x55d2cb32d360 , mutex=0x55d2cb32d2a0 , src_file=0x55d2c98cb428 "/data/bld/bb-MDEV-24-monty-gcov/sql/sql_manager.cc", src_line=109) at /data/bld/bb-MDEV-24-monty-gcov/include/mysql/psi/mysql_thread.h:1070 #8 0x000055d2c7d35cb8 in handle_manager (arg=0x0) at /data/bld/bb-MDEV-24-monty-gcov/sql/sql_manager.cc:109 #9 0x000055d2c8aa4707 in pfs_spawn_thread (arg=0x55d2edf44008) at /data/bld/bb-MDEV-24-monty-gcov/storage/perfschema/pfs.cc:2201 #10 0x00007f5fb3ca81c4 in start_thread (arg=) at ./nptl/pthread_create.c:442 #11 0x00007f5fb3d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Thread 5 (Thread 0x7f5f93fff6c0 (LWP 2628396) "mysqld"): #0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x55d2cae216f8 ) at ./nptl/futex-internal.c:57 #1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x55d2cae216f8 , expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87 #2 0x00007f5fb3ca4f7b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x55d2cae216f8 , expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139 #3 0x00007f5fb3ca75d8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55d2cae215e8 , cond=0x55d2cae216d0 ) at ./nptl/pthread_cond_wait.c:503 #4 ___pthread_cond_wait (cond=0x55d2cae216d0 , mutex=0x55d2cae215e8 ) at ./nptl/pthread_cond_wait.c:618 #5 0x000055d2c96810d8 in safe_cond_wait (cond=0x55d2cae216d0 , mp=0x55d2cae215c0 , file=0x55d2c9d56730 "/data/bld/bb-MDEV-24-monty-gcov/storage/innobase/buf/buf0flu.cc", line=2506) at /data/bld/bb-MDEV-24-monty-gcov/mysys/thr_mutex.c:489 #6 0x000055d2c9344174 in buf_flush_page_cleaner () at /data/bld/bb-MDEV-24-monty-gcov/storage/innobase/buf/buf0flu.cc:2506 #7 0x000055d2c934cb51 in std::__invoke_impl (__f=@0x55d2ede68b68: 0x55d2c9343a53 ) at /usr/include/c++/12/bits/invoke.h:61 #8 0x000055d2c934ca9c in std::__invoke (__fn=@0x55d2ede68b68: 0x55d2c9343a53 ) at /usr/include/c++/12/bits/invoke.h:96 #9 0x000055d2c934c9ca in std::thread::_Invoker >::_M_invoke<0ul> (this=0x55d2ede68b68) at /usr/include/c++/12/bits/std_thread.h:252 #10 0x000055d2c934c956 in std::thread::_Invoker >::operator() (this=0x55d2ede68b68) at /usr/include/c++/12/bits/std_thread.h:259 #11 0x000055d2c934c916 in std::thread::_State_impl > >::_M_run (this=0x55d2ede68b60) at /usr/include/c++/12/bits/std_thread.h:210 #12 0x00007f5fb3ed44a3 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6 #13 0x00007f5fb3ca81c4 in start_thread (arg=) at ./nptl/pthread_create.c:442 #14 0x00007f5fb3d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Thread 4 (Thread 0x7f5fa08d16c0 (LWP 2628395) "mysqld"): #0 0x00007f5fb478a9f7 in ?? () from /lib/x86_64-linux-gnu/liburing.so.2 #1 0x00007f5fb478ac39 in __io_uring_get_cqe () from /lib/x86_64-linux-gnu/liburing.so.2 #2 0x000055d2c9575b38 in io_uring_wait_cqe_nr (ring=0x55d2eddb4ad8, cqe_ptr=0x7f5fa08d0c50, wait_nr=1) at /usr/include/liburing.h:1175 #3 0x000055d2c9575df4 in io_uring_wait_cqe (ring=0x55d2eddb4ad8, cqe_ptr=0x7f5fa08d0c50) at /usr/include/liburing.h:1248 #4 0x000055d2c957720d in (anonymous namespace)::aio_uring::thread_routine (aio=0x55d2eddb4ad0) at /data/bld/bb-MDEV-24-monty-gcov/tpool/aio_liburing.cc:145 #5 0x000055d2c9578070 in std::__invoke_impl (__f=@0x55d2ed9104b0: 0x55d2c95771d8 <(anonymous namespace)::aio_uring::thread_routine((anonymous namespace)::aio_uring*)>) at /usr/include/c++/12/bits/invoke.h:61 #6 0x000055d2c9577f4f in std::__invoke (__fn=@0x55d2ed9104b0: 0x55d2c95771d8 <(anonymous namespace)::aio_uring::thread_routine((anonymous namespace)::aio_uring*)>) at /usr/include/c++/12/bits/invoke.h:96 #7 0x000055d2c9577df7 in std::thread::_Invoker >::_M_invoke<0, 1> (this=0x55d2ed9104a8) at /usr/include/c++/12/bits/std_thread.h:252 #8 0x000055d2c9577d44 in std::thread::_Invoker >::operator() (this=0x55d2ed9104a8) at /usr/include/c++/12/bits/std_thread.h:259 #9 0x000055d2c9577d04 in std::thread::_State_impl > >::_M_run (this=0x55d2ed9104a0) at /usr/include/c++/12/bits/std_thread.h:210 #10 0x00007f5fb3ed44a3 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6 #11 0x00007f5fb3ca81c4 in start_thread (arg=) at ./nptl/pthread_create.c:442 #12 0x00007f5fb3d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Thread 3 (Thread 0x7f5fa14f36c0 (LWP 2628394) "mysqld"): #0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f5fa14f2c30, op=393, expected=0, futex_word=0x55d2cbeb8408 ) at ./nptl/futex-internal.c:57 #1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x55d2cbeb8408 , expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5fa14f2c30, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87 #2 0x00007f5fb3ca4f7b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x55d2cbeb8408 , expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5fa14f2c30, private=private@entry=0) at ./nptl/futex-internal.c:139 #3 0x00007f5fb3ca78bc in __pthread_cond_wait_common (abstime=0x7f5fa14f2c30, clockid=0, mutex=0x55d2cbeb8348 , cond=0x55d2cbeb83e0 ) at ./nptl/pthread_cond_wait.c:503 #4 ___pthread_cond_timedwait64 (cond=0x55d2cbeb83e0 , mutex=0x55d2cbeb8348 , abstime=0x7f5fa14f2c30) at ./nptl/pthread_cond_wait.c:643 #5 0x000055d2c96815fb in safe_cond_timedwait (cond=0x55d2cbeb83e0 , mp=0x55d2cbeb8320 , abstime=0x7f5fa14f2c30, file=0x55d2c9decd68 "/data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c", line=611) at /data/bld/bb-MDEV-24-monty-gcov/mysys/thr_mutex.c:543 #6 0x000055d2c9677a8c in psi_cond_timedwait (that=0x55d2cbeb83e0 , mutex=0x55d2cbeb8320 , abstime=0x7f5fa14f2c30, file=0x55d2c9b56da8 "/data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_servicethread.c", line=115) at /data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c:611 #7 0x000055d2c898ffa9 in inline_mysql_cond_timedwait (that=0x55d2cbeb83e0 , mutex=0x55d2cbeb8320 , abstime=0x7f5fa14f2c30, src_file=0x55d2c9b56da8 "/data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_servicethread.c", src_line=115) at /data/bld/bb-MDEV-24-monty-gcov/include/mysql/psi/mysql_thread.h:1086 #8 0x000055d2c8990917 in my_service_thread_sleep (control=0x55d2cab1c1e0 , sleep_time=1000000000) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_servicethread.c:115 #9 0x000055d2c897cf2a in ma_checkpoint_background (arg=0x1) at /data/bld/bb-MDEV-24-monty-gcov/storage/maria/ma_checkpoint.c:764 #10 0x000055d2c8aa4707 in pfs_spawn_thread (arg=0x55d2edd559d8) at /data/bld/bb-MDEV-24-monty-gcov/storage/perfschema/pfs.cc:2201 #11 0x00007f5fb3ca81c4 in start_thread (arg=) at ./nptl/pthread_create.c:442 #12 0x00007f5fb3d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Thread 2 (Thread 0x7f5fb487b6c0 (LWP 2628393) "mysqld"): #0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f5fb487acf0, op=393, expected=0, futex_word=0x55d2cc30d46c ) at ./nptl/futex-internal.c:57 #1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x55d2cc30d46c , expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5fb487acf0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87 #2 0x00007f5fb3ca4f7b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x55d2cc30d46c , expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5fb487acf0, private=private@entry=0) at ./nptl/futex-internal.c:139 #3 0x00007f5fb3ca78bc in __pthread_cond_wait_common (abstime=0x7f5fb487acf0, clockid=0, mutex=0x55d2cc30d3a8 , cond=0x55d2cc30d440 ) at ./nptl/pthread_cond_wait.c:503 #4 ___pthread_cond_timedwait64 (cond=0x55d2cc30d440 , mutex=0x55d2cc30d3a8 , abstime=0x7f5fb487acf0) at ./nptl/pthread_cond_wait.c:643 #5 0x000055d2c96815fb in safe_cond_timedwait (cond=0x55d2cc30d440 , mp=0x55d2cc30d380 , abstime=0x7f5fb487acf0, file=0x55d2c9decd68 "/data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c", line=611) at /data/bld/bb-MDEV-24-monty-gcov/mysys/thr_mutex.c:543 #6 0x000055d2c9677a8c in psi_cond_timedwait (that=0x55d2cc30d440 , mutex=0x55d2cc30d380 , abstime=0x7f5fb487acf0, file=0x55d2c9dee0c8 "/data/bld/bb-MDEV-24-monty-gcov/mysys/thr_timer.c", line=322) at /data/bld/bb-MDEV-24-monty-gcov/mysys/my_thr_init.c:611 #7 0x000055d2c968325d in inline_mysql_cond_timedwait (that=0x55d2cc30d440 , mutex=0x55d2cc30d380 , abstime=0x7f5fb487acf0, src_file=0x55d2c9dee0c8 "/data/bld/bb-MDEV-24-monty-gcov/mysys/thr_timer.c", src_line=322) at /data/bld/bb-MDEV-24-monty-gcov/include/mysql/psi/mysql_thread.h:1086 #8 0x000055d2c9684862 in timer_handler (arg=0x0) at /data/bld/bb-MDEV-24-monty-gcov/mysys/thr_timer.c:322 #9 0x000055d2c8aa4707 in pfs_spawn_thread (arg=0x55d2edaa7338) at /data/bld/bb-MDEV-24-monty-gcov/storage/perfschema/pfs.cc:2201 #10 0x00007f5fb3ca81c4 in start_thread (arg=) at ./nptl/pthread_create.c:442 #11 0x00007f5fb3d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Thread 1 (Thread 0x7f5fb46998c0 (LWP 2628392) "mysqld"): #0 0x00007f5fb3d1b1df in __GI___poll (fds=0x55d2ee31bf08, nfds=4, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 #1 0x000055d2c7a2f255 in handle_connections_sockets () at /data/bld/bb-MDEV-24-monty-gcov/sql/mysqld.cc:6364 #2 0x000055d2c7a2c168 in run_main_loop () at /data/bld/bb-MDEV-24-monty-gcov/sql/mysqld.cc:5647 #3 0x000055d2c7a2dabc in mysqld_main (argc=53, argv=0x55d2ed9120a8) at /data/bld/bb-MDEV-24-monty-gcov/sql/mysqld.cc:6069 #4 0x000055d2c7a1391b in main (argc=52, argv=0x7ffdde96d068) at /data/bld/bb-MDEV-24-monty-gcov/sql/main.cc:34 [Inferior 1 (process 2628392) detached]