[MDEV-25248] SET GLOBAL server_audit_logging=ON deadlock due to LOCK_global_system_variables - Jira

XML

Word

Printable

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.4.8, 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Fix Version/s: 10.5, 10.6, 10.11, 11.2, 11.4, 11.6
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

relates to

MDEV-19665 Server hangs on client connection with concurrent setting of server audit variable

Open

MDEV-19672 safe_mutex: Trying to lock mutex, when the mutex was already locked upon concurrent INSTALL SONAME and and SET variable

Confirmed

MDEV-22647 Assertion `!check_audit_mask(mysql_global_audit_mask, event_class_mask)'

Closed

MDEV-29557 Assertion failure or server crash in test_plugin_options upon server audit installation

Open

Activity

People

Assignee:: Sergei Golubchik

Reporter:: jinmh

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2021-03-25 09:56

Updated:: 2024-10-25 15:18

Git Integration

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