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

Galera node freezes when query_response_time plugin loading

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.4.12
    • Fix Version/s: 10.4
    • Component/s: Plugins, Server
    • Environment:
      debian 9 & 10
      docker containters & hardware servers too

      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

            Activity

              People

              Assignee:
              holyfoot Alexey Botchkov
              Reporter:
              xeonvs Max Irgiznov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: