Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

throw exception in mysql server 8.0.30 #257

Open
zhengmuzhou opened this issue Feb 22, 2023 · 0 comments
Open

throw exception in mysql server 8.0.30 #257

zhengmuzhou opened this issue Feb 22, 2023 · 0 comments

Comments

@zhengmuzhou
Copy link

zhengmuzhou commented Feb 22, 2023

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant