-
Bug
-
-
Major
-
Resolution:
Fixed
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
-
-
-
https://buildbot.mariadb.net/buildbot/builders/kvm-fulltest2/builds/39795
10.7 bc656c4fa
|
rpl.rpl_delayed_parallel_slave_sbm 'row' w3 [ fail ]
|
Test ended at 2023-02-07 10:31:30
|
|
CURRENT_TEST: rpl.rpl_delayed_parallel_slave_sbm
|
mysqltest: At line 102: Seconds_Behind_Master should not have used second transaction timestamp
|
|
The result from queries just before the failure was:
|
< snip >
|
connection slave;
|
UNLOCK TABLES;
|
include/sync_with_master_gtid.inc
|
#
|
# Pt 2) If the SQL thread has not entered an idle state, ensure
|
# following events do not update SBM
|
# Stop slave IO thread so it receives both events together on restart
|
connection slave;
|
include/stop_slave_io.inc
|
connection master;
|
# Sleep 2 to allow a buffer between events for SBM check
|
insert into t1 values (1);
|
# Sleep 3 to create gap between events
|
insert into t1 values (2);
|
connection slave;
|
LOCK TABLES t1 WRITE;
|
START SLAVE IO_THREAD;
|
# Wait for first transaction to complete SQL delay and begin execution..
|
# Validate SBM calculation doesn't use the second transaction because SQL thread shouldn't have gone idle..
|
# SBM 0 was more recent than time since last transaction (1 seconds)
|
Angelique Sklavounos (Inactive)
made changes -
Summary
|
rpl.rpl_delayed_parallel_slave_sbm sometimes fails with Seconds_Behind_Master should not have used second transaction timestamp
|
[Draft] rpl.rpl_delayed_parallel_slave_sbm sometimes fails with Seconds_Behind_Master should not have used second transaction timestamp
|
Angelique Sklavounos (Inactive)
made changes -
Assignee
|
Angelique Sklavounos
[ JIRAUSER50741
]
|
Brandon Nesterenko
[ JIRAUSER48702
]
|
Summary
|
[Draft] rpl.rpl_delayed_parallel_slave_sbm sometimes fails with Seconds_Behind_Master should not have used second transaction timestamp
|
rpl.rpl_delayed_parallel_slave_sbm sometimes fails with Seconds_Behind_Master should not have used second transaction timestamp
|
Brandon Nesterenko
made changes -
Fix Version/s
|
|
10.3
[ 22126
]
|
Fix Version/s
|
|
10.4
[ 22408
]
|
Fix Version/s
|
|
10.5
[ 23123
]
|
Fix Version/s
|
|
10.6
[ 24028
]
|
Fix Version/s
|
|
10.7
[ 24805
]
|
Fix Version/s
|
|
10.8
[ 26121
]
|
Fix Version/s
|
|
10.9
[ 26905
]
|
Fix Version/s
|
|
10.10
[ 27530
]
|
Fix Version/s
|
|
11.0
[ 28320
]
|
Brandon Nesterenko
made changes -
issue.field.resolutiondate
|
2023-02-09 21:36:14.0
|
2023-02-09 21:36:14.769
|
Brandon Nesterenko
made changes -
Fix Version/s
|
|
10.4.29
[ 28510
]
|
Fix Version/s
|
|
10.5.20
[ 28512
]
|
Fix Version/s
|
|
10.6.13
[ 28514
]
|
Fix Version/s
|
|
10.8.8
[ 28518
]
|
Fix Version/s
|
|
10.9.6
[ 28520
]
|
Fix Version/s
|
|
10.10.4
[ 28522
]
|
Fix Version/s
|
|
10.11.3
[ 28524
]
|
Fix Version/s
|
|
11.0.1
[ 28548
]
|
Fix Version/s
|
10.3
[ 22126
]
|
|
Fix Version/s
|
10.4
[ 22408
]
|
|
Fix Version/s
|
10.5
[ 23123
]
|
|
Fix Version/s
|
10.6
[ 24028
]
|
|
Fix Version/s
|
10.7
[ 24805
]
|
|
Fix Version/s
|
10.8
[ 26121
]
|
|
Fix Version/s
|
10.9
[ 26905
]
|
|
Fix Version/s
|
10.10
[ 27530
]
|
|
Fix Version/s
|
11.0
[ 28320
]
|
|
Resolution
|
|
Fixed
[ 1
]
|
Status
|
In Progress
[ 3
]
|
Closed
[ 6
]
|
{"report":{"fcp":1506.6000003814697,"ttfb":800,"pageVisibility":"visible","entityId":119048,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"09d8dbaf-99c8-4a2e-be90-0cae07edbaad","navigationType":0,"readyForUser":1591.1000003814697,"redirectCount":0,"resourceLoadedEnd":1201.1000003814697,"resourceLoadedStart":808.3999996185303,"resourceTiming":[{"duration":69.20000076293945,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":808.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":808.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":877.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":69.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":808.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":808.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":878.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":270.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":808.8999996185303,"connectEnd":808.8999996185303,"connectStart":808.8999996185303,"domainLookupEnd":808.8999996185303,"domainLookupStart":808.8999996185303,"fetchStart":808.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":884,"responseEnd":1079.5,"responseStart":915.3000001907349,"secureConnectionStart":808.8999996185303},{"duration":392.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":809,"connectEnd":809,"connectStart":809,"domainLookupEnd":809,"domainLookupStart":809,"fetchStart":809,"redirectEnd":0,"redirectStart":0,"requestStart":884.8999996185303,"responseEnd":1201.1000003814697,"responseStart":924.1999998092651,"secureConnectionStart":809},{"duration":119,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":809.1999998092651,"connectEnd":809.1999998092651,"connectStart":809.1999998092651,"domainLookupEnd":809.1999998092651,"domainLookupStart":809.1999998092651,"fetchStart":809.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":885.3000001907349,"responseEnd":928.1999998092651,"responseStart":926.6999998092651,"secureConnectionStart":809.1999998092651},{"duration":121.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":809.3999996185303,"connectEnd":809.3999996185303,"connectStart":809.3999996185303,"domainLookupEnd":809.3999996185303,"domainLookupStart":809.3999996185303,"fetchStart":809.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":885.5,"responseEnd":931.1999998092651,"responseStart":928.3000001907349,"secureConnectionStart":809.3999996185303},{"duration":121.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":809.6000003814697,"connectEnd":809.6000003814697,"connectStart":809.6000003814697,"domainLookupEnd":809.6000003814697,"domainLookupStart":809.6000003814697,"fetchStart":809.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":885.5,"responseEnd":931.5,"responseStart":929,"secureConnectionStart":809.6000003814697},{"duration":77.70000076293945,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":809.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":809.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":887.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":121.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":810,"connectEnd":810,"connectStart":810,"domainLookupEnd":810,"domainLookupStart":810,"fetchStart":810,"redirectEnd":0,"redirectStart":0,"requestStart":888.1999998092651,"responseEnd":931.8000001907349,"responseStart":929.6999998092651,"secureConnectionStart":810},{"duration":77.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":810.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":810.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":887.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":123.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":810.1999998092651,"connectEnd":810.1999998092651,"connectStart":810.1999998092651,"domainLookupEnd":810.1999998092651,"domainLookupStart":810.1999998092651,"fetchStart":810.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":889,"responseEnd":934,"responseStart":933.1000003814697,"secureConnectionStart":810.1999998092651},{"duration":339.5999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":811.3000001907349,"connectEnd":811.3000001907349,"connectStart":811.3000001907349,"domainLookupEnd":811.3000001907349,"domainLookupStart":811.3000001907349,"fetchStart":811.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1009.8999996185303,"responseEnd":1150.8999996185303,"responseStart":1146.8999996185303,"secureConnectionStart":811.3000001907349},{"duration":338.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":813.6999998092651,"connectEnd":813.6999998092651,"connectStart":813.6999998092651,"domainLookupEnd":813.6999998092651,"domainLookupStart":813.6999998092651,"fetchStart":813.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1019,"responseEnd":1152,"responseStart":1148.6000003814697,"secureConnectionStart":813.6999998092651},{"duration":156,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1209.3999996185303,"connectEnd":1209.3999996185303,"connectStart":1209.3999996185303,"domainLookupEnd":1209.3999996185303,"domainLookupStart":1209.3999996185303,"fetchStart":1209.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":1315.8999996185303,"responseEnd":1365.3999996185303,"responseStart":1364.6999998092651,"secureConnectionStart":1209.3999996185303}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":100,"responseStart":800,"responseEnd":808,"domLoading":804,"domInteractive":1694,"domContentLoadedEventStart":1694,"domContentLoadedEventEnd":1756,"domComplete":2175,"loadEventStart":2175,"loadEventEnd":2175,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1665.8000001907349},{"name":"bigPipe.sidebar-id.end","time":1666.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":1666.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1671.1000003814697},{"name":"activityTabFullyLoaded","time":1773}],"measures":[],"correlationId":"34adb9c1d2846d","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":612,"dbReadsTimeInMs":23,"dbConnsTimeInMs":32,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}