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

Mariadb crash schema_table_store_record / run_fill_key_cache_tables

    XMLWordPrintable

Details

    Description

      Mariadb crash, daily, consistently, after upgrade from 10.5.7 to 10.5.8. Simple database, just a lot of InnoDB tables and a few MyISAM tables. No stored procedures.

      This is seen consistently at least once a day. The mariadb server crashes, gets restarted. The backtrace is consistent too about json_locate_key, fill_variables... etc.

      201128 14:18:43 [ERROR] mysqld got signal 11 ;
      [...]
      201129 14:24:08 [ERROR] mysqld got signal 11 ;
      [...]
      201130 14:29:28 [ERROR] mysqld got signal 11 ;
      [...]
      Server version: 10.5.8-MariaDB-log
      key_buffer_size=134217728
      read_buffer_size=134217728
      max_used_connections=1
      max_threads=514
      thread_count=15
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 134886105 K  bytes of memory
      [...]
      Thread pointer: 0x7f9ba80eb4a8
      [...]
      stack_bottom = 0x7f9bc4ff7f30 thread_stack 0x49000
      ??:0(my_print_stacktrace)[0x5555624ba37e]
      ??:0(handle_fatal_signal)[0x555561ec8fe7]
      sigaction.c:0(__restore_rt)[0x7f9d36f12630]
      ??:0(wsrep_notify_status(wsrep::server_state::state, wsrep::view const*))[0x55556219f537]
      ??:0(wsrep_notify_status(wsrep::server_state::state, wsrep::view const*))[0x55556219a8bc]
      ??:0(schema_table_store_record(THD*, TABLE*))[0x555561d336c0]
      ??:0(run_fill_key_cache_tables(char const*, st_key_cache*, void*))[0x555561d3a32c]
      ??:0(fill_variables(THD*, TABLE_LIST*, Item*))[0x555561d3b486]
      ??:0(json_locate_key)[0x555562523258]
      /usr/sbin/mariadbd(+0x6527a0)[0x555561bab7a0]
      ??:0(json_locate_key)[0x55556252337a]
      pthread_create.c:0(start_thread)[0x7f9d36f0aea5]
      ??:0(__clone)[0x7f9d3503396d]
      [...]
      Query (0x0): (null)
      Connection ID (thread ID): 1
      Status: NOT_KILLED
      

      Please let me know if I can provide more information on this. Cannot identify what's causing it.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              jgcovas Juan Gabriel Covas
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.