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

Assertion `vseg < vseg_end' failed upon updating prefixed index on table

Details

    Description

      CREATE TABLE t (f char(8) NOT NULL, KEY(f(5))) CHARACTER SET big5 COLLATE big5_nopad_bin;
      		 
      INSERT INTO t VALUES ('abcd e'),('abcd');
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t;

      10.5 4b38af06a4b762f7cd55fa0292fb5e1e9a4f6b98

      		 
      mariadbd: /data/bld/10.5-asan/storage/myisam/mi_search.c:499: _mi_prefix_search: Assertion `vseg < vseg_end' failed.
      		 
      241107 22:19:49 [ERROR] mysqld got signal 6 ;
      		 
       
      		 
      #9  0x00007fe120c53e32 in __GI___assert_fail (assertion=0x55b6d93e3700 "vseg < vseg_end", file=0x55b6d93e3020 "/data/bld/10.5-asan/storage/myisam/mi_search.c", line=499, function=0x55b6d93e3f80 <__PRETTY_FUNCTION__.0> "_mi_prefix_search") at ./assert/assert.c:101
      		 
      #10 0x000055b6d7f6f7eb in _mi_prefix_search (info=0x61f000033a98, keyinfo=0x61d00021eea8, page=0x7fe1177b5f2e "", key=0x61f00003471d "\004abcd", key_len=2416, nextflag=4, ret_pos=0x7fe1177b6d80, buff=0x7fe1177b6e00 "0n{\027\341\177", last_key=0x7fe1177b6d70 "\340m{\027\341\177") at /data/bld/10.5-asan/storage/myisam/mi_search.c:499
      		 
      #11 0x000055b6d7f86c2f in w_search (info=0x61f000033a98, keyinfo=0x61d00021eea8, comp_flag=4, key=0x61f00003471d "\004abcd", key_length=5, page=1024, father_buff=0x0, father_keypos=0x0, father_page=0, insert_last=1 '\001') at /data/bld/10.5-asan/storage/myisam/mi_write.c:359
      		 
      #12 0x000055b6d7f861ef in _mi_ck_real_write_btree (info=0x61f000033a98, keyinfo=0x61d00021eea8, key=0x61f00003471d "\004abcd", key_length=5, root=0x61d00021f078, comp_flag=4) at /data/bld/10.5-asan/storage/myisam/mi_write.c:299
      		 
      #13 0x000055b6d7f85f04 in _mi_ck_write_btree (info=0x61f000033a98, keynr=0, key=0x61f00003471d "\004abcd", key_length=5) at /data/bld/10.5-asan/storage/myisam/mi_write.c:279
      		 
      #14 0x000055b6d7f85c07 in _mi_ck_write (info=0x61f000033a98, keynr=0, key=0x61f00003471d "\004abcd", key_length=5) at /data/bld/10.5-asan/storage/myisam/mi_write.c:250
      		 
      #15 0x000055b6d7f84734 in mi_write (info=0x61f000033a98, record=0x61900009a6c8 "\377abcd", ' ' <repeats 12 times>, '\276' <repeats 39 times>, "X\247\t") at /data/bld/10.5-asan/storage/myisam/mi_write.c:125
      		 
      #16 0x000055b6d7ec099a in ha_myisam::write_row (this=0x61d00021deb8, buf=0x61900009a6c8 "\377abcd", ' ' <repeats 12 times>, '\276' <repeats 39 times>, "X\247\t") at /data/bld/10.5-asan/storage/myisam/ha_myisam.cc:997
      		 
      #17 0x000055b6d6a7e858 in handler::ha_write_row (this=0x61d00021deb8, buf=0x61900009a6c8 "\377abcd", ' ' <repeats 12 times>, '\276' <repeats 39 times>, "X\247\t") at /data/bld/10.5-asan/sql/handler.cc:7373
      		 
      #18 0x000055b6d6139ee0 in write_record (thd=0x62b000069218, table=0x61900009a198, info=0x7fe1177b7cb0, sink=0x0) at /data/bld/10.5-asan/sql/sql_insert.cc:2227
      		 
      #19 0x000055b6d6131439 in mysql_insert (thd=0x62b000069218, table_list=0x62b000038360, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /data/bld/10.5-asan/sql/sql_insert.cc:1139
      		 
      #20 0x000055b6d61fb614 in mysql_execute_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:4650
      		 
      #21 0x000055b6d621403b in mysql_parse (thd=0x62b000069218, rawbuf=0x62b000038238 "INSERT INTO t VALUES ('abcd e'),('abcd')", length=40, parser_state=0x7fe1177b8c70, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:8237
      		 
      #22 0x000055b6d61e9321 in dispatch_command (command=COM_QUERY, thd=0x62b000069218, packet=0x629000235219 "INSERT INTO t VALUES ('abcd e'),('abcd')", packet_length=40, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:1891
      		 
      #23 0x000055b6d61e5cb4 in do_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:1375
      		 
      #24 0x000055b6d663f869 in do_handle_one_connection (connect=0x608000002ab8, put_in_cache=true) at /data/bld/10.5-asan/sql/sql_connect.cc:1407
      		 
      #25 0x000055b6d663f3cf in handle_one_connection (arg=0x608000002a38) at /data/bld/10.5-asan/sql/sql_connect.cc:1319
      		 
      #26 0x000055b6d729d1f0 in pfs_spawn_thread (arg=0x615000006c18) at /data/bld/10.5-asan/storage/perfschema/pfs.cc:2201
      		 
      #27 0x00007fe120ca8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      		 
      #28 0x00007fe120d2861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

      Also reproducible with Aria

      mariadbd: /data/bld/10.5-asan/storage/maria/ma_search.c:647: _ma_prefix_search: Assertion `vseg < vseg_end' failed.
      		 
      241107 22:21:39 [ERROR] mysqld got signal 6 ;
      		 
       
      		 
      #9  0x00007fadf9053e32 in __GI___assert_fail (assertion=0x558338733340 "vseg < vseg_end", file=0x558338732b00 "/data/bld/10.5-asan/storage/maria/ma_search.c", line=647, function=0x558338733d60 <__PRETTY_FUNCTION__.2> "_ma_prefix_search") at ./assert/assert.c:101
      		 
      #10 0x0000558336d3439b in _ma_prefix_search (key=0x7fadefba1640, ma_page=0x7fadefba0770, nextflag=131076, ret_pos=0x7fadefba0670, buff=0x7fadefba0514 "``", last_key=0x7fadefba0660 " \a\272\357\255\177") at /data/bld/10.5-asan/storage/maria/ma_search.c:647
      		 
      #11 0x0000558336db9a39 in w_search (info=0x62900023f218, comp_flag=131076, key=0x7fadefba1640, page_pos=8192, father_page=0x0, father_keypos=0x0, insert_last=1 '\001') at /data/bld/10.5-asan/storage/maria/ma_write.c:646
      		 
      #12 0x0000558336db84a5 in _ma_ck_real_write_btree (info=0x62900023f218, key=0x7fadefba1640, root=0x7fadefba0970, comp_flag=131076) at /data/bld/10.5-asan/storage/maria/ma_write.c:532
      		 
      #13 0x0000558336db80c3 in _ma_ck_write_btree_with_log (info=0x62900023f218, key=0x7fadefba1640, root=0x62100008bcf8, comp_flag=131076) at /data/bld/10.5-asan/storage/maria/ma_write.c:498
      		 
      #14 0x0000558336db7aee in _ma_ck_write_btree (info=0x62900023f218, key=0x7fadefba1640) at /data/bld/10.5-asan/storage/maria/ma_write.c:456
      		 
      #15 0x0000558336db783b in _ma_ck_write (info=0x62900023f218, key=0x7fadefba1640) at /data/bld/10.5-asan/storage/maria/ma_write.c:441
      		 
      #16 0x0000558336db6115 in maria_write (info=0x62900023f218, record=0x61900009a6c8 "\377abcd", ' ' <repeats 12 times>, '\276' <repeats 39 times>, "X\247\t") at /data/bld/10.5-asan/storage/maria/ma_write.c:189
      		 
      #17 0x0000558336c53180 in ha_maria::write_row (this=0x61d00021fcb8, buf=0x61900009a6c8 "\377abcd", ' ' <repeats 12 times>, '\276' <repeats 39 times>, "X\247\t") at /data/bld/10.5-asan/storage/maria/ha_maria.cc:1246
      		 
      #18 0x00005583366c6858 in handler::ha_write_row (this=0x61d00021fcb8, buf=0x61900009a6c8 "\377abcd", ' ' <repeats 12 times>, '\276' <repeats 39 times>, "X\247\t") at /data/bld/10.5-asan/sql/handler.cc:7373
      		 
      #19 0x0000558335d81ee0 in write_record (thd=0x62b000069218, table=0x61900009a198, info=0x7fadefba1cb0, sink=0x0) at /data/bld/10.5-asan/sql/sql_insert.cc:2227
      		 
      #20 0x0000558335d79439 in mysql_insert (thd=0x62b000069218, table_list=0x62b000038360, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /data/bld/10.5-asan/sql/sql_insert.cc:1139
      		 
      #21 0x0000558335e43614 in mysql_execute_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:4650
      		 
      #22 0x0000558335e5c03b in mysql_parse (thd=0x62b000069218, rawbuf=0x62b000038238 "INSERT INTO t VALUES ('abcd e'),('abcd')", length=40, parser_state=0x7fadefba2c70, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:8237
      		 
      #23 0x0000558335e31321 in dispatch_command (command=COM_QUERY, thd=0x62b000069218, packet=0x629000235219 "INSERT INTO t VALUES ('abcd e'),('abcd')", packet_length=40, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:1891
      		 
      #24 0x0000558335e2dcb4 in do_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:1375
      		 
      #25 0x0000558336287869 in do_handle_one_connection (connect=0x608000002ab8, put_in_cache=true) at /data/bld/10.5-asan/sql/sql_connect.cc:1407
      		 
      #26 0x00005583362873cf in handle_one_connection (arg=0x608000002a38) at /data/bld/10.5-asan/sql/sql_connect.cc:1319
      		 
      #27 0x0000558336ee51f0 in pfs_spawn_thread (arg=0x615000006c18) at /data/bld/10.5-asan/storage/perfschema/pfs.cc:2201
      		 
      #28 0x00007fadf90a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      		 
      #29 0x00007fadf912861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

      No obvious immediate effect on a non-debug build.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          bar Alexander Barkov added a comment -

          Also repeatable with some other character sets:

          CREATE OR REPLACE TABLE t (f char(8) NOT NULL, KEY(f(5))) ENGINE=MyISAM CHARACTER SET gbk COLLATE gbk_nopad_bin;
          		 
          INSERT INTO t VALUES ('abcd e'),('abcd');
          		 
          DROP TABLE t;


          CREATE OR REPLACE TABLE t (f char(8) NOT NULL, KEY(f(5))) ENGINE=MyISAM CHARACTER SET sjis COLLATE sjis_nopad_bin;
          		 
          INSERT INTO t VALUES ('abcd e'),('abcd');
          		 
          DROP TABLE t;


          CREATE OR REPLACE TABLE t (f char(8) NOT NULL, KEY(f(5))) ENGINE=MyISAM CHARACTER SET euckr COLLATE euckr_nopad_bin;
          		 
          INSERT INTO t VALUES ('abcd e'),('abcd');
          		 
          DROP TABLE t;

          bar Alexander Barkov added a comment - Also repeatable with some other character sets: CREATE OR REPLACE TABLE t (f char (8) NOT NULL , KEY (f(5))) ENGINE=MyISAM CHARACTER SET gbk COLLATE gbk_nopad_bin; INSERT INTO t VALUES ( 'abcd e' ),( 'abcd' ); DROP TABLE t; CREATE OR REPLACE TABLE t (f char (8) NOT NULL , KEY (f(5))) ENGINE=MyISAM CHARACTER SET sjis COLLATE sjis_nopad_bin; INSERT INTO t VALUES ( 'abcd e' ),( 'abcd' ); DROP TABLE t; CREATE OR REPLACE TABLE t (f char (8) NOT NULL , KEY (f(5))) ENGINE=MyISAM CHARACTER SET euckr COLLATE euckr_nopad_bin; INSERT INTO t VALUES ( 'abcd e' ),( 'abcd' ); DROP TABLE t;
          bar Alexander Barkov added a comment -

          Also repeatable with pad collations:

          CREATE OR REPLACE TABLE t (f char(8) NOT NULL, KEY(f(5))) ENGINE=MyISAM CHARACTER SET euckr COLLATE euckr_korean_ci;
          		 
          INSERT INTO t VALUES ('abcd e'),('abcd');


          CREATE OR REPLACE TABLE t (f char(8) NOT NULL, KEY(f(5))) ENGINE=MyISAM CHARACTER SET euckr COLLATE euckr_bin;
          		 
          INSERT INTO t VALUES ('abcd e'),('abcd');

          bar Alexander Barkov added a comment - Also repeatable with pad collations: CREATE OR REPLACE TABLE t (f char (8) NOT NULL , KEY (f(5))) ENGINE=MyISAM CHARACTER SET euckr COLLATE euckr_korean_ci; INSERT INTO t VALUES ( 'abcd e' ),( 'abcd' ); CREATE OR REPLACE TABLE t (f char (8) NOT NULL , KEY (f(5))) ENGINE=MyISAM CHARACTER SET euckr COLLATE euckr_bin; INSERT INTO t VALUES ( 'abcd e' ),( 'abcd' );
          elenst Elena Stepanova added a comment -

          Updated the summary to remove "nopad".

          elenst Elena Stepanova added a comment - Updated the summary to remove "nopad".

          People

            bar Alexander Barkov
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.