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

Server crashes on double rename of table if there are references on it

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • 10.5, 10.6
    • Server
    • None

    Description

      After changes MDEV-20865 server crashes on case:

      create  table t1(a int, b int, key(a)) ;
      create  table t2 (a int, foreign key (a)references t1 (a));
      rename table t1 to t3, t3 to t1;
      drop tables t2, t1;
      

      Stacktrace:

      Thread pointer: 0x733ec4000dc8
      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 = 0x733ef8061bf8 thread_stack 0x49000
      mysys/stacktrace.c:215(my_print_stacktrace)[0x5bc71d7b17ee]
      sql/signal_handler.cc:238(handle_fatal_signal)[0x5bc71ce72818]
      libc_sigaction.c:0(__restore_rt)[0x733efd242520]
      nptl/pthread_kill.c:44(__pthread_kill_implementation)[0x733efd2969fc]
      posix/raise.c:27(__GI_raise)[0x733efd242476]
      stdlib/abort.c:81(__GI_abort)[0x733efd2287f3]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x733efd22871b]
      /lib/x86_64-linux-gnu/libc.so.6(+0x39e96)[0x733efd239e96]
      sql/sql_error.cc:460(Diagnostics_area::set_error_status(unsigned int, char const*, char const*, Sql_user_condition_identity const&, Sql_condition const*))[0x5bc71c9d1dd3]
      sql/sql_class.cc:1129(THD::raise_condition(Sql_condition const*))[0x5bc71c99f5da]
      sql/sql_class.h:5383(THD::raise_condition(unsigned int, char const*, Sql_state_errno_level::enum_warning_level, char const*))[0x5bc71c89c8b3]
      sql/mysqld.cc:3345(my_message_sql)[0x5bc71c88ac96]
      mysys/my_error.c:125(my_error)[0x5bc71d7a15c9]
      mysys/my_delete.c:53(my_delete)[0x5bc71d7a1068]
      psi/mysql_file.h:1305(inline_mysql_file_delete(unsigned int, char const*, unsigned int, char const*, unsigned long))[0x5bc71cc98d67]
      sql/datadict.cc:538(fk_install_shadow_frm(Table_name, Table_name))[0x5bc71cc9aa26]
      sql/sql_rename.cc:201(mysql_rename_tables(THD*, TABLE_LIST*, bool, bool))[0x5bc71ca80b34]
      sql/sql_parse.cc:4326(mysql_execute_command(THD*, bool))[0x5bc71ca33445]
      sql/sql_parse.cc:7815(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5bc71ca3f36e]
      sql/sql_parse.cc:1895(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5bc71ca2bcbd]
      sql/sql_parse.cc:1406(do_command(THD*, bool))[0x5bc71ca2a603]
      sql/sql_connect.cc:1437(do_handle_one_connection(CONNECT*, bool))[0x5bc71cc4ac8a]
      sql/sql_connect.cc:1341(handle_one_connection)[0x5bc71cc4a9f3]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5bc71d1eca25]
      nptl/pthread_create.c:442(start_thread)[0x733efd294ac3]
      x86_64/clone3.S:83(__clone3)[0x733efd326850]
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              lstartseva Lena Startseva
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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