Details

Type: Bug

Status: Closed (View Workflow)

Priority: Major

Resolution: Fixed

Affects Version/s: 10.5.3, 10.5

Component/s: Storage Engine  InnoDB

Labels:None
Description
config 
[mysqld]

skipnameresolve


max_prepared_stmt_count=1000000

max_connections=2048

back_log=2000


innodb_buffer_pool_size=27G

innodb_log_file_size=2G

innodb_log_buffer_size=64M


innodb_buffer_pool_dump_pct=100

innodb_buffer_pool_dump_at_shutdown=1

innodb_buffer_pool_load_at_startup=1

innodb_fast_shutdown=0


innodb_flush_neighbors=0

innodb_flush_method=O_DIRECT


table_open_cache=4096

table_open_cache_instances=64


innodb_io_capacity=12000

innodb_io_capacity_max=16000


innodb_read_io_threads=8

innodb_write_io_threads=8

innodb_purge_threads=4

innodb_adaptive_hash_index=0

gdb backtrack 
[Thread debugging using libthread_db enabled]

Using host libthread_db library "/lib/powerpc64lelinuxgnu/libthread_db.so.1".

0x000077abc5bb9768 in __GI___nanosleep (requested_time=0x0, remaining=0x0) at ../sysdeps/unix/sysv/linux/nanosleep.c:28

28 ../sysdeps/unix/sysv/linux/nanosleep.c: No such file or directory.

(gdb) bt

#0 0x000077abc5bb9768 in __GI___nanosleep (requested_time=0x0, remaining=0x0) at ../sysdeps/unix/sysv/linux/nanosleep.c:28

#1 0x00000028f88b1658 in os_thread_sleep (tm=100) at /home/dan/mariadbservernotworktree/storage/innobase/os/os0thread.cc:231

#2 0x00000028f897cd80 in srv_purge_shutdown () at /home/dan/mariadbservernotworktree/storage/innobase/srv/srv0srv.cc:2317

#3 0x00000028f89855ac in innodb_preshutdown () at /home/dan/mariadbservernotworktree/storage/innobase/srv/srv0start.cc:2076

#4 0x00000028f8328678 in plugin_pre_shutdown (plugin=0x10034c6ca50) at /home/dan/mariadbservernotworktree/sql/handler.cc:919

#5 0x00000028f7f99508 in plugin_foreach_with_mask (thd=0x0, func=0x28f832861c <plugin_pre_shutdown(THD*, plugin_ref, void*)>, type=1, state_mask=10, arg=0x0)

at /home/dan/mariadbservernotworktree/sql/sql_plugin.cc:2470

#6 0x00000028f83286dc in ha_pre_shutdown () at /home/dan/mariadbservernotworktree/sql/handler.cc:926

#7 0x00000028f7e13870 in mysqld_main (argc=30, argv=0x10034c32290) at /home/dan/mariadbservernotworktree/sql/mysqld.cc:5643

#8 0x00000028f7e06574 in main (argc=3, argv=0x7ffffb418f18) at /home/dan/mariadbservernotworktree/sql/main.cc:25

(gdb) bt full

#0 0x000077abc5bb9768 in __GI___nanosleep (requested_time=0x0, remaining=0x0) at ../sysdeps/unix/sysv/linux/nanosleep.c:28

r0 = 162

r4 = 0

r6 = 16384

r8 = 0

arg2 = <optimised out>

r3 = 0

r5 = 0

r7 = 131579646544600

arg1 = <optimised out>

sc_err = <optimised out>

sc_ret = <optimised out>

sc_cancel_oldtype = 0

sc_ret = <optimised out>

#1 0x00000028f88b1658 in os_thread_sleep (tm=100) at /home/dan/mariadbservernotworktree/storage/innobase/os/os0thread.cc:231

t = {tv_sec = 0, tv_nsec = 100000}

#2 0x00000028f897cd80 in srv_purge_shutdown () at /home/dan/mariadbservernotworktree/storage/innobase/srv/srv0srv.cc:2317

No locals.

#3 0x00000028f89855ac in innodb_preshutdown () at /home/dan/mariadbservernotworktree/storage/innobase/srv/srv0start.cc:2076

first_time = false

#4 0x00000028f8328678 in plugin_pre_shutdown (plugin=0x10034c6ca50) at /home/dan/mariadbservernotworktree/sql/handler.cc:919

hton = 0x10034d3e0b8

#5 0x00000028f7f99508 in plugin_foreach_with_mask (thd=0x0, func=0x28f832861c <plugin_pre_shutdown(THD*, plugin_ref, void*)>, type=1, state_mask=10, arg=0x0)

at /home/dan/mariadbservernotworktree/sql/sql_plugin.cc:2470

idx = 8

total = 11

plugin = 0x10034c82870

plugins = 0x7ffffb418890

res = 0 '\000'

#6 0x00000028f83286dc in ha_pre_shutdown () at /home/dan/mariadbservernotworktree/sql/handler.cc:926

No locals.

#7 0x00000028f7e13870 in mysqld_main (argc=30, argv=0x10034c32290) at /home/dan/mariadbservernotworktree/sql/mysqld.cc:5643

please_close_stdin = true

ho_error = 0

new_thread_stack_size = 299008

user = 0x0

#8 0x00000028f7e06574 in main (argc=3, argv=0x7ffffb418f18) at /home/dan/mariadbservernotworktree/sql/main.cc:25

No locals.

(gdb) p purge_sys

$1 = {latch = {lock_word = {<std::__atomic_base<int>> = {static _S_alignment = 4, _M_i = 536870912}, <No data fields>}, waiters = {<std::__atomic_base<int>> = {

static _S_alignment = 4, _M_i = 0}, <No data fields>}, sx_recursive = 0, writer_is_wait_ex = false, writer_thread = 0, event = 0x100632d78e8,

wait_ex_event = 0x100632d7978, cfile_name = 0x28f8ee8920 "/home/dan/mariadbservernotworktree/storage/innobase/trx/trx0purge.cc",

last_x_file_name = 0x28f8ee8920 "/home/dan/mariadbservernotworktree/storage/innobase/trx/trx0purge.cc", cline = 175, is_block_lock = 0, last_x_line = 1276,

count_os_wait = 0, list = {prev = 0x1006202f378, next = 0x100632de080}, pfs_psi = 0x0}, m_enabled = {_M_base = {static _S_alignment = 1, _M_i = true}}, m_paused = {

m_counter = {<std::__atomic_base<int>> = {static _S_alignment = 4, _M_i = 0}, <No data fields>}}, query = 0x100632dc5a0, view = {

m_state = {<std::__atomic_base<unsigned int>> = {static _S_alignment = 4, _M_i = 0}, <No data fields>}, m_low_limit_id = 1051743806, m_up_limit_id = 1051743806,

m_creator_trx_id = 0, m_ids = std::vector of length 0, capacity 416, m_low_limit_no = 1051743806}, tail = {commit = 1551671548, undo_no = 0}, head = {

commit = 1551671547, undo_no = 0}, next_stored = false, rseg = 0x100632b4a58, page_no = 3783890, hdr_page_no = 3783890, offset = 11346, hdr_offset = 11160, rseg_iter = {

m_rsegs = {m_commit = 1551671567, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b57e8}}, m_iter = 0x0},

purge_queue = std::priority_queue wrapping: std::vector of length 128, capacity 128 = {{m_commit = 1551671575, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632c0498}}, {m_commit = 1551671583, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b75e8}}, {m_commit = 1551671579,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632b5bb8}}, {m_commit = 1551671585, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b79b8}}, {

m_commit = 1551671605, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c3da8}}, {m_commit = 1551671665, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632b7fe8}}, {m_commit = 1551671591, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b84e8}}, {m_commit = 1551671603,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632b9a18}}, {m_commit = 1551671587, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b6be8}}, {

m_commit = 1551671751, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b0148}}, {m_commit = 1551671671, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632bb578}}, {m_commit = 1551671691, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b5f88}}, {m_commit = 1551671705,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632bb1a8}}, {m_commit = 1551671601, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b65b8}}, {

m_commit = 1551671703, m_rsegs = std::vector of length 1, capacity 1 = {0x100632ac918}}, {m_commit = 1551671651, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632bab78}}, {m_commit = 1551672053, m_rsegs = std::vector of length 1, capacity 1 = {0x100632cbae8}}, {m_commit = 1551671659,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632ade48}}, {m_commit = 1551671621, m_rsegs = std::vector of length 1, capacity 1 = {0x100632ba548}}, {

m_commit = 1551671909, m_rsegs = std::vector of length 1, capacity 1 = {0x100632ce5d8}}, {m_commit = 1551671803, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632b3438}}, {m_commit = 1551671819, m_rsegs = std::vector of length 1, capacity 1 = {0x100632a5d68}}, {m_commit = 1551671683,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632acf48}}, {m_commit = 1551671829, m_rsegs = std::vector of length 1, capacity 1 = {0x100632a4e68}}, {

m_commit = 1551671707, m_rsegs = std::vector of length 1, capacity 1 = {0x100632bbba8}}, {m_commit = 1551671745, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632b9de8}}, {m_commit = 1551671779, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b0a18}}, {m_commit = 1551671933,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632b3938}}, {m_commit = 1551671697, m_rsegs = std::vector of length 1, capacity 1 = {0x100632bbf28}}, {

m_commit = 1551671741, m_rsegs = std::vector of length 1, capacity 1 = {0x100632af378}}, {m_commit = 1551671867, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632ad578}}, {m_commit = 1551671693, m_rsegs = std::vector of length 1, capacity 1 = {0x100632afd78}}, {m_commit = 1551671925,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632ae848}}, {m_commit = 1551672075, m_rsegs = std::vector of length 1, capacity 1 = {0x100632d2458}}, {

m_commit = 1551672293, m_rsegs = std::vector of length 1, capacity 1 = {0x100632bcdd8}}, {m_commit = 1551671735, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632b17a8}}, {m_commit = 1551672193, m_rsegs = std::vector of length 1, capacity 1 = {0x100632cad58}}, {m_commit = 1551672007,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632c7d08}}, {m_commit = 1551671967, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b2908}}, {

m_commit = 1551671979, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c45d8}}, {m_commit = 1551671983, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632c8208}}, {m_commit = 1551671903, m_rsegs = std::vector of length 1, capacity 1 = {0x100632d8b98}}, {m_commit = 1551671889,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632a6898}}, {m_commit = 1551671841, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b93e8}}, {

m_commit = 1551672055, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c28e8}}, {m_commit = 1551671757, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632b70e8}}, {m_commit = 1551671775, m_rsegs = std::vector of length 1, capacity 1 = {0x100632ae348}}, {m_commit = 1551672081,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632c4e38}}, {m_commit = 1551671939, m_rsegs = std::vector of length 1, capacity 1 = {0x100632cf218}}, {

m_commit = 1551671907, m_rsegs = std::vector of length 1, capacity 1 = {0x100632a6d98}}, {m_commit = 1551671959, m_rsegs = std::vector of length 1, capacity 1 = {

Type <RET> for more, q to quit, c to continue without paging

0x100632cf738}}, {m_commit = 1551671941, m_rsegs = std::vector of length 1, capacity 1 = {0x100632d9d28}}, {m_commit = 1551671799,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632d9218}}, {m_commit = 1551671875, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b1f08}}, {

m_commit = 1551671873, m_rsegs = std::vector of length 1, capacity 1 = {0x100632cfcd8}}, {m_commit = 1551672057, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632d2958}}, {m_commit = 1551671971, m_rsegs = std::vector of length 1, capacity 1 = {0x100632d06d8}}, {m_commit = 1551671887,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632b3e38}}, {m_commit = 1551671899, m_rsegs = std::vector of length 1, capacity 1 = {0x100632db428}}, {

m_commit = 1551671905, m_rsegs = std::vector of length 1, capacity 1 = {0x100632cd808}}, {m_commit = 1551671929, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632b4558}}, {m_commit = 1551671957, m_rsegs = std::vector of length 1, capacity 1 = {0x100632ca228}}, {m_commit = 1551671935,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632b8db8}}, {m_commit = 1551671945, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c0998}}, {

m_commit = 1551672145, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b2e08}}, {m_commit = 1551671949, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632a4598}}, {m_commit = 1551671943, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c66a8}}, {m_commit = 1551672477,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632c96f8}}, {m_commit = 1551672503, m_rsegs = std::vector of length 1, capacity 1 = {0x100632be6d8}}, {

m_commit = 1551672433, m_rsegs = std::vector of length 1, capacity 1 = {0x100632dadf8}}, {m_commit = 1551672317, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632dba58}}, {m_commit = 1551671849, m_rsegs = std::vector of length 1, capacity 1 = {0x100632a4a98}}, {m_commit = 1551671791,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632ada78}}, {m_commit = 1551672305, m_rsegs = std::vector of length 1, capacity 1 = {0x100632cec08}}, {

m_commit = 1551672377, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c8d38}}, {m_commit = 1551673143, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632b52e8}}, {m_commit = 1551672027, m_rsegs = std::vector of length 0, capacity 0}, {m_commit = 1551672451, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632bc598}}, {m_commit = 1551672341, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c9bf8}}, {m_commit = 1551672367,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632ce0d8}}, {m_commit = 1551672257, m_rsegs = std::vector of length 1, capacity 1 = {0x100632d3e88}}, {

m_commit = 1551672251, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c4938}}, {m_commit = 1551671991, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632af748}}, {m_commit = 1551672481, m_rsegs = std::vector of length 1, capacity 1 = {0x100632bca08}}, {m_commit = 1551671919,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632d97e8}}, {m_commit = 1551672527, m_rsegs = std::vector of length 1, capacity 1 = {0x100632bfe68}}, {

m_commit = 1551671973, m_rsegs = std::vector of length 1, capacity 1 = {0x100632d2e58}}, {m_commit = 1551672065, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632c2d78}}, {m_commit = 1551672437, m_rsegs = std::vector of length 1, capacity 1 = {0x100632d0308}}, {m_commit = 1551672679,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632c38a8}}, {m_commit = 1551672387, m_rsegs = std::vector of length 1, capacity 1 = {0x100632d3728}}, {

m_commit = 1551671893, m_rsegs = std::vector of length 1, capacity 1 = {0x100632cd308}}, {m_commit = 1551672397, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632c5548}}, {m_commit = 1551671977, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b89e8}}, {m_commit = 1551672465,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632c7808}}, {m_commit = 1551672105, m_rsegs = std::vector of length 1, capacity 1 = {0x100632b0518}}, {

m_commit = 1551672177, m_rsegs = std::vector of length 1, capacity 1 = {0x100632a5738}}, {m_commit = 1551672115, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632bf968}}, {m_commit = 1551672165, m_rsegs = std::vector of length 1, capacity 1 = {0x100632d0d08}}, {m_commit = 1551672093,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632b12a8}}, {m_commit = 1551672215, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c6ba8}}, {

m_commit = 1551672037, m_rsegs = std::vector of length 1, capacity 1 = {0x100632ca728}}, {m_commit = 1551672453, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632b2408}}, {m_commit = 1551672047, m_rsegs = std::vector of length 1, capacity 1 = {0x100632cb258}}, {m_commit = 1551672285,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632a5238}}, {m_commit = 1551672063, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c10f8}}, {

m_commit = 1551672181, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c8708}}, {m_commit = 1551672271, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632cc908}}, {m_commit = 1551672013, m_rsegs = std::vector of length 1, capacity 1 = {0x100632cce08}}, {m_commit = 1551672017,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632d1708}}, {m_commit = 1551672333, m_rsegs = std::vector of length 1, capacity 1 = {0x100632cdbd8}}, {

m_commit = 1551672301, m_rsegs = std::vector of length 1, capacity 1 = {0x100632bd2d8}}, {m_commit = 1551672077, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632c5a48}}, {m_commit = 1551672365, m_rsegs = std::vector of length 1, capacity 1 = {0x100632bdcd8}}, {m_commit = 1551672133,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632da1b8}}, {m_commit = 1551672153, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c33a8}}, {

m_commit = 1551672023, m_rsegs = std::vector of length 1, capacity 1 = {0x100632bd7d8}}, {m_commit = 1551672533, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632d3228}}, {m_commit = 1551672209, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c60e8}}, {m_commit = 1551672595,

Type <RET> for more, q to quit, c to continue without paging

m_rsegs = std::vector of length 1, capacity 1 = {0x100632bf338}}, {m_commit = 1551671953, m_rsegs = std::vector of length 1, capacity 1 = {0x100632d1208}}, {

m_commit = 1551672621, m_rsegs = std::vector of length 1, capacity 1 = {0x100632be1d8}}, {m_commit = 1551672099, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632bed08}}, {m_commit = 1551672069, m_rsegs = std::vector of length 1, capacity 1 = {0x100632c7308}}, {m_commit = 1551672135,

m_rsegs = std::vector of length 1, capacity 1 = {0x100632aed48}}, {m_commit = 1551672303, m_rsegs = std::vector of length 1, capacity 1 = {0x100632a6268}}, {

m_commit = 1551671947, m_rsegs = std::vector of length 1, capacity 1 = {0x100632da8f8}}, {m_commit = 1551671567, m_rsegs = std::vector of length 1, capacity 1 = {

0x100632b57e8}}}, pq_mutex = {m_impl = {m_lock_word = {<std::__atomic_base<unsigned int>> = {static _S_alignment = 4, _M_i = 1}, <No data fields>},

m_event = 0x100632d7a08, m_policy = {m_count = {m_spins = 0, m_waits = 0, m_calls = 0, m_enabled = false},

m_id = LATCH_ID_PURGE_SYS_PQ}}, m_ptr = 0x0}, truncate = {

current = 0x0, last = 0x0}, heap = 0x100632d7b08}

(gdb)

(gdb)

(gdb)

(gdb) p srv_undo_sources

$2 = false

(gdb) p srv_fast_shutdown

$3 = 0

(gdb) p trx_sys

$4 = {m_max_trx_id = {m_counter = {<std::__atomic_base<unsigned long>> = {static _S_alignment = 8, _M_i = 1051743806}, <No data fields>}},

m_rw_trx_hash_version = {<std::__atomic_base<unsigned long>> = {static _S_alignment = 8, _M_i = 1051743806}, <No data fields>}, m_initialised = true, rseg_history_len = {

m_counter = {<std::__atomic_base<unsigned int>> = {static _S_alignment = 4, _M_i = 137963750}, <No data fields>}}, mutex = {m_impl = {

m_lock_word = {<std::__atomic_base<unsigned int>> = {static _S_alignment = 4, _M_i = 0}, <No data fields>}, m_event = 0x10061bffdf8, m_policy = {m_count = {

m_spins = 0, m_waits = 0, m_calls = 0, m_enabled = false}, m_id = LATCH_ID_TRX_SYS}}, m_ptr = 0x0}, trx_list = {count = 1, start = 0x77abaf9a0030,

end = 0x77abaf9a0030, node = &trx_t::trx_list}, temp_rsegs = {0x1006323ef18, 0x100632271b8, 0x100632432f8, 0x10063230338, 0x1006322a338, 0x1006322bd18, 0x100631f7d58,

0x100631eaf78, 0x10063200578, 0x100631ec0b8, 0x100631bd318, 0x100631a7718, 0x100631f5e98, 0x100631eee18, 0x100631fd6f8, 0x100631fe058, 0x10063168598, 0x10063178858,

0x100631e3ad8, 0x100631e8158, 0x100631e7498, 0x100631e63b8, 0x100631eccb8, 0x100631fab18, 0x100631f4038, 0x10063167218, 0x100631734b8, 0x1006316ccd8, 0x10063243d78,

0x10063230e18, 0x100631fa878, 0x10063203f98, 0x1006312dcd8, 0x1006311fcf8, 0x1006312e158, 0x10063130a98, 0x100631fdd58, 0x100631efb38, 0x100631e4f18, 0x100630e4a18,

0x100630e9e18, 0x10063093d78, 0x10063098e78, 0x10063093898, 0x100630819b8, 0x10063087838, 0x1006308cb78, 0x10063084118, 0x1006307dbd8, 0x10063085a98, 0x10063083cf8,

0x100630803f8, 0x100630dc2b8, 0x100630ebcd8, 0x100630cc2f8, 0x100630d15d8, 0x100630d8058, 0x100630dea18, 0x100630d6c18, 0x100630d4ff8, 0x100630e7778, 0x100630e02d8,

0x100630cbd58, 0x100630ecb78, 0x100630db958, 0x10062fdb638, 0x10063049df8, 0x100630d6f78, 0x100630d2178, 0x1006308d0b8, 0x1006309a678, 0x1006307f738, 0x100630904d8,

0x10063042d18, 0x1006302acb8, 0x10063044cf8, 0x10063043f78, 0x100630959f8, 0x100630857f8, 0x1006308ba38, 0x100630997d8, 0x1006308f518, 0x1006308a8f8, 0x10063086cf8,

0x10062fe8a78, 0x10062fea6f8, 0x10062fd84b8, 0x10062fd6838, 0x10062ff2cd8, 0x10062ff0998, 0x10062fef8b8, 0x10062fd5398, 0x10062ff4718, 0x10062fe9198, 0x10062fe52f8,

0x10062fed098, 0x10062f13a18, 0x10062f31f58, 0x10062fd4eb8, 0x10062fdc5f8, 0x10062fde518, 0x10062ff38d8, 0x10062f8e8f8, 0x10062f8fa38, 0x10062fd8f38, 0x10062fda6d8,

0x10062fde878, 0x10062fe7398, 0x10062fe42d8, 0x10062febef8, 0x10062fd56f8, 0x10062fe7878, 0x10062fda8b8, 0x10062fec798, 0x10062ff1e38, 0x10062fe3918, 0x10062fe1d58,

0x10062ff3458, 0x10062fe8658, 0x10062ff4238, 0x10062f8e538, 0x10062fde038, 0x10062fe7f38, 0x10062f94d78, 0x10062fd5038, 0x10062ff3cf8, 0x10062fd6bf8, 0x10062fe9e58},

rseg_array = {0x100632d8b98, 0x100632d9218, 0x100632d97e8, 0x100632d9d28, 0x100632da1b8, 0x100632da8f8, 0x100632dadf8, 0x100632db428, 0x100632dba58, 0x100632cc908,

0x100632cce08, 0x100632cd308, 0x100632cd808, 0x100632cdbd8, 0x100632ce0d8, 0x100632ce5d8, 0x100632cec08, 0x100632cf738, 0x100632cfcd8, 0x100632d0308, 0x100632d06d8,

0x100632d0d08, 0x100632d1208, 0x100632d1708, 0x100632d2458, 0x100632d2958, 0x100632d2e58, 0x100632d3228, 0x100632d3728, 0x100632d3e88, 0x100632c45d8, 0x100632c4938,

0x100632c4e38, 0x100632cf218, 0x100632c60e8, 0x100632c66a8, 0x100632c6ba8, 0x100632c7308, 0x100632c7808, 0x100632c7d08, 0x100632c8208, 0x100632c8708, 0x100632c8d38,

0x100632c96f8, 0x100632c9bf8, 0x100632ca228, 0x100632ca728, 0x100632cad58, 0x100632cb258, 0x100632cbae8, 0x100632bc598, 0x100632bca08, 0x100632bcdd8, 0x100632bd2d8,

0x100632bd7d8, 0x100632bdcd8, 0x100632be1d8, 0x100632be6d8, 0x100632bed08, 0x100632bf338, 0x100632bf968, 0x100632bfe68, 0x100632c0498, 0x100632c0998, 0x100632c10f8,

0x100632c5548, 0x100632c5a48, 0x100632c28e8, 0x100632c2d78, 0x100632c33a8, 0x100632c38a8, 0x100632c3da8, 0x100632b4558, 0x100632b4a58, 0x100632b52e8, 0x100632b57e8,

0x100632b5bb8, 0x100632b5f88, 0x100632b65b8, 0x100632b6be8, 0x100632b70e8, 0x100632b75e8, 0x100632b79b8, 0x100632b7fe8, 0x100632b84e8, 0x100632b89e8, 0x100632b8db8,

0x100632b93e8, 0x100632b9a18, 0x100632b9de8, 0x100632ba548, 0x100632bab78, 0x100632bb1a8, 0x100632bb578, 0x100632bbba8, 0x100632bbf28, 0x100632ac918, 0x100632acf48,

0x100632ad578, 0x100632ada78, 0x100632ade48, 0x100632ae348, 0x100632ae848, 0x100632aed48, 0x100632af378, 0x100632af748, 0x100632afd78, 0x100632b0148, 0x100632b0518,

0x100632b0a18, 0x100632b12a8, 0x100632b17a8, 0x100632b1f08, 0x100632b2408, 0x100632b2908, 0x100632b2e08, 0x100632b3438, 0x100632b3938, 0x100632b3e38, 0x100632a4598,

0x100632a4a98, 0x100632a4e68, 0x100632a5238, 0x100632a5738, 0x100632a5d68, 0x100632a6268, 0x100632a6898, 0x100632a6d98}, rw_trx_hash = {hash = {array = {level = {

0x100632a7290, 0x779e34158048, 0x0, 0x0}, size_of_element = 8}, alloc = {pinbox = {pinarray = {level = {0x10063258e78, 0x779ea8155e88, 0x0, 0x0},

size_of_element = 184}, free_func = 0x28f8bc44d0 <alloc_free>, free_func_arg = 0x28f95a94a8 <trx_sys+2728>, free_ptr_offset = 16, pinstack_top_ver = 1684078815,

pins_in_array = 385}, top = 0x779f24164118 "\271\001\001\360\236w", element_size = 104, mallocs = 0, constructor = 0x28f89c6040

<rw_trx_hash_t::rw_trx_hash_constructor(unsigned char*)>, destructor = 0x28f89c60f8 <rw_trx_hash_t::rw_trx_hash_destructor(unsigned char*)>}, get_key = 0x0,

initializer = 0x28f89c61f0 <rw_trx_hash_t::rw_trx_hash_initializer(st_lf_hash*, rw_trx_hash_element_t*, trx_t*)>, hash_function = 0x28f8bc5250 <calc_hash>,

charset = 0x28f95afd60 <my_charset_bin>, key_offset = 0, key_length = 8, element_size = 72, flags = 1, size = 512, count = 0}}, recovered_wsrep_xid = {formatID = 1,

gtrid_length = 0, bqual_length = 0, data = '\000' <repeats 127 times>}, recovered_binlog_offset = 0, recovered_binlog_filename = '\000' <repeats 511 times>}

Just ran the server though the sysbench tests:
oltp_update_non_index oltp_read_only oltp_point_select
SIGTERM for a normal shutdown started 4 hrs ago
Attachments
Issue Links
 relates to

MDEV29984 innodb_fast_shutdown=0 fails to report change buffer merge progress
 Closed

MDEV12323 Rollback progress log messages during crash recovery are intermixed with unrelated log messages
 Closed

MDEV14486 InnoDB hang on shutdown
 Confirmed

MDEV16260 Scale the purge effort according to the workload
 Open

MDEV21751 innodb_fast_shutdown=0 can be unnecessarily slow
 Closed