Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.4(EOL) , 10.5 , 10.6 , 10.11 , 11.0(EOL) , 11.1(EOL) , 11.2(EOL) , 11.3(EOL)
The test rpl.rpl_seconds_behind_master_spike can fail with
CURRENT_TEST: rpl.rpl_seconds_behind_master_spike
mysqltest: At line 63: query 'select count(*)=1 from t1' failed: ER_NO_SUCH_TABLE (1146): Table 'test.t1' doesn't exist
The result from queries just before the failure was:
< snip >
SET @@global.debug_dbug="+d,pause_sql_thread_on_fde,negate_clock_diff_with_master";
include/start_slave.inc
# Future events must be logged at least 2 seconds after
# the slave starts
connection master;
# Write events to ensure slave will be consistent with master
create table t1 (a int);
insert into t1 values (1);
# Flush logs on master forces slave to generate a Format description
# event in its relay log
flush logs;
connection slave;
# Ignore FDEs that happen before the CREATE/INSERT commands
SET DEBUG_SYNC='now WAIT_FOR paused_on_fde';
SET DEBUG_SYNC='now SIGNAL sql_thread_continue';
SET DEBUG_SYNC='now WAIT_FOR paused_on_fde';
SET DEBUG_SYNC='now SIGNAL sql_thread_continue';
# On the next FDE, the slave should have the master CREATE/INSERT events
SET DEBUG_SYNC='now WAIT_FOR paused_on_fde';
select count(*)=1 from t1;
because the test is reliant on a specific number of format descriptor events (FDEs). However, depending on when the IO thread is stopped, it can send an extra FDE before sending the transactions, forcing the test to pause before executing any transactions.
The test should be fixed to be more flexible and not reliant on FDE count.
Note this test became much more unstable after MDEV-32551 , as the amended kill_zombie_dump_threads would kill the IO thread quicker, making this test fail quite often.
{"report":{"fcp":770.1999998092651,"ttfb":264.4000005722046,"pageVisibility":"visible","entityId":127445,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"22ef2524-cdd9-425e-9a45-249b53f33756","navigationType":0,"readyForUser":832,"redirectCount":0,"resourceLoadedEnd":768.9000005722046,"resourceLoadedStart":271.69999980926514,"resourceTiming":[{"duration":12.600000381469727,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":271.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":271.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":284.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":12.600000381469727,"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":272,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":272,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":284.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":67.40000057220459,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":272.19999980926514,"connectEnd":272.19999980926514,"connectStart":272.19999980926514,"domainLookupEnd":272.19999980926514,"domainLookupStart":272.19999980926514,"fetchStart":272.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":285.69999980926514,"responseEnd":339.6000003814697,"responseStart":303.80000019073486,"secureConnectionStart":272.19999980926514},{"duration":89.59999942779541,"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":272.4000005722046,"connectEnd":272.4000005722046,"connectStart":272.4000005722046,"domainLookupEnd":272.4000005722046,"domainLookupStart":272.4000005722046,"fetchStart":272.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":285.9000005722046,"responseEnd":362,"responseStart":307.6000003814697,"secureConnectionStart":272.4000005722046},{"duration":31.199999809265137,"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":272.5,"connectEnd":272.5,"connectStart":272.5,"domainLookupEnd":272.5,"domainLookupStart":272.5,"fetchStart":272.5,"redirectEnd":0,"redirectStart":0,"requestStart":285.9000005722046,"responseEnd":303.69999980926514,"responseStart":303.19999980926514,"secureConnectionStart":272.5},{"duration":30.40000057220459,"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":272.69999980926514,"connectEnd":272.69999980926514,"connectStart":272.69999980926514,"domainLookupEnd":272.69999980926514,"domainLookupStart":272.69999980926514,"fetchStart":272.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":286.5,"responseEnd":303.1000003814697,"responseStart":302.5,"secureConnectionStart":272.69999980926514},{"duration":34.69999980926514,"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":272.9000005722046,"connectEnd":272.9000005722046,"connectStart":272.9000005722046,"domainLookupEnd":272.9000005722046,"domainLookupStart":272.9000005722046,"fetchStart":272.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":286.9000005722046,"responseEnd":307.6000003814697,"responseStart":307,"secureConnectionStart":272.9000005722046},{"duration":13.600000381469727,"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":273,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":273,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":286.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":41.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":273.19999980926514,"connectEnd":273.19999980926514,"connectStart":273.19999980926514,"domainLookupEnd":273.19999980926514,"domainLookupStart":273.19999980926514,"fetchStart":273.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":288.1000003814697,"responseEnd":314.69999980926514,"responseStart":314,"secureConnectionStart":273.19999980926514},{"duration":14.199999809265137,"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":273.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":273.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":287.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":51.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":273.5,"connectEnd":273.5,"connectStart":273.5,"domainLookupEnd":273.5,"domainLookupStart":273.5,"fetchStart":273.5,"redirectEnd":0,"redirectStart":0,"requestStart":295.9000005722046,"responseEnd":325.30000019073486,"responseStart":324.69999980926514,"secureConnectionStart":273.5},{"duration":487.20000076293945,"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":281.69999980926514,"connectEnd":281.69999980926514,"connectStart":281.69999980926514,"domainLookupEnd":281.69999980926514,"domainLookupStart":281.69999980926514,"fetchStart":281.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":338.69999980926514,"responseEnd":768.9000005722046,"responseStart":763.1000003814697,"secureConnectionStart":281.69999980926514},{"duration":485.79999923706055,"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":281.9000005722046,"connectEnd":281.9000005722046,"connectStart":281.9000005722046,"domainLookupEnd":281.9000005722046,"domainLookupStart":281.9000005722046,"fetchStart":281.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":352.1000003814697,"responseEnd":767.6999998092651,"responseStart":759.8000001907349,"secureConnectionStart":281.9000005722046},{"duration":187.9000005722046,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":542.1999998092651,"connectEnd":542.1999998092651,"connectStart":542.1999998092651,"domainLookupEnd":542.1999998092651,"domainLookupStart":542.1999998092651,"fetchStart":542.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":692.8000001907349,"responseEnd":730.1000003814697,"responseStart":728.6000003814697,"secureConnectionStart":542.1999998092651},{"duration":179.69999980926514,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":750.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":750.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":930,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":107,"responseStart":264,"responseEnd":281,"domLoading":267,"domInteractive":887,"domContentLoadedEventStart":887,"domContentLoadedEventEnd":926,"domComplete":2173,"loadEventStart":2173,"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":870.1000003814697},{"name":"bigPipe.sidebar-id.end","time":870.9000005722046},{"name":"bigPipe.activity-panel-pipe-id.start","time":871},{"name":"bigPipe.activity-panel-pipe-id.end","time":873.3000001907349},{"name":"activityTabFullyLoaded","time":935.6999998092651}],"measures":[],"correlationId":"e1a8eea653926d","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":92,"dbReadsTimeInMs":13,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}