Type:
Bug
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
None
Fix Version/s:
None
In situation with 2 replicas where both are configured in semi-sync and when one of replica is stopped (acting as async), Rpl_semi_sync_master_yes_tx doesn't get incremented for each new transaction.
The PR 2374 introduced test 7 that shows how was it before and after rebasing to latest 10.11 with changes from MDEV-32551 .
Result before rebasing was as expected that on new event, with single active semi-sync replica Rpl_semi_sync_master_yes_tx will be incremented.
See the old behavior where we waited that yes transaction be incremented, while wit latest change this wait condition fails
**** ERROR: failed while waiting for '' 'Rpl_semi_sync_master_yes_tx' = '4' ****
Note: the following output may have changed since the failure was detected
**** Showing STATUS, PROCESSLIST ****
SHOW STATUS LIKE 'Rpl_semi_sync_master_yes_tx' ;
Variable_name Value
Rpl_semi_sync_master_yes_tx 3
SHOW PROCESSLIST;
Id User Host db Command Time State Info Progress
5 root localhost test Sleep 77 NULL 0.000
6 root localhost:42424 test Sleep 77 NULL 0.000
8 root localhost:53268 test Query 0 starting SHOW PROCESSLIST 0.000
9 root localhost:53278 test Sleep 77 NULL 0.000
13 root localhost:53310 NULL Binlog Dump 71 Master has sent all binlog to slave; waiting for more updates NULL 0.000
Please fix the PR test case in rpl_show_slave_hosts.test if PR 2374 gets merged before fixing this bug. Example to uncomment is here:
--echo # Transaction is not incremented and it should (TODO?)
# let $status_var= Rpl_semi_sync_master_yes_tx;
# let $status_var_value= `SELECT $master_request_ack_num + 1`;
# source include/wait_for_status_var.inc;
relates to
MDEV-21322
report slave progress to the master
Stalled
There are no comments yet on this issue.
{"report":{"fcp":685,"ttfb":135,"pageVisibility":"visible","entityId":128247,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"dd24f53f-526b-45a4-ac2e-4152d0d28a97","navigationType":0,"readyForUser":746.5,"redirectCount":0,"resourceLoadedEnd":587.5,"resourceLoadedStart":142.5,"resourceTiming":[{"duration":62.10000014305115,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":142.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":142.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":204.60000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":62.10000014305115,"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":142.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":142.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":204.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":75.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":142.80000019073486,"connectEnd":142.80000019073486,"connectStart":142.80000019073486,"domainLookupEnd":142.80000019073486,"domainLookupStart":142.80000019073486,"fetchStart":142.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":142.80000019073486,"responseEnd":218.30000019073486,"responseStart":218.30000019073486,"secureConnectionStart":142.80000019073486},{"duration":153.20000004768372,"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":142.90000009536743,"connectEnd":142.90000009536743,"connectStart":142.90000009536743,"domainLookupEnd":142.90000009536743,"domainLookupStart":142.90000009536743,"fetchStart":142.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":142.90000009536743,"responseEnd":296.10000014305115,"responseStart":296.10000014305115,"secureConnectionStart":142.90000009536743},{"duration":157.40000009536743,"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":143,"connectEnd":143,"connectStart":143,"domainLookupEnd":143,"domainLookupStart":143,"fetchStart":143,"redirectEnd":0,"redirectStart":0,"requestStart":143,"responseEnd":300.40000009536743,"responseStart":300.40000009536743,"secureConnectionStart":143},{"duration":159,"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":143.10000014305115,"connectEnd":143.10000014305115,"connectStart":143.10000014305115,"domainLookupEnd":143.10000014305115,"domainLookupStart":143.10000014305115,"fetchStart":143.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":143.10000014305115,"responseEnd":302.10000014305115,"responseStart":302.10000014305115,"secureConnectionStart":143.10000014305115},{"duration":164,"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":143.20000004768372,"connectEnd":143.20000004768372,"connectStart":143.20000004768372,"domainLookupEnd":143.20000004768372,"domainLookupStart":143.20000004768372,"fetchStart":143.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":143.20000004768372,"responseEnd":307.2000000476837,"responseStart":307.2000000476837,"secureConnectionStart":143.20000004768372},{"duration":165.5,"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":143.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":143.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":308.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":165.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":143.40000009536743,"connectEnd":143.40000009536743,"connectStart":143.40000009536743,"domainLookupEnd":143.40000009536743,"domainLookupStart":143.40000009536743,"fetchStart":143.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":143.40000009536743,"responseEnd":308.80000019073486,"responseStart":308.80000019073486,"secureConnectionStart":143.40000009536743},{"duration":166.5,"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":143.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":143.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":310.10000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":166.60000014305115,"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":143.70000004768372,"connectEnd":143.70000004768372,"connectStart":143.70000004768372,"domainLookupEnd":143.70000004768372,"domainLookupStart":143.70000004768372,"fetchStart":143.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":143.70000004768372,"responseEnd":310.30000019073486,"responseStart":310.30000019073486,"secureConnectionStart":143.70000004768372},{"duration":443.09999990463257,"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":144.40000009536743,"connectEnd":144.40000009536743,"connectStart":144.40000009536743,"domainLookupEnd":144.40000009536743,"domainLookupStart":144.40000009536743,"fetchStart":144.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":144.40000009536743,"responseEnd":587.5,"responseStart":587.4000000953674,"secureConnectionStart":144.40000009536743},{"duration":442.09999990463257,"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":144.40000009536743,"connectEnd":144.40000009536743,"connectStart":144.40000009536743,"domainLookupEnd":144.40000009536743,"domainLookupStart":144.40000009536743,"fetchStart":144.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":144.40000009536743,"responseEnd":586.5,"responseStart":586.5,"secureConnectionStart":144.40000009536743},{"duration":129.20000004768372,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":432.90000009536743,"connectEnd":432.90000009536743,"connectStart":432.90000009536743,"domainLookupEnd":432.90000009536743,"domainLookupStart":432.90000009536743,"fetchStart":432.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":432.90000009536743,"responseEnd":562.1000001430511,"responseStart":562.1000001430511,"secureConnectionStart":432.90000009536743}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":15,"responseStart":135,"responseEnd":140,"domLoading":139,"domInteractive":795,"domContentLoadedEventStart":795,"domContentLoadedEventEnd":827,"domComplete":1219,"loadEventStart":1219,"loadEventEnd":1219,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":780.4000000953674},{"name":"bigPipe.sidebar-id.end","time":781.1000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":781.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":781.7000000476837},{"name":"activityTabFullyLoaded","time":833.5}],"measures":[],"correlationId":"36d438f6c0bbea","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":68,"dbReadsTimeInMs":12,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}