AUDIT Plugin for MySQL. See wiki and readme for description. If you find the plugin useful, please star us on GitHub. We love stars and it's a great way to show your feedback.
audit_offsets=9408, 9448, 4944, 6424, 1288, 0, 0, 32, 64, 160, 1376, 9548, 6048, 4248, 4256, 4260, 7704, 1576, 32, 8664, 8704, 8688, 12440, 140, 664, 328
when I start mysql server, throw the exception as follow
2023-02-24T01:09:52.653855Z 0 [System] [MY-010910] [Server] /application/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.30-debug) Source distribution.
2023-02-24T01:16:16.865731Z 0 [System] [MY-010116] [Server] /application/mysql/bin/mysqld (mysqld 8.0.30-debug) starting as process 31155
2023-02-24T01:16:16.891344Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-02-24T01:16:17.312289Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-02-24T01:16:18.464794Z 0 [Warning] [MY-000080] [Server] option 'audit-json-file-bufsize': signed value 0 adjusted to 1.
2023-02-24T01:16:18.464850Z 0 [Warning] [MY-000080] [Server] option 'plugin-audit-json-file-bufsize': signed value 0 adjusted to 1.
mysqld: /application/mysql-8.0.30/include/thr_mutex.h:187: int my_mutex_lock(my_mutex_t, const char, uint): Assertion `mp->m_u.m_safe_ptr != nullptr' failed.
01:16:19 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0xb3792c0
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 = 7ffda12f5140 thread_stack 0x100000
/application/mysql/bin/mysqld(my_print_stacktrace(unsigned char const, unsigned long)+0x43) [0x4910998]
/application/mysql/bin/mysqld(print_fatal_signal(int)+0x280) [0x3537a27]
/application/mysql/bin/mysqld(handle_fatal_signal+0x75) [0x3537c2a]
/lib64/libpthread.so.0(+0xf630) [0x7f73f7382630]
/lib64/libc.so.6(gsignal+0x37) [0x7f73f5c65387]
/lib64/libc.so.6(abort+0x148) [0x7f73f5c66a78]
/lib64/libc.so.6(+0x2f1a6) [0x7f73f5c5e1a6]
/lib64/libc.so.6(+0x2f252) [0x7f73f5c5e252]
/application/mysql/bin/mysqld() [0x3424f3c]
/application/mysql/bin/mysqld() [0x342509b]
/application/mysql/bin/mysqld(thd_security_context+0x299) [0x3425b1f]
/application/mysql/lib/plugin/libaudit_plugin.so(+0x10b38) [0x7f73e453cb38]
/application/mysql/lib/plugin/libaudit_plugin.so(+0x11c48) [0x7f73e453dc48]
/application/mysql/lib/plugin/libaudit_plugin.so(+0x12778) [0x7f73e453e778]
/application/mysql/bin/mysqld(initialize_audit_plugin(st_plugin_int)+0x21c) [0x353a79b]
/application/mysql/bin/mysqld() [0x333d296]
/application/mysql/bin/mysqld() [0x333da10]
/application/mysql/bin/mysqld(plugin_register_dynamic_and_init_all(int*, char, int)+0x282) [0x333eaca]
/application/mysql/bin/mysqld() [0x3156482]
/application/mysql/bin/mysqld(mysqld_main(int, char)+0x1801) [0x315a3bc]
/application/mysql/bin/mysqld(main+0x20) [0x31479e6]
/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f73f5c51555]
/application/mysql/bin/mysqld() [0x314790a]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): is an invalid pointer
Connection ID (thread ID): 0
Status: NOT_KILLED
audit plugin version is audit-plugin-mysql-8.0-1.1.13-1008-linux-x86_64 and my.cnf config as follow: [client] port=3306 socket=/application/mysql/run/mysql.sock [mysqld] character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci tmpdir = /application/mysql/tmp basedir=/application/mysql datadir=/application/mysql/data log-error=/application/mysql/log/alert.log socket=/application/mysql/run/mysql.sock symbolic-links=0 plugin-load=AUDIT=libaudit_plugin.so
audit_offsets=9472, 9512, 4968, 6452, 1288, 0, 0, 32, 64, 160, 1376, 9612, 6072, 4248, 4256, 4260, 7736, 1576, 32, 8696, 8736, 8720, 12552, 140, 664
audit_offsets=9408, 9448, 4944, 6424, 1288, 0, 0, 32, 64, 160, 1376, 9548, 6048, 4248, 4256, 4260, 7704, 1576, 32, 8664, 8704, 8688, 12440, 140, 664, 328 when I start mysql server, throw the exception as follow 2023-02-24T01:09:52.653855Z 0 [System] [MY-010910] [Server] /application/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.30-debug) Source distribution. 2023-02-24T01:16:16.865731Z 0 [System] [MY-010116] [Server] /application/mysql/bin/mysqld (mysqld 8.0.30-debug) starting as process 31155 2023-02-24T01:16:16.891344Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-02-24T01:16:17.312289Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-02-24T01:16:18.464794Z 0 [Warning] [MY-000080] [Server] option 'audit-json-file-bufsize': signed value 0 adjusted to 1. 2023-02-24T01:16:18.464850Z 0 [Warning] [MY-000080] [Server] option 'plugin-audit-json-file-bufsize': signed value 0 adjusted to 1. mysqld: /application/mysql-8.0.30/include/thr_mutex.h:187: int my_mutex_lock(my_mutex_t, const char, uint): Assertion `mp->m_u.m_safe_ptr != nullptr' failed. 01:16:19 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0xb3792c0 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 = 7ffda12f5140 thread_stack 0x100000 /application/mysql/bin/mysqld(my_print_stacktrace(unsigned char const, unsigned long)+0x43) [0x4910998] /application/mysql/bin/mysqld(print_fatal_signal(int)+0x280) [0x3537a27] /application/mysql/bin/mysqld(handle_fatal_signal+0x75) [0x3537c2a] /lib64/libpthread.so.0(+0xf630) [0x7f73f7382630] /lib64/libc.so.6(gsignal+0x37) [0x7f73f5c65387] /lib64/libc.so.6(abort+0x148) [0x7f73f5c66a78] /lib64/libc.so.6(+0x2f1a6) [0x7f73f5c5e1a6] /lib64/libc.so.6(+0x2f252) [0x7f73f5c5e252] /application/mysql/bin/mysqld() [0x3424f3c] /application/mysql/bin/mysqld() [0x342509b] /application/mysql/bin/mysqld(thd_security_context+0x299) [0x3425b1f] /application/mysql/lib/plugin/libaudit_plugin.so(+0x10b38) [0x7f73e453cb38] /application/mysql/lib/plugin/libaudit_plugin.so(+0x11c48) [0x7f73e453dc48] /application/mysql/lib/plugin/libaudit_plugin.so(+0x12778) [0x7f73e453e778] /application/mysql/bin/mysqld(initialize_audit_plugin(st_plugin_int)+0x21c) [0x353a79b] /application/mysql/bin/mysqld() [0x333d296] /application/mysql/bin/mysqld() [0x333da10] /application/mysql/bin/mysqld(plugin_register_dynamic_and_init_all(int*, char, int)+0x282) [0x333eaca] /application/mysql/bin/mysqld() [0x3156482] /application/mysql/bin/mysqld(mysqld_main(int, char)+0x1801) [0x315a3bc] /application/mysql/bin/mysqld(main+0x20) [0x31479e6] /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f73f5c51555] /application/mysql/bin/mysqld() [0x314790a]
Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 0 Status: NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Connection closed by foreign host.
Disconnected from remote host(10.0.9.9) at 06:15:47.
Type `help' to learn how to use Xshell prompt.
how to solve this exception let the audit plugin can normal to use.