[MDEV-24684] Aggregate functions min max over a partition have quadratic complexity - Jira

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.4.17, 10.5.8, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Fix Version/s: 10.5, 10.6
Component/s: Optimizer - Window functions
Labels:
None

Description

create or replace table t(id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,part bigint(20) NOT NULL,ts bigint(20) DEFAULT NULL, key idx(part) );

set @seq:=1; insert into t select null ,1 , @seq;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
insert into t select null ,1 , @seq:=@seq+1 from t;
select part , MAX(ts) OVER (PARTITION BY part) AS ts_max FROM t where part=1;

Attachments

Issue Links

relates to

MDEV-30474 Crash when after massively repeated C,U,D(especially INSERT with duplicated update) with ZERO SELECT

Closed

Activity

Ascending order - Click to sort in descending order

Alice Sherepa added a comment - 2021-01-26 09:49

I could not reproduce the hang with the test case above (checked on 10.5.8), could you please check it again (there was a typo in "inssert" and also ts column is NULL in the table). Maybe just add a dump of the table where you get a hang and your .cnf file, if that matters?

Alice Sherepa added a comment - 2021-01-26 09:49 I could not reproduce the hang with the test case above (checked on 10.5.8), could you please check it again (there was a typo in "inssert" and also ts column is NULL in the table). Maybe just add a dump of the table where you get a hang and your .cnf file, if that matters?

VAROQUI Stephane added a comment - 2021-01-26 10:13

ok i can reproduce on 10.5.8 and 10.5.7 it just need more rows
Query OK, 131072 rows affected (1.054 sec)
Records: 131072 Duplicates: 0 Warnings: 0

VAROQUI Stephane added a comment - 2021-01-26 10:13 ok i can reproduce on 10.5.8 and 10.5.7 it just need more rows Query OK, 131072 rows affected (1.054 sec) Records: 131072 Duplicates: 0 Warnings: 0

VAROQUI Stephane added a comment - 2021-01-26 10:22

fixing the test

VAROQUI Stephane added a comment - 2021-01-26 10:22 fixing the test

VAROQUI Stephane added a comment - 2021-01-26 11:30

using a window of 32K records the number of record read is power of 2 of the window size

Handler_read_rnd	1073905663
Handler_read_rnd_next	65538
Handler_tmp_write	32768
Handler_update	32768

Well the result will be the same for all records of the window after first window record scan so a cache strategy may cover this case

if adding a covering index
alter table t add index idx2(part,ts);
We should now get a valid index to scan both partition and max ts per record window but the plan does not change using the index but | Handler_read_rnd | 1073905663 |
A asc scan into index first record should be the max

VAROQUI Stephane added a comment - 2021-01-26 11:30 using a window of 32K records the number of record read is power of 2 of the window size Handler_read_rnd 1073905663 Handler_read_rnd_next 65538 Handler_tmp_write 32768 Handler_update 32768 Well the result will be the same for all records of the window after first window record scan so a cache strategy may cover this case if adding a covering index alter table t add index idx2(part,ts); We should now get a valid index to scan both partition and max ts per record window but the plan does not change using the index but | Handler_read_rnd | 1073905663 | A asc scan into index first record should be the max

Alice Sherepa added a comment - 2021-01-26 11:54 - edited

Thanks!
I repeated on 10.2-10.5, gdb backtrace of mysqld:

10.2 c89f37983ec82e5c6140

#0 0x000056233550bd57 in Frame_cursor::add_value_to_items (this=0x7f261c017820) at /10.2/src/sql/sql_window.cc:987
#1 0x000056233550ddea in Frame_scan_cursor::compute_values_for_current_row (this=0x7f261c017820) at /10.2/src/sql/sql_window.cc:2058
#2 0x000056233550dc98 in Frame_scan_cursor::next_row (this=0x7f261c017820) at /10.2/src/sql/sql_window.cc:2026
#3 0x000056233550c04d in Cursor_manager::notify_cursors_next_row (this=0x7f261c17d3f0) at /10.2/src/sql/sql_window.cc:1064
#4 0x0000562335509f1a in compute_window_func (thd=0x7f261c000d90, window_functions=..., cursor_managers=..., tbl=0x7f261c09f798, filesort_result=0x7f261c1931e0) at /10.2/src/sql/sql_window.cc:2670
#5 0x000056233550a344 in Window_func_runner::exec (this=0x7f261c016e28, thd=0x7f261c000d90, tbl=0x7f261c09f798, filesort_result=0x7f261c1931e0) at /10.2/src/sql/sql_window.cc:2782
#6 0x000056233550a46a in Window_funcs_sort::exec (this=0x7f261c016e20, join=0x7f261c0138a0, keep_filesort_result=true) at /10.2/src/sql/sql_window.cc:2810
#7 0x000056233550a964 in Window_funcs_computation::exec (this=0x7f261c016e00, join=0x7f261c0138a0, keep_last_filesort_result=true) at /10.2/src/sql/sql_window.cc:2937
#8 0x00005623353bc49e in AGGR_OP::end_send (this=0x7f261c016bc0) at /10.2/src/sql/sql_select.cc:26849
#9 0x00005623353a6ef3 in sub_select_postjoin_aggr (join=0x7f261c0138a0, join_tab=0x7f261c015d20, end_of_records=true) at /10.2/src/sql/sql_select.cc:18573
#10 0x00005623353a7227 in sub_select (join=0x7f261c0138a0, join_tab=0x7f261c015970, end_of_records=true) at /10.2/src/sql/sql_select.cc:18809
#11 0x00005623353a6a0b in do_select (join=0x7f261c0138a0, procedure=0x0) at /10.2/src/sql/sql_select.cc:18404
#12 0x0000562335380629 in JOIN::exec_inner (this=0x7f261c0138a0) at /10.2/src/sql/sql_select.cc:3641
#13 0x000056233537fad0 in JOIN::exec (this=0x7f261c0138a0) at /10.2/src/sql/sql_select.cc:3436
#14 0x0000562335380c92 in mysql_select (thd=0x7f261c000d90, tables=0x7f261c012e80, wild_num=0, fields=..., conds=0x7f261c013650, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f261c013880, unit=0x7f261c004988, select_lex=0x7f261c0050c8) at /10.2/src/sql/sql_select.cc:3836
#15 0x0000562335374e0c in handle_select (thd=0x7f261c000d90, lex=0x7f261c0048c8, result=0x7f261c013880, setup_tables_done_option=0) at /10.2/src/sql/sql_select.cc:361
#16 0x000056233533f6bc in execute_sqlcom_select (thd=0x7f261c000d90, all_tables=0x7f261c012e80) at /10.2/src/sql/sql_parse.cc:6248
#17 0x000056233533606b in mysql_execute_command (thd=0x7f261c000d90) at /10.2/src/sql/sql_parse.cc:3559
#18 0x0000562335343465 in mysql_parse (thd=0x7f261c000d90, rawbuf=0x7f261c0126f8 "select part , MAX(ts) OVER (PARTITION BY part) AS ts_max FROM t where part=1", length=78, parser_state=0x7f266ad24570, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:7763
#19 0x000056233533173e in dispatch_command (command=COM_QUERY, thd=0x7f261c000d90, packet=0x7f261c008b51 "", packet_length=78, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:1827
#20 0x0000562335330239 in do_command (thd=0x7f261c000d90) at /10.2/src/sql/sql_parse.cc:1381
#21 0x000056233548a95a in do_handle_one_connection (connect=0x562337b03860) at /10.2/src/sql/sql_connect.cc:1336
#22 0x000056233548a6bf in handle_one_connection (arg=0x562337b03860) at /10.2/src/sql/sql_connect.cc:1241
#23 0x0000562335cb3098 in pfs_spawn_thread (arg=0x562337aedc40) at /10.2/src/storage/perfschema/pfs.cc:1869
#24 0x00007f2670f29609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#25 0x00007f2670b03293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

10.5.8
Thread 12 (Thread 0x7f9215ffd700 (LWP 61706)):
#0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f9215ffcd80, clockid=<optimized out>, expected=0, futex_word=0x564111b0e89c) at ../sysdeps/nptl/futex-internal.h:320
#1 __pthread_cond_wait_common (abstime=0x7f9215ffcd80, clockid=<optimized out>, mutex=0x564111afeef0, cond=0x564111b0e870) at pthread_cond_wait.c:520
#2 __pthread_cond_timedwait (cond=0x564111b0e870, mutex=0x564111afeef0, abstime=0x7f9215ffcd80) at pthread_cond_wait.c:656
#3 0x000056410f06a1d9 in __gthread_cond_timedwait (__abs_timeout=0x7f9215ffcd80, __mutex=<optimized out>, __cond=0x564111b0e870) at /usr/local/include/c++/4.8.5/x86_64-unknown-linux-gnu/bits/gthr-default.h:871
#4 std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__atime=..., __lock=..., this=0x564111b0e870) at /usr/local/include/c++/4.8.5/condition_variable:160
#5 std::condition_variable::wait_until<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__atime=..., __lock=..., this=0x564111b0e870) at /usr/local/include/c++/4.8.5/condition_variable:100
#6 std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (__rtime=..., __lock=..., this=0x564111b0e870) at /usr/local/include/c++/4.8.5/condition_variable:132
#7 tpool::thread_pool_generic::wait_for_tasks (this=this@entry=0x564111afede0, lk=..., thread_data=thread_data@entry=0x564111b0e870) at /home/buildbot/buildbot/build/tpool/tpool_generic.cc:418
#8 0x000056410f06a93d in tpool::thread_pool_generic::get_task (this=this@entry=0x564111afede0, thread_var=thread_var@entry=0x564111b0e870, t=t@entry=0x7f9215ffce20) at /home/buildbot/buildbot/build/tpool/tpool_generic.cc:471
#9 0x000056410f06bcae in tpool::thread_pool_generic::worker_main (this=0x564111afede0, thread_var=0x564111b0e870) at /home/buildbot/buildbot/build/tpool/tpool_generic.cc:516
#10 0x000056410f23c4a0 in std::(anonymous namespace)::execute_native_thread_routine (__p=<optimized out>) at ../../../.././libstdc++-v3/src/c++11/thread.cc:84
#11 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#12 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 11 (Thread 0x7f92157fc700 (LWP 54622)):
#0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f92157fbd80, clockid=<optimized out>, expected=0, futex_word=0x564111b0e69c) at ../sysdeps/nptl/futex-internal.h:320
#1 __pthread_cond_wait_common (abstime=0x7f92157fbd80, clockid=<optimized out>, mutex=0x564111afeef0, cond=0x564111b0e670) at pthread_cond_wait.c:520
#2 __pthread_cond_timedwait (cond=0x564111b0e670, mutex=0x564111afeef0, abstime=0x7f92157fbd80) at pthread_cond_wait.c:656
#3 0x000056410f06a1d9 in __gthread_cond_timedwait (__abs_timeout=0x7f92157fbd80, __mutex=<optimized out>, __cond=0x564111b0e670) at /usr/local/include/c++/4.8.5/x86_64-unknown-linux-gnu/bits/gthr-default.h:871
#4 std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__atime=..., __lock=..., this=0x564111b0e670) at /usr/local/include/c++/4.8.5/condition_variable:160
#5 std::condition_variable::wait_until<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__atime=..., __lock=..., this=0x564111b0e670) at /usr/local/include/c++/4.8.5/condition_variable:100
#6 std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (__rtime=..., __lock=..., this=0x564111b0e670) at /usr/local/include/c++/4.8.5/condition_variable:132
#7 tpool::thread_pool_generic::wait_for_tasks (this=this@entry=0x564111afede0, lk=..., thread_data=thread_data@entry=0x564111b0e670) at /home/buildbot/buildbot/build/tpool/tpool_generic.cc:418
#8 0x000056410f06a93d in tpool::thread_pool_generic::get_task (this=this@entry=0x564111afede0, thread_var=thread_var@entry=0x564111b0e670, t=t@entry=0x7f92157fbe20) at /home/buildbot/buildbot/build/tpool/tpool_generic.cc:471
#9 0x000056410f06bcae in tpool::thread_pool_generic::worker_main (this=0x564111afede0, thread_var=0x564111b0e670) at /home/buildbot/buildbot/build/tpool/tpool_generic.cc:516
#10 0x000056410f23c4a0 in std::(anonymous namespace)::execute_native_thread_routine (__p=<optimized out>) at ../../../.././libstdc++-v3/src/c++11/thread.cc:84
#11 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#12 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 10 (Thread 0x7f92382ed700 (LWP 53650)):
#0 0x000056410edc997f in heap_rrnd (info=0x7f91c401dd48, record=0x7f91c401aa88 "\375\001", pos=0x7f91c41a4f88 "\375\001") at /home/buildbot/buildbot/build/storage/heap/hp_rrnd.c:40
#1 0x000056410ead0662 in handler::ha_rnd_pos (this=0x7f91c401ac00, buf=0x7f91c401aa88 "\375\001", pos=0x7f91c4018448 "\210O\032đ\177") at /home/buildbot/buildbot/build/sql/handler.cc:3098
#2 0x000056410ea37560 in Frame_scan_cursor::compute_values_for_current_row (this=0x7f91c4015580) at /home/buildbot/buildbot/build/sql/sql_window.cc:2209
#3 Frame_scan_cursor::next_row (this=0x7f91c4015580) at /home/buildbot/buildbot/build/sql/sql_window.cc:2179
#4 0x000056410ea3245e in Cursor_manager::notify_cursors_next_row (this=0x7f91c40260f0) at /home/buildbot/buildbot/build/sql/sql_window.cc:1179
#5 compute_window_func (thd=thd@entry=0x7f91c4000c58, window_functions=..., cursor_managers=..., tbl=tbl@entry=0x7f91c4019ba0, filesort_result=filesort_result@entry=0x7f91c4010100) at /home/buildbot/buildbot/build/sql/sql_window.cc:2849
#6 0x000056410ea34759 in Window_func_runner::exec (this=this@entry=0x7f91c4014b30, thd=thd@entry=0x7f91c4000c58, tbl=0x7f91c4019ba0, filesort_result=0x7f91c4010100) at /home/buildbot/buildbot/build/sql/sql_window.cc:2979
#7 0x000056410ea3488e in Window_funcs_sort::exec (this=0x7f91c4014b28, join=join@entry=0x7f91c4012168, keep_filesort_result=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_window.cc:3004
#8 0x000056410ea3493d in Window_funcs_computation::exec (this=0x7f91c4014b08, join=join@entry=0x7f91c4012168, keep_last_filesort_result=keep_last_filesort_result@entry=true) at /home/buildbot/buildbot/build/sql/sql_window.cc:3131
#9 0x000056410e90a33c in AGGR_OP::end_send (this=0x7f91c4014848) at /home/buildbot/buildbot/build/sql/sql_select.cc:28894
#10 0x000056410e90a511 in sub_select_postjoin_aggr (join=0x7f91c4012168, join_tab=0x7f91c4013c30, end_of_records=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_select.cc:20329
#11 0x000056410e9260ea in do_select (procedure=<optimized out>, join=0x7f91c4012168) at /home/buildbot/buildbot/build/sql/sql_select.cc:20155
#12 JOIN::exec_inner (this=this@entry=0x7f91c4012168) at /home/buildbot/buildbot/build/sql/sql_select.cc:4459
#13 0x000056410e926453 in JOIN::exec (this=this@entry=0x7f91c4012168) at /home/buildbot/buildbot/build/sql/sql_select.cc:4240
#14 0x000056410e92463e in mysql_select (thd=thd@entry=0x7f91c4000c58, tables=0x7f91c4011170, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=result@entry=0x7f91c4012140, unit=unit@entry=0x7f91c4004c38, select_lex=select_lex@entry=0x7f91c4010708) at /home/buildbot/buildbot/build/sql/sql_select.cc:4655
#15 0x000056410e92517a in handle_select (thd=thd@entry=0x7f91c4000c58, lex=lex@entry=0x7f91c4004b70, result=result@entry=0x7f91c4012140, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/buildbot/buildbot/build/sql/sql_select.cc:429
#16 0x000056410e78ab23 in execute_sqlcom_select (thd=thd@entry=0x7f91c4000c58, all_tables=0x7f91c4011170) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6266
#17 0x000056410e8caa84 in mysql_execute_command (thd=thd@entry=0x7f91c4000c58) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3968
#18 0x000056410e8cd5fc in mysql_parse (thd=thd@entry=0x7f91c4000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f92382ec420, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:8044
#19 0x000056410e8cf6ba in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f91c4000c58, packet=packet@entry=0x7f91c4007ff9 "", packet_length=packet_length@entry=56, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1873
#20 0x000056410e8d0b2b in do_command (thd=0x7f91c4000c58) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1354
#21 0x000056410e9bb402 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x564112163828, put_in_cache=put_in_cache@entry=true) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1410
#22 0x000056410e9bb6c4 in handle_one_connection (arg=arg@entry=0x564112163828) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1312
#23 0x000056410ed3ef5d in pfs_spawn_thread (arg=0x564111fe9698) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:2201
#24 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#25 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 9 (Thread 0x7f9238338700 (LWP 53600)):
#0 0x000056410eadf8e3 in Item_ref::val_int (this=0x7f91d0012a28) at /home/buildbot/buildbot/build/sql/item.cc:8297
#1 0x000056410eae027a in Item_cache_int::cache_value (this=0x7f91d0012c18) at /home/buildbot/buildbot/build/sql/item.cc:9838
#2 0x000056410eb91b37 in Item_sum_max::add (this=0x7f91d0010e18) at /home/buildbot/buildbot/build/sql/item_sum.cc:2552
#3 0x000056410ea37589 in Frame_cursor::add_value_to_items (this=0x7f91d0015758) at /home/buildbot/buildbot/build/sql/sql_window.cc:1104
#4 Frame_scan_cursor::compute_values_for_current_row (this=0x7f91d0015758) at /home/buildbot/buildbot/build/sql/sql_window.cc:2211
#5 Frame_scan_cursor::next_row (this=0x7f91d0015758) at /home/buildbot/buildbot/build/sql/sql_window.cc:2179
#6 0x000056410ea3245e in Cursor_manager::notify_cursors_next_row (this=0x7f91d00260f0) at /home/buildbot/buildbot/build/sql/sql_window.cc:1179
#7 compute_window_func (thd=thd@entry=0x7f91d0000c58, window_functions=..., cursor_managers=..., tbl=tbl@entry=0x7f91d00188b0, filesort_result=filesort_result@entry=0x7f91d0010100) at /home/buildbot/buildbot/build/sql/sql_window.cc:2849
#8 0x000056410ea34759 in Window_func_runner::exec (this=this@entry=0x7f91d0014d08, thd=thd@entry=0x7f91d0000c58, tbl=0x7f91d00188b0, filesort_result=0x7f91d0010100) at /home/buildbot/buildbot/build/sql/sql_window.cc:2979
#9 0x000056410ea3488e in Window_funcs_sort::exec (this=0x7f91d0014d00, join=join@entry=0x7f91d00122c8, keep_filesort_result=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_window.cc:3004
#10 0x000056410ea3493d in Window_funcs_computation::exec (this=0x7f91d0014ce0, join=join@entry=0x7f91d00122c8, keep_last_filesort_result=keep_last_filesort_result@entry=true) at /home/buildbot/buildbot/build/sql/sql_window.cc:3131
#11 0x000056410e90a33c in AGGR_OP::end_send (this=0x7f91d0014a20) at /home/buildbot/buildbot/build/sql/sql_select.cc:28894
#12 0x000056410e90a511 in sub_select_postjoin_aggr (join=0x7f91d00122c8, join_tab=0x7f91d0013e08, end_of_records=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_select.cc:20329
#13 0x000056410e9260ea in do_select (procedure=<optimized out>, join=0x7f91d00122c8) at /home/buildbot/buildbot/build/sql/sql_select.cc:20155
#14 JOIN::exec_inner (this=this@entry=0x7f91d00122c8) at /home/buildbot/buildbot/build/sql/sql_select.cc:4459
#15 0x000056410e926453 in JOIN::exec (this=this@entry=0x7f91d00122c8) at /home/buildbot/buildbot/build/sql/sql_select.cc:4240
#16 0x000056410e92463e in mysql_select (thd=thd@entry=0x7f91d0000c58, tables=0x7f91d00112d0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=result@entry=0x7f91d00122a0, unit=unit@entry=0x7f91d0004c38, select_lex=select_lex@entry=0x7f91d0010710) at /home/buildbot/buildbot/build/sql/sql_select.cc:4655
#17 0x000056410e92517a in handle_select (thd=thd@entry=0x7f91d0000c58, lex=lex@entry=0x7f91d0004b70, result=result@entry=0x7f91d00122a0, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/buildbot/buildbot/build/sql/sql_select.cc:429
#18 0x000056410e78ab23 in execute_sqlcom_select (thd=thd@entry=0x7f91d0000c58, all_tables=0x7f91d00112d0) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6266
#19 0x000056410e8caa84 in mysql_execute_command (thd=thd@entry=0x7f91d0000c58) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3968
#20 0x000056410e8cd5fc in mysql_parse (thd=thd@entry=0x7f91d0000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f9238337420, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:8044
#21 0x000056410e8cf6ba in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f91d0000c58, packet=packet@entry=0x7f91d0007ff9 "", packet_length=packet_length@entry=63, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1873
#22 0x000056410e8d0b2b in do_command (thd=0x7f91d0000c58) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1354
#23 0x000056410e9bb402 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56411218f208, put_in_cache=put_in_cache@entry=true) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1410
#24 0x000056410e9bb6c4 in handle_one_connection (arg=arg@entry=0x56411218f208) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1312
#25 0x000056410ed3ef5d in pfs_spawn_thread (arg=0x564111fe87a8) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:2201
#26 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#27 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 8 (Thread 0x7f9238401700 (LWP 53523)):
#0 Rowid_seq_cursor::at_eof (this=0x7f920c02bac8) at /home/buildbot/buildbot/build/sql/sql_window.cc:852
#1 Table_read_cursor::fetch (this=0x7f920c02bac8) at /home/buildbot/buildbot/build/sql/sql_window.cc:906
#2 0x000056410ea37560 in Frame_scan_cursor::compute_values_for_current_row (this=0x7f920c02ba90) at /home/buildbot/buildbot/build/sql/sql_window.cc:2209
#3 Frame_scan_cursor::next_row (this=0x7f920c02ba90) at /home/buildbot/buildbot/build/sql/sql_window.cc:2179
#4 0x000056410ea3245e in Cursor_manager::notify_cursors_next_row (this=0x564111fe7760) at /home/buildbot/buildbot/build/sql/sql_window.cc:1179
#5 compute_window_func (thd=thd@entry=0x7f920c00fcc8, window_functions=..., cursor_managers=..., tbl=tbl@entry=0x7f920c0279f0, filesort_result=filesort_result@entry=0x7f920c008860) at /home/buildbot/buildbot/build/sql/sql_window.cc:2849
#6 0x000056410ea34759 in Window_func_runner::exec (this=this@entry=0x7f920c023b88, thd=thd@entry=0x7f920c00fcc8, tbl=0x7f920c0279f0, filesort_result=0x7f920c008860) at /home/buildbot/buildbot/build/sql/sql_window.cc:2979
#7 0x000056410ea3488e in Window_funcs_sort::exec (this=0x7f920c023b80, join=join@entry=0x7f920c0203c8, keep_filesort_result=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_window.cc:3004
#8 0x000056410ea3493d in Window_funcs_computation::exec (this=0x7f920c023b60, join=join@entry=0x7f920c0203c8, keep_last_filesort_result=keep_last_filesort_result@entry=true) at /home/buildbot/buildbot/build/sql/sql_window.cc:3131
#9 0x000056410e90a33c in AGGR_OP::end_send (this=0x7f920c0238a0) at /home/buildbot/buildbot/build/sql/sql_select.cc:28894
#10 0x000056410e90a511 in sub_select_postjoin_aggr (join=0x7f920c0203c8, join_tab=0x7f920c022a30, end_of_records=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_select.cc:20329
#11 0x000056410e9260ea in do_select (procedure=<optimized out>, join=0x7f920c0203c8) at /home/buildbot/buildbot/build/sql/sql_select.cc:20155
#12 JOIN::exec_inner (this=this@entry=0x7f920c0203c8) at /home/buildbot/buildbot/build/sql/sql_select.cc:4459
#13 0x000056410e926453 in JOIN::exec (this=this@entry=0x7f920c0203c8) at /home/buildbot/buildbot/build/sql/sql_select.cc:4240
#14 0x000056410e92463e in mysql_select (thd=thd@entry=0x7f920c00fcc8, tables=0x7f920c01efa0, fields=..., conds=0x7f920c01f870, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=result@entry=0x7f920c0203a0, unit=unit@entry=0x7f920c013ca8, select_lex=select_lex@entry=0x7f920c01e3e0) at /home/buildbot/buildbot/build/sql/sql_select.cc:4655
#15 0x000056410e92517a in handle_select (thd=thd@entry=0x7f920c00fcc8, lex=lex@entry=0x7f920c013be0, result=result@entry=0x7f920c0203a0, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/buildbot/buildbot/build/sql/sql_select.cc:429
#16 0x000056410e78ab23 in execute_sqlcom_select (thd=thd@entry=0x7f920c00fcc8, all_tables=0x7f920c01efa0) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6266
#17 0x000056410e8caa84 in mysql_execute_command (thd=thd@entry=0x7f920c00fcc8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3968
#18 0x000056410e8cd5fc in mysql_parse (thd=thd@entry=0x7f920c00fcc8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f9238400420, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:8044
#19 0x000056410e8cf6ba in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f920c00fcc8, packet=packet@entry=0x7f920c016269 "", packet_length=packet_length@entry=76, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1873
#20 0x000056410e8d0b2b in do_command (thd=0x7f920c00fcc8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1354
#21 0x000056410e9bb402 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56411215f308, put_in_cache=put_in_cache@entry=true) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1410
#22 0x000056410e9bb6c4 in handle_one_connection (arg=arg@entry=0x56411215f308) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1312
#23 0x000056410ed3ef5d in pfs_spawn_thread (arg=0x5641121193d8) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:2201
#24 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#25 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 7 (Thread 0x7f923844c700 (LWP 19836)):
#0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x56410faba02c <COND_slave_background+44>) at ../sysdeps/nptl/futex-internal.h:183
#1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x56410fab7300 <LOCK_slave_background>, cond=0x56410faba000 <COND_slave_background>) at pthread_cond_wait.c:508
#2 __pthread_cond_wait (cond=0x56410faba000 <COND_slave_background>, mutex=0x56410fab7300 <LOCK_slave_background>) at pthread_cond_wait.c:638
#3 0x000056410e814d77 in inline_mysql_cond_wait (that=<optimized out>, mutex=<optimized out>, src_file=0x56410f273ff8 "/home/buildbot/buildbot/build/sql/slave.cc", src_line=525) at /home/buildbot/buildbot/build/include/mysql/psi/mysql_thread.h:1233
#4 handle_slave_background (arg=arg@entry=0x0) at /home/buildbot/buildbot/build/sql/slave.cc:525
#5 0x000056410ed3ef5d in pfs_spawn_thread (arg=0x564112188748) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:2201
#6 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#7 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 6 (Thread 0x7f9238497700 (LWP 19835)):
#0 0x00007f923b9fe322 in __GI___sigtimedwait (set=0x7f9238496cf0, info=0x7f9238496d70, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:29
#1 0x000056410e7f6aeb in my_sigwait (code=<synthetic pointer>, sig=0x7f9238496ce0, set=0x7f9238496cf0) at /home/buildbot/buildbot/build/include/my_pthread.h:196
#2 signal_hand (arg=arg@entry=0x0) at /home/buildbot/buildbot/build/sql/mysqld.cc:2988
#3 0x000056410ed3ef5d in pfs_spawn_thread (arg=0x564111a48b88) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:2201
#4 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#5 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 5 (Thread 0x7f9224d1a700 (LWP 19824)):
#0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f9224d19ce0, clockid=<optimized out>, expected=0, futex_word=0x56410fa392c0 <buf_pool+800>) at ../sysdeps/nptl/futex-internal.h:320
#1 __pthread_cond_wait_common (abstime=0x7f9224d19ce0, clockid=<optimized out>, mutex=0x56410fa39238 <buf_pool+664>, cond=0x56410fa39298 <buf_pool+760>) at pthread_cond_wait.c:520
#2 __pthread_cond_timedwait (cond=0x56410fa39298 <buf_pool+760>, mutex=0x56410fa39238 <buf_pool+664>, abstime=0x7f9224d19ce0) at pthread_cond_wait.c:656
#3 0x000056410ef8c6d8 in inline_mysql_cond_timedwait (that=that@entry=0x56410fa39298 <buf_pool+760>, mutex=mutex@entry=0x56410fa39238 <buf_pool+664>, abstime=abstime@entry=0x7f9224d19ce0, src_line=src_line@entry=2067, src_file=0x56410f443a38 "/home/buildbot/buildbot/build/storage/innobase/buf/buf0flu.cc") at /home/buildbot/buildbot/build/include/mysql/psi/mysql_thread.h:1270
#4 0x000056410ef902a4 in buf_flush_page_cleaner () at /home/buildbot/buildbot/build/storage/innobase/buf/buf0flu.cc:2067
#5 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#6 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 4 (Thread 0x7f9238c98700 (LWP 19823)):
#0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38
#1 0x00007f923bee227b in ?? () from /usr/lib/x86_64-linux-gnu/libaio.so.1
#2 0x000056410f06e2f9 in tpool::aio_linux::getevent_thread_routine (aio=0x564111b67280) at /home/buildbot/buildbot/build/tpool/aio_linux.cc:53
#3 0x000056410f23c4a0 in std::(anonymous namespace)::execute_native_thread_routine (__p=<optimized out>) at ../../../.././libstdc++-v3/src/c++11/thread.cc:84
#4 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#5 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 3 (Thread 0x7f923989a700 (LWP 19822)):
#0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f9239899d70, clockid=<optimized out>, expected=0, futex_word=0x5641102f8be8 <COND_checkpoint+40>) at ../sysdeps/nptl/futex-internal.h:320
#1 __pthread_cond_wait_common (abstime=0x7f9239899d70, clockid=<optimized out>, mutex=0x5641102f8c00 <LOCK_checkpoint>, cond=0x5641102f8bc0 <COND_checkpoint>) at pthread_cond_wait.c:520
#2 __pthread_cond_timedwait (cond=cond@entry=0x5641102f8bc0 <COND_checkpoint>, mutex=mutex@entry=0x5641102f8c00 <LOCK_checkpoint>, abstime=abstime@entry=0x7f9239899d70) at pthread_cond_wait.c:656
#3 0x000056410ecd01d6 in inline_mysql_cond_timedwait (src_file=0x56410f3e99e0 "/home/buildbot/buildbot/build/storage/maria/ma_servicethread.c", src_line=116, abstime=0x7f9239899d70, mutex=0x5641102f8c00 <LOCK_checkpoint>, that=0x5641102f8bc0 <COND_checkpoint>) at /home/buildbot/buildbot/build/include/mysql/psi/mysql_thread.h:1270
#4 my_service_thread_sleep (control=control@entry=0x56410fa2b6c0 <checkpoint_control>, sleep_time=<optimized out>) at /home/buildbot/buildbot/build/storage/maria/ma_servicethread.c:115
#5 0x000056410ecc78fe in ma_checkpoint_background (arg=0x1e) at /home/buildbot/buildbot/build/storage/maria/ma_checkpoint.c:707
#6 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#7 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 2 (Thread 0x7f923bf82700 (LWP 19821)):
#0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f923bf81df0, clockid=<optimized out>, expected=0, futex_word=0x5641103a71ac <COND_timer+44>) at ../sysdeps/nptl/futex-internal.h:320
#1 __pthread_cond_wait_common (abstime=0x7f923bf81df0, clockid=<optimized out>, mutex=0x5641103a71c0 <LOCK_timer>, cond=0x5641103a7180 <COND_timer>) at pthread_cond_wait.c:520
#2 __pthread_cond_timedwait (cond=cond@entry=0x5641103a7180 <COND_timer>, mutex=mutex@entry=0x5641103a71c0 <LOCK_timer>, abstime=abstime@entry=0x7f923bf81df0) at pthread_cond_wait.c:656
#3 0x000056410f0e7ce6 in inline_mysql_cond_timedwait (that=0x5641103a7180 <COND_timer>, mutex=0x5641103a71c0 <LOCK_timer>, src_file=0x56410f458778 "/home/buildbot/buildbot/build/mysys/thr_timer.c", src_line=321, abstime=0x7f923bf81df0) at /home/buildbot/buildbot/build/include/mysql/psi/mysql_thread.h:1270
#4 timer_handler (arg=<optimized out>) at /home/buildbot/buildbot/build/mysys/thr_timer.c:321
#5 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#6 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 1 (Thread 0x7f923b9977c0 (LWP 19817)):
#0 0x00007f923baccaff in __GI___poll (fds=0x7ffeab2c5a20, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29
#1 0x000056410e7ff1c2 in handle_connections_sockets () at /home/buildbot/buildbot/build/sql/mysqld.cc:6219
#2 0x000056410e8003c0 in mysqld_main (argc=16, argv=0x564111a07780) at /home/buildbot/buildbot/build/sql/mysqld.cc:5668
#3 0x00007f923b9de0b3 in __libc_start_main (main=0x56410e7ac9c0 <main(int, char**)>, argc=3, argv=0x7ffeab2c5e98, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>, stack_end=0x7ffeab2c5e88) at ../csu/libc-start.c:308
#4 0x000056410e7f4841 in _start ()
[Inferior 1 (process 19817) detached]

Alice Sherepa added a comment - 2021-01-26 11:54 - edited Thanks! I repeated on 10.2-10.5, gdb backtrace of mysqld: 10.2 c89f37983ec82e5c6140 #0 0x000056233550bd57 in Frame_cursor::add_value_to_items (this=0x7f261c017820) at /10.2/src/sql/sql_window.cc:987 #1 0x000056233550ddea in Frame_scan_cursor::compute_values_for_current_row (this=0x7f261c017820) at /10.2/src/sql/sql_window.cc:2058 #2 0x000056233550dc98 in Frame_scan_cursor::next_row (this=0x7f261c017820) at /10.2/src/sql/sql_window.cc:2026 #3 0x000056233550c04d in Cursor_manager::notify_cursors_next_row (this=0x7f261c17d3f0) at /10.2/src/sql/sql_window.cc:1064 #4 0x0000562335509f1a in compute_window_func (thd=0x7f261c000d90, window_functions=..., cursor_managers=..., tbl=0x7f261c09f798, filesort_result=0x7f261c1931e0) at /10.2/src/sql/sql_window.cc:2670 #5 0x000056233550a344 in Window_func_runner::exec (this=0x7f261c016e28, thd=0x7f261c000d90, tbl=0x7f261c09f798, filesort_result=0x7f261c1931e0) at /10.2/src/sql/sql_window.cc:2782 #6 0x000056233550a46a in Window_funcs_sort::exec (this=0x7f261c016e20, join=0x7f261c0138a0, keep_filesort_result=true) at /10.2/src/sql/sql_window.cc:2810 #7 0x000056233550a964 in Window_funcs_computation::exec (this=0x7f261c016e00, join=0x7f261c0138a0, keep_last_filesort_result=true) at /10.2/src/sql/sql_window.cc:2937 #8 0x00005623353bc49e in AGGR_OP::end_send (this=0x7f261c016bc0) at /10.2/src/sql/sql_select.cc:26849 #9 0x00005623353a6ef3 in sub_select_postjoin_aggr (join=0x7f261c0138a0, join_tab=0x7f261c015d20, end_of_records=true) at /10.2/src/sql/sql_select.cc:18573 #10 0x00005623353a7227 in sub_select (join=0x7f261c0138a0, join_tab=0x7f261c015970, end_of_records=true) at /10.2/src/sql/sql_select.cc:18809 #11 0x00005623353a6a0b in do_select (join=0x7f261c0138a0, procedure=0x0) at /10.2/src/sql/sql_select.cc:18404 #12 0x0000562335380629 in JOIN::exec_inner (this=0x7f261c0138a0) at /10.2/src/sql/sql_select.cc:3641 #13 0x000056233537fad0 in JOIN::exec (this=0x7f261c0138a0) at /10.2/src/sql/sql_select.cc:3436 #14 0x0000562335380c92 in mysql_select (thd=0x7f261c000d90, tables=0x7f261c012e80, wild_num=0, fields=..., conds=0x7f261c013650, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f261c013880, unit=0x7f261c004988, select_lex=0x7f261c0050c8) at /10.2/src/sql/sql_select.cc:3836 #15 0x0000562335374e0c in handle_select (thd=0x7f261c000d90, lex=0x7f261c0048c8, result=0x7f261c013880, setup_tables_done_option=0) at /10.2/src/sql/sql_select.cc:361 #16 0x000056233533f6bc in execute_sqlcom_select (thd=0x7f261c000d90, all_tables=0x7f261c012e80) at /10.2/src/sql/sql_parse.cc:6248 #17 0x000056233533606b in mysql_execute_command (thd=0x7f261c000d90) at /10.2/src/sql/sql_parse.cc:3559 #18 0x0000562335343465 in mysql_parse (thd=0x7f261c000d90, rawbuf=0x7f261c0126f8 "select part , MAX(ts) OVER (PARTITION BY part) AS ts_max FROM t where part=1", length=78, parser_state=0x7f266ad24570, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:7763 #19 0x000056233533173e in dispatch_command (command=COM_QUERY, thd=0x7f261c000d90, packet=0x7f261c008b51 "", packet_length=78, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:1827 #20 0x0000562335330239 in do_command (thd=0x7f261c000d90) at /10.2/src/sql/sql_parse.cc:1381 #21 0x000056233548a95a in do_handle_one_connection (connect=0x562337b03860) at /10.2/src/sql/sql_connect.cc:1336 #22 0x000056233548a6bf in handle_one_connection (arg=0x562337b03860) at /10.2/src/sql/sql_connect.cc:1241 #23 0x0000562335cb3098 in pfs_spawn_thread (arg=0x562337aedc40) at /10.2/src/storage/perfschema/pfs.cc:1869 #24 0x00007f2670f29609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #25 0x00007f2670b03293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 10.5.8 Thread 12 (Thread 0x7f9215ffd700 (LWP 61706)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f9215ffcd80, clockid=<optimized out>, expected=0, futex_word=0x564111b0e89c) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7f9215ffcd80, clockid=<optimized out>, mutex=0x564111afeef0, cond=0x564111b0e870) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=0x564111b0e870, mutex=0x564111afeef0, abstime=0x7f9215ffcd80) at pthread_cond_wait.c:656 #3 0x000056410f06a1d9 in __gthread_cond_timedwait (__abs_timeout=0x7f9215ffcd80, __mutex=<optimized out>, __cond=0x564111b0e870) at /usr/local/include/c++/4.8.5/x86_64-unknown-linux-gnu/bits/gthr-default.h:871 #4 std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__atime=..., __lock=..., this=0x564111b0e870) at /usr/local/include/c++/4.8.5/condition_variable:160 #5 std::condition_variable::wait_until<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__atime=..., __lock=..., this=0x564111b0e870) at /usr/local/include/c++/4.8.5/condition_variable:100 #6 std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (__rtime=..., __lock=..., this=0x564111b0e870) at /usr/local/include/c++/4.8.5/condition_variable:132 #7 tpool::thread_pool_generic::wait_for_tasks (this=this@entry=0x564111afede0, lk=..., thread_data=thread_data@entry=0x564111b0e870) at /home/buildbot/buildbot/build/tpool/tpool_generic.cc:418 #8 0x000056410f06a93d in tpool::thread_pool_generic::get_task (this=this@entry=0x564111afede0, thread_var=thread_var@entry=0x564111b0e870, t=t@entry=0x7f9215ffce20) at /home/buildbot/buildbot/build/tpool/tpool_generic.cc:471 #9 0x000056410f06bcae in tpool::thread_pool_generic::worker_main (this=0x564111afede0, thread_var=0x564111b0e870) at /home/buildbot/buildbot/build/tpool/tpool_generic.cc:516 #10 0x000056410f23c4a0 in std::(anonymous namespace)::execute_native_thread_routine (__p=<optimized out>) at ../../../.././libstdc++-v3/src/c++11/thread.cc:84 #11 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #12 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 11 (Thread 0x7f92157fc700 (LWP 54622)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f92157fbd80, clockid=<optimized out>, expected=0, futex_word=0x564111b0e69c) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7f92157fbd80, clockid=<optimized out>, mutex=0x564111afeef0, cond=0x564111b0e670) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=0x564111b0e670, mutex=0x564111afeef0, abstime=0x7f92157fbd80) at pthread_cond_wait.c:656 #3 0x000056410f06a1d9 in __gthread_cond_timedwait (__abs_timeout=0x7f92157fbd80, __mutex=<optimized out>, __cond=0x564111b0e670) at /usr/local/include/c++/4.8.5/x86_64-unknown-linux-gnu/bits/gthr-default.h:871 #4 std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__atime=..., __lock=..., this=0x564111b0e670) at /usr/local/include/c++/4.8.5/condition_variable:160 #5 std::condition_variable::wait_until<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (__atime=..., __lock=..., this=0x564111b0e670) at /usr/local/include/c++/4.8.5/condition_variable:100 #6 std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (__rtime=..., __lock=..., this=0x564111b0e670) at /usr/local/include/c++/4.8.5/condition_variable:132 #7 tpool::thread_pool_generic::wait_for_tasks (this=this@entry=0x564111afede0, lk=..., thread_data=thread_data@entry=0x564111b0e670) at /home/buildbot/buildbot/build/tpool/tpool_generic.cc:418 #8 0x000056410f06a93d in tpool::thread_pool_generic::get_task (this=this@entry=0x564111afede0, thread_var=thread_var@entry=0x564111b0e670, t=t@entry=0x7f92157fbe20) at /home/buildbot/buildbot/build/tpool/tpool_generic.cc:471 #9 0x000056410f06bcae in tpool::thread_pool_generic::worker_main (this=0x564111afede0, thread_var=0x564111b0e670) at /home/buildbot/buildbot/build/tpool/tpool_generic.cc:516 #10 0x000056410f23c4a0 in std::(anonymous namespace)::execute_native_thread_routine (__p=<optimized out>) at ../../../.././libstdc++-v3/src/c++11/thread.cc:84 #11 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #12 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 10 (Thread 0x7f92382ed700 (LWP 53650)): #0 0x000056410edc997f in heap_rrnd (info=0x7f91c401dd48, record=0x7f91c401aa88 "\375\001", pos=0x7f91c41a4f88 "\375\001") at /home/buildbot/buildbot/build/storage/heap/hp_rrnd.c:40 #1 0x000056410ead0662 in handler::ha_rnd_pos (this=0x7f91c401ac00, buf=0x7f91c401aa88 "\375\001", pos=0x7f91c4018448 "\210O\032đ\177") at /home/buildbot/buildbot/build/sql/handler.cc:3098 #2 0x000056410ea37560 in Frame_scan_cursor::compute_values_for_current_row (this=0x7f91c4015580) at /home/buildbot/buildbot/build/sql/sql_window.cc:2209 #3 Frame_scan_cursor::next_row (this=0x7f91c4015580) at /home/buildbot/buildbot/build/sql/sql_window.cc:2179 #4 0x000056410ea3245e in Cursor_manager::notify_cursors_next_row (this=0x7f91c40260f0) at /home/buildbot/buildbot/build/sql/sql_window.cc:1179 #5 compute_window_func (thd=thd@entry=0x7f91c4000c58, window_functions=..., cursor_managers=..., tbl=tbl@entry=0x7f91c4019ba0, filesort_result=filesort_result@entry=0x7f91c4010100) at /home/buildbot/buildbot/build/sql/sql_window.cc:2849 #6 0x000056410ea34759 in Window_func_runner::exec (this=this@entry=0x7f91c4014b30, thd=thd@entry=0x7f91c4000c58, tbl=0x7f91c4019ba0, filesort_result=0x7f91c4010100) at /home/buildbot/buildbot/build/sql/sql_window.cc:2979 #7 0x000056410ea3488e in Window_funcs_sort::exec (this=0x7f91c4014b28, join=join@entry=0x7f91c4012168, keep_filesort_result=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_window.cc:3004 #8 0x000056410ea3493d in Window_funcs_computation::exec (this=0x7f91c4014b08, join=join@entry=0x7f91c4012168, keep_last_filesort_result=keep_last_filesort_result@entry=true) at /home/buildbot/buildbot/build/sql/sql_window.cc:3131 #9 0x000056410e90a33c in AGGR_OP::end_send (this=0x7f91c4014848) at /home/buildbot/buildbot/build/sql/sql_select.cc:28894 #10 0x000056410e90a511 in sub_select_postjoin_aggr (join=0x7f91c4012168, join_tab=0x7f91c4013c30, end_of_records=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_select.cc:20329 #11 0x000056410e9260ea in do_select (procedure=<optimized out>, join=0x7f91c4012168) at /home/buildbot/buildbot/build/sql/sql_select.cc:20155 #12 JOIN::exec_inner (this=this@entry=0x7f91c4012168) at /home/buildbot/buildbot/build/sql/sql_select.cc:4459 #13 0x000056410e926453 in JOIN::exec (this=this@entry=0x7f91c4012168) at /home/buildbot/buildbot/build/sql/sql_select.cc:4240 #14 0x000056410e92463e in mysql_select (thd=thd@entry=0x7f91c4000c58, tables=0x7f91c4011170, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=result@entry=0x7f91c4012140, unit=unit@entry=0x7f91c4004c38, select_lex=select_lex@entry=0x7f91c4010708) at /home/buildbot/buildbot/build/sql/sql_select.cc:4655 #15 0x000056410e92517a in handle_select (thd=thd@entry=0x7f91c4000c58, lex=lex@entry=0x7f91c4004b70, result=result@entry=0x7f91c4012140, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/buildbot/buildbot/build/sql/sql_select.cc:429 #16 0x000056410e78ab23 in execute_sqlcom_select (thd=thd@entry=0x7f91c4000c58, all_tables=0x7f91c4011170) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6266 #17 0x000056410e8caa84 in mysql_execute_command (thd=thd@entry=0x7f91c4000c58) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3968 #18 0x000056410e8cd5fc in mysql_parse (thd=thd@entry=0x7f91c4000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f92382ec420, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:8044 #19 0x000056410e8cf6ba in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f91c4000c58, packet=packet@entry=0x7f91c4007ff9 "", packet_length=packet_length@entry=56, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1873 #20 0x000056410e8d0b2b in do_command (thd=0x7f91c4000c58) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1354 #21 0x000056410e9bb402 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x564112163828, put_in_cache=put_in_cache@entry=true) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1410 #22 0x000056410e9bb6c4 in handle_one_connection (arg=arg@entry=0x564112163828) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1312 #23 0x000056410ed3ef5d in pfs_spawn_thread (arg=0x564111fe9698) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:2201 #24 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #25 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 9 (Thread 0x7f9238338700 (LWP 53600)): #0 0x000056410eadf8e3 in Item_ref::val_int (this=0x7f91d0012a28) at /home/buildbot/buildbot/build/sql/item.cc:8297 #1 0x000056410eae027a in Item_cache_int::cache_value (this=0x7f91d0012c18) at /home/buildbot/buildbot/build/sql/item.cc:9838 #2 0x000056410eb91b37 in Item_sum_max::add (this=0x7f91d0010e18) at /home/buildbot/buildbot/build/sql/item_sum.cc:2552 #3 0x000056410ea37589 in Frame_cursor::add_value_to_items (this=0x7f91d0015758) at /home/buildbot/buildbot/build/sql/sql_window.cc:1104 #4 Frame_scan_cursor::compute_values_for_current_row (this=0x7f91d0015758) at /home/buildbot/buildbot/build/sql/sql_window.cc:2211 #5 Frame_scan_cursor::next_row (this=0x7f91d0015758) at /home/buildbot/buildbot/build/sql/sql_window.cc:2179 #6 0x000056410ea3245e in Cursor_manager::notify_cursors_next_row (this=0x7f91d00260f0) at /home/buildbot/buildbot/build/sql/sql_window.cc:1179 #7 compute_window_func (thd=thd@entry=0x7f91d0000c58, window_functions=..., cursor_managers=..., tbl=tbl@entry=0x7f91d00188b0, filesort_result=filesort_result@entry=0x7f91d0010100) at /home/buildbot/buildbot/build/sql/sql_window.cc:2849 #8 0x000056410ea34759 in Window_func_runner::exec (this=this@entry=0x7f91d0014d08, thd=thd@entry=0x7f91d0000c58, tbl=0x7f91d00188b0, filesort_result=0x7f91d0010100) at /home/buildbot/buildbot/build/sql/sql_window.cc:2979 #9 0x000056410ea3488e in Window_funcs_sort::exec (this=0x7f91d0014d00, join=join@entry=0x7f91d00122c8, keep_filesort_result=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_window.cc:3004 #10 0x000056410ea3493d in Window_funcs_computation::exec (this=0x7f91d0014ce0, join=join@entry=0x7f91d00122c8, keep_last_filesort_result=keep_last_filesort_result@entry=true) at /home/buildbot/buildbot/build/sql/sql_window.cc:3131 #11 0x000056410e90a33c in AGGR_OP::end_send (this=0x7f91d0014a20) at /home/buildbot/buildbot/build/sql/sql_select.cc:28894 #12 0x000056410e90a511 in sub_select_postjoin_aggr (join=0x7f91d00122c8, join_tab=0x7f91d0013e08, end_of_records=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_select.cc:20329 #13 0x000056410e9260ea in do_select (procedure=<optimized out>, join=0x7f91d00122c8) at /home/buildbot/buildbot/build/sql/sql_select.cc:20155 #14 JOIN::exec_inner (this=this@entry=0x7f91d00122c8) at /home/buildbot/buildbot/build/sql/sql_select.cc:4459 #15 0x000056410e926453 in JOIN::exec (this=this@entry=0x7f91d00122c8) at /home/buildbot/buildbot/build/sql/sql_select.cc:4240 #16 0x000056410e92463e in mysql_select (thd=thd@entry=0x7f91d0000c58, tables=0x7f91d00112d0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=result@entry=0x7f91d00122a0, unit=unit@entry=0x7f91d0004c38, select_lex=select_lex@entry=0x7f91d0010710) at /home/buildbot/buildbot/build/sql/sql_select.cc:4655 #17 0x000056410e92517a in handle_select (thd=thd@entry=0x7f91d0000c58, lex=lex@entry=0x7f91d0004b70, result=result@entry=0x7f91d00122a0, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/buildbot/buildbot/build/sql/sql_select.cc:429 #18 0x000056410e78ab23 in execute_sqlcom_select (thd=thd@entry=0x7f91d0000c58, all_tables=0x7f91d00112d0) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6266 #19 0x000056410e8caa84 in mysql_execute_command (thd=thd@entry=0x7f91d0000c58) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3968 #20 0x000056410e8cd5fc in mysql_parse (thd=thd@entry=0x7f91d0000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f9238337420, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:8044 #21 0x000056410e8cf6ba in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f91d0000c58, packet=packet@entry=0x7f91d0007ff9 "", packet_length=packet_length@entry=63, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1873 #22 0x000056410e8d0b2b in do_command (thd=0x7f91d0000c58) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1354 #23 0x000056410e9bb402 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56411218f208, put_in_cache=put_in_cache@entry=true) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1410 #24 0x000056410e9bb6c4 in handle_one_connection (arg=arg@entry=0x56411218f208) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1312 #25 0x000056410ed3ef5d in pfs_spawn_thread (arg=0x564111fe87a8) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:2201 #26 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #27 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 8 (Thread 0x7f9238401700 (LWP 53523)): #0 Rowid_seq_cursor::at_eof (this=0x7f920c02bac8) at /home/buildbot/buildbot/build/sql/sql_window.cc:852 #1 Table_read_cursor::fetch (this=0x7f920c02bac8) at /home/buildbot/buildbot/build/sql/sql_window.cc:906 #2 0x000056410ea37560 in Frame_scan_cursor::compute_values_for_current_row (this=0x7f920c02ba90) at /home/buildbot/buildbot/build/sql/sql_window.cc:2209 #3 Frame_scan_cursor::next_row (this=0x7f920c02ba90) at /home/buildbot/buildbot/build/sql/sql_window.cc:2179 #4 0x000056410ea3245e in Cursor_manager::notify_cursors_next_row (this=0x564111fe7760) at /home/buildbot/buildbot/build/sql/sql_window.cc:1179 #5 compute_window_func (thd=thd@entry=0x7f920c00fcc8, window_functions=..., cursor_managers=..., tbl=tbl@entry=0x7f920c0279f0, filesort_result=filesort_result@entry=0x7f920c008860) at /home/buildbot/buildbot/build/sql/sql_window.cc:2849 #6 0x000056410ea34759 in Window_func_runner::exec (this=this@entry=0x7f920c023b88, thd=thd@entry=0x7f920c00fcc8, tbl=0x7f920c0279f0, filesort_result=0x7f920c008860) at /home/buildbot/buildbot/build/sql/sql_window.cc:2979 #7 0x000056410ea3488e in Window_funcs_sort::exec (this=0x7f920c023b80, join=join@entry=0x7f920c0203c8, keep_filesort_result=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_window.cc:3004 #8 0x000056410ea3493d in Window_funcs_computation::exec (this=0x7f920c023b60, join=join@entry=0x7f920c0203c8, keep_last_filesort_result=keep_last_filesort_result@entry=true) at /home/buildbot/buildbot/build/sql/sql_window.cc:3131 #9 0x000056410e90a33c in AGGR_OP::end_send (this=0x7f920c0238a0) at /home/buildbot/buildbot/build/sql/sql_select.cc:28894 #10 0x000056410e90a511 in sub_select_postjoin_aggr (join=0x7f920c0203c8, join_tab=0x7f920c022a30, end_of_records=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_select.cc:20329 #11 0x000056410e9260ea in do_select (procedure=<optimized out>, join=0x7f920c0203c8) at /home/buildbot/buildbot/build/sql/sql_select.cc:20155 #12 JOIN::exec_inner (this=this@entry=0x7f920c0203c8) at /home/buildbot/buildbot/build/sql/sql_select.cc:4459 #13 0x000056410e926453 in JOIN::exec (this=this@entry=0x7f920c0203c8) at /home/buildbot/buildbot/build/sql/sql_select.cc:4240 #14 0x000056410e92463e in mysql_select (thd=thd@entry=0x7f920c00fcc8, tables=0x7f920c01efa0, fields=..., conds=0x7f920c01f870, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=result@entry=0x7f920c0203a0, unit=unit@entry=0x7f920c013ca8, select_lex=select_lex@entry=0x7f920c01e3e0) at /home/buildbot/buildbot/build/sql/sql_select.cc:4655 #15 0x000056410e92517a in handle_select (thd=thd@entry=0x7f920c00fcc8, lex=lex@entry=0x7f920c013be0, result=result@entry=0x7f920c0203a0, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/buildbot/buildbot/build/sql/sql_select.cc:429 #16 0x000056410e78ab23 in execute_sqlcom_select (thd=thd@entry=0x7f920c00fcc8, all_tables=0x7f920c01efa0) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6266 #17 0x000056410e8caa84 in mysql_execute_command (thd=thd@entry=0x7f920c00fcc8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3968 #18 0x000056410e8cd5fc in mysql_parse (thd=thd@entry=0x7f920c00fcc8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f9238400420, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:8044 #19 0x000056410e8cf6ba in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f920c00fcc8, packet=packet@entry=0x7f920c016269 "", packet_length=packet_length@entry=76, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1873 #20 0x000056410e8d0b2b in do_command (thd=0x7f920c00fcc8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1354 #21 0x000056410e9bb402 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56411215f308, put_in_cache=put_in_cache@entry=true) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1410 #22 0x000056410e9bb6c4 in handle_one_connection (arg=arg@entry=0x56411215f308) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1312 #23 0x000056410ed3ef5d in pfs_spawn_thread (arg=0x5641121193d8) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:2201 #24 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #25 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 7 (Thread 0x7f923844c700 (LWP 19836)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x56410faba02c <COND_slave_background+44>) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x56410fab7300 <LOCK_slave_background>, cond=0x56410faba000 <COND_slave_background>) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x56410faba000 <COND_slave_background>, mutex=0x56410fab7300 <LOCK_slave_background>) at pthread_cond_wait.c:638 #3 0x000056410e814d77 in inline_mysql_cond_wait (that=<optimized out>, mutex=<optimized out>, src_file=0x56410f273ff8 "/home/buildbot/buildbot/build/sql/slave.cc", src_line=525) at /home/buildbot/buildbot/build/include/mysql/psi/mysql_thread.h:1233 #4 handle_slave_background (arg=arg@entry=0x0) at /home/buildbot/buildbot/build/sql/slave.cc:525 #5 0x000056410ed3ef5d in pfs_spawn_thread (arg=0x564112188748) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:2201 #6 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #7 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 6 (Thread 0x7f9238497700 (LWP 19835)): #0 0x00007f923b9fe322 in __GI___sigtimedwait (set=0x7f9238496cf0, info=0x7f9238496d70, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:29 #1 0x000056410e7f6aeb in my_sigwait (code=<synthetic pointer>, sig=0x7f9238496ce0, set=0x7f9238496cf0) at /home/buildbot/buildbot/build/include/my_pthread.h:196 #2 signal_hand (arg=arg@entry=0x0) at /home/buildbot/buildbot/build/sql/mysqld.cc:2988 #3 0x000056410ed3ef5d in pfs_spawn_thread (arg=0x564111a48b88) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:2201 #4 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 5 (Thread 0x7f9224d1a700 (LWP 19824)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f9224d19ce0, clockid=<optimized out>, expected=0, futex_word=0x56410fa392c0 <buf_pool+800>) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7f9224d19ce0, clockid=<optimized out>, mutex=0x56410fa39238 <buf_pool+664>, cond=0x56410fa39298 <buf_pool+760>) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=0x56410fa39298 <buf_pool+760>, mutex=0x56410fa39238 <buf_pool+664>, abstime=0x7f9224d19ce0) at pthread_cond_wait.c:656 #3 0x000056410ef8c6d8 in inline_mysql_cond_timedwait (that=that@entry=0x56410fa39298 <buf_pool+760>, mutex=mutex@entry=0x56410fa39238 <buf_pool+664>, abstime=abstime@entry=0x7f9224d19ce0, src_line=src_line@entry=2067, src_file=0x56410f443a38 "/home/buildbot/buildbot/build/storage/innobase/buf/buf0flu.cc") at /home/buildbot/buildbot/build/include/mysql/psi/mysql_thread.h:1270 #4 0x000056410ef902a4 in buf_flush_page_cleaner () at /home/buildbot/buildbot/build/storage/innobase/buf/buf0flu.cc:2067 #5 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #6 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 4 (Thread 0x7f9238c98700 (LWP 19823)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007f923bee227b in ?? () from /usr/lib/x86_64-linux-gnu/libaio.so.1 #2 0x000056410f06e2f9 in tpool::aio_linux::getevent_thread_routine (aio=0x564111b67280) at /home/buildbot/buildbot/build/tpool/aio_linux.cc:53 #3 0x000056410f23c4a0 in std::(anonymous namespace)::execute_native_thread_routine (__p=<optimized out>) at ../../../.././libstdc++-v3/src/c++11/thread.cc:84 #4 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #5 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 3 (Thread 0x7f923989a700 (LWP 19822)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f9239899d70, clockid=<optimized out>, expected=0, futex_word=0x5641102f8be8 <COND_checkpoint+40>) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7f9239899d70, clockid=<optimized out>, mutex=0x5641102f8c00 <LOCK_checkpoint>, cond=0x5641102f8bc0 <COND_checkpoint>) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=cond@entry=0x5641102f8bc0 <COND_checkpoint>, mutex=mutex@entry=0x5641102f8c00 <LOCK_checkpoint>, abstime=abstime@entry=0x7f9239899d70) at pthread_cond_wait.c:656 #3 0x000056410ecd01d6 in inline_mysql_cond_timedwait (src_file=0x56410f3e99e0 "/home/buildbot/buildbot/build/storage/maria/ma_servicethread.c", src_line=116, abstime=0x7f9239899d70, mutex=0x5641102f8c00 <LOCK_checkpoint>, that=0x5641102f8bc0 <COND_checkpoint>) at /home/buildbot/buildbot/build/include/mysql/psi/mysql_thread.h:1270 #4 my_service_thread_sleep (control=control@entry=0x56410fa2b6c0 <checkpoint_control>, sleep_time=<optimized out>) at /home/buildbot/buildbot/build/storage/maria/ma_servicethread.c:115 #5 0x000056410ecc78fe in ma_checkpoint_background (arg=0x1e) at /home/buildbot/buildbot/build/storage/maria/ma_checkpoint.c:707 #6 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #7 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 2 (Thread 0x7f923bf82700 (LWP 19821)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f923bf81df0, clockid=<optimized out>, expected=0, futex_word=0x5641103a71ac <COND_timer+44>) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7f923bf81df0, clockid=<optimized out>, mutex=0x5641103a71c0 <LOCK_timer>, cond=0x5641103a7180 <COND_timer>) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=cond@entry=0x5641103a7180 <COND_timer>, mutex=mutex@entry=0x5641103a71c0 <LOCK_timer>, abstime=abstime@entry=0x7f923bf81df0) at pthread_cond_wait.c:656 #3 0x000056410f0e7ce6 in inline_mysql_cond_timedwait (that=0x5641103a7180 <COND_timer>, mutex=0x5641103a71c0 <LOCK_timer>, src_file=0x56410f458778 "/home/buildbot/buildbot/build/mysys/thr_timer.c", src_line=321, abstime=0x7f923bf81df0) at /home/buildbot/buildbot/build/include/mysql/psi/mysql_thread.h:1270 #4 timer_handler (arg=<optimized out>) at /home/buildbot/buildbot/build/mysys/thr_timer.c:321 #5 0x00007f923bf35609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #6 0x00007f923bad9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 1 (Thread 0x7f923b9977c0 (LWP 19817)): #0 0x00007f923baccaff in __GI___poll (fds=0x7ffeab2c5a20, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 #1 0x000056410e7ff1c2 in handle_connections_sockets () at /home/buildbot/buildbot/build/sql/mysqld.cc:6219 #2 0x000056410e8003c0 in mysqld_main (argc=16, argv=0x564111a07780) at /home/buildbot/buildbot/build/sql/mysqld.cc:5668 #3 0x00007f923b9de0b3 in __libc_start_main (main=0x56410e7ac9c0 <main(int, char**)>, argc=3, argv=0x7ffeab2c5e98, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>, stack_end=0x7ffeab2c5e88) at ../csu/libc-start.c:308 #4 0x000056410e7f4841 in _start () [Inferior 1 (process 19817) detached]

VAROQUI Stephane added a comment - 2021-01-26 13:01

Can reproduce with MIN but not with SUM or AVG aggregate function

VAROQUI Stephane added a comment - 2021-01-26 13:01 Can reproduce with MIN but not with SUM or AVG aggregate function

Alice Sherepa added a comment - 2022-02-01 10:30

10.7 d6e3cd6f233730e168
[New LWP 101715]
[New LWP 101716]
[New LWP 101717]
[New LWP 101718]
[New LWP 101721]
[New LWP 101722]
[New LWP 101723]
[New LWP 101726]
[New LWP 101727]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
0x00007fbc13eeeaff in __GI___poll (fds=0x61200001b248, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29
29 ../sysdeps/unix/sysv/linux/poll.c: No such file or directory.

Thread 10 (Thread 0x7fbc054af700 (LWP 101727)):
#0 0x00005634c028f168 in _db_pargs_ (_line_=2561, keyword=0x5634c0b466a0 "enter") at /10.7/src/dbug/dbug.c:1268
#1 0x00005634bf0251ce in Item_sum_max::add (this=0x629000109ab0) at /10.7/src/sql/item_sum.cc:2561
#2 0x00005634beb48859 in Frame_cursor::add_value_to_items (this=0x6290002f59f0) at /10.7/src/sql/sql_window.cc:1112
#3 0x00005634beb4d10a in Frame_scan_cursor::compute_values_for_current_row (this=0x6290002f59f0) at /10.7/src/sql/sql_window.cc:2219
#4 0x00005634beb4cdef in Frame_scan_cursor::next_row (this=0x6290002f59f0) at /10.7/src/sql/sql_window.cc:2187
#5 0x00005634beb49295 in Cursor_manager::notify_cursors_next_row (this=0x603000043030) at /10.7/src/sql/sql_window.cc:1187
#6 0x00005634beb43fb7 in compute_window_func (thd=0x62b00017a288, window_functions=..., cursor_managers=..., tbl=0x620000020128, filesort_result=0x615000030f00) at /10.7/src/sql/sql_window.cc:2857
#7 0x00005634beb447af in Window_func_runner::exec (this=0x6290002f4e48, thd=0x62b00017a288, tbl=0x620000020128, filesort_result=0x615000030f00) at /10.7/src/sql/sql_window.cc:2985
#8 0x00005634beb449fe in Window_funcs_sort::exec (this=0x6290002f4e40, join=0x62900010b3d0, keep_filesort_result=true) at /10.7/src/sql/sql_window.cc:3013
#9 0x00005634beb45812 in Window_funcs_computation::exec (this=0x62900010d248, join=0x62900010b3d0, keep_last_filesort_result=true) at /10.7/src/sql/sql_window.cc:3140
#10 0x00005634be67316a in AGGR_OP::end_send (this=0x62900010d1e8) at /10.7/src/sql/sql_select.cc:29516
#11 0x00005634be631f62 in sub_select_postjoin_aggr (join=0x62900010b3d0, join_tab=0x6290002f3d40, end_of_records=true) at /10.7/src/sql/sql_select.cc:20790
#12 0x00005634be632915 in sub_select (join=0x62900010b3d0, join_tab=0x6290002f3990, end_of_records=true) at /10.7/src/sql/sql_select.cc:21025
#13 0x00005634be631248 in do_select (join=0x62900010b3d0, procedure=0x0) at /10.7/src/sql/sql_select.cc:20627
#14 0x00005634be5bd378 in JOIN::exec_inner (this=0x62900010b3d0) at /10.7/src/sql/sql_select.cc:4735
#15 0x00005634be5ba878 in JOIN::exec (this=0x62900010b3d0) at /10.7/src/sql/sql_select.cc:4513
#16 0x00005634be5bede7 in mysql_select (thd=0x62b00017a288, tables=0x629000109fa0, fields=..., conds=0x62900010a870, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62900010b3a0, unit=0x62b00017e690, select_lex=0x6290001093b0) at /10.7/src/sql/sql_select.cc:4993
#17 0x00005634be58f28d in handle_select (thd=0x62b00017a288, lex=0x62b00017e5b8, result=0x62900010b3a0, setup_tables_done_option=0) at /10.7/src/sql/sql_select.cc:545
#18 0x00005634be4b5dde in execute_sqlcom_select (thd=0x62b00017a288, all_tables=0x629000109fa0) at /10.7/src/sql/sql_parse.cc:6252
#19 0x00005634be4a49ad in mysql_execute_command (thd=0x62b00017a288, is_called_from_prepared_stmt=false) at /10.7/src/sql/sql_parse.cc:3943
#20 0x00005634be4c107d in mysql_parse (thd=0x62b00017a288, rawbuf=0x6290001092a8 "select part , MAX(ts) OVER (PARTITION BY part) AS ts_max FROM t where part=1", length=76, parser_state=0x7fbc054ada20) at /10.7/src/sql/sql_parse.cc:8027
#21 0x00005634be4972b4 in dispatch_command (command=COM_QUERY, thd=0x62b00017a288, packet=0x629000299289 "", packet_length=76, blocking=true) at /10.7/src/sql/sql_parse.cc:1894
#22 0x00005634be493fd8 in do_command (thd=0x62b00017a288, blocking=true) at /10.7/src/sql/sql_parse.cc:1402
#23 0x00005634be935299 in do_handle_one_connection (connect=0x61100002a288, put_in_cache=true) at /10.7/src/sql/sql_connect.cc:1418
#24 0x00005634be934b25 in handle_one_connection (arg=0x61100002a148) at /10.7/src/sql/sql_connect.cc:1312
#25 0x00005634bf5dc2df in pfs_spawn_thread (arg=0x618000008108) at /10.7/src/storage/perfschema/pfs.cc:2201
#26 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#27 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 9 (Thread 0x7fbc055c1700 (LWP 101726)):
#0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x5634c28ce4c8 <COND_manager+40>) at ../sysdeps/nptl/futex-internal.h:183
#1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x5634c28ce3e8 <LOCK_manager+40>, cond=0x5634c28ce4a0 <COND_manager>) at pthread_cond_wait.c:508
#2 __pthread_cond_wait (cond=0x5634c28ce4a0 <COND_manager>, mutex=0x5634c28ce3e8 <LOCK_manager+40>) at pthread_cond_wait.c:638
#3 0x00005634c022b4a3 in safe_cond_wait (cond=0x5634c28ce4a0 <COND_manager>, mp=0x5634c28ce3c0 <LOCK_manager>, file=0x5634c1486200 "/10.7/src/mysys/my_thr_init.c", line=596) at /10.7/src/mysys/thr_mutex.c:494
#4 0x00005634c021926b in psi_cond_wait (that=0x5634c28ce4a0 <COND_manager>, mutex=0x5634c28ce3c0 <LOCK_manager>, file=0x5634c058bf40 "/10.7/src/sql/sql_manager.cc", line=103) at /10.7/src/mysys/my_thr_init.c:596
#5 0x00005634be489e30 in inline_mysql_cond_wait (that=0x5634c28ce4a0 <COND_manager>, mutex=0x5634c28ce3c0 <LOCK_manager>, src_file=0x5634c058bf40 "/10.7/src/sql/sql_manager.cc", src_line=103) at /10.7/src/include/mysql/psi/mysql_thread.h:1070
#6 0x00005634be48a4c8 in handle_manager (arg=0x0) at /10.7/src/sql/sql_manager.cc:103
#7 0x00005634bf5dc2df in pfs_spawn_thread (arg=0x618000007d08) at /10.7/src/storage/perfschema/pfs.cc:2201
#8 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#9 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 8 (Thread 0x7fbc056c3700 (LWP 101723)):
#0 0x00007fbc13e20322 in __GI___sigtimedwait (set=0x7fbc056c2cf0, info=0x7fbc056c2b20, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:29
#1 0x00007fbc1479d111 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
#2 0x00005634be0dc00c in my_sigwait (set=0x7fbc056c2cf0, sig=0x7fbc056c2c60, code=0x7fbc056c2c70) at /10.7/src/include/my_pthread.h:195
#3 0x00005634be0eac28 in signal_hand (arg=0x0) at /10.7/src/sql/mysqld.cc:3146
#4 0x00005634bf5dc2df in pfs_spawn_thread (arg=0x618000005108) at /10.7/src/storage/perfschema/pfs.cc:2201
#5 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#6 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 7 (Thread 0x7fbc05ec4700 (LWP 101722)):
#0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7fbc05ec3810, clockid=<optimized out>, expected=0, futex_word=0x63000002fc2c) at ../sysdeps/nptl/futex-internal.h:320
#1 __pthread_cond_wait_common (abstime=0x7fbc05ec3810, clockid=<optimized out>, mutex=0x618000001190, cond=0x63000002fc00) at pthread_cond_wait.c:520
#2 __pthread_cond_timedwait (cond=0x63000002fc00, mutex=0x618000001190, abstime=0x7fbc05ec3810) at pthread_cond_wait.c:656
#3 0x00005634c004d1ed in __gthread_cond_timedwait (__cond=0x63000002fc00, __mutex=0x618000001190, __abs_timeout=0x7fbc05ec3810) at /usr/include/x86_64-linux-gnu/c++/9/bits/gthr-default.h:872
#4 0x00005634c0055045 in std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (this=0x63000002fc00, __lock=..., __atime=...) at /usr/include/c++/9/condition_variable:188
#5 0x00005634c0052a35 in std::condition_variable::wait_until<std::chrono::_V2::steady_clock, std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (this=0x63000002fc00, __lock=..., __atime=...) at /usr/include/c++/9/condition_variable:121
#6 0x00005634c004fe61 in std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (this=0x63000002fc00, __lock=..., __rtime=...) at /usr/include/c++/9/condition_variable:152
#7 0x00005634c0049568 in tpool::thread_pool_generic::wait_for_tasks (this=0x618000001080, lk=..., thread_data=0x63000002fc00) at /10.7/src/tpool/tpool_generic.cc:449
#8 0x00005634c00499c6 in tpool::thread_pool_generic::get_task (this=0x618000001080, thread_var=0x63000002fc00, t=0x7fbc05ec3bc0) at /10.7/src/tpool/tpool_generic.cc:502
#9 0x00005634c004a006 in tpool::thread_pool_generic::worker_main (this=0x618000001080, thread_var=0x63000002fc00) at /10.7/src/tpool/tpool_generic.cc:547
#10 0x00005634c005cab1 in std::__invoke_impl<void, void (tpool::thread_pool_generic::)(tpool::worker_data), tpool::thread_pool_generic, tpool::worker_data> (__f=@0x604000006028: (void (tpool::thread_pool_generic::)(class tpool::thread_pool_generic const, struct tpool::worker_data )) 0x5634c0049ee4 <tpool::thread_pool_generic::worker_main(tpool::worker_data)>, __t=@0x604000006020: 0x618000001080) at /usr/include/c++/9/bits/invoke.h:73
#11 0x00005634c005c85c in std::__invoke<void (tpool::thread_pool_generic::)(tpool::worker_data), tpool::thread_pool_generic, tpool::worker_data> (__fn=@0x604000006028: (void (tpool::thread_pool_generic::)(class tpool::thread_pool_generic const, struct tpool::worker_data )) 0x5634c0049ee4 <tpool::thread_pool_generic::worker_main(tpool::worker_data)>) at /usr/include/c++/9/bits/invoke.h:95
#12 0x00005634c005c6ed in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::)(tpool::worker_data), tpool::thread_pool_generic, tpool::worker_data> >::_M_invoke<0ul, 1ul, 2ul> (this=0x604000006018) at /usr/include/c++/9/thread:244
#13 0x00005634c005c637 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::)(tpool::worker_data), tpool::thread_pool_generic, tpool::worker_data> >::operator() (this=0x604000006018) at /usr/include/c++/9/thread:251
#14 0x00005634c005c59c in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::)(tpool::worker_data), tpool::thread_pool_generic, tpool::worker_data> > >::_M_run (this=0x604000006010) at /usr/include/c++/9/thread:195
#15 0x00007fbc1420dde4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
#16 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#17 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 6 (Thread 0x7fbc07b78700 (LWP 101721)):
#0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7fbc07b77810, clockid=<optimized out>, expected=0, futex_word=0x63000002fcac) at ../sysdeps/nptl/futex-internal.h:320
#1 __pthread_cond_wait_common (abstime=0x7fbc07b77810, clockid=<optimized out>, mutex=0x618000001190, cond=0x63000002fc80) at pthread_cond_wait.c:520
#2 __pthread_cond_timedwait (cond=0x63000002fc80, mutex=0x618000001190, abstime=0x7fbc07b77810) at pthread_cond_wait.c:656
#3 0x00005634c004d1ed in __gthread_cond_timedwait (__cond=0x63000002fc80, __mutex=0x618000001190, __abs_timeout=0x7fbc07b77810) at /usr/include/x86_64-linux-gnu/c++/9/bits/gthr-default.h:872
#4 0x00005634c0055045 in std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (this=0x63000002fc80, __lock=..., __atime=...) at /usr/include/c++/9/condition_variable:188
#5 0x00005634c0052a35 in std::condition_variable::wait_until<std::chrono::_V2::steady_clock, std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (this=0x63000002fc80, __lock=..., __atime=...) at /usr/include/c++/9/condition_variable:121
#6 0x00005634c004fe61 in std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (this=0x63000002fc80, __lock=..., __rtime=...) at /usr/include/c++/9/condition_variable:152
#7 0x00005634c0049568 in tpool::thread_pool_generic::wait_for_tasks (this=0x618000001080, lk=..., thread_data=0x63000002fc80) at /10.7/src/tpool/tpool_generic.cc:449
#8 0x00005634c00499c6 in tpool::thread_pool_generic::get_task (this=0x618000001080, thread_var=0x63000002fc80, t=0x7fbc07b77bc0) at /10.7/src/tpool/tpool_generic.cc:502
#9 0x00005634c004a006 in tpool::thread_pool_generic::worker_main (this=0x618000001080, thread_var=0x63000002fc80) at /10.7/src/tpool/tpool_generic.cc:547
#10 0x00005634c005cab1 in std::__invoke_impl<void, void (tpool::thread_pool_generic::)(tpool::worker_data), tpool::thread_pool_generic, tpool::worker_data> (__f=@0x604000004028: (void (tpool::thread_pool_generic::)(class tpool::thread_pool_generic const, struct tpool::worker_data )) 0x5634c0049ee4 <tpool::thread_pool_generic::worker_main(tpool::worker_data)>, __t=@0x604000004020: 0x618000001080) at /usr/include/c++/9/bits/invoke.h:73
#11 0x00005634c005c85c in std::__invoke<void (tpool::thread_pool_generic::)(tpool::worker_data), tpool::thread_pool_generic, tpool::worker_data> (__fn=@0x604000004028: (void (tpool::thread_pool_generic::)(class tpool::thread_pool_generic const, struct tpool::worker_data )) 0x5634c0049ee4 <tpool::thread_pool_generic::worker_main(tpool::worker_data)>) at /usr/include/c++/9/bits/invoke.h:95
#12 0x00005634c005c6ed in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::)(tpool::worker_data), tpool::thread_pool_generic, tpool::worker_data> >::_M_invoke<0ul, 1ul, 2ul> (this=0x604000004018) at /usr/include/c++/9/thread:244
#13 0x00005634c005c637 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::)(tpool::worker_data), tpool::thread_pool_generic, tpool::worker_data> >::operator() (this=0x604000004018) at /usr/include/c++/9/thread:251
#14 0x00005634c005c59c in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::)(tpool::worker_data), tpool::thread_pool_generic, tpool::worker_data> > >::_M_run (this=0x604000004010) at /usr/include/c++/9/thread:195
#15 0x00007fbc1420dde4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
#16 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#17 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 5 (Thread 0x7fbc097cd700 (LWP 101718)):
#0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x5634c24f1e28 <buf_pool+17576>) at ../sysdeps/nptl/futex-internal.h:183
#1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x5634c24f1d28 <buf_pool+17320>, cond=0x5634c24f1e00 <buf_pool+17536>) at pthread_cond_wait.c:508
#2 __pthread_cond_wait (cond=0x5634c24f1e00 <buf_pool+17536>, mutex=0x5634c24f1d28 <buf_pool+17320>) at pthread_cond_wait.c:638
#3 0x00005634c022b4a3 in safe_cond_wait (cond=0x5634c24f1e00 <buf_pool+17536>, mp=0x5634c24f1d00 <buf_pool+17280>, file=0x5634c12dd440 "/10.7/src/storage/innobase/buf/buf0flu.cc", line=2184) at /10.7/src/mysys/thr_mutex.c:494
#4 0x00005634bfe2f093 in buf_flush_page_cleaner () at /10.7/src/storage/innobase/buf/buf0flu.cc:2184
#5 0x00005634bfe3663c in std::__invoke_impl<void, void (*)()> (__f=@0x6020000001d8: 0x5634bfe2e9ef <buf_flush_page_cleaner()>) at /usr/include/c++/9/bits/invoke.h:60
#6 0x00005634bfe36578 in std::__invoke<void (*)()> (__fn=@0x6020000001d8: 0x5634bfe2e9ef <buf_flush_page_cleaner()>) at /usr/include/c++/9/bits/invoke.h:95
#7 0x00005634bfe3649e in std::thread::_Invoker<std::tuple<void (*)()> >::_M_invoke<0ul> (this=0x6020000001d8) at /usr/include/c++/9/thread:244
#8 0x00005634bfe3641f in std::thread::_Invoker<std::tuple<void (*)()> >::operator() (this=0x6020000001d8) at /usr/include/c++/9/thread:251
#9 0x00005634bfe36384 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (*)()> > >::_M_run (this=0x6020000001d0) at /usr/include/c++/9/thread:195
#10 0x00007fbc1420dde4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
#11 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#12 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 4 (Thread 0x7fbc0ac4a700 (LWP 101717)):
#0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38
#1 0x00005634c005e80a in my_getevents (ctx=0x7fbc0ac4b000, min_nr=1, nr=256, ev=0x7fbc0ac47b10) at /10.7/src/tpool/aio_linux.cc:62
#2 0x00005634c005ee0d in tpool::aio_linux::getevent_thread_routine (aio=0x6030000003a0) at /10.7/src/tpool/aio_linux.cc:104
#3 0x00005634c00605e9 in std::__invoke_impl<void, void ()(tpool::aio_linux), tpool::aio_linux> (__f=@0x6030000003e0: 0x5634c005ecbc <tpool::aio_linux::getevent_thread_routine(tpool::aio_linux)>) at /usr/include/c++/9/bits/invoke.h:60
#4 0x00005634c00604bc in std::__invoke<void ()(tpool::aio_linux), tpool::aio_linux> (__fn=@0x6030000003e0: 0x5634c005ecbc <tpool::aio_linux::getevent_thread_routine(tpool::aio_linux)>) at /usr/include/c++/9/bits/invoke.h:95
#5 0x00005634c0060399 in std::thread::_Invoker<std::tuple<void ()(tpool::aio_linux), tpool::aio_linux*> >::_M_invoke<0ul, 1ul> (this=0x6030000003d8) at /usr/include/c++/9/thread:244
#6 0x00005634c00602ff in std::thread::_Invoker<std::tuple<void ()(tpool::aio_linux), tpool::aio_linux*> >::operator() (this=0x6030000003d8) at /usr/include/c++/9/thread:251
#7 0x00005634c0060264 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void ()(tpool::aio_linux), tpool::aio_linux*> > >::_M_run (this=0x6030000003d0) at /usr/include/c++/9/thread:195
#8 0x00007fbc1420dde4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
#9 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#10 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 3 (Thread 0x7fbc0b875700 (LWP 101716)):
#0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7fbc0b874c40, clockid=<optimized out>, expected=0, futex_word=0x5634c3130fc8 <COND_checkpoint+40>) at ../sysdeps/nptl/futex-internal.h:320
#1 __pthread_cond_wait_common (abstime=0x7fbc0b874c40, clockid=<optimized out>, mutex=0x5634c3130ee8 <LOCK_checkpoint+40>, cond=0x5634c3130fa0 <COND_checkpoint>) at pthread_cond_wait.c:520
#2 __pthread_cond_timedwait (cond=0x5634c3130fa0 <COND_checkpoint>, mutex=0x5634c3130ee8 <LOCK_checkpoint+40>, abstime=0x7fbc0b874c40) at pthread_cond_wait.c:656
#3 0x00005634c022bddc in safe_cond_timedwait (cond=0x5634c3130fa0 <COND_checkpoint>, mp=0x5634c3130ec0 <LOCK_checkpoint>, abstime=0x7fbc0b874c40, file=0x5634c1486200 "/10.7/src/mysys/my_thr_init.c", line=609) at /10.7/src/mysys/thr_mutex.c:548
#4 0x00005634c021953c in psi_cond_timedwait (that=0x5634c3130fa0 <COND_checkpoint>, mutex=0x5634c3130ec0 <LOCK_checkpoint>, abstime=0x7fbc0b874c40, file=0x5634c0cb5260 "/10.7/src/storage/maria/ma_servicethread.c", line=115) at /10.7/src/mysys/my_thr_init.c:609
#5 0x00005634bf3e4e7d in inline_mysql_cond_timedwait (that=0x5634c3130fa0 <COND_checkpoint>, mutex=0x5634c3130ec0 <LOCK_checkpoint>, abstime=0x7fbc0b874c40, src_file=0x5634c0cb5260 "/10.7/src/storage/maria/ma_servicethread.c", src_line=115) at /10.7/src/include/mysql/psi/mysql_thread.h:1086
#6 0x00005634bf3e5c42 in my_service_thread_sleep (control=0x5634c2073e40 <checkpoint_control>, sleep_time=30000000000) at /10.7/src/storage/maria/ma_servicethread.c:115
#7 0x00005634bf3c7dbf in ma_checkpoint_background (arg=0x1e) at /10.7/src/storage/maria/ma_checkpoint.c:725
#8 0x00005634bf5dc2df in pfs_spawn_thread (arg=0x618000000d08) at /10.7/src/storage/perfschema/pfs.cc:2201
#9 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#10 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 2 (Thread 0x7fbc0c796700 (LWP 101715)):
#0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7fbc0c795d90, clockid=<optimized out>, expected=0, futex_word=0x5634c320fdec <COND_timer+44>) at ../sysdeps/nptl/futex-internal.h:320
#1 __pthread_cond_wait_common (abstime=0x7fbc0c795d90, clockid=<optimized out>, mutex=0x5634c320fd08 <LOCK_timer+40>, cond=0x5634c320fdc0 <COND_timer>) at pthread_cond_wait.c:520
#2 __pthread_cond_timedwait (cond=0x5634c320fdc0 <COND_timer>, mutex=0x5634c320fd08 <LOCK_timer+40>, abstime=0x7fbc0c795d90) at pthread_cond_wait.c:656
#3 0x00005634c022bddc in safe_cond_timedwait (cond=0x5634c320fdc0 <COND_timer>, mp=0x5634c320fce0 <LOCK_timer>, abstime=0x7fbc0c795d90, file=0x5634c1486200 "/10.7/src/mysys/my_thr_init.c", line=609) at /10.7/src/mysys/thr_mutex.c:548
#4 0x00005634c021953c in psi_cond_timedwait (that=0x5634c320fdc0 <COND_timer>, mutex=0x5634c320fce0 <LOCK_timer>, abstime=0x7fbc0c795d90, file=0x5634c1489940 "/10.7/src/mysys/thr_timer.c", line=321) at /10.7/src/mysys/my_thr_init.c:609
#5 0x00005634c022e862 in inline_mysql_cond_timedwait (that=0x5634c320fdc0 <COND_timer>, mutex=0x5634c320fce0 <LOCK_timer>, abstime=0x7fbc0c795d90, src_file=0x5634c1489940 "/10.7/src/mysys/thr_timer.c", src_line=321) at /10.7/src/include/mysql/psi/mysql_thread.h:1086
#6 0x00005634c0230a42 in timer_handler (arg=0x0) at /10.7/src/mysys/thr_timer.c:321
#7 0x00005634bf5dc2df in pfs_spawn_thread (arg=0x618000000108) at /10.7/src/storage/perfschema/pfs.cc:2201
#8 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#9 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 1 (Thread 0x7fbc13dc9800 (LWP 101714)):
#0 0x00007fbc13eeeaff in __GI___poll (fds=0x61200001b248, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29
#1 0x00007fbc147525ba in poll () from /lib/x86_64-linux-gnu/libasan.so.5
#2 0x00005634be0f58e2 in handle_connections_sockets () at /10.7/src/sql/mysqld.cc:6157
#3 0x00005634be0f40cc in mysqld_main (argc=156, argv=0x61c000001968) at /10.7/src/sql/mysqld.cc:5862
#4 0x00005634be0dbe8d in main (argc=24, argv=0x7ffcb8d51778) at /10.7/src/sql/main.cc:34

Alice Sherepa added a comment - 2022-02-01 10:30 10.7 d6e3cd6f233730e168 [New LWP 101715] [New LWP 101716] [New LWP 101717] [New LWP 101718] [New LWP 101721] [New LWP 101722] [New LWP 101723] [New LWP 101726] [New LWP 101727] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". 0x00007fbc13eeeaff in __GI___poll (fds=0x61200001b248, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 29 ../sysdeps/unix/sysv/linux/poll.c: No such file or directory. Thread 10 (Thread 0x7fbc054af700 (LWP 101727)): #0 0x00005634c028f168 in _db_pargs_ (_line_=2561, keyword=0x5634c0b466a0 "enter") at /10.7/src/dbug/dbug.c:1268 #1 0x00005634bf0251ce in Item_sum_max::add (this=0x629000109ab0) at /10.7/src/sql/item_sum.cc:2561 #2 0x00005634beb48859 in Frame_cursor::add_value_to_items (this=0x6290002f59f0) at /10.7/src/sql/sql_window.cc:1112 #3 0x00005634beb4d10a in Frame_scan_cursor::compute_values_for_current_row (this=0x6290002f59f0) at /10.7/src/sql/sql_window.cc:2219 #4 0x00005634beb4cdef in Frame_scan_cursor::next_row (this=0x6290002f59f0) at /10.7/src/sql/sql_window.cc:2187 #5 0x00005634beb49295 in Cursor_manager::notify_cursors_next_row (this=0x603000043030) at /10.7/src/sql/sql_window.cc:1187 #6 0x00005634beb43fb7 in compute_window_func (thd=0x62b00017a288, window_functions=..., cursor_managers=..., tbl=0x620000020128, filesort_result=0x615000030f00) at /10.7/src/sql/sql_window.cc:2857 #7 0x00005634beb447af in Window_func_runner::exec (this=0x6290002f4e48, thd=0x62b00017a288, tbl=0x620000020128, filesort_result=0x615000030f00) at /10.7/src/sql/sql_window.cc:2985 #8 0x00005634beb449fe in Window_funcs_sort::exec (this=0x6290002f4e40, join=0x62900010b3d0, keep_filesort_result=true) at /10.7/src/sql/sql_window.cc:3013 #9 0x00005634beb45812 in Window_funcs_computation::exec (this=0x62900010d248, join=0x62900010b3d0, keep_last_filesort_result=true) at /10.7/src/sql/sql_window.cc:3140 #10 0x00005634be67316a in AGGR_OP::end_send (this=0x62900010d1e8) at /10.7/src/sql/sql_select.cc:29516 #11 0x00005634be631f62 in sub_select_postjoin_aggr (join=0x62900010b3d0, join_tab=0x6290002f3d40, end_of_records=true) at /10.7/src/sql/sql_select.cc:20790 #12 0x00005634be632915 in sub_select (join=0x62900010b3d0, join_tab=0x6290002f3990, end_of_records=true) at /10.7/src/sql/sql_select.cc:21025 #13 0x00005634be631248 in do_select (join=0x62900010b3d0, procedure=0x0) at /10.7/src/sql/sql_select.cc:20627 #14 0x00005634be5bd378 in JOIN::exec_inner (this=0x62900010b3d0) at /10.7/src/sql/sql_select.cc:4735 #15 0x00005634be5ba878 in JOIN::exec (this=0x62900010b3d0) at /10.7/src/sql/sql_select.cc:4513 #16 0x00005634be5bede7 in mysql_select (thd=0x62b00017a288, tables=0x629000109fa0, fields=..., conds=0x62900010a870, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62900010b3a0, unit=0x62b00017e690, select_lex=0x6290001093b0) at /10.7/src/sql/sql_select.cc:4993 #17 0x00005634be58f28d in handle_select (thd=0x62b00017a288, lex=0x62b00017e5b8, result=0x62900010b3a0, setup_tables_done_option=0) at /10.7/src/sql/sql_select.cc:545 #18 0x00005634be4b5dde in execute_sqlcom_select (thd=0x62b00017a288, all_tables=0x629000109fa0) at /10.7/src/sql/sql_parse.cc:6252 #19 0x00005634be4a49ad in mysql_execute_command (thd=0x62b00017a288, is_called_from_prepared_stmt=false) at /10.7/src/sql/sql_parse.cc:3943 #20 0x00005634be4c107d in mysql_parse (thd=0x62b00017a288, rawbuf=0x6290001092a8 "select part , MAX(ts) OVER (PARTITION BY part) AS ts_max FROM t where part=1", length=76, parser_state=0x7fbc054ada20) at /10.7/src/sql/sql_parse.cc:8027 #21 0x00005634be4972b4 in dispatch_command (command=COM_QUERY, thd=0x62b00017a288, packet=0x629000299289 "", packet_length=76, blocking=true) at /10.7/src/sql/sql_parse.cc:1894 #22 0x00005634be493fd8 in do_command (thd=0x62b00017a288, blocking=true) at /10.7/src/sql/sql_parse.cc:1402 #23 0x00005634be935299 in do_handle_one_connection (connect=0x61100002a288, put_in_cache=true) at /10.7/src/sql/sql_connect.cc:1418 #24 0x00005634be934b25 in handle_one_connection (arg=0x61100002a148) at /10.7/src/sql/sql_connect.cc:1312 #25 0x00005634bf5dc2df in pfs_spawn_thread (arg=0x618000008108) at /10.7/src/storage/perfschema/pfs.cc:2201 #26 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #27 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 9 (Thread 0x7fbc055c1700 (LWP 101726)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x5634c28ce4c8 <COND_manager+40>) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x5634c28ce3e8 <LOCK_manager+40>, cond=0x5634c28ce4a0 <COND_manager>) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x5634c28ce4a0 <COND_manager>, mutex=0x5634c28ce3e8 <LOCK_manager+40>) at pthread_cond_wait.c:638 #3 0x00005634c022b4a3 in safe_cond_wait (cond=0x5634c28ce4a0 <COND_manager>, mp=0x5634c28ce3c0 <LOCK_manager>, file=0x5634c1486200 "/10.7/src/mysys/my_thr_init.c", line=596) at /10.7/src/mysys/thr_mutex.c:494 #4 0x00005634c021926b in psi_cond_wait (that=0x5634c28ce4a0 <COND_manager>, mutex=0x5634c28ce3c0 <LOCK_manager>, file=0x5634c058bf40 "/10.7/src/sql/sql_manager.cc", line=103) at /10.7/src/mysys/my_thr_init.c:596 #5 0x00005634be489e30 in inline_mysql_cond_wait (that=0x5634c28ce4a0 <COND_manager>, mutex=0x5634c28ce3c0 <LOCK_manager>, src_file=0x5634c058bf40 "/10.7/src/sql/sql_manager.cc", src_line=103) at /10.7/src/include/mysql/psi/mysql_thread.h:1070 #6 0x00005634be48a4c8 in handle_manager (arg=0x0) at /10.7/src/sql/sql_manager.cc:103 #7 0x00005634bf5dc2df in pfs_spawn_thread (arg=0x618000007d08) at /10.7/src/storage/perfschema/pfs.cc:2201 #8 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #9 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 8 (Thread 0x7fbc056c3700 (LWP 101723)): #0 0x00007fbc13e20322 in __GI___sigtimedwait (set=0x7fbc056c2cf0, info=0x7fbc056c2b20, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:29 #1 0x00007fbc1479d111 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5 #2 0x00005634be0dc00c in my_sigwait (set=0x7fbc056c2cf0, sig=0x7fbc056c2c60, code=0x7fbc056c2c70) at /10.7/src/include/my_pthread.h:195 #3 0x00005634be0eac28 in signal_hand (arg=0x0) at /10.7/src/sql/mysqld.cc:3146 #4 0x00005634bf5dc2df in pfs_spawn_thread (arg=0x618000005108) at /10.7/src/storage/perfschema/pfs.cc:2201 #5 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #6 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 7 (Thread 0x7fbc05ec4700 (LWP 101722)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7fbc05ec3810, clockid=<optimized out>, expected=0, futex_word=0x63000002fc2c) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7fbc05ec3810, clockid=<optimized out>, mutex=0x618000001190, cond=0x63000002fc00) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=0x63000002fc00, mutex=0x618000001190, abstime=0x7fbc05ec3810) at pthread_cond_wait.c:656 #3 0x00005634c004d1ed in __gthread_cond_timedwait (__cond=0x63000002fc00, __mutex=0x618000001190, __abs_timeout=0x7fbc05ec3810) at /usr/include/x86_64-linux-gnu/c++/9/bits/gthr-default.h:872 #4 0x00005634c0055045 in std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (this=0x63000002fc00, __lock=..., __atime=...) at /usr/include/c++/9/condition_variable:188 #5 0x00005634c0052a35 in std::condition_variable::wait_until<std::chrono::_V2::steady_clock, std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (this=0x63000002fc00, __lock=..., __atime=...) at /usr/include/c++/9/condition_variable:121 #6 0x00005634c004fe61 in std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (this=0x63000002fc00, __lock=..., __rtime=...) at /usr/include/c++/9/condition_variable:152 #7 0x00005634c0049568 in tpool::thread_pool_generic::wait_for_tasks (this=0x618000001080, lk=..., thread_data=0x63000002fc00) at /10.7/src/tpool/tpool_generic.cc:449 #8 0x00005634c00499c6 in tpool::thread_pool_generic::get_task (this=0x618000001080, thread_var=0x63000002fc00, t=0x7fbc05ec3bc0) at /10.7/src/tpool/tpool_generic.cc:502 #9 0x00005634c004a006 in tpool::thread_pool_generic::worker_main (this=0x618000001080, thread_var=0x63000002fc00) at /10.7/src/tpool/tpool_generic.cc:547 #10 0x00005634c005cab1 in std::__invoke_impl<void, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__f=@0x604000006028: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x5634c0049ee4 <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>, __t=@0x604000006020: 0x618000001080) at /usr/include/c++/9/bits/invoke.h:73 #11 0x00005634c005c85c in std::__invoke<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__fn=@0x604000006028: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x5634c0049ee4 <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>) at /usr/include/c++/9/bits/invoke.h:95 #12 0x00005634c005c6ed in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::_M_invoke<0ul, 1ul, 2ul> (this=0x604000006018) at /usr/include/c++/9/thread:244 #13 0x00005634c005c637 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::operator() (this=0x604000006018) at /usr/include/c++/9/thread:251 #14 0x00005634c005c59c in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> > >::_M_run (this=0x604000006010) at /usr/include/c++/9/thread:195 #15 0x00007fbc1420dde4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6 #16 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #17 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 6 (Thread 0x7fbc07b78700 (LWP 101721)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7fbc07b77810, clockid=<optimized out>, expected=0, futex_word=0x63000002fcac) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7fbc07b77810, clockid=<optimized out>, mutex=0x618000001190, cond=0x63000002fc80) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=0x63000002fc80, mutex=0x618000001190, abstime=0x7fbc07b77810) at pthread_cond_wait.c:656 #3 0x00005634c004d1ed in __gthread_cond_timedwait (__cond=0x63000002fc80, __mutex=0x618000001190, __abs_timeout=0x7fbc07b77810) at /usr/include/x86_64-linux-gnu/c++/9/bits/gthr-default.h:872 #4 0x00005634c0055045 in std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (this=0x63000002fc80, __lock=..., __atime=...) at /usr/include/c++/9/condition_variable:188 #5 0x00005634c0052a35 in std::condition_variable::wait_until<std::chrono::_V2::steady_clock, std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (this=0x63000002fc80, __lock=..., __atime=...) at /usr/include/c++/9/condition_variable:121 #6 0x00005634c004fe61 in std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (this=0x63000002fc80, __lock=..., __rtime=...) at /usr/include/c++/9/condition_variable:152 #7 0x00005634c0049568 in tpool::thread_pool_generic::wait_for_tasks (this=0x618000001080, lk=..., thread_data=0x63000002fc80) at /10.7/src/tpool/tpool_generic.cc:449 #8 0x00005634c00499c6 in tpool::thread_pool_generic::get_task (this=0x618000001080, thread_var=0x63000002fc80, t=0x7fbc07b77bc0) at /10.7/src/tpool/tpool_generic.cc:502 #9 0x00005634c004a006 in tpool::thread_pool_generic::worker_main (this=0x618000001080, thread_var=0x63000002fc80) at /10.7/src/tpool/tpool_generic.cc:547 #10 0x00005634c005cab1 in std::__invoke_impl<void, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__f=@0x604000004028: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x5634c0049ee4 <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>, __t=@0x604000004020: 0x618000001080) at /usr/include/c++/9/bits/invoke.h:73 #11 0x00005634c005c85c in std::__invoke<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__fn=@0x604000004028: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x5634c0049ee4 <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>) at /usr/include/c++/9/bits/invoke.h:95 #12 0x00005634c005c6ed in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::_M_invoke<0ul, 1ul, 2ul> (this=0x604000004018) at /usr/include/c++/9/thread:244 #13 0x00005634c005c637 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::operator() (this=0x604000004018) at /usr/include/c++/9/thread:251 #14 0x00005634c005c59c in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> > >::_M_run (this=0x604000004010) at /usr/include/c++/9/thread:195 #15 0x00007fbc1420dde4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6 #16 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #17 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 5 (Thread 0x7fbc097cd700 (LWP 101718)): #0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x5634c24f1e28 <buf_pool+17576>) at ../sysdeps/nptl/futex-internal.h:183 #1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x5634c24f1d28 <buf_pool+17320>, cond=0x5634c24f1e00 <buf_pool+17536>) at pthread_cond_wait.c:508 #2 __pthread_cond_wait (cond=0x5634c24f1e00 <buf_pool+17536>, mutex=0x5634c24f1d28 <buf_pool+17320>) at pthread_cond_wait.c:638 #3 0x00005634c022b4a3 in safe_cond_wait (cond=0x5634c24f1e00 <buf_pool+17536>, mp=0x5634c24f1d00 <buf_pool+17280>, file=0x5634c12dd440 "/10.7/src/storage/innobase/buf/buf0flu.cc", line=2184) at /10.7/src/mysys/thr_mutex.c:494 #4 0x00005634bfe2f093 in buf_flush_page_cleaner () at /10.7/src/storage/innobase/buf/buf0flu.cc:2184 #5 0x00005634bfe3663c in std::__invoke_impl<void, void (*)()> (__f=@0x6020000001d8: 0x5634bfe2e9ef <buf_flush_page_cleaner()>) at /usr/include/c++/9/bits/invoke.h:60 #6 0x00005634bfe36578 in std::__invoke<void (*)()> (__fn=@0x6020000001d8: 0x5634bfe2e9ef <buf_flush_page_cleaner()>) at /usr/include/c++/9/bits/invoke.h:95 #7 0x00005634bfe3649e in std::thread::_Invoker<std::tuple<void (*)()> >::_M_invoke<0ul> (this=0x6020000001d8) at /usr/include/c++/9/thread:244 #8 0x00005634bfe3641f in std::thread::_Invoker<std::tuple<void (*)()> >::operator() (this=0x6020000001d8) at /usr/include/c++/9/thread:251 #9 0x00005634bfe36384 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (*)()> > >::_M_run (this=0x6020000001d0) at /usr/include/c++/9/thread:195 #10 0x00007fbc1420dde4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6 #11 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #12 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 4 (Thread 0x7fbc0ac4a700 (LWP 101717)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00005634c005e80a in my_getevents (ctx=0x7fbc0ac4b000, min_nr=1, nr=256, ev=0x7fbc0ac47b10) at /10.7/src/tpool/aio_linux.cc:62 #2 0x00005634c005ee0d in tpool::aio_linux::getevent_thread_routine (aio=0x6030000003a0) at /10.7/src/tpool/aio_linux.cc:104 #3 0x00005634c00605e9 in std::__invoke_impl<void, void (*)(tpool::aio_linux*), tpool::aio_linux*> (__f=@0x6030000003e0: 0x5634c005ecbc <tpool::aio_linux::getevent_thread_routine(tpool::aio_linux*)>) at /usr/include/c++/9/bits/invoke.h:60 #4 0x00005634c00604bc in std::__invoke<void (*)(tpool::aio_linux*), tpool::aio_linux*> (__fn=@0x6030000003e0: 0x5634c005ecbc <tpool::aio_linux::getevent_thread_routine(tpool::aio_linux*)>) at /usr/include/c++/9/bits/invoke.h:95 #5 0x00005634c0060399 in std::thread::_Invoker<std::tuple<void (*)(tpool::aio_linux*), tpool::aio_linux*> >::_M_invoke<0ul, 1ul> (this=0x6030000003d8) at /usr/include/c++/9/thread:244 #6 0x00005634c00602ff in std::thread::_Invoker<std::tuple<void (*)(tpool::aio_linux*), tpool::aio_linux*> >::operator() (this=0x6030000003d8) at /usr/include/c++/9/thread:251 #7 0x00005634c0060264 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (*)(tpool::aio_linux*), tpool::aio_linux*> > >::_M_run (this=0x6030000003d0) at /usr/include/c++/9/thread:195 #8 0x00007fbc1420dde4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6 #9 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #10 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 3 (Thread 0x7fbc0b875700 (LWP 101716)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7fbc0b874c40, clockid=<optimized out>, expected=0, futex_word=0x5634c3130fc8 <COND_checkpoint+40>) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7fbc0b874c40, clockid=<optimized out>, mutex=0x5634c3130ee8 <LOCK_checkpoint+40>, cond=0x5634c3130fa0 <COND_checkpoint>) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=0x5634c3130fa0 <COND_checkpoint>, mutex=0x5634c3130ee8 <LOCK_checkpoint+40>, abstime=0x7fbc0b874c40) at pthread_cond_wait.c:656 #3 0x00005634c022bddc in safe_cond_timedwait (cond=0x5634c3130fa0 <COND_checkpoint>, mp=0x5634c3130ec0 <LOCK_checkpoint>, abstime=0x7fbc0b874c40, file=0x5634c1486200 "/10.7/src/mysys/my_thr_init.c", line=609) at /10.7/src/mysys/thr_mutex.c:548 #4 0x00005634c021953c in psi_cond_timedwait (that=0x5634c3130fa0 <COND_checkpoint>, mutex=0x5634c3130ec0 <LOCK_checkpoint>, abstime=0x7fbc0b874c40, file=0x5634c0cb5260 "/10.7/src/storage/maria/ma_servicethread.c", line=115) at /10.7/src/mysys/my_thr_init.c:609 #5 0x00005634bf3e4e7d in inline_mysql_cond_timedwait (that=0x5634c3130fa0 <COND_checkpoint>, mutex=0x5634c3130ec0 <LOCK_checkpoint>, abstime=0x7fbc0b874c40, src_file=0x5634c0cb5260 "/10.7/src/storage/maria/ma_servicethread.c", src_line=115) at /10.7/src/include/mysql/psi/mysql_thread.h:1086 #6 0x00005634bf3e5c42 in my_service_thread_sleep (control=0x5634c2073e40 <checkpoint_control>, sleep_time=30000000000) at /10.7/src/storage/maria/ma_servicethread.c:115 #7 0x00005634bf3c7dbf in ma_checkpoint_background (arg=0x1e) at /10.7/src/storage/maria/ma_checkpoint.c:725 #8 0x00005634bf5dc2df in pfs_spawn_thread (arg=0x618000000d08) at /10.7/src/storage/perfschema/pfs.cc:2201 #9 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #10 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 2 (Thread 0x7fbc0c796700 (LWP 101715)): #0 futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7fbc0c795d90, clockid=<optimized out>, expected=0, futex_word=0x5634c320fdec <COND_timer+44>) at ../sysdeps/nptl/futex-internal.h:320 #1 __pthread_cond_wait_common (abstime=0x7fbc0c795d90, clockid=<optimized out>, mutex=0x5634c320fd08 <LOCK_timer+40>, cond=0x5634c320fdc0 <COND_timer>) at pthread_cond_wait.c:520 #2 __pthread_cond_timedwait (cond=0x5634c320fdc0 <COND_timer>, mutex=0x5634c320fd08 <LOCK_timer+40>, abstime=0x7fbc0c795d90) at pthread_cond_wait.c:656 #3 0x00005634c022bddc in safe_cond_timedwait (cond=0x5634c320fdc0 <COND_timer>, mp=0x5634c320fce0 <LOCK_timer>, abstime=0x7fbc0c795d90, file=0x5634c1486200 "/10.7/src/mysys/my_thr_init.c", line=609) at /10.7/src/mysys/thr_mutex.c:548 #4 0x00005634c021953c in psi_cond_timedwait (that=0x5634c320fdc0 <COND_timer>, mutex=0x5634c320fce0 <LOCK_timer>, abstime=0x7fbc0c795d90, file=0x5634c1489940 "/10.7/src/mysys/thr_timer.c", line=321) at /10.7/src/mysys/my_thr_init.c:609 #5 0x00005634c022e862 in inline_mysql_cond_timedwait (that=0x5634c320fdc0 <COND_timer>, mutex=0x5634c320fce0 <LOCK_timer>, abstime=0x7fbc0c795d90, src_file=0x5634c1489940 "/10.7/src/mysys/thr_timer.c", src_line=321) at /10.7/src/include/mysql/psi/mysql_thread.h:1086 #6 0x00005634c0230a42 in timer_handler (arg=0x0) at /10.7/src/mysys/thr_timer.c:321 #7 0x00005634bf5dc2df in pfs_spawn_thread (arg=0x618000000108) at /10.7/src/storage/perfschema/pfs.cc:2201 #8 0x00007fbc14328609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #9 0x00007fbc13efb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 1 (Thread 0x7fbc13dc9800 (LWP 101714)): #0 0x00007fbc13eeeaff in __GI___poll (fds=0x61200001b248, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 #1 0x00007fbc147525ba in poll () from /lib/x86_64-linux-gnu/libasan.so.5 #2 0x00005634be0f58e2 in handle_connections_sockets () at /10.7/src/sql/mysqld.cc:6157 #3 0x00005634be0f40cc in mysqld_main (argc=156, argv=0x61c000001968) at /10.7/src/sql/mysqld.cc:5862 #4 0x00005634be0dbe8d in main (argc=24, argv=0x7ffcb8d51778) at /10.7/src/sql/main.cc:34

People

Assignee:: Sergei Petrunia

Reporter:: VAROQUI Stephane

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2021-01-25 22:18

Updated:: 2024-09-10 15:04

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server