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

SEGFAULT in get_column_grant()

    XMLWordPrintable

    Details

    • Sprint:
      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]
      

        Attachments

          Activity

            People

            Assignee:
            cvicentiu Vicențiu Ciorbaru
            Reporter:
            ip1981 Igor Pashev
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration