Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 13.0, 13.1
-
Can result in hang or crash
Description
--source include/have_innodb.inc |
--source include/have_sequence.inc |
--source include/have_debug.inc |
CREATE TABLE t1 (a INT PRIMARY KEY, b INT, KEY(b)) ENGINE=InnoDB STATS_PERSISTENT=0; |
CREATE TABLE t2 (a INT PRIMARY KEY, c VARBINARY(4000)) ENGINE=InnoDB STATS_PERSISTENT=0; |
INSERT INTO t1 VALUES (1,1),(2,2); |
INSERT INTO t2 SELECT seq, REPEAT(x'0808', 2000) FROM seq_1_to_12; |
UPDATE t1 SET b=b+1; |
--connect con1,localhost,root |
BEGIN; |
UPDATE t1 SET b=b+1; |
--connection default |
SET GLOBAL innodb_max_purge_lag_wait=0; |
UPDATE t2 SET c='x' WHERE a<=4; |
UPDATE t2 SET c='x' WHERE a BETWEEN 5 AND 8; |
UPDATE t2 SET c='x' WHERE a>8; |
--let $shutdown_timeout= 0 |
--let $restart_parameters= --innodb-log-recovery-target=18446744073709551615 |
--source include/restart_mysqld.inc |
--disconnect con1 |
CHECK TABLE t1 EXTENDED; |
--let $shutdown_timeout= |
--let $restart_parameters= |
--source include/restart_mysqld.inc |
DROP TABLE t1, t2; |
Leads to:
INFO: no cores found at data*/core nor at node*/core, and no *SAN or Valgrind report found in the error log
|
CS 13.0.2 620a4b5624222048fece7fe1789978ae0675cae2 (Debug, Clang 22.1.8-20260621) Build 25/09/2026 |
mariadbd: /test/13.0_dbg/storage/innobase/trx/trx0rec.cc:515: const byte *trx_undo_rec_get_pars(const trx_undo_rec_t *, byte *, byte *, bool *, undo_no_t *, table_id_t *): Assertion `*type >= TRX_UNDO_RENAME_TABLE' failed.
|
|
CS 13.0.2 620a4b5624222048fece7fe1789978ae0675cae2 (Debug, Clang 22.1.8-20260621) Build 25/09/2026 |
Core was generated by `/test/MD250926-mariadb-13.0.2-linux-x86_64-dbg/bin/mariadbd --defaults-group-su'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
 |
