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

Server crash in fields_in_hash_keyinfo or Assertion `key_info->key_part->field->flags & (1<< 30)' failed in setup_keyinfo_hash

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4.3
    • 10.4.4
    • Server
    • None

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (f VARCHAR(4096), UNIQUE(f)) ENGINE=InnoDB;
      --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
      ALTER TABLE t1 DROP KEY f, ADD INDEX idx1(f), ALGORITHM=INSTANT;
      ALTER TABLE t1 ADD KEY idx2(f);
       
      # Cleanup
      DROP TABLE t1;
      

      10.4 3b47587f debug

      mysqld: /data/src/10.4/sql/table.cc:8981: void setup_keyinfo_hash(KEY*): Assertion `key_info->key_part->field->flags & (1<< 30)' failed.
      190304 12:47:41 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f861625bee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055c137f2991f in setup_keyinfo_hash (key_info=0x7f85bc00a018) at /data/src/10.4/sql/table.cc:8981
      #9  0x000055c137edf4d1 in mysql_prepare_alter_table (thd=0x7f85bc000b00, table=0x7f85bc1a12c0, create_info=0x7f860b562cd0, alter_info=0x7f860b562c10, alter_ctx=0x7f860b5620e0) at /data/src/10.4/sql/sql_table.cc:8305
      #10 0x000055c137ee313e in mysql_alter_table (thd=0x7f85bc000b00, new_db=0x7f85bc005290, new_name=0x7f85bc005690, create_info=0x7f860b562cd0, table_list=0x7f85bc015590, alter_info=0x7f860b562c10, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9609
      #11 0x000055c137f720ee in Sql_cmd_alter_table::execute (this=0x7f85bc015d10, thd=0x7f85bc000b00) at /data/src/10.4/sql/sql_alter.cc:499
      #12 0x000055c137e0348e in mysql_execute_command (thd=0x7f85bc000b00) at /data/src/10.4/sql/sql_parse.cc:6346
      #13 0x000055c137e08636 in mysql_parse (thd=0x7f85bc000b00, rawbuf=0x7f85bc0154a8 "ALTER TABLE t1 ADD KEY idx2(f)", length=30, parser_state=0x7f860b564180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8157
      #14 0x000055c137df3d24 in dispatch_command (command=COM_QUERY, thd=0x7f85bc000b00, packet=0x7f85bc139fd1 "ALTER TABLE t1 ADD KEY idx2(f)", packet_length=30, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1829
      #15 0x000055c137df24f8 in do_command (thd=0x7f85bc000b00) at /data/src/10.4/sql/sql_parse.cc:1358
      #16 0x000055c137f6c003 in do_handle_one_connection (connect=0x55c13b97fd10) at /data/src/10.4/sql/sql_connect.cc:1399
      #17 0x000055c137f6bd74 in handle_one_connection (arg=0x55c13b97fd10) at /data/src/10.4/sql/sql_connect.cc:1302
      #18 0x000055c138462d17 in pfs_spawn_thread (arg=0x55c13b9c5b80) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #19 0x00007f8617f32494 in start_thread (arg=0x7f860b565700) at pthread_create.c:333
      #20 0x00007f861631893f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      10.4 3b47587f non-debug

      #2  <signal handler called>
      #3  0x000055dd5a24077e in fields_in_hash_keyinfo (keyinfo=keyinfo@entry=0x7f2b3c0c7850) at /data/src/10.4/sql/table.cc:8971
      #4  0x000055dd5a240799 in setup_keyinfo_hash (key_info=key_info@entry=0x7f2b3c0c7850) at /data/src/10.4/sql/table.cc:8982
      #5  0x000055dd5a212ef4 in mysql_prepare_alter_table (thd=thd@entry=0x7f2b3c0009a8, table=table@entry=0x7f2b3c081c28, create_info=create_info@entry=0x7f2b90131220, alter_info=alter_info@entry=0x7f2b90131160, alter_ctx=alter_ctx@entry=0x7f2b90130660) at /data/src/10.4/sql/sql_table.cc:8305
      #6  0x000055dd5a21794d in mysql_alter_table (thd=<optimized out>, new_db=<optimized out>, new_name=<optimized out>, create_info=<optimized out>, table_list=0x7f2b3c011f88, alter_info=0x7f2b90131160, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9609
      #7  0x000055dd5a26857b in Sql_cmd_alter_table::execute (this=0x7f2b3c0c7850, thd=0x7f2b3c0009a8) at /data/src/10.4/sql/sql_alter.cc:499
      #8  0x000055dd5a180256 in mysql_execute_command (thd=thd@entry=0x7f2b3c0009a8) at /data/src/10.4/sql/sql_parse.cc:6346
      #9  0x000055dd5a187711 in mysql_parse (thd=thd@entry=0x7f2b3c0009a8, rawbuf=<optimized out>, length=30, parser_state=parser_state@entry=0x7f2b901341d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:8157
      #10 0x000055dd5a189f3f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f2b3c0009a8, packet=packet@entry=0x7f2b3c009b39 "ALTER TABLE t1 ADD KEY idx2(f)", packet_length=packet_length@entry=30, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:1829
      #11 0x000055dd5a18b397 in do_command (thd=0x7f2b3c0009a8) at /data/src/10.4/sql/sql_parse.cc:1358
      #12 0x000055dd5a26594c in do_handle_one_connection (connect=connect@entry=0x55dd5d629718) at /data/src/10.4/sql/sql_connect.cc:1399
      #13 0x000055dd5a265ab4 in handle_one_connection (arg=arg@entry=0x55dd5d629718) at /data/src/10.4/sql/sql_connect.cc:1302
      #14 0x000055dd5a583154 in pfs_spawn_thread (arg=0x55dd5d629778) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #15 0x00007f2b97a93494 in start_thread (arg=0x7f2b90135700) at pthread_create.c:333
      #16 0x00007f2b95e7993f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Issue Links

          Activity

            People

              sachin.setiya.007 Sachin Setiya (Inactive)
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.