Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3.12
-
None
Description
Similar to MDEV-17898 server crash during massive role grants.
10.2.21
Server version: 10.2.21-MariaDB-log |
key_buffer_size=134217728 |
read_buffer_size=131072 |
max_used_connections=0 |
max_threads=502 |
thread_count=9 |
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1234101 K bytes of memory |
Hope that's ok; if not, decrease some variables in the equation. |
Thread pointer: 0x55a049a67238 |
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 = 0x7ffe71dc70c0 thread_stack 0x49000 |
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55a0473d3dbe] |
mysys/stacktrace.c:268(my_print_stacktrace)[0x55a046e5aec5] |
sigaction.c:0(__restore_rt)[0x7f5fcf2c35d0] |
:0(__strcmp_sse42)[0x7f5fcd69f01a] |
/usr/sbin/mysqld(+0x47cc42)[0x55a046c68c42] |
sql/sql_acl.cc:5946(merge_role_db_privileges)[0x55a046c5b80d] |
sql/sql_acl.cc:5717(traverse_role_graph_impl(ACL_USER_BASE*, void*, long, int (*)(ACL_USER_BASE*, void*), int (*)(ACL_USER_BASE*, ACL_ROLE*, void*)) [clone .constprop.293])[0x55a046c5ba14] |
mysys/hash.c:796(my_hash_iterate)[0x55a0473b1d4c] |
sql/sql_acl.cc:7493(grant_reload(THD*))[0x55a046c6a730] |
sql/sql_acl.cc:7248(grant_init())[0x55a046c6aa03] |
sql/mysqld.cc:5947(mysqld_main(int, char**))[0x55a046c38aec] |
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7f5fcd5833d5] |
/usr/sbin/mysqld(+0x4403fd)[0x55a046c2c3fd] |
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x0): |
Connection ID (thread ID): 0 |
Status: NOT_KILLED
|
|
Same with
10.3.12
90121 13:13:57 server_audit: logging started to the file /opt/mariadb/log/mariadb/server_audit_s00249177uv.ads.provinzial.com.log. |
2019-01-21 13:13:57 0 [Note] Server socket created on IP: '::'. |
190121 13:13:57 [ERROR] mysqld got signal 11 ; |
This could be because you hit a bug. It is also possible that this binary |
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs |
|
We will try our best to scrape up some info that will hopefully help |
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail. |
|
Server version: 10.3.12-MariaDB-log |
key_buffer_size=134217728 |
read_buffer_size=131072 |
max_used_connections=0 |
max_threads=502 |
thread_count=9 |
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1234594 K bytes of memory |
Hope that's ok; if not, decrease some variables in the equation. |
|
Thread pointer: 0x560bf08e1618 |
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 = 0x7fff5f5ee620 thread_stack 0x49000 |
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x560bd9180d1e] |
/usr/sbin/mysqld(handle_fatal_signal+0x357)[0x560bd8c21d97] |
/lib64/libpthread.so.0(+0xf5d0)[0x7fd0a5d285d0] |
/lib64/libc.so.6(+0x13e01a)[0x7fd0a410401a] |
/usr/sbin/mysqld(+0x534b72)[0x560bd89dbb72] |
/usr/sbin/mysqld(+0x526fbd)[0x560bd89cdfbd] |
/usr/sbin/mysqld(+0x5271d4)[0x560bd89ce1d4] |
/usr/sbin/mysqld(my_hash_iterate+0x4c)[0x560bd915eaec] |
/usr/sbin/mysqld(_Z12grant_reloadP3THD+0xd27)[0x560bd89ddb07] |
/usr/sbin/mysqld(_Z10grant_initv+0x55)[0x560bd89dddf5] |
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0xc5c)[0x560bd89989dc] |
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7fd0a3fe83d5] |
/usr/sbin/mysqld(+0x4e476d)[0x560bd898b76d] |
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x0): |
Connection ID (thread ID): 0 |
Status: NOT_KILLED
|
|
Optimizer switch: |
gdb extract is attached.
Attachments
Issue Links
- blocks
-
MDEV-17898 FLUSH PRIVILEGES crashes server with segfault
- Closed
- is duplicated by
-
MDEV-18298 Crashes server with segfault during role grants
- Closed