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

Atomic CoR: Server crash in drop_open_table upon CREATE OR REPLACE with table name containing non-alpha-num

    XMLWordPrintable

Details

    Description

      CREATE TABLE `t-t` (a INT);
      CREATE TRIGGER tr BEFORE INSERT ON `t-t` FOR EACH ROW SET new.a = 1;
      CREATE OR REPLACE TABLE `t-t` AS SELECT 1 AS b;
       
      DROP TABLE `t-t`;
      

      bb-main-atomic 82cc6f32b8fbd4a190159d5a7139afc052b52154 non-debug

      #2  <signal handler called>
      #3  0x00005610dca940b0 in close_thread_table (thd=0x7fe79c000c70, table_ptr=0x7fe79c000dd8) at /data/bld/testing/bb-main-atomic-rel/sql/sql_base.cc:1015
      #4  0x00005610dca94cbc in drop_open_table (thd=0x7fe79c000c70, table=0x7fe79c14f6e0, db_name=0x7fe79c013830, table_name=0x7fe79c013840) at /data/bld/testing/bb-main-atomic-rel/sql/sql_base.cc:1528
      #5  0x00005610dcad59a6 in select_create::abort_result_set (this=0x7fe79c014fc0) at /data/bld/testing/bb-main-atomic-rel/sql/sql_insert.cc:5760
      #6  0x00005610dcb91275 in handle_select (thd=thd@entry=0x7fe79c000c70, lex=lex@entry=0x7fe79c005100, result=result@entry=0x7fe79c014fc0, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/bld/testing/bb-main-atomic-rel/sql/sql_select.cc:655
      #7  0x00005610dcbd5d1b in Sql_cmd_create_table_like::execute (this=<optimized out>, thd=0x7fe79c000c70) at /data/bld/testing/bb-main-atomic-rel/sql/sql_table.cc:14170
      #8  0x00005610dcb110fe in mysql_execute_command (thd=thd@entry=0x7fe79c000c70, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/testing/bb-main-atomic-rel/sql/sql_parse.cc:5905
      #9  0x00005610dcb15b76 in mysql_parse (thd=0x7fe79c000c70, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/bld/testing/bb-main-atomic-rel/sql/sql_parse.cc:7945
      #10 0x00005610dcb18615 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fe79c000c70, packet=packet@entry=0x7fe79c008e91 "CREATE OR REPLACE TABLE `t-t` AS SELECT 1 AS b", packet_length=packet_length@entry=46, blocking=blocking@entry=true) at /data/bld/testing/bb-main-atomic-rel/sql/sql_parse.cc:2002
      #11 0x00005610dcb19c40 in do_command (thd=thd@entry=0x7fe79c000c70, blocking=blocking@entry=true) at /data/bld/testing/bb-main-atomic-rel/sql/sql_parse.cc:1437
      #12 0x00005610dcc44cad in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5610f123b9b0, put_in_cache=put_in_cache@entry=true) at /data/bld/testing/bb-main-atomic-rel/sql/sql_connect.cc:1503
      #13 0x00005610dcc4500d in handle_one_connection (arg=arg@entry=0x5610f123b9b0) at /data/bld/testing/bb-main-atomic-rel/sql/sql_connect.cc:1415
      #14 0x00005610dd00bbfc in pfs_spawn_thread (arg=0x5610f11d4900) at /data/bld/testing/bb-main-atomic-rel/storage/perfschema/pfs.cc:2198
      #15 0x00007fe7bf5c91c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #16 0x00007fe7bf64985c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      bb-main-atomic 82cc6f32b8fbd4a190159d5a7139afc052b52154 debug

      mariadbd: /data/bld/testing/bb-main-atomic-asan/sql/sql_base.cc:1523: void drop_open_table(THD*, TABLE*, const LEX_CSTRING*, const LEX_CSTRING*): Assertion `table == thd->open_tables' failed.
       
      #10 0x00007f94b3453eb2 in __GI___assert_fail (assertion=0x556ba6c8b580 "table == thd->open_tables", file=0x556ba6c87920 "/data/bld/testing/bb-main-atomic-asan/sql/sql_base.cc", line=1523, function=0x556ba6c8b5c0 "void drop_open_table(THD*, TABLE*, const LEX_CSTRING*, const LEX_CSTRING*)") at ./assert/assert.c:101
      #11 0x0000556ba4967586 in drop_open_table (thd=0x62c0000b0220, table=0x61900005a0a0, db_name=<optimized out>, table_name=<optimized out>) at /data/bld/testing/bb-main-atomic-asan/sql/sql_base.cc:1523
      #12 0x0000556ba4a6f3e9 in select_create::abort_result_set (this=0x62d000105e20) at /data/bld/testing/bb-main-atomic-asan/sql/sql_insert.cc:5760
      #13 0x0000556ba4cebece in handle_select (thd=thd@entry=0x62c0000b0220, lex=lex@entry=0x62c0000b4888, result=result@entry=0x62d000105e20, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/bld/testing/bb-main-atomic-asan/sql/sql_select.cc:655
      #14 0x0000556ba4e114e8 in Sql_cmd_create_table_like::execute (this=<optimized out>, thd=0x62c0000b0220) at /data/bld/testing/bb-main-atomic-asan/sql/sql_table.cc:14170
      #15 0x0000556ba4b496d4 in mysql_execute_command (thd=thd@entry=0x62c0000b0220, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/testing/bb-main-atomic-asan/sql/sql_parse.cc:5905
      #16 0x0000556ba4b4b649 in mysql_parse (thd=thd@entry=0x62c0000b0220, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f94a742a990) at /data/bld/testing/bb-main-atomic-asan/sql/sql_parse.cc:7945
      #17 0x0000556ba4b4f311 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62c0000b0220, packet=packet@entry=0x62900029e221 "CREATE OR REPLACE TABLE `t-t` AS SELECT 1 AS b", packet_length=packet_length@entry=46, blocking=blocking@entry=true) at /data/bld/testing/bb-main-atomic-asan/sql/sql_parse.cc:1903
      #18 0x0000556ba4b541a8 in do_command (thd=thd@entry=0x62c0000b0220, blocking=blocking@entry=true) at /data/bld/testing/bb-main-atomic-asan/sql/sql_parse.cc:1437
      #19 0x0000556ba500648a in do_handle_one_connection (connect=<optimized out>, connect@entry=0x60b000004730, put_in_cache=put_in_cache@entry=true) at /data/bld/testing/bb-main-atomic-asan/sql/sql_connect.cc:1503
      #20 0x0000556ba5006980 in handle_one_connection (arg=arg@entry=0x60b000004730) at /data/bld/testing/bb-main-atomic-asan/sql/sql_connect.cc:1415
      #21 0x0000556ba5cd998f in pfs_spawn_thread (arg=0x6170000069a0) at /data/bld/testing/bb-main-atomic-asan/storage/perfschema/pfs.cc:2198
      #22 0x00007f94b34a81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #23 0x00007f94b352885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.