Type:
Bug
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
10.2(EOL) , 10.3(EOL) , 10.4(EOL) , 10.5 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL)
./mtr --mysqld=--debug=d,intermittent_read_failure binlog_encryption.rpl_parallel_incorrect_relay_pos rpl.rpl_semisync_ali_issues binlog_encryption.rpl_parallel_stop_on_con_kill gcol.gcol_purge rpl.rpl_seconds_behind_master_spike binlog_encryption.rpl_parallel_retry_deadlock rpl.rpl_row_corruption rpl.rpl_parallel_stop_on_con_kill rpl.rpl_parallel_incorrect_relay_pos rpl.rpl_semi_sync_master_shutdown rpl.rpl_parallel_retry_deadlock
fails at check testcase step:
rpl.rpl_semi_sync_master_shutdown 'stmt' [ pass ] 3916
MTR's internal check of the test case 'rpl.rpl_semi_sync_master_shutdown' failed.
This means that the test case does not preserve the state that existed
before the test case was executed. Most likely the test case did not
do a proper clean-up. It could also be caused by the previous test run
by this thread, if the server wasn't restarted.
This is the diff of the states of the servers before and after the
test case was executed:
mysqltest: Logging to '/home/parallels/dev/10.5/build1/mysql-test/var/tmp/check-mysqld_1.log'.
mysqltest: Results saved in '/home/parallels/dev/10.5/build1/mysql-test/var/tmp/check-mysqld_1.result'.
mysqltest: Connecting to server localhost:16000 (socket /home/parallels/dev/10.5/build1/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-testcase.test' ...
mysqltest: ... Done processing test commands.
--- /home/parallels/dev/10.5/build1/mysql-test/var/tmp/check-mysqld_1.result 2022-05-11 13:25:37.457554354 +0100
+++ /home/parallels/dev/10.5/build1/mysql-test/var/tmp/check-mysqld_1.reject 2022-05-11 13:25:41.554341020 +0100
@@ -124,9 +124,9 @@
DEADLOCK_SEARCH_DEPTH_SHORT 4
DEADLOCK_TIMEOUT_LONG 50000000
DEADLOCK_TIMEOUT_SHORT 10000
-DEBUG d,intermittent_read_failure
+DEBUG
DEBUG_BINLOG_FSYNC_SLEEP 0
-DEBUG_DBUG d,intermittent_read_failure
+DEBUG_DBUG
DEBUG_MUTEX_DEADLOCK_DETECTOR ON
DEBUG_NO_THREAD_ALARM OFF
DEFAULT_PASSWORD_LIFETIME 0
mysqltest: Result length mismatch
not ok
Checked with:
10.2 a5dc12eefd4bea1c3f77d02c55d0d459b4ae0566
10.3 b208030ef5b4274fd66cc9667a2dc96f6e63db81
10.4 a4139f8d68bd31e80ff6202c093cd232c194ddfd
10.5 fe3d07cab82b2215dc64f52ac93122072c33d021
10.6 cad792c6862546a13b83f05209e7842a95bdc5fa
10.7 9e314fcf6e666ce6fdbdd8ca1ae23d6c4b389b21
10.8 bde0b31dc59bd1f171f3e62efb5443382c94c141
10.9 51b28b24ca3a33a3a9b2a844c6c8a94df1bad253
Discovered from work on MDEV-13542 .
{"report":{"fcp":877.9000000953674,"ttfb":133.5,"pageVisibility":"visible","entityId":110892,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"16cbbd02-9019-448d-8c0b-b5787f2ff811","navigationType":0,"readyForUser":933.4000000953674,"redirectCount":0,"resourceLoadedEnd":1148.5,"resourceLoadedStart":138.80000019073486,"resourceTiming":[{"duration":276.89999985694885,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":138.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":138.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":415.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":276.59999990463257,"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":139.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":139.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":415.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":287.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":139.30000019073486,"connectEnd":139.30000019073486,"connectStart":139.30000019073486,"domainLookupEnd":139.30000019073486,"domainLookupStart":139.30000019073486,"fetchStart":139.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":139.30000019073486,"responseEnd":426.80000019073486,"responseStart":426.80000019073486,"secureConnectionStart":139.30000019073486},{"duration":313.59999990463257,"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":139.40000009536743,"connectEnd":139.40000009536743,"connectStart":139.40000009536743,"domainLookupEnd":139.40000009536743,"domainLookupStart":139.40000009536743,"fetchStart":139.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":139.40000009536743,"responseEnd":453,"responseStart":452.90000009536743,"secureConnectionStart":139.40000009536743},{"duration":317.10000014305115,"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":139.5,"connectEnd":139.5,"connectStart":139.5,"domainLookupEnd":139.5,"domainLookupStart":139.5,"fetchStart":139.5,"redirectEnd":0,"redirectStart":0,"requestStart":139.5,"responseEnd":456.60000014305115,"responseStart":456.60000014305115,"secureConnectionStart":139.5},{"duration":317.59999990463257,"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":139.60000014305115,"connectEnd":139.60000014305115,"connectStart":139.60000014305115,"domainLookupEnd":139.60000014305115,"domainLookupStart":139.60000014305115,"fetchStart":139.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":139.60000014305115,"responseEnd":457.2000000476837,"responseStart":457.2000000476837,"secureConnectionStart":139.60000014305115},{"duration":317.69999980926514,"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":139.80000019073486,"connectEnd":139.80000019073486,"connectStart":139.80000019073486,"domainLookupEnd":139.80000019073486,"domainLookupStart":139.80000019073486,"fetchStart":139.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":139.80000019073486,"responseEnd":457.5,"responseStart":457.5,"secureConnectionStart":139.80000019073486},{"duration":325.7999999523163,"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":139.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":139.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":465.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":318.10000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":140,"connectEnd":140,"connectStart":140,"domainLookupEnd":140,"domainLookupStart":140,"fetchStart":140,"redirectEnd":0,"redirectStart":0,"requestStart":140,"responseEnd":458.10000014305115,"responseStart":458.10000014305115,"secureConnectionStart":140},{"duration":325.7999999523163,"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":140.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":140.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":466,"responseStart":0,"secureConnectionStart":0},{"duration":318.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":140.30000019073486,"connectEnd":140.30000019073486,"connectStart":140.30000019073486,"domainLookupEnd":140.30000019073486,"domainLookupStart":140.30000019073486,"fetchStart":140.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":140.30000019073486,"responseEnd":458.80000019073486,"responseStart":458.80000019073486,"secureConnectionStart":140.30000019073486},{"duration":1006.6000001430511,"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":141,"connectEnd":141,"connectStart":141,"domainLookupEnd":141,"domainLookupStart":141,"fetchStart":141,"redirectEnd":0,"redirectStart":0,"requestStart":141,"responseEnd":1147.6000001430511,"responseStart":1147.5,"secureConnectionStart":141},{"duration":1007.3999998569489,"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":141.10000014305115,"connectEnd":141.10000014305115,"connectStart":141.10000014305115,"domainLookupEnd":141.10000014305115,"domainLookupStart":141.10000014305115,"fetchStart":141.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":141.10000014305115,"responseEnd":1148.5,"responseStart":1148.5,"secureConnectionStart":141.10000014305115},{"duration":427.90000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":671.2000000476837,"connectEnd":671.2000000476837,"connectStart":671.2000000476837,"domainLookupEnd":671.2000000476837,"domainLookupStart":671.2000000476837,"fetchStart":671.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":671.2000000476837,"responseEnd":1099.1000001430511,"responseStart":1099.1000001430511,"secureConnectionStart":671.2000000476837}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":13,"responseStart":133,"responseEnd":136,"domLoading":136,"domInteractive":1199,"domContentLoadedEventStart":1199,"domContentLoadedEventEnd":1234,"domComplete":1959,"loadEventStart":1959,"loadEventEnd":1960,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1182.7000000476837},{"name":"bigPipe.sidebar-id.end","time":1183.6000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":1183.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":1186.3000001907349},{"name":"activityTabFullyLoaded","time":1240.2000000476837}],"measures":[],"correlationId":"dc8691a61edc16","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":68,"dbReadsTimeInMs":12,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}