Details
-
Bug
-
Status: In Progress (View Workflow)
-
Major
-
Resolution: Unresolved
-
13.0, 13.1
-
None
-
Can result in hang or crash
Description
--source include/have_innodb.inc
|
--source include/have_debug.inc
|
--source include/have_sequence.inc
|
|
|
--disable_query_log
|
call mtr.add_suppression("InnoDB: Did not find innodb_log_recovery_start="); |
--enable_query_log
|
|
|
CREATE TABLE t1(a INT PRIMARY KEY AUTO_INCREMENT, b VARCHAR(200)) ENGINE=InnoDB; |
SET GLOBAL innodb_log_archive=1; |
|
|
# Force the 4M (minimum) redo log to roll over into several archived |
# ib_<lsn>.log files, so that a later restart's recovery-start LSN will |
# fall inside a non-first archive file.
|
--disable_query_log
|
let $i=0;
|
while ($i < 8)
|
{
|
INSERT INTO t1(b) SELECT REPEAT('y',180) FROM seq_1_to_3000; |
SET GLOBAL innodb_log_checkpoint_now=ON;
|
inc $i;
|
}
|
--enable_query_log
|
|
|
let $lsn= query_get_value(SHOW STATUS LIKE 'Innodb_lsn_current', Value, 1); |
|
|
--source include/shutdown_mysqld.inc
|
--let $restart_parameters= --innodb-log-recovery-start=$lsn
|
--source include/start_mysqld.inc
|
|
|
SELECT COUNT(*) FROM t1; |
DROP TABLE t1; |
SET GLOBAL innodb_log_archive=0; |
Command to start the test
./mtr test --mysqld=--innodb-log-file-size=4194304 |
Leads to :-
|
CS 13.0.2 b2c4e675049e23ce8c7346985f40840fcd4e583f (Debug, Clang 22.1.8-20260621) Build 09/09/2026 |
mariadbd: /test/13.0_dbg/storage/innobase/log/log0recv.cc:5854: dberr_t recv_sys_t::find_checkpoint_archived(lsn_t, bool): Assertion `!silent' failed.
|
|
CS 13.0.2 b2c4e675049e23ce8c7346985f40840fcd4e583f (Debug, Clang 22.1.8-20260621) Build 09/09/2026 |
Core was generated by `/test/MD090926-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 3865302)]
|
(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 0x00007c7382e4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x00007c7382e288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00007c7382e2881b in __assert_fail_base (fmt=0x7c7382fd1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5876876e8bc9 "!silent", file=file@entry=0x5876876e723b "/test/13.0_dbg/storage/innobase/log/log0recv.cc", line=line@entry=5854, function=function@entry=0x5876876e8a5e "dberr_t recv_sys_t::find_checkpoint_archived(lsn_t, bool)") at ./assert/assert.c:96
|
#6 0x00007c7382e3b517 in __assert_fail (assertion=0x5876876e8bc9 "!silent", file=0x5876876e723b "/test/13.0_dbg/storage/innobase/log/log0recv.cc", line=5854, function=0x5876876e8a5e "dberr_t recv_sys_t::find_checkpoint_archived(lsn_t, bool)") at ./assert/assert.c:105
|
#7 0x0000587686e40941 in recv_sys_t::find_checkpoint_archived (this=0x5876880257c0 <recv_sys>, first_lsn=4194304, silent=true)at /test/13.0_dbg/storage/innobase/log/log0recv.cc:5854
|
#8 0x0000587686e3e20b in recv_sys_t::find_checkpoint (this=0x5876880257c0 <recv_sys>)at /test/13.0_dbg/storage/innobase/log/log0recv.cc:2006
|
#9 0x0000587686fca0c9 in srv_start (create_new_db=false)at /test/13.0_dbg/storage/innobase/srv/srv0start.cc:1419
|
#10 0x0000587686d772c5 in innodb_init (p=0x5876a0ff8e30)at /test/13.0_dbg/storage/innobase/handler/ha_innodb.cc:4288
|
#11 0x00005876869814fe in ha_initialize_handlerton (plugin_=0x5876a0fd4550)at /test/13.0_dbg/sql/handler.cc:737
|
#12 0x00005876865aa27f in plugin_do_initialize (plugin=0x5876a0fd4550, state=@0x7ffc668b0584: 4) at /test/13.0_dbg/sql/sql_plugin.cc:1464
|
#13 0x00005876865a9cb5 in plugin_initialize (tmp_root=0x7ffc668b0b88, plugin=0x5876a0fd4550, argc=0x587688236338 <remaining_argc>, argv=0x5876a0d38c90, options_only=false)at /test/13.0_dbg/sql/sql_plugin.cc:1518
|
#14 0x00005876865a958b in plugin_init (argc=0x587688236338 <remaining_argc>, argv=0x5876a0d38c90, flags=0) at /test/13.0_dbg/sql/sql_plugin.cc:1762
|
#15 0x00005876863c1a68 in init_server_components ()at /test/13.0_dbg/sql/mysqld.cc:5458
|
#16 0x00005876863be46e in mysqld_main (argc=163, argv=0x5876a0d38c90)at /test/13.0_dbg/sql/mysqld.cc:6258
|
#17 0x00005876863bb6b2 in main (argc=26, argv=0x7ffc668b3c28)at /test/13.0_dbg/sql/main.cc:34
|
Attachments
Issue Links
- relates to
-
MDEV-37949 Implement innodb_log_archive
-
- Closed
-