Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4910

auditlog lead to mysql hang

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Cannot Reproduce
    • Affects Version/s: 5.7.x
    • Fix Version/s: None
    • Component/s: None

      Description

      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

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              luojia luojia
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: