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

Assertion `dict_index_is_clust(index)' failed in row_ins_index_entry_set_vals

Details

    Description

      Note: The problem might be related to (or even be a side-effect of) MDEV-20902, as the test case involves the same flawed structure; but I'm not sure it's the only way to get the same failure, so I'm filing it separately, to be safe.

      Note: Run the test case with --mysqld=--innodb_page_size=4K.

      --source include/have_innodb.inc
      		 
       
      		 
      CREATE TABLE t1 (
      		 
          pk integer,
      		 
          f01 char(255) CHARACTER SET utf8,
      		 
          f02 char(255) CHARACTER SET ucs2,
      		 
          f03 set ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') CHARACTER SET ucs2,
      		 
          f04 INT,
      		 
          f05 varchar(255)  CHARACTER SET ucs2,
      		 
          f06 longtext  CHARACTER SET utf8,
      		 
          f07 char(255)  CHARACTER SET ucs2,
      		 
          f08 longtext  CHARACTER SET utf8,
      		 
          f09 varchar(255)  CHARACTER SET ucs2,
      		 
          f10 longtext  CHARACTER SET ucs2,
      		 
          f11 set ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') CHARACTER SET ucs2,
      		 
          f12 char(255)  CHARACTER SET utf8,
      		 
          PRIMARY KEY (pk),
      		 
          KEY (f05),
      		 
          KEY (f11),
      		 
          FOREIGN KEY (f03) REFERENCES t1 (f11) ON DELETE SET NULL
      		 
      ) ENGINE=InnoDB WITH SYSTEM VERSIONING;
      		 
       
      		 
      INSERT IGNORE INTO t1 VALUES
      		 
          (1,'a', 'c', 'a', 1, REPEAT('a',189), 's', 'h', 'y', 'foobar', 'g', 'a', 'c') ,
      		 
          (2,'b', 'e', 'a', 2, REPEAT('a',145), 'q', 't', 'o', 'l', 'h', 'a', 'h');
      		 
       
      		 
      DELETE FROM t1 WHERE f01 = 'b';
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t1;

      10.3 803d0521

      		 
      mysqld: /data/src/10.3/storage/innobase/row/row0ins.cc:3475: dberr_t row_ins_index_entry_set_vals(const dict_index_t*, dtuple_t*, const dtuple_t*): Assertion `dict_index_is_clust(index)' failed.
      		 
      191028  1:08:19 [ERROR] mysqld got signal 6 ;
      		 
       
      		 
      #7  0x00007fc702939f12 in __GI___assert_fail (assertion=0x56176f761d56 "dict_index_is_clust(index)", file=0x56176f761f60 "/data/src/10.3/storage/innobase/row/row0ins.cc", line=3475, function=0x56176f766140 <row_ins_index_entry_set_vals(dict_index_t const*, dtuple_t*, dtuple_t const*)::__PRETTY_FUNCTION__> "dberr_t row_ins_index_entry_set_vals(const dict_index_t*, dtuple_t*, const dtuple_t*)") at assert.c:101
      		 
      #8  0x000056176ef95959 in row_ins_index_entry_set_vals (index=0x7fc6ac090e48, entry=0x7fc6ac040be8, row=0x7fc6ac03ff20) at /data/src/10.3/storage/innobase/row/row0ins.cc:3475
      		 
      #9  0x000056176ef95a54 in row_ins_index_entry_step (node=0x7fc6ac040118, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0ins.cc:3500
      		 
      #10 0x000056176ef95f3c in row_ins (node=0x7fc6ac040118, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0ins.cc:3644
      		 
      #11 0x000056176ef966e4 in row_ins_step (thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0ins.cc:3787
      		 
      #12 0x000056176efbef36 in row_update_vers_insert (thr=0x7fc6ac03ae08, node=0x7fc6ac03ee48) at /data/src/10.3/storage/innobase/row/row0mysql.cc:2191
      		 
      #13 0x000056176efbf0c7 in row_update_cascade_for_mysql (thr=0x7fc6ac03ae08, node=0x7fc6ac03ee48, table=0x7fc6ac06fea8) at /data/src/10.3/storage/innobase/row/row0mysql.cc:2247
      		 
      #14 0x000056176ef8fce1 in row_ins_foreign_check_on_constraint (thr=0x7fc6ac03ae08, foreign=0x7fc6ac08b548, pcur=0x7fc6fc534bd0, entry=0x7fc6ac0908e0, mtr=0x7fc6fc535030) at /data/src/10.3/storage/innobase/row/row0ins.cc:1441
      		 
      #15 0x000056176ef90db4 in row_ins_check_foreign_constraint (check_ref=0, foreign=0x7fc6ac08b548, table=0x7fc6ac06fea8, entry=0x7fc6ac0908e0, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0ins.cc:1864
      		 
      #16 0x000056176f023bf4 in row_upd_check_references_constraints (node=0x7fc6ac03a890, pcur=0x7fc6fc5356c0, table=0x7fc6ac06fea8, index=0x7fc6ac08abd8, offsets=0x7fc6ac03ea48, thr=0x7fc6ac03ae08, mtr=0x7fc6fc535c40) at /data/src/10.3/storage/innobase/row/row0upd.cc:296
      		 
      #17 0x000056176f029b80 in row_upd_sec_index_entry (node=0x7fc6ac03a890, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0upd.cc:2510
      		 
      #18 0x000056176f029edb in row_upd_sec_step (node=0x7fc6ac03a890, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0upd.cc:2559
      		 
      #19 0x000056176f02cc7a in row_upd (node=0x7fc6ac03a890, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0upd.cc:3326
      		 
      #20 0x000056176f02d0c7 in row_upd_step (thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0upd.cc:3441
      		 
      #21 0x000056176efbe25a in row_update_for_mysql (prebuilt=0x7fc6ac06dd58) at /data/src/10.3/storage/innobase/row/row0mysql.cc:1888
      		 
      #22 0x000056176ee29e41 in ha_innobase::update_row (this=0x7fc6ac00ae88, old_row=0x7fc6ac0a4118 "", new_row=0x7fc6ac0a32d8 "") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8850
      		 
      #23 0x000056176ec0919c in handler::ha_update_row (this=0x7fc6ac00ae88, old_data=0x7fc6ac0a4118 "", new_data=0x7fc6ac0a32d8 "") at /data/src/10.3/sql/handler.cc:6478
      		 
      #24 0x000056176edb05d1 in TABLE::delete_row (this=0x7fc6ac06d110) at /data/src/10.3/sql/sql_delete.cc:257
      		 
      #25 0x000056176edad7cc in mysql_delete (thd=0x7fc6ac000b00, table_list=0x7fc6ac012900, conds=0x7fc6ac013108, order_list=0x7fc6ac0053c8, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.3/sql/sql_delete.cc:750
      		 
      #26 0x000056176e8e38ee in mysql_execute_command (thd=0x7fc6ac000b00) at /data/src/10.3/sql/sql_parse.cc:4658
      		 
      #27 0x000056176e8ee41b in mysql_parse (thd=0x7fc6ac000b00, rawbuf=0x7fc6ac012818 "DELETE FROM t1 WHERE f01 = 'b'", length=30, parser_state=0x7fc6fc5375e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7834
      		 
      #28 0x000056176e8daf8d in dispatch_command (command=COM_QUERY, thd=0x7fc6ac000b00, packet=0x7fc6ac15fe41 "DELETE FROM t1 WHERE f01 = 'b'", packet_length=30, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1856
      		 
      #29 0x000056176e8d98d5 in do_command (thd=0x7fc6ac000b00) at /data/src/10.3/sql/sql_parse.cc:1401
      		 
      #30 0x000056176ea50894 in do_handle_one_connection (connect=0x56177295f550) at /data/src/10.3/sql/sql_connect.cc:1403
      		 
      #31 0x000056176ea505f6 in handle_one_connection (arg=0x56177295f550) at /data/src/10.3/sql/sql_connect.cc:1308
      		 
      #32 0x000056176f3fec2c in pfs_spawn_thread (arg=0x5617728a4b40) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      		 
      #33 0x00007fc7044af4a4 in start_thread (arg=0x7fc6fc538700) at pthread_create.c:456
      		 
      #34 0x00007fc7029f6d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

      Reproducible on 10.3-10.5. Not reproducible with this test case with other values of innodb_page_size, but it might be the matter of specific data.
      No obvious problem on a non-debug build.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23644 Assertion on evaluating foreign referential action for self-reference in system versioned table

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Attachment clust1.test [ 50379 ]
            elenst Elena Stepanova added a comment -

            Another variation of apparently the same problem:

            10.4 4d61f124

            		 
            mysqld: /data/src/10.4/storage/innobase/row/row0ins.cc:3494: dberr_t row_ins_index_entry_set_vals(const dict_index_t*, dtuple_t*, const dtuple_t*): Assertion `(index)->is_clust()' failed.
            		 
            200201  0:23:08 [ERROR] mysqld got signal 6 ;
            		 
             
            		 
            #7  0x00007eff8e8dff12 in __GI___assert_fail (assertion=0x55d26d5b39db "(index)->is_clust()", file=0x55d26d5b3b90 "/data/src/10.4/storage/innobase/row/row0ins.cc", line=3494, function=0x55d26d5b7ba0 <row_ins_index_entry_set_vals(dict_index_t const*, dtuple_t*, dtuple_t const*)::__PRETTY_FUNCTION__> "dberr_t row_ins_index_entry_set_vals(const dict_index_t*, dtuple_t*, const dtuple_t*)") at assert.c:101
            		 
            #8  0x000055d26cd5e60e in row_ins_index_entry_set_vals (index=0x7eff280651e8, entry=0x7eff2804c468, row=0x7eff2804baf0) at /data/src/10.4/storage/innobase/row/row0ins.cc:3494
            		 
            #9  0x000055d26cd5e709 in row_ins_index_entry_step (node=0x7eff2804bda8, thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0ins.cc:3520
            		 
            #10 0x000055d26cd5ebea in row_ins (node=0x7eff2804bda8, thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0ins.cc:3664
            		 
            #11 0x000055d26cd5f395 in row_ins_step (thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0ins.cc:3807
            		 
            #12 0x000055d26cd8697f in row_update_vers_insert (thr=0x7eff28046f50, node=0x7eff28060cd8) at /data/src/10.4/storage/innobase/row/row0mysql.cc:2192
            		 
            #13 0x000055d26cd86b13 in row_update_cascade_for_mysql (thr=0x7eff28046f50, node=0x7eff28060cd8, table=0x7eff2802cd18) at /data/src/10.4/storage/innobase/row/row0mysql.cc:2248
            		 
            #14 0x000055d26cd5857a in row_ins_foreign_check_on_constraint (thr=0x7eff28046f50, foreign=0x7eff2802c868, pcur=0x7eff883eeff0, entry=0x7eff2804aa08, mtr=0x7eff883ef390) at /data/src/10.4/storage/innobase/row/row0ins.cc:1441
            		 
            #15 0x000055d26cd59617 in row_ins_check_foreign_constraint (check_ref=0, foreign=0x7eff2802c868, table=0x7eff2802cd18, entry=0x7eff2804aa08, thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0ins.cc:1850
            		 
            #16 0x000055d26cde07ce in row_upd_check_references_constraints (node=0x7eff28046858, pcur=0x7eff883ef9e0, table=0x7eff2802cd18, index=0x7eff2805df28, offsets=0x7eff28023c58, thr=0x7eff28046f50, mtr=0x7eff883f00e0) at /data/src/10.4/storage/innobase/row/row0upd.cc:296
            		 
            #17 0x000055d26cde6bee in row_upd_sec_index_entry (node=0x7eff28046858, thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0upd.cc:2499
            		 
            #18 0x000055d26cde6f4c in row_upd_sec_step (node=0x7eff28046858, thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0upd.cc:2546
            		 
            #19 0x000055d26cde9f6d in row_upd (node=0x7eff28046858, thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0upd.cc:3327
            		 
            #20 0x000055d26cdea3b3 in row_upd_step (thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0upd.cc:3442
            		 
            #21 0x000055d26cd85c8a in row_update_for_mysql (prebuilt=0x7eff28045c88) at /data/src/10.4/storage/innobase/row/row0mysql.cc:1889
            		 
            #22 0x000055d26cbe0dfc in ha_innobase::update_row (this=0x7eff2802c068, old_row=0x7eff28042b18 "", new_row=0x7eff280416c8 "") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:8830
            		 
            #23 0x000055d26c9a2790 in handler::ha_update_row (this=0x7eff2802c068, old_data=0x7eff28042b18 "", new_data=0x7eff280416c8 "") at /data/src/10.4/sql/handler.cc:6720
            		 
            #24 0x000055d26cb5d31b in TABLE::delete_row (this=0x7eff2805ee10) at /data/src/10.4/sql/sql_delete.cc:293
            		 
            #25 0x000055d26cb5a07a in mysql_delete (thd=0x7eff28000af0, table_list=0x7eff28011e80, conds=0x7eff28013900, order_list=0x7eff280054a8, limit=18446744073709551613, options=0, result=0x0) at /data/src/10.4/sql/sql_delete.cc:804
            		 
            #26 0x000055d26c6340c6 in mysql_execute_command (thd=0x7eff28000af0) at /data/src/10.4/sql/sql_parse.cc:4728
            		 
            #27 0x000055d26c63f903 in mysql_parse (thd=0x7eff28000af0, rawbuf=0x7eff28011d38 "DELETE FROM table100_int_autoinc WHERE col_set_ucs2 IS NOT NULL", length=63, parser_state=0x7eff883f2160, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7901
            		 
            #28 0x000055d26c62aad0 in dispatch_command (command=COM_QUERY, thd=0x7eff28000af0, packet=0x7eff280083a1 "DELETE FROM table100_int_autoinc WHERE col_set_ucs2 IS NOT NULL   ", packet_length=66, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1842
            		 
            #29 0x000055d26c62915d in do_command (thd=0x7eff28000af0) at /data/src/10.4/sql/sql_parse.cc:1360
            		 
            #30 0x000055d26c7b2377 in do_handle_one_connection (connect=0x55d2701df770) at /data/src/10.4/sql/sql_connect.cc:1412
            		 
            #31 0x000055d26c7b20c6 in handle_one_connection (arg=0x55d2701df770) at /data/src/10.4/sql/sql_connect.cc:1316
            		 
            #32 0x000055d26d1ba7c3 in pfs_spawn_thread (arg=0x55d270175030) at /data/src/10.4/storage/perfschema/pfs.cc:1869
            		 
            #33 0x00007eff908684a4 in start_thread (arg=0x7eff883f3700) at pthread_create.c:456
            		 
            #34 0x00007eff8e99cd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

            Dirty test case is attached as clust1.test, also to be run with --mysqld=--innodb_page_size=4K

            elenst Elena Stepanova added a comment - Another variation of apparently the same problem: 10.4 4d61f124 mysqld: /data/src/10.4/storage/innobase/row/row0ins.cc:3494: dberr_t row_ins_index_entry_set_vals(const dict_index_t*, dtuple_t*, const dtuple_t*): Assertion `(index)->is_clust()' failed. 200201 0:23:08 [ERROR] mysqld got signal 6 ;   #7 0x00007eff8e8dff12 in __GI___assert_fail (assertion=0x55d26d5b39db "(index)->is_clust()", file=0x55d26d5b3b90 "/data/src/10.4/storage/innobase/row/row0ins.cc", line=3494, function=0x55d26d5b7ba0 <row_ins_index_entry_set_vals(dict_index_t const*, dtuple_t*, dtuple_t const*)::__PRETTY_FUNCTION__> "dberr_t row_ins_index_entry_set_vals(const dict_index_t*, dtuple_t*, const dtuple_t*)") at assert.c:101 #8 0x000055d26cd5e60e in row_ins_index_entry_set_vals (index=0x7eff280651e8, entry=0x7eff2804c468, row=0x7eff2804baf0) at /data/src/10.4/storage/innobase/row/row0ins.cc:3494 #9 0x000055d26cd5e709 in row_ins_index_entry_step (node=0x7eff2804bda8, thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0ins.cc:3520 #10 0x000055d26cd5ebea in row_ins (node=0x7eff2804bda8, thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0ins.cc:3664 #11 0x000055d26cd5f395 in row_ins_step (thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0ins.cc:3807 #12 0x000055d26cd8697f in row_update_vers_insert (thr=0x7eff28046f50, node=0x7eff28060cd8) at /data/src/10.4/storage/innobase/row/row0mysql.cc:2192 #13 0x000055d26cd86b13 in row_update_cascade_for_mysql (thr=0x7eff28046f50, node=0x7eff28060cd8, table=0x7eff2802cd18) at /data/src/10.4/storage/innobase/row/row0mysql.cc:2248 #14 0x000055d26cd5857a in row_ins_foreign_check_on_constraint (thr=0x7eff28046f50, foreign=0x7eff2802c868, pcur=0x7eff883eeff0, entry=0x7eff2804aa08, mtr=0x7eff883ef390) at /data/src/10.4/storage/innobase/row/row0ins.cc:1441 #15 0x000055d26cd59617 in row_ins_check_foreign_constraint (check_ref=0, foreign=0x7eff2802c868, table=0x7eff2802cd18, entry=0x7eff2804aa08, thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0ins.cc:1850 #16 0x000055d26cde07ce in row_upd_check_references_constraints (node=0x7eff28046858, pcur=0x7eff883ef9e0, table=0x7eff2802cd18, index=0x7eff2805df28, offsets=0x7eff28023c58, thr=0x7eff28046f50, mtr=0x7eff883f00e0) at /data/src/10.4/storage/innobase/row/row0upd.cc:296 #17 0x000055d26cde6bee in row_upd_sec_index_entry (node=0x7eff28046858, thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0upd.cc:2499 #18 0x000055d26cde6f4c in row_upd_sec_step (node=0x7eff28046858, thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0upd.cc:2546 #19 0x000055d26cde9f6d in row_upd (node=0x7eff28046858, thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0upd.cc:3327 #20 0x000055d26cdea3b3 in row_upd_step (thr=0x7eff28046f50) at /data/src/10.4/storage/innobase/row/row0upd.cc:3442 #21 0x000055d26cd85c8a in row_update_for_mysql (prebuilt=0x7eff28045c88) at /data/src/10.4/storage/innobase/row/row0mysql.cc:1889 #22 0x000055d26cbe0dfc in ha_innobase::update_row (this=0x7eff2802c068, old_row=0x7eff28042b18 "", new_row=0x7eff280416c8 "") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:8830 #23 0x000055d26c9a2790 in handler::ha_update_row (this=0x7eff2802c068, old_data=0x7eff28042b18 "", new_data=0x7eff280416c8 "") at /data/src/10.4/sql/handler.cc:6720 #24 0x000055d26cb5d31b in TABLE::delete_row (this=0x7eff2805ee10) at /data/src/10.4/sql/sql_delete.cc:293 #25 0x000055d26cb5a07a in mysql_delete (thd=0x7eff28000af0, table_list=0x7eff28011e80, conds=0x7eff28013900, order_list=0x7eff280054a8, limit=18446744073709551613, options=0, result=0x0) at /data/src/10.4/sql/sql_delete.cc:804 #26 0x000055d26c6340c6 in mysql_execute_command (thd=0x7eff28000af0) at /data/src/10.4/sql/sql_parse.cc:4728 #27 0x000055d26c63f903 in mysql_parse (thd=0x7eff28000af0, rawbuf=0x7eff28011d38 "DELETE FROM table100_int_autoinc WHERE col_set_ucs2 IS NOT NULL", length=63, parser_state=0x7eff883f2160, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7901 #28 0x000055d26c62aad0 in dispatch_command (command=COM_QUERY, thd=0x7eff28000af0, packet=0x7eff280083a1 "DELETE FROM table100_int_autoinc WHERE col_set_ucs2 IS NOT NULL ", packet_length=66, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1842 #29 0x000055d26c62915d in do_command (thd=0x7eff28000af0) at /data/src/10.4/sql/sql_parse.cc:1360 #30 0x000055d26c7b2377 in do_handle_one_connection (connect=0x55d2701df770) at /data/src/10.4/sql/sql_connect.cc:1412 #31 0x000055d26c7b20c6 in handle_one_connection (arg=0x55d2701df770) at /data/src/10.4/sql/sql_connect.cc:1316 #32 0x000055d26d1ba7c3 in pfs_spawn_thread (arg=0x55d270175030) at /data/src/10.4/storage/perfschema/pfs.cc:1869 #33 0x00007eff908684a4 in start_thread (arg=0x7eff883f3700) at pthread_create.c:456 #34 0x00007eff8e99cd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Dirty test case is attached as clust1.test , also to be run with --mysqld=--innodb_page_size=4K
            elenst Elena Stepanova made changes -
            Description _Note: The problem might be related to (or even be a side-effect of) MDEV-20902, as the test case involves the same flawed structure; but I'm not sure it's the only way to get the same failure, so I'm filing it separately, to be safe._

            _Note: Run the test case with *{{\-\-mysqld=\-\-innodb_page_size=4K}}*._

            {code:sql}
            --source include/have_innodb.inc

            CREATE TABLE t1 (
                pk integer,
                f01 char(255) CHARACTER SET utf8,
                f02 char(255) CHARACTER SET ucs2,
                f03 set ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') CHARACTER SET ucs2,
                f04 INT,
                f05 varchar(255) CHARACTER SET ucs2,
                f06 longtext CHARACTER SET utf8,
                f07 char(255) CHARACTER SET ucs2,
                f08 longtext CHARACTER SET utf8,
                f09 varchar(255) CHARACTER SET ucs2,
                f10 longtext CHARACTER SET ucs2,
                f11 set ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') CHARACTER SET ucs2,
                f12 char(255) CHARACTER SET utf8,
                PRIMARY KEY (pk),
                KEY (f05),
                KEY (f11),
                FOREIGN KEY (f03) REFERENCES t1 (f11) ON DELETE SET NULL
            ) ENGINE=InnoDB WITH SYSTEM VERSIONING;

            INSERT IGNORE INTO t1 VALUES
                (1,'a', 'c', 'a', 1, REPEAT('a',189), 's', 'h', 'y', 'foobar', 'g', 'a', 'c') ,
                (2,'b', 'e', 'a', 2, REPEAT('a',145), 'q', 't', 'o', 'l', 'h', 'a', 'h');

            DELETE FROM t1 WHERE f01 = 'b';

            # Cleanup
            DROP TABLE t1;
            {code}

            {noformat:title=10.3 803d0521}
            mysqld: /data/src/10.3/storage/innobase/row/row0ins.cc:3475: dberr_t row_ins_index_entry_set_vals(const dict_index_t*, dtuple_t*, const dtuple_t*): Assertion `dict_index_is_clust(index)' failed.
            191028 1:08:19 [ERROR] mysqld got signal 6 ;

            #7 0x00007fc702939f12 in __GI___assert_fail (assertion=0x56176f761d56 "dict_index_is_clust(index)", file=0x56176f761f60 "/data/src/10.3/storage/innobase/row/row0ins.cc", line=3475, function=0x56176f766140 <row_ins_index_entry_set_vals(dict_index_t const*, dtuple_t*, dtuple_t const*)::__PRETTY_FUNCTION__> "dberr_t row_ins_index_entry_set_vals(const dict_index_t*, dtuple_t*, const dtuple_t*)") at assert.c:101
            #8 0x000056176ef95959 in row_ins_index_entry_set_vals (index=0x7fc6ac090e48, entry=0x7fc6ac040be8, row=0x7fc6ac03ff20) at /data/src/10.3/storage/innobase/row/row0ins.cc:3475
            #9 0x000056176ef95a54 in row_ins_index_entry_step (node=0x7fc6ac040118, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0ins.cc:3500
            #10 0x000056176ef95f3c in row_ins (node=0x7fc6ac040118, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0ins.cc:3644
            #11 0x000056176ef966e4 in row_ins_step (thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0ins.cc:3787
            #12 0x000056176efbef36 in row_update_vers_insert (thr=0x7fc6ac03ae08, node=0x7fc6ac03ee48) at /data/src/10.3/storage/innobase/row/row0mysql.cc:2191
            #13 0x000056176efbf0c7 in row_update_cascade_for_mysql (thr=0x7fc6ac03ae08, node=0x7fc6ac03ee48, table=0x7fc6ac06fea8) at /data/src/10.3/storage/innobase/row/row0mysql.cc:2247
            #14 0x000056176ef8fce1 in row_ins_foreign_check_on_constraint (thr=0x7fc6ac03ae08, foreign=0x7fc6ac08b548, pcur=0x7fc6fc534bd0, entry=0x7fc6ac0908e0, mtr=0x7fc6fc535030) at /data/src/10.3/storage/innobase/row/row0ins.cc:1441
            #15 0x000056176ef90db4 in row_ins_check_foreign_constraint (check_ref=0, foreign=0x7fc6ac08b548, table=0x7fc6ac06fea8, entry=0x7fc6ac0908e0, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0ins.cc:1864
            #16 0x000056176f023bf4 in row_upd_check_references_constraints (node=0x7fc6ac03a890, pcur=0x7fc6fc5356c0, table=0x7fc6ac06fea8, index=0x7fc6ac08abd8, offsets=0x7fc6ac03ea48, thr=0x7fc6ac03ae08, mtr=0x7fc6fc535c40) at /data/src/10.3/storage/innobase/row/row0upd.cc:296
            #17 0x000056176f029b80 in row_upd_sec_index_entry (node=0x7fc6ac03a890, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0upd.cc:2510
            #18 0x000056176f029edb in row_upd_sec_step (node=0x7fc6ac03a890, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0upd.cc:2559
            #19 0x000056176f02cc7a in row_upd (node=0x7fc6ac03a890, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0upd.cc:3326
            #20 0x000056176f02d0c7 in row_upd_step (thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0upd.cc:3441
            #21 0x000056176efbe25a in row_update_for_mysql (prebuilt=0x7fc6ac06dd58) at /data/src/10.3/storage/innobase/row/row0mysql.cc:1888
            #22 0x000056176ee29e41 in ha_innobase::update_row (this=0x7fc6ac00ae88, old_row=0x7fc6ac0a4118 "", new_row=0x7fc6ac0a32d8 "") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8850
            #23 0x000056176ec0919c in handler::ha_update_row (this=0x7fc6ac00ae88, old_data=0x7fc6ac0a4118 "", new_data=0x7fc6ac0a32d8 "") at /data/src/10.3/sql/handler.cc:6478
            #24 0x000056176edb05d1 in TABLE::delete_row (this=0x7fc6ac06d110) at /data/src/10.3/sql/sql_delete.cc:257
            #25 0x000056176edad7cc in mysql_delete (thd=0x7fc6ac000b00, table_list=0x7fc6ac012900, conds=0x7fc6ac013108, order_list=0x7fc6ac0053c8, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.3/sql/sql_delete.cc:750
            #26 0x000056176e8e38ee in mysql_execute_command (thd=0x7fc6ac000b00) at /data/src/10.3/sql/sql_parse.cc:4658
            #27 0x000056176e8ee41b in mysql_parse (thd=0x7fc6ac000b00, rawbuf=0x7fc6ac012818 "DELETE FROM t1 WHERE f01 = 'b'", length=30, parser_state=0x7fc6fc5375e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7834
            #28 0x000056176e8daf8d in dispatch_command (command=COM_QUERY, thd=0x7fc6ac000b00, packet=0x7fc6ac15fe41 "DELETE FROM t1 WHERE f01 = 'b'", packet_length=30, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1856
            #29 0x000056176e8d98d5 in do_command (thd=0x7fc6ac000b00) at /data/src/10.3/sql/sql_parse.cc:1401
            #30 0x000056176ea50894 in do_handle_one_connection (connect=0x56177295f550) at /data/src/10.3/sql/sql_connect.cc:1403
            #31 0x000056176ea505f6 in handle_one_connection (arg=0x56177295f550) at /data/src/10.3/sql/sql_connect.cc:1308
            #32 0x000056176f3fec2c in pfs_spawn_thread (arg=0x5617728a4b40) at /data/src/10.3/storage/perfschema/pfs.cc:1862
            #33 0x00007fc7044af4a4 in start_thread (arg=0x7fc6fc538700) at pthread_create.c:456
            #34 0x00007fc7029f6d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
            {noformat}

            Reproducible on 10.3-10.5. Not reproducible with this test case with other values of {{innodb_page_size}}, but it might be the matter of specific data.             		_Note: The problem might be related to (or even be a side-effect of) MDEV-20902, as the test case involves the same flawed structure; but I'm not sure it's the only way to get the same failure, so I'm filing it separately, to be safe._

            _Note: Run the test case with *{{\-\-mysqld=\-\-innodb_page_size=4K}}*._

            {code:sql}
            --source include/have_innodb.inc

            CREATE TABLE t1 (
                pk integer,
                f01 char(255) CHARACTER SET utf8,
                f02 char(255) CHARACTER SET ucs2,
                f03 set ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') CHARACTER SET ucs2,
                f04 INT,
                f05 varchar(255) CHARACTER SET ucs2,
                f06 longtext CHARACTER SET utf8,
                f07 char(255) CHARACTER SET ucs2,
                f08 longtext CHARACTER SET utf8,
                f09 varchar(255) CHARACTER SET ucs2,
                f10 longtext CHARACTER SET ucs2,
                f11 set ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') CHARACTER SET ucs2,
                f12 char(255) CHARACTER SET utf8,
                PRIMARY KEY (pk),
                KEY (f05),
                KEY (f11),
                FOREIGN KEY (f03) REFERENCES t1 (f11) ON DELETE SET NULL
            ) ENGINE=InnoDB WITH SYSTEM VERSIONING;

            INSERT IGNORE INTO t1 VALUES
                (1,'a', 'c', 'a', 1, REPEAT('a',189), 's', 'h', 'y', 'foobar', 'g', 'a', 'c') ,
                (2,'b', 'e', 'a', 2, REPEAT('a',145), 'q', 't', 'o', 'l', 'h', 'a', 'h');

            DELETE FROM t1 WHERE f01 = 'b';

            # Cleanup
            DROP TABLE t1;
            {code}

            {noformat:title=10.3 803d0521}
            mysqld: /data/src/10.3/storage/innobase/row/row0ins.cc:3475: dberr_t row_ins_index_entry_set_vals(const dict_index_t*, dtuple_t*, const dtuple_t*): Assertion `dict_index_is_clust(index)' failed.
            191028 1:08:19 [ERROR] mysqld got signal 6 ;

            #7 0x00007fc702939f12 in __GI___assert_fail (assertion=0x56176f761d56 "dict_index_is_clust(index)", file=0x56176f761f60 "/data/src/10.3/storage/innobase/row/row0ins.cc", line=3475, function=0x56176f766140 <row_ins_index_entry_set_vals(dict_index_t const*, dtuple_t*, dtuple_t const*)::__PRETTY_FUNCTION__> "dberr_t row_ins_index_entry_set_vals(const dict_index_t*, dtuple_t*, const dtuple_t*)") at assert.c:101
            #8 0x000056176ef95959 in row_ins_index_entry_set_vals (index=0x7fc6ac090e48, entry=0x7fc6ac040be8, row=0x7fc6ac03ff20) at /data/src/10.3/storage/innobase/row/row0ins.cc:3475
            #9 0x000056176ef95a54 in row_ins_index_entry_step (node=0x7fc6ac040118, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0ins.cc:3500
            #10 0x000056176ef95f3c in row_ins (node=0x7fc6ac040118, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0ins.cc:3644
            #11 0x000056176ef966e4 in row_ins_step (thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0ins.cc:3787
            #12 0x000056176efbef36 in row_update_vers_insert (thr=0x7fc6ac03ae08, node=0x7fc6ac03ee48) at /data/src/10.3/storage/innobase/row/row0mysql.cc:2191
            #13 0x000056176efbf0c7 in row_update_cascade_for_mysql (thr=0x7fc6ac03ae08, node=0x7fc6ac03ee48, table=0x7fc6ac06fea8) at /data/src/10.3/storage/innobase/row/row0mysql.cc:2247
            #14 0x000056176ef8fce1 in row_ins_foreign_check_on_constraint (thr=0x7fc6ac03ae08, foreign=0x7fc6ac08b548, pcur=0x7fc6fc534bd0, entry=0x7fc6ac0908e0, mtr=0x7fc6fc535030) at /data/src/10.3/storage/innobase/row/row0ins.cc:1441
            #15 0x000056176ef90db4 in row_ins_check_foreign_constraint (check_ref=0, foreign=0x7fc6ac08b548, table=0x7fc6ac06fea8, entry=0x7fc6ac0908e0, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0ins.cc:1864
            #16 0x000056176f023bf4 in row_upd_check_references_constraints (node=0x7fc6ac03a890, pcur=0x7fc6fc5356c0, table=0x7fc6ac06fea8, index=0x7fc6ac08abd8, offsets=0x7fc6ac03ea48, thr=0x7fc6ac03ae08, mtr=0x7fc6fc535c40) at /data/src/10.3/storage/innobase/row/row0upd.cc:296
            #17 0x000056176f029b80 in row_upd_sec_index_entry (node=0x7fc6ac03a890, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0upd.cc:2510
            #18 0x000056176f029edb in row_upd_sec_step (node=0x7fc6ac03a890, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0upd.cc:2559
            #19 0x000056176f02cc7a in row_upd (node=0x7fc6ac03a890, thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0upd.cc:3326
            #20 0x000056176f02d0c7 in row_upd_step (thr=0x7fc6ac03ae08) at /data/src/10.3/storage/innobase/row/row0upd.cc:3441
            #21 0x000056176efbe25a in row_update_for_mysql (prebuilt=0x7fc6ac06dd58) at /data/src/10.3/storage/innobase/row/row0mysql.cc:1888
            #22 0x000056176ee29e41 in ha_innobase::update_row (this=0x7fc6ac00ae88, old_row=0x7fc6ac0a4118 "", new_row=0x7fc6ac0a32d8 "") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8850
            #23 0x000056176ec0919c in handler::ha_update_row (this=0x7fc6ac00ae88, old_data=0x7fc6ac0a4118 "", new_data=0x7fc6ac0a32d8 "") at /data/src/10.3/sql/handler.cc:6478
            #24 0x000056176edb05d1 in TABLE::delete_row (this=0x7fc6ac06d110) at /data/src/10.3/sql/sql_delete.cc:257
            #25 0x000056176edad7cc in mysql_delete (thd=0x7fc6ac000b00, table_list=0x7fc6ac012900, conds=0x7fc6ac013108, order_list=0x7fc6ac0053c8, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.3/sql/sql_delete.cc:750
            #26 0x000056176e8e38ee in mysql_execute_command (thd=0x7fc6ac000b00) at /data/src/10.3/sql/sql_parse.cc:4658
            #27 0x000056176e8ee41b in mysql_parse (thd=0x7fc6ac000b00, rawbuf=0x7fc6ac012818 "DELETE FROM t1 WHERE f01 = 'b'", length=30, parser_state=0x7fc6fc5375e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7834
            #28 0x000056176e8daf8d in dispatch_command (command=COM_QUERY, thd=0x7fc6ac000b00, packet=0x7fc6ac15fe41 "DELETE FROM t1 WHERE f01 = 'b'", packet_length=30, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1856
            #29 0x000056176e8d98d5 in do_command (thd=0x7fc6ac000b00) at /data/src/10.3/sql/sql_parse.cc:1401
            #30 0x000056176ea50894 in do_handle_one_connection (connect=0x56177295f550) at /data/src/10.3/sql/sql_connect.cc:1403
            #31 0x000056176ea505f6 in handle_one_connection (arg=0x56177295f550) at /data/src/10.3/sql/sql_connect.cc:1308
            #32 0x000056176f3fec2c in pfs_spawn_thread (arg=0x5617728a4b40) at /data/src/10.3/storage/perfschema/pfs.cc:1862
            #33 0x00007fc7044af4a4 in start_thread (arg=0x7fc6fc538700) at pthread_create.c:456
            #34 0x00007fc7029f6d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
            {noformat}

            Reproducible on 10.3-10.5. Not reproducible with this test case with other values of {{innodb_page_size}}, but it might be the matter of specific data.
            No obvious problem on a non-debug build.
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 100610 ] MariaDB v4 [ 141606 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.3 [ 22126 ]
            midenok Aleksey Midenkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            midenok Aleksey Midenkov added a comment -

            That doesn't reproduce for me in 10.4 3e7561cf35a (nor clean, nor dirty test)

            midenok Aleksey Midenkov added a comment - That doesn't reproduce for me in 10.4 3e7561cf35a (nor clean, nor dirty test)
            midenok Aleksey Midenkov made changes -
            Assignee Aleksey Midenkov [ midenok ] Elena Stepanova [ elenst ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            elenst Elena Stepanova added a comment -

            There have been so many changes around FK over this time, so it's not at all surprising; but I'll check it later, just to be sure.

            elenst Elena Stepanova added a comment - There have been so many changes around FK over this time, so it's not at all surprising; but I'll check it later, just to be sure.
            elenst Elena Stepanova made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            elenst Elena Stepanova added a comment -

            It was fixed along with MDEV-23644.

            elenst Elena Stepanova added a comment - It was fixed along with MDEV-23644 .
            elenst Elena Stepanova made changes -
            Fix Version/s 10.3.38 [ 28507 ]
            Fix Version/s 10.5.9 [ 25109 ]
            Fix Version/s 10.4.18 [ 25110 ]
            Fix Version/s 10.4 [ 22408 ]
            Assignee Elena Stepanova [ elenst ]
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]
            elenst Elena Stepanova made changes -

            People

              Unassigned Unassigned
              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.