Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.1.13, 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
10.0.25
Description
We get [ERROR] mysqld got signal 11 quite often. And stack trace looks the same each time. There might be a lot of GRANT... statements running at the same time.
Apr 13 14:26:58 petcat mysqld[32002]: Server version: 10.1.13-MariaDB
|
Apr 13 14:26:58 petcat mysqld[32002]: key_buffer_size=134217728
|
Apr 13 14:26:58 petcat mysqld[32002]: read_buffer_size=131072
|
Apr 13 14:26:58 petcat mysqld[32002]: max_used_connections=59
|
Apr 13 14:26:58 petcat mysqld[32002]: max_threads=1002
|
Apr 13 14:26:58 petcat mysqld[32002]: thread_count=33
|
Apr 13 14:26:58 petcat mysqld[32002]: It is possible that mysqld could use up to
|
Apr 13 14:26:58 petcat mysqld[32002]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4384024 K bytes of memory
|
Apr 13 14:26:58 petcat mysqld[32002]: Hope that's ok; if not, decrease some variables in the equation.
|
Apr 13 14:26:58 petcat mysqld[32002]: Thread pointer: 0x0x7f0e6736c008
|
Apr 13 14:26:58 petcat mysqld[32002]: Attempting backtrace. You can use the following information to find out
|
Apr 13 14:26:58 petcat mysqld[32002]: where mysqld died. If you see no messages after this, something went
|
Apr 13 14:26:58 petcat mysqld[32002]: terribly wrong...
|
Apr 13 14:26:58 petcat mysqld[32002]: stack_bottom = 0x7f0e009f8218 thread_stack 0x48400
|
Apr 13 14:26:59 petcat mysqld[32002]: (my_addr_resolve failure: fork)
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(my_print_stacktrace+0x29) [0x7f1949d56179]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(handle_fatal_signal+0x355) [0x7f19498b5465]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7b82878b8l4d136i6pxmwcc12sfsda33-glibc-2.21/lib/libpthread.so.0(+0x103e0) [0x7f1948edd3e0]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(get_column_grant(THD*, st_grant_info*, char const*, char const*, char const*)+0x
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(+0x4940e4) [0x7f19497a10e4]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(+0x48a9db) [0x7f19497979db]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(get_all_tables(THD*, TABLE_LIST*, Item*)+0x1c7) [0x7f19497a94c7]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(get_schema_tables_result(JOIN*, enum_schema_table_state)+0x287) [0x7f19497ab167]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(JOIN::exec_inner()+0x590) [0x7f1949792310]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(JOIN::exec()+0x44) [0x7f19497944b4]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsig
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x130) [0x7f19497919b0]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(+0x426a18) [0x7f1949733a18]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(mysql_execute_command(THD*)+0x6170) [0x7f194973f830]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x274) [0x7f1949742a54]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x1bb6) [0x7f19
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(do_command(THD*)+0x16b) [0x7f1949745afb]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(do_handle_one_connection(THD*)+0x18c) [0x7f1949806b0c]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(handle_one_connection+0x37) [0x7f1949806ce7]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7b82878b8l4d136i6pxmwcc12sfsda33-glibc-2.21/lib/libpthread.so.0(+0x8484) [0x7f1948ed5484]
|
Apr 13 14:26:59 petcat mysqld[32002]: /nix/store/7b82878b8l4d136i6pxmwcc12sfsda33-glibc-2.21/lib/libc.so.6(clone+0x6d) [0x7f194685ff3d]
|
 |
...
|
Apr 14 15:52:59 petcat mysqld[1554]: (my_addr_resolve failure: fork)
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(my_print_stacktrace+0x29) [0x7f482fca0179]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(handle_fatal_signal+0x355) [0x7f482f7ff465]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7b82878b8l4d136i6pxmwcc12sfsda33-glibc-2.21/lib/libpthread.so.0(+0x103e0) [0x7f482ee273e0]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(get_column_grant(THD*, st_grant_info*, char const*, char const*, char const*)+0x1
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(+0x4940e4) [0x7f482f6eb0e4]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(+0x48a9db) [0x7f482f6e19db]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(get_all_tables(THD*, TABLE_LIST*, Item*)+0x1c7) [0x7f482f6f34c7]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(get_schema_tables_result(JOIN*, enum_schema_table_state)+0x287) [0x7f482f6f5167]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(JOIN::exec_inner()+0x590) [0x7f482f6dc310]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(JOIN::exec()+0x44) [0x7f482f6de4b4]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsign
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x130) [0x7f482f6db9b0]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(+0x426a18) [0x7f482f67da18]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(mysql_execute_command(THD*)+0x6170) [0x7f482f689830]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x274) [0x7f482f68ca54]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x1bb6) [0x7f482
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(do_command(THD*)+0x16b) [0x7f482f68fafb]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(do_handle_one_connection(THD*)+0x18c) [0x7f482f750b0c]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7ygzwj9zfa1qzcv79gdbffnks57ip3i9-mariadb-10.1.13/bin/mysqld(handle_one_connection+0x37) [0x7f482f750ce7]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7b82878b8l4d136i6pxmwcc12sfsda33-glibc-2.21/lib/libpthread.so.0(+0x8484) [0x7f482ee1f484]
|
Apr 14 15:52:59 petcat mysqld[1554]: /nix/store/7b82878b8l4d136i6pxmwcc12sfsda33-glibc-2.21/lib/libc.so.6(clone+0x6d) [0x7f482c7a9f3d]
|