auditlog lead to mysql hang
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Activity
Show:
Lalit Choudhary April 16, 2019 at 7:46 AM
We cannot reproduce described behavior. Please upgrade to the latest version of Percona software and test with it. In case if you are still able to reproduce the issue, please, update the report with the repeatable test case.
Lalit Choudhary October 29, 2018 at 12:13 PM
Hi luojia,
Thank you for the report.
Tested this with percona server 5.7.23 and audit plugin by running concurrent read-write load, cannot reproduce the described behavior.
Send full my.cnf and mysql error log entries at the time of the crash for further investigation.
Also, it will good if you can upgrade percona server to the latest version.
Cannot Reproduce
Details
Details
Assignee
Unassigned
UnassignedReporter
luojia
luojiaLabels
Affects versions
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created October 8, 2018 at 9:40 AM
Updated March 6, 2024 at 12:47 PM
Resolved April 16, 2019 at 7:46 AM
mysql version:mysql Ver 14.14 Distrib 5.7.21-21, for Linux (x86_64) using 6.0
mysql hang,can't connect
the pstack :
Thread 3 (Thread 0x7f76bbb97700 (LWP 47010)):
#0 0x00007f9684f9a334 in __lll_lock_wait () from /lib64/libpthread.so.0
#1 0x00007f9684f9560e in _L_lock_995 () from /lib64/libpthread.so.0
#2 0x00007f9684f95576 in pthread_mutex_lock () from /lib64/libpthread.so.0
#3 0x0000000000c5cbb8 in THD::init() ()
#4 0x0000000000c5f8f9 in THD::THD(bool) ()
#5 0x0000000000e1f79a in Channel_info::create_thd() ()
#6 0x0000000000d6ee0e in Channel_info_tcpip_socket::create_thd() ()
#7 0x0000000000d6b7ef in handle_connection ()
#8 0x0000000000edeb84 in pfs_spawn_thread ()
#9 0x00007f9684f93aa1 in start_thread () from /lib64/libpthread.so.0
#10 0x00007f968328ac4d in clone () from /lib64/libc.so.6
Thread 2 (Thread 0x7f76bbb16700 (LWP 47012)):
#0 0x00007f9684f9a334 in __lll_lock_wait () from /lib64/libpthread.so.0
#1 0x00007f9684f9560e in _L_lock_995 () from /lib64/libpthread.so.0
#2 0x00007f9684f95576 in pthread_mutex_lock () from /lib64/libpthread.so.0
#3 0x0000000000c5cbb8 in THD::init() ()
#4 0x0000000000c5f8f9 in THD::THD(bool) ()
#5 0x0000000000e1f79a in Channel_info::create_thd() ()
#6 0x0000000000d6ee0e in Channel_info_tcpip_socket::create_thd() ()
#7 0x0000000000d6b7ef in handle_connection ()
#8 0x0000000000edeb84 in pfs_spawn_thread ()
#9 0x00007f9684f93aa1 in start_thread () from /lib64/libpthread.so.0
#10 0x00007f968328ac4d in clone () from /lib64/libc.so.6
Thread 1 (Thread 0x7f96853b47e0 (LWP 82884)):
#0 0x00007f9684f9a334 in __lll_lock_wait () from /lib64/libpthread.so.0
#1 0x00007f9684f9560e in _L_lock_995 () from /lib64/libpthread.so.0
#2 0x00007f9684f95576 in pthread_mutex_lock () from /lib64/libpthread.so.0
#3 0x0000000000c5cbb8 in THD::init() ()
#4 0x0000000000c5f8f9 in THD::THD(bool) ()
#5 0x0000000000d16296 in create_thd(bool, bool, bool, unsigned int) ()
#6 0x000000000079d84b in mysql_audit_notify(mysql_event_server_shutdown_subclass_t, mysql_server_shutdown_reason_t, int) ()
#7 0x0000000000797417 in mysqld_main(int, char**) ()
#8 0x00007f96831c0d20 in __libc_start_main () from /lib64/libc.so.6
#9 0x000000000078b195 in _start ()
my.cnf:
loose_audit_log_policy=NONE
loose_audit_log_format=JSON