[MDEV-24684] Aggregate functions min max over a partition have quadratic complexity Created: 2021-01-25  Updated: 2023-11-28

Status: Confirmed
Project: MariaDB Server
Component/s: Optimizer - Window functions
Affects Version/s: 10.4.17, 10.5.8, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Major
Reporter: VAROQUI Stephane Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-30474 Crash when after massively repeated C... Closed

 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;

 Comments   
Comment by Alice Sherepa [ 2021-01-26 ]

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?

Comment by VAROQUI Stephane [ 2021-01-26 ]

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

Comment by VAROQUI Stephane [ 2021-01-26 ]

fixing the test

Comment by VAROQUI Stephane [ 2021-01-26 ]

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

Comment by Alice Sherepa [ 2021-01-26 ]

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]

Comment by VAROQUI Stephane [ 2021-01-26 ]

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

Comment by Alice Sherepa [ 2022-02-01 ]

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

Generated at Thu Feb 08 09:31:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.