SET GLOBAL innodb_max_purge_lag_wait=… hangs if innodb_read_only=ON

# # mysqld options required for replay:  --innodb-force-recovery=6

SET GLOBAL innodb_undo_log_truncate=1;

mariadbd: /test/10.5_dbg/storage/innobase/srv/srv0srv.cc:1351: void srv_wake_purge_thread_if_not_active(): Assertion `!srv_read_only_mode' failed.

Core was generated by `/test/MD040723-mariadb-10.5.22-linux-x86_64-dbg/bin/mariadbd --no-defaults --in'.

Program terminated with signal SIGABRT, Aborted.

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

[Current thread is 1 (Thread 0x1503332bd700 (LWP 1968710))]

(gdb) bt

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#1  0x000015035285b859 in __GI_abort () at abort.c:79

#2  0x000015035285b729 in __assert_fail_base (fmt=0x1503529f1588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55d0439638dd "!srv_read_only_mode", file=0x55d0439b7b00 "/test/10.5_dbg/storage/innobase/srv/srv0srv.cc", line=1351, function=<optimized out>) at assert.c:92

#3  0x000015035286cfd6 in __GI___assert_fail (assertion=assertion@entry=0x55d0439638dd "!srv_read_only_mode", file=file@entry=0x55d0439b7b00 "/test/10.5_dbg/storage/innobase/srv/srv0srv.cc", line=line@entry=1351, function=function@entry=0x55d0439b7b78 "void srv_wake_purge_thread_if_not_active()") at assert.c:101

#4  0x000055d043341033 in srv_wake_purge_thread_if_not_active () at /test/10.5_dbg/storage/innobase/srv/srv0srv.cc:1351

#5  0x000055d04312ed31 in innodb_undo_log_truncate_update (thd=<optimized out>, save=<optimized out>) at /test/10.5_dbg/storage/innobase/handler/ha_innodb.cc:19691

#6  0x000055d042b7e485 in sys_var_pluginvar::global_update (this=0x55d0464104e8, thd=0x15031c000d48, var=0x15031c012f38) at /test/10.5_dbg/sql/sql_plugin.cc:3628

#7  0x000055d042a94a9a in sys_var::update (this=0x55d0464104e8, thd=0x15031c000d48, var=0x15031c012f38) at /test/10.5_dbg/sql/set_var.cc:207

#8  0x000055d042a94fe7 in set_var::update (this=<optimized out>, thd=<optimized out>) at /test/10.5_dbg/sql/set_var.cc:859

#9  0x000055d042a96279 in sql_set_variables (thd=thd@entry=0x15031c000d48, var_list=var_list@entry=0x15031c005c88, free=free@entry=true) at /test/10.5_dbg/sql/set_var.cc:746

#10 0x000055d042b753be in mysql_execute_command (thd=thd@entry=0x15031c000d48) at /test/10.5_dbg/sql/sql_parse.cc:5112

#11 0x000055d042b5fe55 in mysql_parse (thd=thd@entry=0x15031c000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1503332bc310, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:8106

#12 0x000055d042b6db08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x15031c000d48, packet=packet@entry=0x15031c00a9e9 "SET GLOBAL innodb_undo_log_truncate=1", packet_length=packet_length@entry=37, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_class.h:1320

#13 0x000055d042b703c6 in do_command (thd=0x15031c000d48) at /test/10.5_dbg/sql/sql_parse.cc:1375

#14 0x000055d042cab37e in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55d046b98258, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1416

#15 0x000055d042cab84c in handle_one_connection (arg=0x55d046b98258) at /test/10.5_dbg/sql/sql_connect.cc:1318

#16 0x0000150352d6c609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#17 0x0000150352958133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

mariadbd: /test/11.2_dbg/storage/innobase/srv/srv0srv.cc:1127: void srv_wake_purge_thread_if_not_active(): Assertion `!srv_read_only_mode' failed.

Core was generated by `/test/MD270723-mariadb-11.2.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --inn'.

Program terminated with signal SIGABRT, Aborted.

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

[Current thread is 1 (Thread 0x146b81a2b700 (LWP 598206))]

(gdb) bt

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#1  0x0000146ba0fbf859 in __GI_abort () at abort.c:79

#2  0x0000146ba0fbf729 in __assert_fail_base (fmt=0x146ba1155588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x562a3efbe0ee "!srv_read_only_mode", file=0x562a3f00ce10 "/test/11.2_dbg/storage/innobase/srv/srv0srv.cc", line=1127, function=<optimized out>) at assert.c:92

#3  0x0000146ba0fd0fd6 in __GI___assert_fail (assertion=assertion@entry=0x562a3efbe0ee "!srv_read_only_mode", file=file@entry=0x562a3f00ce10 "/test/11.2_dbg/storage/innobase/srv/srv0srv.cc", line=line@entry=1127, function=function@entry=0x562a3f00d390 "void srv_wake_purge_thread_if_not_active()") at assert.c:101

#4  0x0000562a3e9b25bd in srv_wake_purge_thread_if_not_active () at /test/11.2_dbg/storage/innobase/srv/srv0srv.cc:1127

#5  0x0000562a3e7bf696 in innodb_undo_log_truncate_update (thd=<optimized out>, save=<optimized out>) at /test/11.2_dbg/storage/innobase/handler/ha_innodb.cc:19340

#6  0x0000562a3e1f690d in sys_var_pluginvar::global_update (this=0x562a42100810, thd=0x146b6c000d48, var=0x146b6c013410) at /test/11.2_dbg/sql/sql_plugin.cc:3635

#7  0x0000562a3e0f7ae0 in sys_var::update (this=0x562a42100810, thd=0x146b6c000d48, var=0x146b6c013410) at /test/11.2_dbg/sql/set_var.cc:207

#8  0x0000562a3e0f8023 in set_var::update (this=<optimized out>, thd=<optimized out>) at /test/11.2_dbg/sql/set_var.cc:864

#9  0x0000562a3e0f924a in sql_set_variables (thd=thd@entry=0x146b6c000d48, var_list=var_list@entry=0x146b6c005fe8, free=free@entry=true) at /test/11.2_dbg/sql/set_var.cc:746

#10 0x0000562a3e1db77a in mysql_execute_command (thd=thd@entry=0x146b6c000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/11.2_dbg/sql/sql_parse.cc:4803

#11 0x0000562a3e1c773b in mysql_parse (thd=thd@entry=0x146b6c000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x146b81a2a2c0) at /test/11.2_dbg/sql/sql_parse.cc:7800

#12 0x0000562a3e1d4c00 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x146b6c000d48, packet=packet@entry=0x146b6c00af49 "SET GLOBAL innodb_undo_log_truncate=1", packet_length=packet_length@entry=37, blocking=blocking@entry=true) at /test/11.2_dbg/sql/sql_class.h:1374

#13 0x0000562a3e1d70b8 in do_command (thd=0x146b6c000d48, blocking=blocking@entry=true) at /test/11.2_dbg/sql/sql_parse.cc:1405

#14 0x0000562a3e33c717 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x562a4236a848, put_in_cache=put_in_cache@entry=true) at /test/11.2_dbg/sql/sql_connect.cc:1445

#15 0x0000562a3e33cbe6 in handle_one_connection (arg=0x562a4236a848) at /test/11.2_dbg/sql/sql_connect.cc:1347

#16 0x0000146ba14d0609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#17 0x0000146ba10bc133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95