[MDEV-27963] multisource_for_channel sometimes fails in bb with result content mismatch Created: 2022-02-28  Updated: 2022-10-19  Resolved: 2022-10-19

Status: Closed
Project: MariaDB Server
Component/s: Replication, Tests
Affects Version/s: 10.7, 10.8
Fix Version/s: 10.7.7

Type: Bug Priority: Major
Reporter: Angelique Sklavounos (Inactive) Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None


 Description   

Multi_source.multisource_for_channel innodb sometimes fails on a variety of builders (but usually seems to be retry-pass) with "mysqltest: Result content mismatch".

https://buildbot.askmonty.org/buildbot/builders/kvm-rpm-fedora35-amd64/builds/358/steps/mtr/logs/stdio
10.7 3d88f9f34c1223c59272d5086dcd2b4b

multi_source.multisource_for_channel 'innodb' w4 [ fail ]
 
        Test ended at 2022-02-25 16:35:32
 
 
 
CURRENT_TEST: multi_source.multisource_for_channel
 
--- /usr/share/mysql-test/suite/multi_source/multisource_for_channel.result	2022-02-25 14:31:38.000000000 +0000
 
+++ /dev/shm/var/4/log/multisource_for_channel.reject	2022-02-25 16:35:32.812674873 +0000
 
@@ -282,7 +282,7 @@
 
 
 show slave status for channel 'master1'
 
 Master_Port = 'MYPORT_1'
 
-Relay_Log_File = 'mysqld-relay-bin-master1.000005'
 
+Relay_Log_File = 'mysqld-relay-bin-master1.000004'
 
 Slave_IO_Running = 'Yes'
 
 Slave_SQL_Running = 'Yes'
 
 Last_Errno = '0'
 
 
 
mysqltest: Result content mismatch
 
 
 
 - saving '/dev/shm/var/4/log/multi_source.multisource_for_channel-innodb/' to '/dev/shm/var/log/multi_source.multisource_for_channel-innodb/'
 
 
 
Retrying test multi_source.multisource_for_channel, attempt(2/3)...
 
 
 
worker[4] > Restart  - not started

https://buildbot.askmonty.org/buildbot/builders/kvm-zyp-opensuse150-amd64/builds/7439/steps/mtr/logs/stdio
10.9 3e92b3e9f883c324cf63e8b52184387d

https://buildbot.mariadb.org/#/builders/236/builds/3745/steps/7/logs/stdio
10.8 a64991df9d86c57a597e012cbf04accb7a49defe

From a Multi-CI cross-ref search, the first fail appears to have been with:
10.7 0ff8976e129a0e1f3f17a6ed278ddc48

 Comments   
Comment by Andrei Elkin [ 2022-03-01 ]

Angelique, could you please review the commit, I've just pushed to bb-10.7-repl_tests branch.
This commit will hopefully serve your as an example to follow.
So feel free to ask from me any clarification, and the more questions you'll ask the better !

/ndrei

Comment by Andrei Elkin [ 2022-03-02 ]

angelique.sklavounos, the patch is updated now to account our yesterday conversation.

Comment by Angelique Sklavounos (Inactive) [ 2022-03-07 ]

Elkin I just quickly checked the failures on the branch and they look okay with the latest patch.

Comment by Michael Widenius [ 2022-10-19 ]

This is apparently not yet fixed.
I am now trying a fix that should work. Will push it to bb-10.7-monty and if it works, will push it to 10.7

The fix is basically this:
+++ b/mysql-test/suite/multi_source/multisource_for_channel.result
@@ -279,6 +279,10 @@ Last_SQL_Errno = '0'
#
START SLAVE for channel 'master1';
include/wait_for_slave_to_start.inc
+connection master1;
+create table foo (a int);
+drop table foo;
+connection slave;

Comment by Michael Widenius [ 2022-10-19 ]

Closed bug. Description in comment

Generated at Thu Feb 08 09:56:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.