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

MDEV-25440: Assertion `(cs->state & 0x20000) == 0' failed in my_strnncollsp_nchars_generic_8bit

    XMLWordPrintable

Details

    Description

      Appears only in the MDEV-25440 branch, and only in debug. Likely other versions affected.

      CREATE TABLE t (a INT KEY,b INT,c CHAR,KEY(b),KEY(c)) ROW_FORMAT=REDUNDANT COLLATE=tis620_thai_nopad_ci ENGINE=InnoDB;
      INSERT INTO t VALUES (3,4,4);
      

      Leads to:

      10.5.14 cf63eecef44f189ce2d221612dee9dfc1885ba4e (Debug)

      mysqld: /test/MDEV-25440-2-bb-10.5-release_dbg/strings/ctype.c:1380: my_strnncollsp_nchars_generic_8bit: Assertion `(cs->state & 0x20000) == 0' failed.
      

      10.5.14 cf63eecef44f189ce2d221612dee9dfc1885ba4e (Debug)

      Core was generated by `/test/MDEV-25440-2-MD040222-mariadb-10.5.14-linux-x86_64-dbg/bin/mysqld --no-de'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      [Current thread is 1 (Thread 0x1534e55cc700 (LWP 3277868))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x00001534fc47b859 in __GI_abort () at abort.c:79
      #2  0x00001534fc47b729 in __assert_fail_base (fmt=0x1534fc611588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55f5f488374f "(cs->state & 0x20000) == 0", file=0x55f5f4883998 "/test/MDEV-25440-2-bb-10.5-release_dbg/strings/ctype.c", line=1380, function=<optimized out>) at assert.c:92
      #3  0x00001534fc48cf36 in __GI___assert_fail (assertion=assertion@entry=0x55f5f488374f "(cs->state & 0x20000) == 0", file=file@entry=0x55f5f4883998 "/test/MDEV-25440-2-bb-10.5-release_dbg/strings/ctype.c", line=line@entry=1380, function=function@entry=0x55f5f48848c0 <__PRETTY_FUNCTION__.13851> "my_strnncollsp_nchars_generic_8bit") at assert.c:101
      #4  0x000055f5f41be4b5 in my_strnncollsp_nchars_generic_8bit (cs=<optimized out>, str1=<optimized out>, len1=<optimized out>, str2=<optimized out>, len2=<optimized out>, nchars=<optimized out>) at /test/MDEV-25440-2-bb-10.5-release_dbg/strings/ctype.c:1380
      #5  0x000055f5f3de62d4 in cmp_data (mtype=<optimized out>, prtype=<optimized out>, data1=data1@entry=0x15345c025821 "4", '\245' <repeats 22 times>, "\320X\002\\4\025", len1=len1@entry=1, data2=data2@entry=0x1534d87a4085 "4\200", len2=len2@entry=1) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/rem/rem0cmp.cc:293
      #6  0x000055f5f3de6ef4 in cmp_dtuple_rec_with_match_low (dtuple=dtuple@entry=0x15345c021e70, rec=rec@entry=0x1534d87a4085 "4\200", offsets=offsets@entry=0x1534e55c94f0, n_cmp=2, matched_fields=matched_fields@entry=0x1534e55c8d88) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/rem/rem0cmp.cc:411
      #7  0x000055f5f3de728e in cmp_dtuple_rec (dtuple=dtuple@entry=0x15345c021e70, rec=rec@entry=0x1534d87a4085 "4\200", offsets=0x1534e55c94f0) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/include/data0data.inl:253
      #8  0x000055f5f3f64556 in page_cur_tuple_insert (cursor=cursor@entry=0x1534e55c9368, tuple=tuple@entry=0x15345c021e70, index=index@entry=0x15345c0238b8, offsets=offsets@entry=0x1534e55c92b8, heap=heap@entry=0x1534e55c92a8, n_ext=<optimized out>, mtr=0x1534e55c98d0) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/include/page0cur.inl:289
      #9  0x000055f5f3f685da in btr_cur_optimistic_insert (flags=flags@entry=0, cursor=cursor@entry=0x1534e55c9360, offsets=offsets@entry=0x1534e55c92b8, heap=heap@entry=0x1534e55c92a8, entry=entry@entry=0x15345c021e70, rec=rec@entry=0x1534e55c9310, big_rec=0x1534e55c9400, n_ext=<optimized out>, thr=0x15345c028640, mtr=0x1534e55c98d0) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/btr/btr0cur.cc:3564
      #10 0x000055f5f3e2493b in row_ins_sec_index_entry_low (flags=flags@entry=0, mode=mode@entry=2, index=index@entry=0x15345c0238b8, offsets_heap=<optimized out>, offsets_heap@entry=0x15345c06c928, heap=heap@entry=0x15345c06cdc8, entry=entry@entry=0x15345c021e70, trx_id=0, thr=0x15345c028640) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/row/row0ins.cc:3093
      #11 0x000055f5f3e2acb8 in row_ins_sec_index_entry (index=index@entry=0x15345c0238b8, entry=entry@entry=0x15345c021e70, thr=thr@entry=0x15345c028640, check_foreign=check_foreign@entry=true) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/row/row0ins.cc:3294
      #12 0x000055f5f3e2c9bb in row_ins_index_entry (thr=0x15345c028640, entry=0x15345c021e70, index=0x15345c0238b8) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/row/row0ins.cc:3342
      #13 row_ins_index_entry_step (thr=0x15345c028640, node=0x15345c0283e0) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/row/row0ins.cc:3508
      #14 row_ins (thr=0x15345c028640, node=0x15345c0283e0) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/row/row0ins.cc:3667
      #15 row_ins_step (thr=thr@entry=0x15345c028640) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/row/row0ins.cc:3817
      #16 0x000055f5f3e516aa in row_insert_for_mysql (mysql_rec=mysql_rec@entry=0x15345c025818 "\371\003", prebuilt=0x15345c027e88, ins_mode=ROW_INS_NORMAL) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/row/row0mysql.cc:1400
      #17 0x000055f5f3cbd954 in ha_innobase::write_row (this=0x15345c01e660, record=0x15345c025818 "\371\003") at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/innobase/handler/ha_innodb.cc:7708
      #18 0x000055f5f38cdff6 in handler::ha_write_row (this=0x15345c01e660, buf=0x15345c025818 "\371\003") at /test/MDEV-25440-2-bb-10.5-release_dbg/sql/handler.cc:7174
      #19 0x000055f5f359cb94 in write_record (thd=thd@entry=0x15345c000db8, table=table@entry=0x15345c026d08, info=info@entry=0x1534e55cac70, sink=sink@entry=0x0) at /test/MDEV-25440-2-bb-10.5-release_dbg/sql/sql_insert.cc:2140
      #20 0x000055f5f35a922b in mysql_insert (thd=thd@entry=0x15345c000db8, table_list=0x15345c013dd0, fields=@0x15345c005e38: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55f5f4c64300 <end_of_list>, last = 0x15345c005e38, elements = 0}, <No data fields>}, values_list=@0x15345c005e80: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x15345c014b60, last = 0x15345c014b60, elements = 1}, <No data fields>}, update_fields=@0x15345c005e68: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55f5f4c64300 <end_of_list>, last = 0x15345c005e68, elements = 0}, <No data fields>}, update_values=@0x15345c005e50: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55f5f4c64300 <end_of_list>, last = 0x15345c005e50, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false, result=0x0) at /test/MDEV-25440-2-bb-10.5-release_dbg/sql/sql_insert.cc:1118
      #21 0x000055f5f35f15ed in mysql_execute_command (thd=thd@entry=0x15345c000db8) at /test/MDEV-25440-2-bb-10.5-release_dbg/sql/sql_parse.cc:4624
      #22 0x000055f5f35daf34 in mysql_parse (thd=thd@entry=0x15345c000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1534e55cb3d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/MDEV-25440-2-bb-10.5-release_dbg/sql/sql_parse.cc:8100
      #23 0x000055f5f35ea787 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x15345c000db8, packet=packet@entry=0x15345c00b4a9 "INSERT INTO t VALUES (3,4,4)", packet_length=packet_length@entry=28, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/MDEV-25440-2-bb-10.5-release_dbg/sql/sql_class.h:1290
      #24 0x000055f5f35ee003 in do_command (thd=0x15345c000db8) at /test/MDEV-25440-2-bb-10.5-release_dbg/sql/sql_parse.cc:1370
      #25 0x000055f5f374ad24 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55f5f7126ad8, put_in_cache=put_in_cache@entry=true) at /test/MDEV-25440-2-bb-10.5-release_dbg/sql/sql_connect.cc:1418
      #26 0x000055f5f374b427 in handle_one_connection (arg=arg@entry=0x55f5f7126ad8) at /test/MDEV-25440-2-bb-10.5-release_dbg/sql/sql_connect.cc:1312
      #27 0x000055f5f3c04845 in pfs_spawn_thread (arg=0x55f5f7064588) at /test/MDEV-25440-2-bb-10.5-release_dbg/storage/perfschema/pfs.cc:2201
      #28 0x00001534fc98a609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #29 0x00001534fc578293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.