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

SET GLOBAL server_audit_logging=ON deadlock due to LOCK_global_system_variables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.4.8
    • Fix Version/s: 10.4
    • Component/s: Plugins
    • Labels:
      None

      Description

      INSTALL PLUGIN server_audit SONAME 'server_audit.so';
      SET GLOBAL server_audit_logging=ON;

      #0  __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135
      #1  0x00007ffa57d4ae01 in _L_lock_1093 () from /usr/lib64/libpthread.so.0
      #2  0x00007ffa57d4ada2 in __GI___pthread_mutex_lock (mutex=mutex@entry=0x7ffa59800600 <LOCK_global_system_variables>) at ../nptl/pthread_mutex_lock.c:133
      #3  0x00007ffa587ad083 in inline_mysql_mutex_lock (src_file=0x7ffa58ead250 "/data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/sql_plugin.cc", src_line=3037, 
          that=<optimized out>) at /data01/jinmh/mdb_4.0/mariadb-10.4.8/include/mysql/psi/mysql_thread.h:712
      #4  sync_dynamic_session_variables (thd=thd@entry=0x7ff8c0002ea8, global_lock=global_lock@entry=true)
          at /data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/sql_plugin.cc:3037
      #5  0x00007ffa587ad12c in intern_sys_var_ptr (thd=0x7ff8c0002ea8, offset=128, global_lock=<optimized out>)
          at /data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/sql_plugin.cc:3104
      #6  0x00007ff9901f3d25 in get_loc_info (thd=0x7ff8c0002ea8) at /data01/jinmh/mdb_4.0/mariadb-10.4.8/plugin/server_audit/server_audit.c:953
      #7  mark_always_logged (thd=0x7ff8c0002ea8) at /data01/jinmh/mdb_4.0/mariadb-10.4.8/plugin/server_audit/server_audit.c:2594
      #8  update_logging (thd=0x7ff8c0002ea8, var=<optimized out>, var_ptr=<optimized out>, save=<optimized out>)
          at /data01/jinmh/mdb_4.0/mariadb-10.4.8/plugin/server_audit/server_audit.c:2864
      #9  0x00007ffa587ad84b in sys_var_pluginvar::global_update (this=0x7ff90c0fbf58, thd=0x7ff8c0002ea8, var=0x7ff8c000acc8)
          at /data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/sql_plugin.cc:3567
      #10 0x00007ffa58703033 in sys_var::update (this=0x7ff90c0fbf58, thd=0x7ff8c0002ea8, var=0x7ff8c000acc8)
          at /data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/set_var.cc:208
      #11 0x00007ffa58703567 in set_var::update (this=<optimized out>, thd=<optimized out>) at /data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/set_var.cc:837
      #12 0x00007ffa587048c9 in sql_set_variables (thd=thd@entry=0x7ff8c0002ea8, var_list=0x7ff8c000a018, var_list@entry=0x0, free=free@entry=true)
          at /data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/set_var.cc:740
      #13 0x00007ffa587a2a87 in mysql_execute_command (thd=thd@entry=0x7ff8c0002ea8) at /data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/sql_parse.cc:4964
      #14 0x00007ffa587b25f8 in Execute_sql_statement::execute_server_code (this=<optimized out>, thd=0x7ff8c0002ea8)
          at /data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/sql_prepare.cc:3757
      #15 0x00007ffa587b6141 in Prepared_statement::execute_server_runnable (this=this@entry=0x7ff8ca7f75a0, 
          server_runnable=server_runnable@entry=0x7ff8ca7f7990) at /data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/sql_prepare.cc:4452
      #16 0x00007ffa587b6ff3 in Ed_connection::execute_direct (this=this@entry=0x7ff8ca7f8260, server_runnable=server_runnable@entry=0x7ff8ca7f7990)
          at /data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/sql_prepare.cc:5041
      #17 0x00007ffa587b70cf in Ed_connection::execute_direct (this=this@entry=0x7ff8ca7f8260, sql_text=...)
          at /data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/sql_prepare.cc:5009
      #18 0x00007ff9a9d40223 in mdb::Mdb_inner_caller::execute_query (this=0x7ff8c0000f40, sql_text=..., result=result@entry=0x7ff8ca7f86b0, 
          errmsg=errmsg@entry=0x7ff8ca7f86d0) at /data01/jinmh/mdb_4.0/mariadb-10.4.8/storage/mdb/src/handler/mdb_inner_caller.cc:269
      #19 0x00007ff9a9ea6223 in mdb::CMiscWorker::exec_dmdb_sql (param=param@entry=0x7ff9cc1fa900)
          at /data01/jinmh/mdb_4.0/mariadb-10.4.8/storage/mdb/src/rpl/mdb_misc_worker.cpp:192
      #20 0x00007ff9a9eb32ee in mdb::handle_forward_sql (p=0x7ff9cc1fa900)
          at /data01/jinmh/mdb_4.0/mariadb-10.4.8/storage/mdb/src/session/mdb_session_service.cc:81
      #21 0x00007ffa57d48dd5 in start_thread (arg=0x7ff8ca7f9700) at pthread_create.c:307
      #22 0x00007ffa55855ead in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              holyfoot Alexey Botchkov
              Reporter:
              yyjbb jinmh
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: