InnoDB: InnoDB: Long wait (… seconds) for double-write buffer flush

# 2025-07-31T03:58:04 [2939738] #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=140466280437312) at ./nptl/pthread_kill.c:44

# 2025-07-31T03:58:04 [2939738] [Current thread is 1 (Thread 0x7fc0dabf9640 (LWP 2963519))]

# 2025-07-31T03:58:04 [2939738] #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=140466280437312) at ./nptl/pthread_kill.c:44

# 2025-07-31T03:58:04 [2939738] #1  __pthread_kill_internal (signo=6, threadid=140466280437312) at ./nptl/pthread_kill.c:78

# 2025-07-31T03:58:04 [2939738] #2  __GI___pthread_kill (threadid=140466280437312, signo=6) at ./nptl/pthread_kill.c:89

# 2025-07-31T03:58:04 [2939738] #3  0x000055ac88c43fec in my_write_core (sig=6) at /data/Server/11.8A/mysys/stacktrace.c:424

# 2025-07-31T03:58:04 [2939738] #4  0x000055ac883fdb02 in handle_fatal_signal (sig=6) at /data/Server/11.8A/sql/signal_handler.cc:298

# 2025-07-31T03:58:04 [2939738] #5  <signal handler called>

# 2025-07-31T03:58:04 [2939738] #6  __pthread_kill_implementation (no_tid=0, signo=6, threadid=140466280437312) at ./nptl/pthread_kill.c:44

# 2025-07-31T03:58:04 [2939738] #7  __pthread_kill_internal (signo=6, threadid=140466280437312) at ./nptl/pthread_kill.c:78

# 2025-07-31T03:58:04 [2939738] #8  __GI___pthread_kill (threadid=140466280437312, signo=signo@entry=6) at ./nptl/pthread_kill.c:89

# 2025-07-31T03:58:04 [2939738] #9  0x00007fc10f54f476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26

# 2025-07-31T03:58:04 [2939738] #10 0x00007fc10f5357f3 in __GI_abort () at ./stdlib/abort.c:79

# 2025-07-31T03:58:04 [2939738] #11 0x000055ac88a291f0 in ib::fatal::~fatal (this=this@entry=0x7fc0dabf87a0, __in_chrg=<optimized out>) at /data/Server/11.8A/storage/innobase/ut/ut0ut.cc:486

# 2025-07-31T03:58:04 [2939738] #12 0x000055ac88a94640 in buf_dblwr_t::flush_buffered_writes (this=this@entry=0x55ac8a251b20 <buf_dblwr>, size=64) at /data/Server/11.8A/storage/innobase/buf/buf0dblwr.cc:645

# 2025-07-31T03:58:04 [2939738] #13 0x000055ac88a94c49 in buf_dblwr_t::flush_buffered_writes (this=0x55ac8a251b20 <buf_dblwr>) at /data/Server/11.8A/storage/innobase/buf/buf0dblwr.cc:813

# 2025-07-31T03:58:04 [2939738] #14 0x000055ac88a82f19 in buf_pool_t::io_buf_t::reserve (this=this@entry=0x55ac899304a8 <buf_pool+18216>, wait_for_reads=wait_for_reads@entry=false) at /data/Server/11.8A/storage/innobase/buf/buf0buf.cc:1598

# 2025-07-31T03:58:04 [2939738] #15 0x000055ac88a84741 in buf_pool_t::io_buf_reserve (wait_for_reads=false, this=0x55ac8992bd80 <buf_pool>) at /data/Server/11.8A/storage/innobase/include/buf0buf.h:1697

# 2025-07-31T03:58:04 [2939738] #16 buf_page_decrypt_after_read (bpage=bpage@entry=0x7fc100803a80, node=...) at /data/Server/11.8A/storage/innobase/buf/buf0buf.cc:500

# 2025-07-31T03:58:04 [2939738] #17 0x000055ac88a8641f in buf_page_t::read_complete (this=0x7fc100803a80, node=...) at /data/Server/11.8A/storage/innobase/buf/buf0buf.cc:3434

# 2025-07-31T03:58:04 [2939738] #18 0x000055ac88b378ec in IORequest::read_complete (this=this@entry=0x7fc0a8020a00, io_error=0) at /data/Server/11.8A/storage/innobase/fil/fil0fil.cc:2947

# 2025-07-31T03:58:04 [2939738] #19 0x000055ac88899362 in read_io_callback (c=0x7fc0a8020988) at /data/Server/11.8A/storage/innobase/os/os0file.cc:3056

# 2025-07-31T03:58:04 [2939738] #20 0x000055ac88bd92d0 in tpool::task_group::execute (this=0x55ac8ac5e930, t=t@entry=0x7fc0a80209e0) at /data/Server/11.8A/tpool/task_group.cc:73

# 2025-07-31T03:58:04 [2939738] #21 0x000055ac88bd96a3 in tpool::task::execute (this=0x7fc0a80209e0) at /data/Server/11.8A/tpool/task.cc:32

# 2025-07-31T03:58:04 [2939738] #22 0x000055ac88bd5bd5 in tpool::thread_pool_generic::worker_main (this=0x55ac8ac153d0, thread_var=0x55ac8ac15ca0) at /data/Server/11.8A/tpool/tpool_generic.cc:573

# 2025-07-31T03:58:04 [2939738] #23 0x000055ac88bd5e2d in std::__invoke_impl<void, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__t=<optimized out>, __f=<optimized out>) at /usr/include/c++/11/bits/invoke.h:74

# 2025-07-31T03:58:04 [2939738] #24 std::__invoke<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__fn=<optimized out>) at /usr/include/c++/11/bits/invoke.h:96

# 2025-07-31T03:58:04 [2939738] #25 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=<optimized out>) at /usr/include/c++/11/bits/std_thread.h:259

# 2025-07-31T03:58:04 [2939738] #26 std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::operator() (this=<optimized out>) at /usr/include/c++/11/bits/std_thread.h:266

# 2025-07-31T03:58:04 [2939738] #27 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=<optimized out>) at /usr/include/c++/11/bits/std_thread.h:211

# 2025-07-31T03:58:04 [2939738] #28 0x00007fc10f91b253 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

# 2025-07-31T03:58:04 [2939738] #29 0x00007fc10f5a1ac3 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

# 2025-07-31T03:58:04 [2939738] #30 0x00007fc10f633850 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

# 2025-07-31T03:58:04 [2939738] #5  <signal handler called>

# 2025-07-31T03:58:04 [2939738] 39      in ./nptl/pthread_kill.c