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

Server crashes in Alter_info::add_stat_drop_index upon CREATE TABLE

    XMLWordPrintable

Details

    Description

      I have set it tentatively to blocker and regression, as very similar issues were observed and fixed during testing of MDEV-31957 – so similar in fact that I think one of the fixes made in bb-10.6-monty may have gotten lost while force-pushing or merging into main.

      10.6 8bf17c579b9a2d8d2f3c611f4b22fa5edb8e117c

      0x000055f5938ab1f1 in Alter_info::add_stat_drop_index (this=0x7f5c95976f90, thd=0x30c044000aa8, key_name=0x30c044014250) at /data/for_monty/10.6/sql/sql_alter.cc:343
      343	      if (key_info->name.length &&
      (rr) bt
      #0  0x000055f5938ab1f1 in Alter_info::add_stat_drop_index (this=0x7f5c95976f90, thd=0x30c044000aa8, key_name=0x30c044014250) at /data/for_monty/10.6/sql/sql_alter.cc:343
      #1  0x000055f5937ea3c3 in mysql_prepare_create_table (thd=0x30c044000aa8, create_info=0x7f5c95977100, alter_info=0x7f5c95976f90, db_options=0x7f5c9597628c, file=0x30c044014360, 
          key_info_buffer=0x7f5c95976bd0, key_count=0x7f5c95976bc4, create_table_mode=0) at /data/for_monty/10.6/sql/sql_table.cc:2904
      #2  0x000055f5937ee059 in mysql_create_frm_image (thd=0x30c044000aa8, create_info=0x7f5c95977100, alter_info=0x7f5c95976f90, create_table_mode=0, key_info=0x7f5c95976bd0, key_count=0x7f5c95976bc4, 
          frm=0x7f5c95976c00) at /data/for_monty/10.6/sql/sql_table.cc:4094
      #3  0x000055f5937eed3a in create_table_impl (thd=0x30c044000aa8, ddl_log_state_create=0x7f5c95976e90, ddl_log_state_rm=0x7f5c95976eb0, orig_db=..., orig_table_name=..., db=..., table_name=..., path=..., 
          options=..., create_info=0x7f5c95977100, alter_info=0x7f5c95976f90, create_table_mode=0, is_trans=0x7f5c95976e63, key_info=0x7f5c95976bd0, key_count=0x7f5c95976bc4, frm=0x7f5c95976c00)
          at /data/for_monty/10.6/sql/sql_table.cc:4408
      #4  0x000055f5937ef2d0 in mysql_create_table_no_lock (thd=0x30c044000aa8, ddl_log_state_create=0x7f5c95976e90, ddl_log_state_rm=0x7f5c95976eb0, create_info=0x7f5c95977100, alter_info=0x7f5c95976f90, 
          is_trans=0x7f5c95976e63, create_table_mode=0, table_list=0x30c044013030) at /data/for_monty/10.6/sql/sql_table.cc:4533
      #5  0x000055f5937f1251 in mysql_create_like_table (thd=0x30c044000aa8, table=0x30c044013030, src_table=0x30c0440137d0, create_info=0x7f5c959789e0) at /data/for_monty/10.6/sql/sql_table.cc:5210
      #6  0x000055f59380532e in Sql_cmd_create_table_like::execute (this=0x30c044012fd0, thd=0x30c044000aa8) at /data/for_monty/10.6/sql/sql_table.cc:11995
      #7  0x000055f593703856 in mysql_execute_command (thd=0x30c044000aa8, is_called_from_prepared_stmt=false) at /data/for_monty/10.6/sql/sql_parse.cc:6026
      #8  0x000055f5937093f0 in mysql_parse (thd=0x30c044000aa8, rawbuf=0x30c044012ed0 "/* WRK-1 QNO 2007 */  CREATE TABLE IF NOT EXISTS r LIKE `alt_table_db`.`alt_t1`", length=79, parser_state=0x7f5c95979390)
          at /data/for_monty/10.6/sql/sql_parse.cc:8050
      #9  0x000055f5936f5f74 in dispatch_command (command=COM_QUERY, thd=0x30c044000aa8, packet=0x30c04400ab29 "/* WRK-1 QNO 2007 */  CREATE TABLE IF NOT EXISTS r LIKE `alt_table_db`.`alt_t1`", 
          packet_length=79, blocking=true) at /data/for_monty/10.6/sql/sql_parse.cc:1896
      #10 0x000055f5936f4995 in do_command (thd=0x30c044000aa8, blocking=true) at /data/for_monty/10.6/sql/sql_parse.cc:1410
      #11 0x000055f5938a17de in do_handle_one_connection (connect=0x55f59782efd8, put_in_cache=true) at /data/for_monty/10.6/sql/sql_connect.cc:1416
      #12 0x000055f5938a153f in handle_one_connection (arg=0x55f59782efd8) at /data/for_monty/10.6/sql/sql_connect.cc:1318
      #13 0x000055f593dcb642 in pfs_spawn_thread (arg=0x55f5976794f8) at /data/for_monty/10.6/storage/perfschema/pfs.cc:2201
      #14 0x000055f595b216ba in start_thread (arg=0x7f5c9597a700) at pthread_create.c:333
      #15 0x00001d205aa7251d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            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.