Bug #119251 Test rpl.rpl_seconds_behind_master failure

Submitted: 28 Oct 2025 4:47 Modified: 2 Jul 3:57
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Open Impact on me:
None 
Category:Tests: Replication Severity:S7 (Test Cases)
Version:9.7.0 OS:MacOS (26.0.1)
Assigned to: CPU Architecture:ARM

[28 Oct 2025 4:47] Laurynas Biveinis
Description:
./mtr rpl.rpl_seconds_behind_master
...
[ 75%] rpl.rpl_seconds_behind_master 'stmt'      [ fail ]
        Test ended at 2025-10-28 06:45:11

CURRENT_TEST: rpl.rpl_seconds_behind_master
mysqltest: At line 102: Test assertion failed in assert.inc
In included file ./include/assert.inc: 103
included from /Users/laurynas/vilniusdb/mysql-9.5.0/mysql-test/suite/rpl/t/rpl_seconds_behind_master.test: 157

The result from queries just before the failure was:
1 tests executed in this mtr thread: rpl.rpl_seconds_behind_master
last error log entry: SERVER_1:<none>; SERVER_2:<none>
rpl error summary: no errors in workers, receivers, or coordinators
connection slave;
# Re-executing the condition to print intermediate results.
.==== BEGIN include/eval.inc ====
DO_NOT_CHECK_IN_THIS_LINE: $rpl_debug should only be used for debugging. Never check in a test that has $rpl_debug=1.
. con='slave' warn='1' qlog='1' rlog='1' aborterr='1'
# debug: eval_expr='3600 = 0' eval_no_result='' eval_escape=''
# debug: interpolated_expr='3600 = 0'
# debug: result='0'
[connection slave]
connection slave;
.==== END include/eval.inc ====
. con='slave' warn='1' qlog='1' rlog='1' aborterr='1'
# End re-executing the condition to print intermediate results.
Assertion text: 'Seconds_Behind_Source must be 0'
Assertion condition: '3600 = 0'
Assertion condition, interpolated: '3600 = 0'
Assertion result: '0'
safe_process[91726]: Child process: 91727, exit: 1

How to repeat:
CMake options -DCMAKE_EXPORT_COMPILE_COMMANDS=ON -DFORCE_UNSUPPORTED_COMPILER=ON -DCMAKE_BUILD_TYPE=Debug -DWITH_DEBUG=ON -DMYSQL_MAINTAINER_MODE=ON -DWITH_SYSTEM_LIBS=ON -DWITH_NDBCLUSTER_STORAGE_ENGINE=OFF -DFORCE_COLORED_OUTPUT=ON -DCMAKE_CXX_FLAGS=-Wno-nonnull -g -DCMAKE_CXX_FLAGS_DEBUG=-Wno-nonnull -g -DCMAKE_CXX_FLAGS_RELEASE=-O2 -DNDEBUG -Wno-nonnull -g
[22 Jan 11:16] Laurynas Biveinis
Same on 9.6.0
[24 Mar 12:51] Laurynas Biveinis
Same on 9.7.0-er
[2 Jul 3:57] Laurynas Biveinis
Same on 9.7.0

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.