In an addition to test rpl.rpl_parallel_sbm added by MDEV-32265, the test uses sleep statements alone to test Seconds_Behind_Master with delayed replication. On slow running machines, the test can pass the intended MASTER_DELAY duration and Seconds_Behind_Master can become 0, when the test expects the transaction to still be actively in a delaying state.
Attachments
Issue Links
duplicates
MDEV-33500rpl.rpl_parallel_sbm can fail on slow machines, e.g. MSAN/Valgrind builders
Closed
is caused by
MDEV-32265seconds_behind_master is inaccurate for Delayed replication
mysqltest: At line 92: Seconds_Behind_Master did not increase after sleeping, but should have
Marko Mäkelä
added a comment - The test still fails :
rpl.rpl_parallel_sbm 'mix' w24 [ fail ]
Test ended at 2024-09-06 11:43:50
CURRENT_TEST: rpl.rpl_parallel_sbm
mysqltest: At line 92: Seconds_Behind_Master did not increase after sleeping, but should have
Closing this ticket as duplicate and will re-open MDEV-33500. JIRA bugged in the original creation of the ticket, and the original work was done via 33500, so further work will be done on that ticket for consistency.
Brandon Nesterenko
added a comment - Closing this ticket as duplicate and will re-open MDEV-33500 . JIRA bugged in the original creation of the ticket, and the original work was done via 33500, so further work will be done on that ticket for consistency.
People
Brandon Nesterenko
Brandon Nesterenko
Votes:
0Vote for this issue
Watchers:
3Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":1173.7999992370605,"ttfb":257.5,"pageVisibility":"visible","entityId":127992,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"9d5155c0-053e-4eb7-8405-0fdb761ee895","navigationType":0,"readyForUser":1373.5,"redirectCount":0,"resourceLoadedEnd":1411.6999998092651,"resourceLoadedStart":266.29999923706055,"resourceTiming":[{"duration":300.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":266.29999923706055,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":266.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":566.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":300.4000005722046,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":266.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":266.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":567,"responseStart":0,"secureConnectionStart":0},{"duration":310.9000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":266.79999923706055,"connectEnd":266.79999923706055,"connectStart":266.79999923706055,"domainLookupEnd":266.79999923706055,"domainLookupStart":266.79999923706055,"fetchStart":266.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":266.79999923706055,"responseEnd":577.6999998092651,"responseStart":577.6999998092651,"secureConnectionStart":266.79999923706055},{"duration":360.79999923706055,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":267,"connectEnd":267,"connectStart":267,"domainLookupEnd":267,"domainLookupStart":267,"fetchStart":267,"redirectEnd":0,"redirectStart":0,"requestStart":267,"responseEnd":627.7999992370605,"responseStart":627.7999992370605,"secureConnectionStart":267},{"duration":364.20000076293945,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":267.29999923706055,"connectEnd":267.29999923706055,"connectStart":267.29999923706055,"domainLookupEnd":267.29999923706055,"domainLookupStart":267.29999923706055,"fetchStart":267.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":267.29999923706055,"responseEnd":631.5,"responseStart":631.5,"secureConnectionStart":267.29999923706055},{"duration":365.0999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":267.5,"connectEnd":267.5,"connectStart":267.5,"domainLookupEnd":267.5,"domainLookupStart":267.5,"fetchStart":267.5,"redirectEnd":0,"redirectStart":0,"requestStart":267.5,"responseEnd":632.5999994277954,"responseStart":632.5999994277954,"secureConnectionStart":267.5},{"duration":365.5999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":267.69999980926514,"connectEnd":267.69999980926514,"connectStart":267.69999980926514,"domainLookupEnd":267.69999980926514,"domainLookupStart":267.69999980926514,"fetchStart":267.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":267.69999980926514,"responseEnd":633.2999992370605,"responseStart":633.2999992370605,"secureConnectionStart":267.69999980926514},{"duration":463,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":267.79999923706055,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":267.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":730.7999992370605,"responseStart":0,"secureConnectionStart":0},{"duration":366.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":268,"connectEnd":268,"connectStart":268,"domainLookupEnd":268,"domainLookupStart":268,"fetchStart":268,"redirectEnd":0,"redirectStart":0,"requestStart":268,"responseEnd":634.5,"responseStart":634.5,"secureConnectionStart":268},{"duration":462.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":268.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":268.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":730.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":367.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":268.29999923706055,"connectEnd":268.29999923706055,"connectStart":268.29999923706055,"domainLookupEnd":268.29999923706055,"domainLookupStart":268.29999923706055,"fetchStart":268.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":268.29999923706055,"responseEnd":635.5999994277954,"responseStart":635.5999994277954,"secureConnectionStart":268.29999923706055},{"duration":727.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":269.19999980926514,"connectEnd":269.19999980926514,"connectStart":269.19999980926514,"domainLookupEnd":269.19999980926514,"domainLookupStart":269.19999980926514,"fetchStart":269.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":269.19999980926514,"responseEnd":996.5999994277954,"responseStart":996.5999994277954,"secureConnectionStart":269.19999980926514},{"duration":1142.4000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":269.29999923706055,"connectEnd":269.29999923706055,"connectStart":269.29999923706055,"domainLookupEnd":269.29999923706055,"domainLookupStart":269.29999923706055,"fetchStart":269.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":269.29999923706055,"responseEnd":1411.6999998092651,"responseStart":1411.6999998092651,"secureConnectionStart":269.29999923706055},{"duration":235.89999961853027,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":761.1999998092651,"connectEnd":761.1999998092651,"connectStart":761.1999998092651,"domainLookupEnd":761.1999998092651,"domainLookupStart":761.1999998092651,"fetchStart":761.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":761.1999998092651,"responseEnd":997.0999994277954,"responseStart":997.0999994277954,"secureConnectionStart":761.1999998092651},{"duration":449.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1110.2999992370605,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1110.2999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1559.7999992370605,"responseStart":0,"secureConnectionStart":0},{"duration":418.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1111.6999998092651,"connectEnd":1111.6999998092651,"connectStart":1111.6999998092651,"domainLookupEnd":1111.6999998092651,"domainLookupStart":1111.6999998092651,"fetchStart":1111.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1111.6999998092651,"responseEnd":1530.3999996185303,"responseStart":1530.3999996185303,"secureConnectionStart":1111.6999998092651},{"duration":428.79999923706055,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":1112,"connectEnd":1112,"connectStart":1112,"domainLookupEnd":1112,"domainLookupStart":1112,"fetchStart":1112,"redirectEnd":0,"redirectStart":0,"requestStart":1112,"responseEnd":1540.7999992370605,"responseStart":1540.6999998092651,"secureConnectionStart":1112}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":102,"responseStart":258,"responseEnd":262,"domLoading":264,"domInteractive":1516,"domContentLoadedEventStart":1516,"domContentLoadedEventEnd":1560,"domComplete":2170,"loadEventStart":2170,"loadEventEnd":2171,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1463.7999992370605},{"name":"bigPipe.sidebar-id.end","time":1464.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1464.7999992370605},{"name":"bigPipe.activity-panel-pipe-id.end","time":1466.2999992370605},{"name":"activityTabFullyLoaded","time":1609.6999998092651}],"measures":[],"correlationId":"4221415e4aa7ff","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":100,"dbReadsTimeInMs":13,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
A JIRA error had this ticket initially created in error, being duplicated by +1 as
MDEV-33500