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
- relates to
-
MDEV-29954 Unique hash key on column prefix is computed incorrectly
- Closed