Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3383

mysqld crashing on replication drop table - local query PMs

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 1.2.3
    • Icebox
    • MariaDB Server
    • None
    • 2um 2pm with local query

    Description

      Customer reporting the system was down and the mysqld on pm1 and pm2 were crashing.

      This might be the same issue as https://jira.mariadb.org/browse/MCOL-2212, which is tied to 1.2.4.

      But customer is asking is the actually crash fixed? They request that the mysqld server be fixed not to crash in the case of the failed drop table.

      Server version: 10.3.13-MariaDB-log
      key_buffer_size=536870912
      read_buffer_size=4194304
      max_used_connections=0
      max_threads=153
      thread_count=9
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1781053 K bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.

      Thread pointer: 0x7efcf40012a8
      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 = 0x7efd54405588 thread_stack 0x80000
      mysys/stacktrace.c:270(my_print_stacktrace)[0x55d934421ac9]
      sql/signal_handler.cc:168(handle_fatal_signal)[0x55d933f5a6ff]
      sigaction.c:0(__restore_rt)[0x7efd9d1095d0]
      sql/ha_sequence.cc:53(ha_sequence)[0x55d934404e17]
      sql/handler.cc:268(get_new_handler(TABLE_SHARE*, st_mem_root*, handlerton*))[0x55d933f5c770]
      sql/handler.cc:2588(ha_delete_table(THD*, handlerton*, char const*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, bool))[0x55d933f62587]
      sql/sql_table.cc:2511(mysql_rm_table_no_locks(THD*, TABLE_LIST*, bool, bool, bool, bool, bool, bool))[0x55d933e2939f]
      sql/sql_table.cc:2125(mysql_rm_table(THD*, TABLE_LIST*, bool, bool, bool))[0x55d933e2a433]
      sql/sql_parse.cc:5108(mysql_execute_command(THD*))[0x55d933dafdb6]
      sql/sql_parse.cc:8143(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55d933db3fa2]
      sql/log_event.cc:5681(Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int))[0x55d93404534e]
      sql/log_event.h:1483(Log_event::apply_event(rpl_group_info*))[0x55d933d17728]
      sql/slave.cc:4371(exec_relay_log_event)[0x55d933d206a2]
      pthread_create.c:0(start_thread)[0x7efd9d101dd5]
      /lib64/libc.so.6(clone+0x6d)[0x7efd9b0acead]

      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7efcf4014d84): is an invalid pointer
      Connection ID (thread ID): 11
      Status: NOT_KILLED

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              hill David Hill (Inactive)
              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.