Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22406

Galera node freezes when query_response_time plugin loading

Details

    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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32626 Server hangs during startup with plugin_load_add=server_audit when plugin is already loaded with INSTALL SONAME

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19918 Server hangs or crashes while trying to lock mutex when the mutex was already locked upon startup with server_audit and orphan records in mysql.plugin

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            elenst Elena Stepanova added a comment -

            Likely to be related to MDEV-19918

            elenst Elena Stepanova added a comment - Likely to be related to MDEV-19918

            People

              holyfoot Alexey Botchkov
              xeonvs Max Irgiznov
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.