[Current thread is 1 (LWP 3649951)]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
|
#3 0x00007a367a04527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x00007a367a0288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00007a367a02881b in __assert_fail_base (fmt=0x7a367a1d1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x59fd4eceac69 "*type >= TRX_UNDO_RENAME_TABLE", file=file@entry=0x59fd4eceac3a "/test/13.0_dbg/storage/innobase/trx/trx0rec.cc", line=line@entry=515, function=function@entry=0x59fd4eceac88 "const byte *trx_undo_rec_get_pars(const trx_undo_rec_t *, byte *, byte *, bool *, undo_no_t *, table_id_t *)")at ./assert/assert.c:96
|
#6 0x00007a367a03b517 in __assert_fail (assertion=0x59fd4eceac69 "*type >= TRX_UNDO_RENAME_TABLE", file=0x59fd4eceac3a "/test/13.0_dbg/storage/innobase/trx/trx0rec.cc", line=515, function=0x59fd4eceac88 "const byte *trx_undo_rec_get_pars(const trx_undo_rec_t *, byte *, byte *, bool *, undo_no_t *, table_id_t *)")at ./assert/assert.c:105
|
#7 0x000059fd4e5be40c in trx_undo_rec_get_pars (undo_rec=0x7236540ac110 '\b' <repeats 200 times>..., type=0x7a3678429697 "\bp\227Bx6z", cmpl_info=0x7a3678429696 "", updated_extern=0x7a3678429695, undo_no=0x7a3678429688, table_id=0x7a3678429680)at /test/13.0_dbg/storage/innobase/trx/trx0rec.cc:515
|
#8 0x000059fd4e5c6ab0 in trx_undo_prev_version (rec=0x72359002af4e "\200", index=0x59fd7c092d68, offsets=0x7235900082a8, heap=0x72359002b280, old_vers=0x7a3678429c58, check=@0x7a3678429770: {latch = purge_sys_t::view_guard::END_VIEW}, v_status=0, v_heap=0x0, vrow=0x0, undo_rec=0x7236540ac110 '\b' <repeats 200 times>...)at /test/13.0_dbg/storage/innobase/trx/trx0rec.cc:2221
|
#9 0x000059fd4e5c66d3 in trx_undo_prev_version_build (rec=0x72359002af4e "\200", index=0x59fd7c092d68, offsets=0x7235900082a8, heap=0x72359002b280, old_vers=0x7a3678429c58, mtr=0x7a367842a498, v_status=0, v_heap=0x0, vrow=0x0)at /test/13.0_dbg/storage/innobase/trx/trx0rec.cc:2198
|
#10 0x000059fd4e56bc0c in row_check_index (prebuilt=0x7235900298e8, n_rows=0x7a367842a8e8)at /test/13.0_dbg/storage/innobase/row/row0sel.cc:6632
|
#11 0x000059fd4e344c20 in ha_innobase::check (this=0x723590032e10, thd=0x723590000d60, check_opt=0x723590006638)at /test/13.0_dbg/storage/innobase/handler/ha_innodb.cc:15573
|
#12 0x000059fd4df5fbb9 in handler::ha_check (this=0x723590032e10, thd=0x723590000d60, check_opt=0x723590006638)at /test/13.0_dbg/sql/handler.cc:5757
|
#13 0x000059fd4dd32c3a in mysql_admin_table (thd=0x723590000d60, tables=0x7235900195b0, check_opt=0x723590006638, operator_name=0x59fd4f433cd8 <msg_check>, lock_type=TL_READ_NO_INSERT, org_open_for_modify=false, no_errors_from_open=false, extra_open_options=32, prepare_func=0x0, operator_func=(int (handler::*)(class handler * const, class THD *, HA_CHECK_OPT *)) 0x59fd4df5fa20 <handler::ha_check(THD*, st_ha_check_opt*)>, view_operator_func=0x59fd4dcae700 <view_check(THD*, TABLE_LIST*, st_ha_check_opt*)>, is_cmd_replicated=false) at /test/13.0_dbg/sql/sql_admin.cc:949
|
#14 0x000059fd4dd356b3 in Sql_cmd_check_table::execute (this=0x723590019d00, thd=0x723590000d60) at /test/13.0_dbg/sql/sql_admin.cc:1702
|
#15 0x000059fd4db56974 in mysql_execute_command (thd=0x723590000d60, is_called_from_prepared_stmt=false) at /test/13.0_dbg/sql/sql_parse.cc:5892
|
#16 0x000059fd4db47ba8 in mysql_parse (thd=0x723590000d60, rawbuf=0x7235900194c0 "CHECK TABLE t1 EXTENDED", length=23, parser_state=0x7a367842d9f0) at /test/13.0_dbg/sql/sql_parse.cc:7930
|
#17 0x000059fd4db4538e in dispatch_command (command=COM_QUERY, thd=0x723590000d60, packet=0x72359000b6d1 "", packet_length=23, blocking=true) at /test/13.0_dbg/sql/sql_parse.cc:1903
|
#18 0x000059fd4db4862a in do_command (thd=0x723590000d60, blocking=true)at /test/13.0_dbg/sql/sql_parse.cc:1437
|
#19 0x000059fd4dd1b20e in do_handle_one_connection (connect=0x59fd7c1c4100, put_in_cache=true) at /test/13.0_dbg/sql/sql_connect.cc:1514
|
#20 0x000059fd4dd1aff1 in handle_one_connection (arg=0x59fd7c1c4100)at /test/13.0_dbg/sql/sql_connect.cc:1426
|
#21 0x00007a367a09cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#22 0x00007a367a129ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.11 dbg 250926 307a82c97316ea0ed3fde318d19c0770ab898d89 No bug found
|
CS 10.11 opt 250926 307a82c97316ea0ed3fde318d19c0770ab898d89 Assert: no error log(s) found - exiting
|
CS 11.4 dbg 250926 511d7527eb356aab52fa183456333c5ba9741bcf No bug found
|
CS 11.4 opt 250926 511d7527eb356aab52fa183456333c5ba9741bcf Assert: no error log(s) found - exiting
|
CS 11.8 dbg 250926 e87b958d2e411af8e088d1716f99d06534e932f3 No bug found
|
CS 11.8 opt 250926 e87b958d2e411af8e088d1716f99d06534e932f3 Assert: no error log(s) found - exiting
|
CS 12.3 dbg 250926 881b64e8add374802e1871814dd0a3a673a9b3e6 No bug found
|
CS 12.3 opt 250926 881b64e8add374802e1871814dd0a3a673a9b3e6 Assert: no error log(s) found - exiting
|
CS 13.0 dbg 250926 620a4b5624222048fece7fe1789978ae0675cae2 *type >= TRX_UNDO_RENAME_TABLE|SIGABRT|trx_undo_rec_get_pars|trx_undo_prev_version|trx_undo_prev_version_build|row_check_index
|
CS 13.0 opt 250926 620a4b5624222048fece7fe1789978ae0675cae2 Assert: no error log(s) found - exiting
|
CS 13.2 dbg 250926 45717ef4c736a6a92e0acf49399ce677bfcaea89 *type >= TRX_UNDO_RENAME_TABLE|SIGABRT|trx_undo_rec_get_pars|trx_undo_prev_version|trx_undo_prev_version_build|row_check_index
|
CS 13.2 opt 250926 45717ef4c736a6a92e0acf49399ce677bfcaea89 Assert: no error log(s) found - exiting
|
ES 10.6 dbg 250926 aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb No bug found
|
ES 10.6 opt 250926 aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb Assert: no error log(s) found - exiting
|
ES 11.4 dbg 250926 5fa1ee1c7342644dda74ff137ff55c4df79939cf No bug found
|
ES 11.4 opt 250926 5fa1ee1c7342644dda74ff137ff55c4df79939cf Assert: no error log(s) found - exiting
|
ES 11.8 dbg 250926 1eae6f8f0c743cbff67675ae3e5cf9d25a5d8f61 No bug found
|
ES 11.8 opt 250926 1eae6f8f0c743cbff67675ae3e5cf9d25a5d8f61 Assert: no error log(s) found - exiting
|
ES 12.3 dbg 250926 f46597716bc5fbf9081c0fa17bd3e0d6c9e9db1d No bug found
|
ES 12.3 opt 250926 f46597716bc5fbf9081c0fa17bd3e0d6c9e9db1d Assert: no error log(s) found - exiting
|
Attachments
Issue Links
- duplicates
-
MDEV-41290 innodb_force_recovery=3 leads to crash in CHECK TABLE EXTENDED
-
- Confirmed
-
- is caused by
-
MDEV-37949 Implement innodb_log_archive
-
- Closed
-
- relates to
-
MDEV-41290 innodb_force_recovery=3 leads to crash in CHECK TABLE EXTENDED
-
- Confirmed
-