Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.7(EOL), 10.8(EOL)
-
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
Attachments
Activity
angelique.sklavounos, the patch is updated now to account our yesterday conversation.
Elkin I just quickly checked the failures on the branch and they look okay with the latest patch.
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;
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