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

InnoDB: Flagged corruption, Assertion `inited==INDEX' failed

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE t (a CHAR(16), b TEXT, UNIQUE(b,a(8))) ENGINE=InnoDB;
      INSERT INTO t VALUES ('foo','bar');
      CHECK TABLE t EXTENDED;
      ANALYZE TABLE t PERSISTENT FOR ALL;
      

      10.6.16

      2024-03-02 21:06:50 4 [ERROR] InnoDB: Flagged corruption of `b` in table `test`.`t` in CHECK TABLE; Wrong count
      mariadbd: /data/bld/10.6.16-asan/sql/handler.cc:3608: int handler::ha_index_first(uchar*): Assertion `inited==INDEX' failed.
      240302 21:06:50 [ERROR] mysqld got signal 6 ;
       
      #8  0x00007fa982645395 in __assert_fail_base (fmt=0x7fa9827b9a90 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5597b8cbe000 "inited==INDEX", file=file@entry=0x5597b8cc4260 "/data/bld/10.6.16-asan/sql/handler.cc", line=line@entry=3608, function=function@entry=0x5597b8cc8c80 "int handler::ha_index_first(uchar*)") at ./assert/assert.c:92
      #9  0x00007fa982653e32 in __GI___assert_fail (assertion=0x5597b8cbe000 "inited==INDEX", file=0x5597b8cc4260 "/data/bld/10.6.16-asan/sql/handler.cc", line=3608, function=0x5597b8cc8c80 "int handler::ha_index_first(uchar*)") at ./assert/assert.c:101
      #10 0x00005597b7016dad in handler::ha_index_first (this=0x61d0002c4cb8, buf=0x6190000f6ec8 "\376foo", ' ' <repeats 13 times>) at /data/bld/10.6.16-asan/sql/handler.cc:3608
      #11 0x00005597b69d7f93 in collect_statistics_for_index (thd=0x62b0000bd218, table=0x6190000f6998, index=0) at /data/bld/10.6.16-asan/sql/sql_statistics.cc:2560
      #12 0x00005597b69d9271 in collect_statistics_for_table (thd=0x62b0000bd218, table=0x6190000f6998) at /data/bld/10.6.16-asan/sql/sql_statistics.cc:2743
      #13 0x00005597b6c2792b in mysql_admin_table (thd=0x62b0000bd218, tables=0x62b0000c4340, check_opt=0x62b0000c28e8, operator_name=0x5597b9f1baa0 <msg_analyze>, lock_type=TL_READ_NO_INSERT, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x5597b7022b56 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0x0, is_cmd_replicated=true) at /data/bld/10.6.16-asan/sql/sql_admin.cc:1067
      #14 0x00005597b6c2bc98 in Sql_cmd_analyze_table::execute (this=0x62b0000c4a60, thd=0x62b0000bd218) at /data/bld/10.6.16-asan/sql/sql_admin.cc:1561
      #15 0x00005597b679773a in mysql_execute_command (thd=0x62b0000bd218, is_called_from_prepared_stmt=false) at /data/bld/10.6.16-asan/sql/sql_parse.cc:6026
      #16 0x00005597b67a4bc7 in mysql_parse (thd=0x62b0000bd218, rawbuf=0x62b0000c4238 "ANALYZE TABLE t PERSISTENT FOR ALL", length=34, parser_state=0x7fa9755809f0) at /data/bld/10.6.16-asan/sql/sql_parse.cc:8051
      #17 0x00005597b677a7ec in dispatch_command (command=COM_QUERY, thd=0x62b0000bd218, packet=0x62900028a219 "", packet_length=34, blocking=true) at /data/bld/10.6.16-asan/sql/sql_parse.cc:1896
      #18 0x00005597b6777520 in do_command (thd=0x62b0000bd218, blocking=true) at /data/bld/10.6.16-asan/sql/sql_parse.cc:1409
      #19 0x00005597b6bea114 in do_handle_one_connection (connect=0x608000003ab8, put_in_cache=true) at /data/bld/10.6.16-asan/sql/sql_connect.cc:1416
      #20 0x00005597b6be9ad5 in handle_one_connection (arg=0x608000003a38) at /data/bld/10.6.16-asan/sql/sql_connect.cc:1318
      #21 0x00005597b784eec0 in pfs_spawn_thread (arg=0x617000008218) at /data/bld/10.6.16-asan/storage/perfschema/pfs.cc:2201
      #22 0x00007fa9826a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #23 0x00007fa98272861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.