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

[ERROR] InnoDB: Field <wrong len>, Assertion `err != DB_SUCCESS || btr_validate_index(m_index, __null, false) == DB_SUCCESS' failed

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (
        pk int,
        c1 char(255),
        c2 char(255),
        c3 char(255),
        c4 char(255),
        c5 char(255),
        c6 char(255),
        c7 char(255),
        c8 char(255),
        primary key (pk)
      ) CHARACTER SET utf32 ENGINE=InnoDB;
      INSERT INTO t1 VALUES
        (1, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'),
        (2, 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p');
       
      CHECK TABLE t1;
      ALTER TABLE t1 FORCE;
       
      # Cleanup
      DROP TABLE t1;
      

      10.2 b87c342d

      CHECK TABLE t1;
      Table	Op	Msg_type	Msg_text
      test.t1	check	Warning	InnoDB: The B-tree of index PRIMARY is corrupted.
      test.t1	check	error	Corrupt
      

      10.2 b87c342d

      2021-01-31 20:49:18 140313766991616 [Note] InnoDB: Record in index `PRIMARY` of table `test`.`t1`, page [page id: space=4, page number=3], at offset 142
      2021-01-31 20:49:18 140313766991616 [ERROR] InnoDB: Field 3 len is 20, should be 1020; COMPACT RECORD(info_bits=0, 11 fields): {[4]    (0x80000001),[6]      (0x000000000503),[7]    5  (0x82000001350110),[0+20](0x)(0x00000004000000040000002600000000000003FC),[1020]   b                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
      2021-01-31 20:49:18 140313766991616 [Note] InnoDB: Record in index `PRIMARY` of table `test`.`#sql-1e7da9_9`, page [page id: space=5, page number=3], at offset 142
      2021-01-31 20:49:18 140313766991616 [ERROR] InnoDB: Field 3 len is 20, should be 1020; COMPACT RECORD(info_bits=0, 11 fields): {[4]    (0x80000001),[6]      (0x000000000503),[7]    5  (0x82000001350110),[0+20](0x)(0x00000005000000050000002600000000000003FC),[1020]   b                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
      mysqld: /data/src/10.2/storage/innobase/btr/btr0bulk.cc:1092: dberr_t BtrBulk::finish(dberr_t): Assertion `err != DB_SUCCESS || btr_validate_index(m_index, __null, false) == DB_SUCCESS' failed.
      210131 20:49:18 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f9d5df69f36 in __GI___assert_fail (assertion=0x55b1f63d9130 "err != DB_SUCCESS || btr_validate_index(m_index, __null, false) == DB_SUCCESS", file=0x55b1f63d8910 "/data/src/10.2/storage/innobase/btr/btr0bulk.cc", line=1092, function=0x55b1f63d90b8 "dberr_t BtrBulk::finish(dberr_t)") at assert.c:101
      #8  0x000055b1f5e38259 in BtrBulk::finish (this=0x7f9cf8039190, err=DB_SUCCESS) at /data/src/10.2/storage/innobase/btr/btr0bulk.cc:1092
      #9  0x000055b1f5d3dfb5 in row_merge_read_clustered_index (trx=0x7f9d58fa2120, table=0x7f9cf8098c50, old_table=0x7f9cf8173450, new_table=0x7f9cf809d5e0, online=true, index=0x7f9cf809d378, fts_sort_idx=0x0, psort_info=0x0, files=0x7f9cf817c570, key_numbers=0x7f9cf809d380, n_index=1, add_cols=0x0, add_v=0x0, col_map=0x7f9cf809d448, add_autoinc=18446744073709551615, sequence=..., block=0x7f9d484f9000 <error: Cannot access memory at address 0x7f9d484f9000>, skip_pk_sort=true, tmpfd=0x7f9d583cd988, stage=0x7f9cf8182d10, pct_cost=50, crypt_block=0x0, eval_table=0x7f9cf8098c50) at /data/src/10.2/storage/innobase/row/row0merge.cc:2401
      #10 0x000055b1f5d44282 in row_merge_build_indexes (trx=0x7f9d58fa2120, old_table=0x7f9cf8173450, new_table=0x7f9cf809d5e0, online=true, indexes=0x7f9cf809d378, key_numbers=0x7f9cf809d380, n_indexes=1, table=0x7f9cf8098c50, add_cols=0x0, col_map=0x7f9cf809d448, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=true, stage=0x7f9cf8182d10, add_v=0x0, eval_table=0x7f9cf8098c50) at /data/src/10.2/storage/innobase/row/row0merge.cc:4681
      #11 0x000055b1f5c4b2f7 in ha_innobase::inplace_alter_table (this=0x7f9cf8036ea8, altered_table=0x7f9cf8098c50, ha_alter_info=0x7f9d583ce030) at /data/src/10.2/storage/innobase/handler/handler0alter.cc:6292
      #12 0x000055b1f585f371 in handler::ha_inplace_alter_table (this=0x7f9cf8036ea8, altered_table=0x7f9cf8098c50, ha_alter_info=0x7f9d583ce030) at /data/src/10.2/sql/handler.h:3792
      #13 0x000055b1f5854801 in mysql_inplace_alter_table (thd=0x7f9cf8000d90, table_list=0x7f9cf80127c8, table=0x7f9cf809f8e0, altered_table=0x7f9cf8098c50, ha_alter_info=0x7f9d583ce030, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f9d583ce0c0, alter_ctx=0x7f9d583ce670) at /data/src/10.2/sql/sql_table.cc:7458
      #14 0x000055b1f585a698 in mysql_alter_table (thd=0x7f9cf8000d90, new_db=0x7f9cf8012de0 "test", new_name=0x0, create_info=0x7f9d583cf290, table_list=0x7f9cf80127c8, alter_info=0x7f9d583cf1e0, order_num=0, order=0x0, ignore=false) at /data/src/10.2/sql/sql_table.cc:9627
      #15 0x000055b1f58d8d68 in Sql_cmd_alter_table::execute (this=0x7f9cf8012de8, thd=0x7f9cf8000d90) at /data/src/10.2/sql/sql_alter.cc:333
      #16 0x000055b1f578704d in mysql_execute_command (thd=0x7f9cf8000d90) at /data/src/10.2/sql/sql_parse.cc:5994
      #17 0x000055b1f578c065 in mysql_parse (thd=0x7f9cf8000d90, rawbuf=0x7f9cf80126f8 "ALTER TABLE t1 FORCE", length=20, parser_state=0x7f9d583d05f0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7763
      #18 0x000055b1f577a33e in dispatch_command (command=COM_QUERY, thd=0x7f9cf8000d90, packet=0x7f9cf8008b51 "ALTER TABLE t1 FORCE", packet_length=20, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1827
      #19 0x000055b1f5778e39 in do_command (thd=0x7f9cf8000d90) at /data/src/10.2/sql/sql_parse.cc:1381
      #20 0x000055b1f58d375e in do_handle_one_connection (connect=0x55b1f8349f90) at /data/src/10.2/sql/sql_connect.cc:1336
      #21 0x000055b1f58d34c3 in handle_one_connection (arg=0x55b1f8349f90) at /data/src/10.2/sql/sql_connect.cc:1241
      #22 0x000055b1f60fba52 in pfs_spawn_thread (arg=0x55b1f832d380) at /data/src/10.2/storage/perfschema/pfs.cc:1869
      #23 0x00007f9d5e479609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #24 0x00007f9d5e055293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Reproducible on 10.2-10.6.
      Non-debug build doesn't crash immediately, but the errors upon CHECK (in the client and in the log) are still there.
      The debug build, on the other hand, fails even without CHECK.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              thiru Thirunarayanan Balathandayuthapani
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: