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

server crashed when I reinstall server_audit plugin after uninstall

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.4(EOL)
    • 10.4(EOL)
    • None
    • None

    Description

      I use the mariadb's server_audit as the audit plugin in mysql, but mysqld server crashed when I reinstall server_audit plugin.

      // mysql shell
      mysql> install plugin server_audit soname 'server_audit.so';
      Query OK, 0 rows affected (0.00 sec)
      mysql> uninstall plugin server_audit;
      Query OK, 0 rows affected, 1 warning (0.01 sec)
      

      quit the connection and reconnect, then reinstall the plugin

      // Some comments here
      mysql> install plugin server_audit soname 'server_audit.so';
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      

      the backtrace is in the following

      Thread pointer: 0x7f20ac000e10
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 7f212c1a0e18 thread_stack 0x40000
      /opt/mysql/mysql-5.7.31/bin/mysqld(my_print_stacktrace+0x4b)[0x55b81cb7e4ec]
      /opt/mysql/mysql-5.7.31/bin/mysqld(handle_fatal_signal+0x3f7)[0x55b81c0e2a5e]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x143c0)[0x7f21386e93c0]
      /opt/mysql/mysql-5.7.31/lib/plugin/server_audit.so(+0x4a95)[0x7f2138ab3a95]
      /opt/mysql/mysql-5.7.31/lib/plugin/server_audit.so(+0x7c53)[0x7f2138ab6c53]
      /opt/mysql/mysql-5.7.31/lib/plugin/server_audit.so(auditing+0xed)[0x7f2138ab7162]
      /opt/mysql/mysql-5.7.31/lib/plugin/server_audit.so(+0xa152)[0x7f2138ab9152]
      /opt/mysql/mysql-5.7.31/bin/mysqld(+0xdd3046)[0x55b81c0e5046]
      /opt/mysql/mysql-5.7.31/bin/mysqld(+0xdd3161)[0x55b81c0e5161]
      /opt/mysql/mysql-5.7.31/bin/mysqld(_Z18mysql_audit_notifyP3THD30mysql_event_general_subclass_tPKciS3_m+0x29b)[0x55b81c0e35db]
      /opt/mysql/mysql-5.7.31/bin/mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0x217c)[0x55b81c8052c9]
      /opt/mysql/mysql-5.7.31/bin/mysqld(_Z10do_commandP3THD+0x522)[0x55b81c802c0c]
      /opt/mysql/mysql-5.7.31/bin/mysqld(handle_connection+0x1f0)[0x55b81c94a61c]
      /opt/mysql/mysql-5.7.31/bin/mysqld(pfs_spawn_thread+0x174)[0x55b81d051761]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x8609)[0x7f21386dd609]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f21382b4163]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (7f20ac008060): install plugin server_audit soname 'server_audit.so'
      Connection ID (thread ID): 3
      Status: NOT_KILLED
      

      mysql version: MySQL 5.7.31
      server_audit is from MariaDB 10.4.6

      I try with MySQL 5.7.39, and the server_audit from MariaDB 10.5.15, the same problem.

      Attachments

        Activity

          People

            holyfoot Alexey Botchkov
            yutellite yuweixing
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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