Details
Minor Description
If the configuration file on the galera node has plugin_load_add=query_response_time and this plugin was previously installed via INSTALL SONAME 'query_response_time' on another node, the current node freezes.
Simple steps for reproduce:
1. install and bootstrap mariadb-10.4 galera node
2. on bootstrap node do mysql> INSTALL SONAME 'query_response_time';
3. on second node add to config plugin_load_add=query_response_time then start mysqld aganin. After SST it freezes on InnoDB: Buffer pool(s) load completed
Freeze point details:
#strace -p 123
|
futex(0x56214e17a220, FUTEX_WAIT_PRIVATE, 2, NULL
|
#gdb mysqld -p 123
|
0x00007fd1df9ba29c in __lll_lock_wait () from /lib/x86_64-linux-gnu/libpthread.so.0 |
(gdb) where
|
#0 0x00007fd1df9ba29c in __lll_lock_wait () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#1 0x00007fd1df9b387a in pthread_mutex_lock () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#2 0x000056214d2b81f4 in plugin_foreach_with_mask(THD*, char (*)(THD*, st_plugin_int*, void*), int, unsigned int, void*) ()
|
#3 0x000056214d3840a5 in mysql_audit_acquire_plugins(THD*, unsigned long*) ()
|
#4 0x000056214d38456f in mysql_audit_notify(THD*, unsigned int, void const*) ()
|
#5 0x000056214d25eed5 in THD::raise_condition(unsigned int, char const*, Sql_state_errno_level::enum_warning_level, Sql_user_condition_identity const&, char const*) ()
|
#6 0x000056214d1f2717 in my_message_sql ()
|
#7 0x000056214d91fc1f in my_error ()
|
#8 0x000056214d2b663a in ?? ()
|
#9 0x000056214d2b6bce in ?? ()
|
#10 0x000056214d2bba3d in plugin_init(int*, char**, int) ()
|
#11 0x000056214d1f8a31 in ?? ()
|
#12 0x000056214d1fcec9 in mysqld_main(int, char**) ()
|
#13 0x00007fd1def0c09b in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6
|
#14 0x000056214d1f13ca in _start () |
Standalone node don't affected.
Workaround: exclude plugin_load_add from config file or remove plugin.
Attachments
Issue Links
- relates to
-
MDEV-32626 Server hangs during startup with plugin_load_add=server_audit when plugin is already loaded with INSTALL SONAME
-
- Closed
-
-
-
- Closed
-