Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2, 10.3, 10.4, 10.5, 10.6
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
- is duplicated by
-
-
- Closed
-
- relates to
-
-
- Closed
-