MySQL Bugs: #114525: log_first_rec

Bug #114525	log_first_rec_group failed
Submitted:	1 Apr 2024 13:18	Modified:	2 Apr 2024 10:49
Reporter:	xu chunming	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S7 (Test Cases)
Version:	8.0.35	OS:	MacOS (Big Sur 11.3.1)
Assigned to:		CPU Architecture:	x86

Description:
The case main.log_first_rec_group failed

How to repeat:
Running the command as follows:
./mtr --do-test=log_first_rec_group  --verbose --verbose

It will failed, and Partial output results are as follows:

mysqltest: At line 96: Test assertion failed in assert.inc

The result from queries just before the failure was:

**** slave_master_info on default ****
SELECT * FROM mysql.slave_master_info;
Number_of_lines	Master_log_name	Master_log_pos	Host	User_name	User_password	Port	Connect_retry	Enabled_ssl	Ssl_ca	Ssl_capath	Ssl_cert	Ssl_cipher	Ssl_key	Ssl_verify_server_cert	Heartbeat	Bind	Ignored_server_ids	Uuid	Retry_count	Ssl_crl	Ssl_crlpath	Enabled_auto_position	Channel_name	Tls_version	Public_key_path	Get_public_key	Network_namespace	Master_compression_algorithm	Master_zstd_compression_level	Tls_ciphersuites	Source_connection_auto_failover	Gtid_only

**** mysql.gtid_executed on default ****
SELECT * FROM mysql.gtid_executed;
source_uuid	interval_start	interval_end

rpl_topology=
extra debug info if any: ''
connection default;
1 tests executed in this mtr thread: innodb.log_first_rec_group
last error log entry: SERVER_1:<none>
rpl error summary: no errors in workers, receivers, or coordinators
connection default;
Assertion text: 'All must happen within the single log block (this was required for the bug)'
Assertion condition: '[SELECT 20670476 DIV 512] = [SELECT (20671327 + 50) DIV 512]'
Assertion condition, interpolated: '40372 = 40373'
Assertion result: '0'
safe_process[275]: Got SIGCHLD from process: 276
safe_process[275]: Killing child: 276
safe_process[275]: Child process: 276, exit: 1

Hi Mr. chunming,

Thank you for your bug report.

However, with our own built MySQL 8.0.36 binaries, our test worked just fine:

----------------------------------------
Logging: ./mtr  --do-test=log_first_rec_group --verbose
> exe_name: mysqld
MySQL Version 8.0.36
Checking supported features
> openssl is  ../.../mysql-8.0.36-macos14-x86_64/bin/my_openssl
> Testing FIPS: --test-ssl-fips-mode 0 error:12800067:DSO support routines::could not load the shared library

Using suite(s): audit_null,auth_sec,binlog,binlog_gtid,binlog_nogtid,clone,collations,component_keyring_file,connection_control,encryption,engines,engines/funcs,engines/iuds,engines/rr_trx,federated,funcs_1,funcs_2,gcol,gis,group_replication,information_schema,innodb,innodb_fts,innodb_gis,innodb_stress,innodb_undo,innodb_zip,interactive_utilities,jp,json,large_tests,lock_order,main,max_parts,memcached,network_namespace,opt_trace,parts,parts/special_tests,perfschema,query_rewrite_plugins,rpl,rpl_gtid,rpl_nogtid,secondary_engine,service_status_var_registration,service_sys_var_registration,service_udf_registration,special,stress,sys_vars,sysschema,test_service_sql_api,test_services,x
Collecting tests

==============================================================================
                  TEST NAME                       RESULT  TIME (ms) COMMENT
------------------------------------------------------------------------------
> Client connected
worker[1] > mtr_ping_port: 13000
worker[1] > FREE
worker[1] > mtr_ping_port: 13001
worker[1] > FREE
worker[1] > mtr_ping_port: 13002
worker[1] > FREE
worker[1] > mtr_ping_port: 13003
worker[1] > FREE
worker[1] > mtr_ping_port: 13004
worker[1] > FREE
worker[1] > mtr_ping_port: 13005
worker[1] > FREE
worker[1] > mtr_ping_port: 13006
worker[1] > FREE
worker[1] > mtr_ping_port: 13007
worker[1] > FREE
worker[1] > mtr_ping_port: 13008
worker[1] > FREE
worker[1] > mtr_ping_port: 13009
worker[1] > FREE
worker[1] > mtr_ping_port: 13010
worker[1] > FREE
worker[1] > mtr_ping_port: 13011
worker[1] > FREE
worker[1] > mtr_ping_port: 13012
worker[1] > FREE
worker[1] > mtr_ping_port: 13013
worker[1] > FREE
worker[1] > mtr_ping_port: 13014
worker[1] > FREE
worker[1] > mtr_ping_port: 13015
worker[1] > FREE
worker[1] > mtr_ping_port: 13016
worker[1] > FREE
worker[1] > mtr_ping_port: 13017
worker[1] > FREE
worker[1] > mtr_ping_port: 13018
worker[1] > FREE
worker[1] > mtr_ping_port: 13019
worker[1] > FREE
worker[1] > mtr_ping_port: 13020
worker[1] > FREE
worker[1] > mtr_ping_port: 13021
worker[1] > FREE
worker[1] > mtr_ping_port: 13022
worker[1] > FREE
worker[1] > mtr_ping_port: 13023
worker[1] > FREE
worker[1] > mtr_ping_port: 13024
worker[1] > FREE
worker[1] > mtr_ping_port: 13025
worker[1] > FREE
worker[1] > mtr_ping_port: 13026
worker[1] > FREE
worker[1] > mtr_ping_port: 13027
worker[1] > FREE
worker[1] > mtr_ping_port: 13028
worker[1] > FREE
worker[1] > mtr_ping_port: 13029
worker[1] > FREE
worker[1] > Using MTR_BUILD_THREAD 300, with reserved ports 13000..13029
worker[1] Creating var directory '../..//mysql-test/var'
worker[1] > result: , file_mode: 0
[100%] innodb.log_first_rec_group          [ pass ].
worker[1] > Stopping all servers...
> Child closed socket
[100%] shutdown_report                           [ pass ]
------------------------------------------------------------------------------
The servers were restarted 0 times
The servers were reinitialized 0 times
Spent 0.000 of 11 seconds executing testcases

Completed: All 1 tests were successful.
----------------------------------------

Can't repeat.