Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
13.0, 13.2
-
Can result in hang or crash
Description
CLI compatible test case
SET GLOBAL innodb_log_archive=ON; |
SET GLOBAL innodb_file_per_table=0; |
CREATE TABLE t1 (b VARCHAR(8000)) STATS_PERSISTENT=0; |
SET GLOBAL innodb_trx_purge_view_update_only_debug=ON; |
SET GLOBAL debug_dbug='+d,ib_log_checkpoint_avoid'; |
SET debug_dbug='+d,skip_page_checksum'; |
INSERT INTO t1 SELECT REPEAT('x', 8000) FROM seq_1_to_10000; |
SET GLOBAL innodb_log_checkpoint_now=ON; |
DELIMITER //
|
BEGIN NOT ATOMIC |
WHILE (@r:= 2 * @@innodb_log_file_size - 12304 - (SELECT variable_value FROM information_schema.global_status WHERE variable_name='INNODB_LSN_CURRENT')) >= 3000 DO |
INSERT INTO t1 VALUES (REPEAT('x', LEAST(8000, @r - 2500))); |
END WHILE; |
WHILE @r > @r MOD 10 * 11 DO SET GLOBAL innodb_fil_make_page_dirty_debug=0, @r=@r-10; END WHILE; |
SET GLOBAL innodb_saved_page_number_debug=1000; |
WHILE @r > 0 DO SET GLOBAL innodb_fil_make_page_dirty_debug=0, @r=@r-11; END WHILE; |
END// |
DELIMITER ;
|
SET GLOBAL debug_dbug=''; |
check table t1 ; |
Leads to:
|
CS 13.0.2 620a4b5624222048fece7fe1789978ae0675cae2 (Debug, Clang 22.1.8-20260621) Build 25/09/2026 |
mariadbd: /test/13.0_dbg/storage/innobase/buf/buf0flu.cc:1944: lsn_t log_t::write_checkpoint(lsn_t, lsn_t): Assertion `current_lsn < archive_header_was_reset' 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 --no-defaults --loo'.
|
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 979056)]
|
(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 0x00007a24e8c4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x00007a24e8c288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00007a24e8c2881b in __assert_fail_base (fmt=0x7a24e8dd1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x6490d697b4bd "current_lsn < archive_header_was_reset", file=file@entry=0x6490d697a0b5 "/test/13.0_dbg/storage/innobase/buf/buf0flu.cc", line=line@entry=1944, function=function@entry=0x6490d697b1e6 "lsn_t log_t::write_checkpoint(lsn_t, lsn_t)") at ./assert/assert.c:96
|
#6 0x00007a24e8c3b517 in __assert_fail (assertion=0x6490d697b4bd "current_lsn < archive_header_was_reset", file=0x6490d697a0b5 "/test/13.0_dbg/storage/innobase/buf/buf0flu.cc", line=1944, function=0x6490d697b1e6 "lsn_t log_t::write_checkpoint(lsn_t, lsn_t)")at ./assert/assert.c:105
|
#7 0x00006490d62fcd12 in log_t::write_checkpoint (this=0x6490d7ce0a80 <log_sys>, checkpoint=200675242, end_lsn=201314288)at /test/13.0_dbg/storage/innobase/buf/buf0flu.cc:1944
|
#8 0x00006490d62f7571 in log_checkpoint_low (oldest_lsn=200675242, end_lsn=201314288) at /test/13.0_dbg/storage/innobase/buf/buf0flu.cc:2270
|
#9 0x00006490d62f59cc in log_checkpoint ()at /test/13.0_dbg/storage/innobase/buf/buf0flu.cc:2324
|
#10 0x00006490d62f3abc in buf_flush_page_cleaner ()at /test/13.0_dbg/storage/innobase/buf/buf0flu.cc:2887
|
#11 0x00006490d62ffc82 in std::__invoke_impl<void, void (*)() noexcept>(std::__invoke_other, void (*&&)() noexcept) (__f=@0x6490e1617248: 0x6490d62f34a0 <buf_flush_page_cleaner()>)at /usr/lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/invoke.h:61
|
#12 0x00006490d62ffc35 in std::__invoke<void (*)() noexcept>(void (*&&)() noexcept) (__fn=@0x6490e1617248: 0x6490d62f34a0 <buf_flush_page_cleaner()>)at /usr/lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/invoke.h:96
|
#13 0x00006490d62ffc0d in std::thread::_Invoker<std::tuple<void (*)() noexcept> >::_M_invoke<0ul>(std::_Index_tuple<0ul>) (this=0x6490e1617248)at /usr/lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/std_thread.h:292
|
#14 0x00006490d62ffbe5 in std::thread::_Invoker<std::tuple<void (*)() noexcept> >::operator()() (this=0x6490e1617248)at /usr/lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/std_thread.h:299
|
#15 0x00006490d62ffb49 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (*)() noexcept> > >::_M_run() (this=0x6490e1617240)at /usr/lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/std_thread.h:244
|
#16 0x00007a24e90ecdb4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
|
#17 0x00007a24e8c9cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#18 0x00007a24e8d29ecc 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 No bug found
|
CS 11.4 dbg 250926 511d7527eb356aab52fa183456333c5ba9741bcf No bug found
|
CS 11.4 opt 250926 511d7527eb356aab52fa183456333c5ba9741bcf No bug found
|
CS 11.8 dbg 250926 e87b958d2e411af8e088d1716f99d06534e932f3 No bug found
|
CS 11.8 opt 250926 e87b958d2e411af8e088d1716f99d06534e932f3 No bug found
|
CS 12.3 dbg 250926 881b64e8add374802e1871814dd0a3a673a9b3e6 No bug found
|
CS 12.3 opt 250926 881b64e8add374802e1871814dd0a3a673a9b3e6 No bug found
|
CS 13.0 dbg 250926 620a4b5624222048fece7fe1789978ae0675cae2 current_lsn < archive_header_was_reset|SIGABRT|log_t::write_checkpoint|log_checkpoint_low|log_checkpoint|buf_flush_page_cleaner
|
CS 13.0 opt 250926 620a4b5624222048fece7fe1789978ae0675cae2 No bug found
|
CS 13.2 dbg 250926 45717ef4c736a6a92e0acf49399ce677bfcaea89 current_lsn < archive_header_was_reset|SIGABRT|log_t::write_checkpoint|log_checkpoint_low|log_checkpoint|buf_flush_page_cleaner
|
CS 13.2 opt 250926 45717ef4c736a6a92e0acf49399ce677bfcaea89 No bug found
|
ES 10.6 dbg 250926 aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb !thd || !coordinator_thd|SIGABRT|purge_sys_t::clone_oldest_view<false>|trx_purge|purge_coordinator_state::do_purge|purge_coordinator_callback
|
ES 10.6 opt 250926 aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb No bug found
|
ES 11.4 dbg 250926 5fa1ee1c7342644dda74ff137ff55c4df79939cf No bug found
|
ES 11.4 opt 250926 5fa1ee1c7342644dda74ff137ff55c4df79939cf No bug found
|
ES 11.8 dbg 250926 1eae6f8f0c743cbff67675ae3e5cf9d25a5d8f61 No bug found
|
ES 11.8 opt 250926 1eae6f8f0c743cbff67675ae3e5cf9d25a5d8f61 No bug found
|
ES 12.3 dbg 250926 f46597716bc5fbf9081c0fa17bd3e0d6c9e9db1d No bug found
|
ES 12.3 opt 250926 f46597716bc5fbf9081c0fa17bd3e0d6c9e9db1d No bug found
|
Attachments
Issue Links
- relates to
-
MDEV-37949 Implement innodb_log_archive
-
- Closed
-