[MDEV-22406] Galera node freezes when query_response_time plugin loading Created: 2020-04-29  Updated: 2023-10-30

Status: Open
Project: MariaDB Server
Component/s: Plugins, Server
Affects Version/s: 10.4.12
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Max Irgiznov Assignee: Alexey Botchkov
Resolution: Unresolved Votes: 1
Labels: galera, server, startup
Environment:

debian 9 & 10
docker containters & hardware servers too


Issue Links:
Relates
relates to MDEV-32626 Server hangs during startup with plug... Closed
relates to MDEV-19918 Server hangs or crashes while trying ... Closed

 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.



 Comments   
Comment by Elena Stepanova [ 2020-05-04 ]

Likely to be related to MDEV-19918

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