Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
Description
--source include/have_innodb.inc
|
|
CREATE TEMPORARY TABLE t (a INT, KEY(a)) ENGINE=InnoDB; |
INSERT INTO t VALUES (1); |
ALTER TABLE t FORCE; |
UPDATE t SET a = 8; |
CHECK TABLE t EXTENDED; |
|
# Cleanup
|
DROP TABLE t; |
10.6 b7fe6179 |
mariadbd: /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/trx/trx0rec.cc:2164: dberr_t trx_undo_prev_version_build(const rec_t*, dict_index_t*, rec_offs*, mem_heap_t*, rec_t**, mem_heap_t*, dtuple_t**, ulint): Assertion `!index->table->is_temporary()' failed.
|
221026 14:26:01 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007ff20a715662 in __GI___assert_fail (assertion=0x55c263dc3f20 "!index->table->is_temporary()", file=0x55c263dc4f00 "/home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/trx/trx0rec.cc", line=2164, function=0x55c263dc7aa0 "dberr_t trx_undo_prev_version_build(const rec_t*, dict_index_t*, rec_offs*, mem_heap_t*, rec_t**, mem_heap_t*, dtuple_t**, ulint)") at assert.c:101
|
#8 0x000055c2628f1af7 in trx_undo_prev_version_build (rec=0x7ff2006b807e "", index=0x6160009c0d20, offsets=0x611000069220, heap=0x61a00005a098, old_vers=0x7ff1f71f96a0, v_heap=0x0, vrow=0x0, v_status=0) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/trx/trx0rec.cc:2164
|
#9 0x000055c262852c29 in row_check_index (prebuilt=0x620000014120, n_rows=0x7ff1f71fa670) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/row/row0sel.cc:6591
|
#10 0x000055c2624567d6 in ha_innobase::check (this=0x61d0002846b8, thd=0x62b0000bd218, check_opt=0x62b0000c2848) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/handler/ha_innodb.cc:15311
|
#11 0x000055c261a3b33b in handler::ha_check (this=0x61d0002846b8, thd=0x62b0000bd218, check_opt=0x62b0000c2848) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/handler.cc:4949
|
#12 0x000055c261653dd6 in mysql_admin_table (thd=0x62b0000bd218, tables=0x62b0000c4320, check_opt=0x62b0000c2848, operator_name=0x55c2644f0580 <msg_check>, lock_type=TL_READ_NO_INSERT, org_open_for_modify=false, repair_table_use_frm=false, extra_open_options=32, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x55c261a3aeb6 <handler::ha_check(THD*, st_ha_check_opt*)>, view_operator_func=0x55c2615158b9 <view_check(THD*, TABLE_LIST*, st_ha_check_opt*)>, is_cmd_replicated=false) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_admin.cc:875
|
#13 0x000055c2616590de in Sql_cmd_check_table::execute (this=0x62b0000c4a40, thd=0x62b0000bd218) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_admin.cc:1486
|
#14 0x000055c2611e22ae in mysql_execute_command (thd=0x62b0000bd218, is_called_from_prepared_stmt=false) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:5997
|
#15 0x000055c2611ef430 in mysql_parse (thd=0x62b0000bd218, rawbuf=0x62b0000c4238 "CHECK TABLE t EXTENDED", length=22, parser_state=0x7ff1f71fc990) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:8016
|
#16 0x000055c2611c5d86 in dispatch_command (command=COM_QUERY, thd=0x62b0000bd218, packet=0x62900028a219 "", packet_length=22, blocking=true) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:1896
|
#17 0x000055c2611c2b4d in do_command (thd=0x62b0000bd218, blocking=true) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:1409
|
#18 0x000055c26161afbc in do_handle_one_connection (connect=0x608000003338, put_in_cache=true) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_connect.cc:1416
|
#19 0x000055c26161a952 in handle_one_connection (arg=0x6080000032b8) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_connect.cc:1318
|
#20 0x000055c2622409ac in pfs_spawn_thread (arg=0x617000007418) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/perfschema/pfs.cc:2201
|
#21 0x00007ff20abf3ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#22 0x00007ff20a7e0aef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
The failure started happening on 10.6 after
commit ab0190101b0587e0e03b2d75a967050b9a85fd1b
|
Author: Marko Mäkelä
|
Date: Fri Oct 21 10:02:54 2022 +0300
|
|
MDEV-24402: InnoDB CHECK TABLE ... EXTENDED
|
Attachments
Issue Links
- is caused by
-
MDEV-24402 CHECK TABLE may miss some cases of index inconsistencies
- Closed