Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.5, 10.6, 10.11, 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
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
- duplicates
-
MDEV-27670 Assertion `(cs->state & 0x20000) == 0' failed in my_strnncollsp_nchars_generic_8bit
- Closed
- is caused by
-
MDEV-25440 Assertion `cmp_rec_rec(rec, old_rec, offsets, old_offsets, m_index) > 0' failed in PageBulk::insert
- Closed
- relates to
-
MDEV-25904 New collation functions to compare InnoDB style trimmed NO PAD strings
- Closed
-
MDEV-30034 UNIQUE USING HASH accepts duplicate entries for tricky collations
- Closed
-
MDEV-30048 Prefix keys for CHAR work differently for MyISAM vs InnoDB
- Closed
-
MDEV-30050 Inconsistent results of DISTINCT with NOPAD
- Closed