rpl.rpl_mysqlbinlog_slave_consistency fails intermittently (retry-pass or retry-fail [but not necessarily for the same test case]):
10.9 43fa8e0b8f3bae1ff8493cfd3adb3944
https://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos73-ppc64le/builds/14215/steps/mtr/logs/stdio
rpl.rpl_mysqlbinlog_slave_consistency 'stmt' w4 [ fail ]
|
Test ended at 2022-04-26 22:41:54
|
|
CURRENT_TEST: rpl.rpl_mysqlbinlog_slave_consistency
|
mysqltest: In included file "/usr/share/mysql-test/suite/rpl/include/rpl_check_table_consistency.inc":
|
included from /usr/share/mysql-test/suite/rpl/include/mysqlbinlog_slave_consistency.inc at line 147:
|
included from /usr/share/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 249:
|
At line 36: "master had 3 tables but slave had 1 after binlog replay"
|
Searching through cross-ref, this same error is seen randomly with the various test cases (see below).
FWIW, I looked through most of the failures and could not see any cases fail where a --stop_position was specified.
Below are collated fail messages from different builders:
included from /buildbot/s390x-sles-15/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 73:
|
At line 36: "master had 5 tables but slave had 0 after binlog replay"
|
|
included from /home/buildbot/aarch64-debian-9/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 85:
|
At line 36: "master had 2 tables but slave had 0 after binlog replay"
|
|
included from /home/buildbot/s390x-ubuntu-2004/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 97:
|
At line 36: "master had 4 tables but slave had 0 after binlog replay"
|
|
included from /buildbot/s390x-sles-15/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 108:
|
At line 36: "master had 3 tables but slave had 0 after binlog replay"
|
|
included from /home/buildbot/s390x-ubuntu-2004/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 120:
|
At line 36: "master had 1 tables but slave had 0 after binlog replay"
|
|
included from /home/buildbot/aarch64-centos-7/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 131:
|
At line 36: "master had 2 tables but slave had 0 after binlog replay"
|
|
included from /home/buildbot/s390x-ubuntu-2004/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 143:
|
At line 36: "master had 2 tables but slave had 0 after binlog replay"
|
|
included from /home/buildbot/s390x-ubuntu-2004/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 165:
|
At line 36: "master had 4 tables but slave had 0 after binlog replay"
|
|
included from /buildbot/s390x-rhel-8/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 177:
|
At line 36: "master had 1 tables but slave had 0 after binlog replay"
|
|
included from /usr/share/mysql/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 189:
|
At line 36: "master had 1 tables but slave had 0 after binlog replay"
|
|
included from /buildbot/s390x-rhel-8/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 237:
|
At line 36: "master had 1 tables but slave had 0 after binlog replay"
|
|
included from /usr/share/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 249:
|
At line 36: "master had 3 tables but slave had 1 after binlog replay"
|
|
included from /buildbot/amd64-ubuntu-2004-fulltest/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 261:
|
At line 36: "master had 2 tables but slave had 0 after binlog replay"
|
|
included from /buildbot/s390x-rhel-8/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 344:
|
At line 36: "master had 1 tables but slave had 0 after binlog replay"
|
First seen on 63a479e2e033cfe578040e1331efc1192413ee7c.
{"report":{"fcp":778.5,"ttfb":197.30000001192093,"pageVisibility":"visible","entityId":110390,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"fc483507-c425-4799-b4b1-43962de123b8","navigationType":0,"readyForUser":906.1000000238419,"redirectCount":0,"resourceLoadedEnd":497.80000001192093,"resourceLoadedStart":204.9000000357628,"resourceTiming":[{"duration":4.899999976158142,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":204.9000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":204.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":209.80000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":205.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":210.19999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":163.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":205.30000001192093,"connectEnd":205.30000001192093,"connectStart":205.30000001192093,"domainLookupEnd":205.30000001192093,"domainLookupStart":205.30000001192093,"fetchStart":205.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":212.9000000357628,"responseEnd":369.10000002384186,"responseStart":228.4000000357628,"secureConnectionStart":205.30000001192093},{"duration":292.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":205.5,"connectEnd":205.5,"connectStart":205.5,"domainLookupEnd":205.5,"domainLookupStart":205.5,"fetchStart":205.5,"redirectEnd":0,"redirectStart":0,"requestStart":215.4000000357628,"responseEnd":497.80000001192093,"responseStart":236.10000002384186,"secureConnectionStart":205.5},{"duration":8.199999988079071,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":205.60000002384186,"connectEnd":205.60000002384186,"connectStart":205.60000002384186,"domainLookupEnd":205.60000002384186,"domainLookupStart":205.60000002384186,"fetchStart":205.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":205.60000002384186,"responseEnd":213.80000001192093,"responseStart":213.80000001192093,"secureConnectionStart":205.60000002384186},{"duration":28.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":205.9000000357628,"connectEnd":205.9000000357628,"connectStart":205.9000000357628,"domainLookupEnd":205.9000000357628,"domainLookupStart":205.9000000357628,"fetchStart":205.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":215.9000000357628,"responseEnd":234.10000002384186,"responseStart":232.60000002384186,"secureConnectionStart":205.9000000357628},{"duration":36,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":206,"connectEnd":206,"connectStart":206,"domainLookupEnd":206,"domainLookupStart":206,"fetchStart":206,"redirectEnd":0,"redirectStart":0,"requestStart":216.9000000357628,"responseEnd":242,"responseStart":239.69999998807907,"secureConnectionStart":206},{"duration":10,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":206.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":206.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":216.19999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":29.299999952316284,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":206.4000000357628,"connectEnd":206.4000000357628,"connectStart":206.4000000357628,"domainLookupEnd":206.4000000357628,"domainLookupStart":206.4000000357628,"fetchStart":206.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":218.4000000357628,"responseEnd":235.69999998807907,"responseStart":234.30000001192093,"secureConnectionStart":206.4000000357628},{"duration":11.100000023841858,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":206.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":206.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":217.60000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":41.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":206.69999998807907,"connectEnd":206.69999998807907,"connectStart":206.69999998807907,"domainLookupEnd":206.69999998807907,"domainLookupStart":206.69999998807907,"fetchStart":206.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":219.80000001192093,"responseEnd":248.19999998807907,"responseStart":240.60000002384186,"secureConnectionStart":206.69999998807907},{"duration":5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":243.4000000357628,"connectEnd":243.4000000357628,"connectStart":243.4000000357628,"domainLookupEnd":243.4000000357628,"domainLookupStart":243.4000000357628,"fetchStart":243.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":243.4000000357628,"responseEnd":248.4000000357628,"responseStart":248.4000000357628,"secureConnectionStart":243.4000000357628},{"duration":5.400000035762787,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":243.69999998807907,"connectEnd":243.69999998807907,"connectStart":243.69999998807907,"domainLookupEnd":243.69999998807907,"domainLookupStart":243.69999998807907,"fetchStart":243.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":243.69999998807907,"responseEnd":249.10000002384186,"responseStart":249.10000002384186,"secureConnectionStart":243.69999998807907},{"duration":57.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":529.4000000357628,"connectEnd":529.4000000357628,"connectStart":529.4000000357628,"domainLookupEnd":529.4000000357628,"domainLookupStart":529.4000000357628,"fetchStart":529.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":550.5,"responseEnd":586.9000000357628,"responseStart":585.5,"secureConnectionStart":529.4000000357628},{"duration":256.80000001192093,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":771.6999999880791,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":771.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1028.5,"responseStart":0,"secureConnectionStart":0},{"duration":263.19999998807907,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":777.9000000357628,"connectEnd":777.9000000357628,"connectStart":777.9000000357628,"domainLookupEnd":777.9000000357628,"domainLookupStart":777.9000000357628,"fetchStart":777.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":1008.9000000357628,"responseEnd":1041.1000000238419,"responseStart":1040.1000000238419,"secureConnectionStart":777.9000000357628}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":10,"responseStart":197,"responseEnd":243,"domLoading":201,"domInteractive":967,"domContentLoadedEventStart":967,"domContentLoadedEventEnd":1025,"domComplete":1517,"loadEventStart":1517,"loadEventEnd":1517,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":948.1000000238419},{"name":"bigPipe.sidebar-id.end","time":948.9000000357628},{"name":"bigPipe.activity-panel-pipe-id.start","time":949},{"name":"bigPipe.activity-panel-pipe-id.end","time":950.1000000238419},{"name":"activityTabFullyLoaded","time":1046.4000000357628}],"measures":[],"correlationId":"71edaae9503f30","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":109,"dbReadsTimeInMs":17,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
Hi Andrei! This is ready for review:
Patch 695854a