Build tested: 22.08.2, latest build from drone (#5838)
Steps:
1. Create a 3PM docker cluster
2. Check cluster status on PM1. master=PM1, slave=PM2, PM3
3. Create a database and a table, insert a row in PM1
4. Verify table gets replicated to PM2
5. Execute "docker container stop mcs1", wait 90 seconds
6. Execute "docker container start mcs1", wait 60 seconds
7. Check cluster status on PM1. master=PM1, slave=PM2, PM3
Yesterday, I noticed MaxScale had PM2 sat as the master
Today, MaxScale also set PM1 as the master (I don't know why such behavior today)
For this test, PM2 was expected to take over as the master
8. Create another table and inserted a row on PM1
9. The table did not get replicated to PM2 or PM3
10. "show slave status" on PM2 returned nothing
11. "show slave status" on PM3 did return status, and no error
PM3 slave status showed master log mariadb-bin.000002, position 4684
PM1 master status showed master log mariadb-bin.000004, position 568
Executed test case in mustest, test advance.a000_failover.test
Steps performed.
echo Checking MaxScale status......
echo Checking ColumnStore status on mcs1......
echo Running sanity test on mcs1......
echo Checking ColumnStore status on mcs1......
echo Stopping node mcs1......
echo Checking MaxScale status......
echo Checking ColumnStore status on mcs2......
echo Starting node mcs1......
echo Checking MaxScale status......
echo Checking ColumnStore status on mcs1......
echo Create a 1g DBT2 database on mcs2......
echo Check row counts on mcs1 for replication......
echo Drop test database......
echo Ending of test.
Test result, output from the test, has been attached.
Daniel Lee (Inactive)
added a comment - Build verified: 22.08.7
engine: e243a5332b8613ce0e370a503461990fefc24fce
server: d3049350bb5c61340f5a7518b155d3c9dacdcb33
buildNo: 6202
Executed test case in mustest, test advance.a000_failover.test
Steps performed.
echo Checking MaxScale status......
echo Checking ColumnStore status on mcs1......
echo Running sanity test on mcs1......
echo Checking ColumnStore status on mcs1......
echo Stopping node mcs1......
echo Checking MaxScale status......
echo Checking ColumnStore status on mcs2......
echo Starting node mcs1......
echo Checking MaxScale status......
echo Checking ColumnStore status on mcs1......
echo Create a 1g DBT2 database on mcs2......
echo Check row counts on mcs1 for replication......
echo Drop test database......
echo Ending of test.
Test result, output from the test, has been attached.
People
Roman
Daniel Lee (Inactive)
Daniel Lee (Inactive)
Votes:
0Vote for this issue
Watchers:
5Start 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":1465.5999999046326,"ttfb":536.1999998092651,"pageVisibility":"visible","entityId":116295,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"6fa40212-3a60-491b-83c6-730953c1b4f3","navigationType":0,"readyForUser":1558.3999996185303,"redirectCount":0,"resourceLoadedEnd":1592.1999998092651,"resourceLoadedStart":542.8999996185303,"resourceTiming":[{"duration":337.1000003814697,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":542.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":542.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":880,"responseStart":0,"secureConnectionStart":0},{"duration":336.7999997138977,"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":543.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":543.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":880.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":399.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":544.1999998092651,"connectEnd":544.1999998092651,"connectStart":544.1999998092651,"domainLookupEnd":544.1999998092651,"domainLookupStart":544.1999998092651,"fetchStart":544.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":544.1999998092651,"responseEnd":944.0999999046326,"responseStart":944.0999999046326,"secureConnectionStart":544.1999998092651},{"duration":497.8999996185303,"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":544.5,"connectEnd":544.5,"connectStart":544.5,"domainLookupEnd":544.5,"domainLookupStart":544.5,"fetchStart":544.5,"redirectEnd":0,"redirectStart":0,"requestStart":544.5,"responseEnd":1042.3999996185303,"responseStart":1042.3999996185303,"secureConnectionStart":544.5},{"duration":501.80000019073486,"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":544.7999997138977,"connectEnd":544.7999997138977,"connectStart":544.7999997138977,"domainLookupEnd":544.7999997138977,"domainLookupStart":544.7999997138977,"fetchStart":544.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":544.7999997138977,"responseEnd":1046.5999999046326,"responseStart":1046.5999999046326,"secureConnectionStart":544.7999997138977},{"duration":502,"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":545,"connectEnd":545,"connectStart":545,"domainLookupEnd":545,"domainLookupStart":545,"fetchStart":545,"redirectEnd":0,"redirectStart":0,"requestStart":545,"responseEnd":1047,"responseStart":1047,"secureConnectionStart":545},{"duration":502.2999997138977,"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":545.0999999046326,"connectEnd":545.0999999046326,"connectStart":545.0999999046326,"domainLookupEnd":545.0999999046326,"domainLookupStart":545.0999999046326,"fetchStart":545.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":545.0999999046326,"responseEnd":1047.3999996185303,"responseStart":1047.3999996185303,"secureConnectionStart":545.0999999046326},{"duration":546.5,"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":545.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":545.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1091.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":502.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":545.5,"connectEnd":545.5,"connectStart":545.5,"domainLookupEnd":545.5,"domainLookupStart":545.5,"fetchStart":545.5,"redirectEnd":0,"redirectStart":0,"requestStart":545.5,"responseEnd":1048,"responseStart":1048,"secureConnectionStart":545.5},{"duration":546.5,"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":545.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":545.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1092.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":502.7000002861023,"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":545.7999997138977,"connectEnd":545.7999997138977,"connectStart":545.7999997138977,"domainLookupEnd":545.7999997138977,"domainLookupStart":545.7999997138977,"fetchStart":545.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":545.7999997138977,"responseEnd":1048.5,"responseStart":1048.5,"secureConnectionStart":545.7999997138977},{"duration":959.0999999046326,"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":547.2999997138977,"connectEnd":547.2999997138977,"connectStart":547.2999997138977,"domainLookupEnd":547.2999997138977,"domainLookupStart":547.2999997138977,"fetchStart":547.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":547.2999997138977,"responseEnd":1506.3999996185303,"responseStart":1506.3999996185303,"secureConnectionStart":547.2999997138977},{"duration":1001,"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":547.2999997138977,"connectEnd":547.2999997138977,"connectStart":547.2999997138977,"domainLookupEnd":547.2999997138977,"domainLookupStart":547.2999997138977,"fetchStart":547.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":547.2999997138977,"responseEnd":1548.2999997138977,"responseStart":1548.2999997138977,"secureConnectionStart":547.2999997138977},{"duration":228.09999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1117.5999999046326,"connectEnd":1117.5999999046326,"connectStart":1117.5999999046326,"domainLookupEnd":1117.5999999046326,"domainLookupStart":1117.5999999046326,"fetchStart":1117.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1117.5999999046326,"responseEnd":1345.6999998092651,"responseStart":1345.6999998092651,"secureConnectionStart":1117.5999999046326},{"duration":197.09999990463257,"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":1395.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1395.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1592.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":153.2999997138977,"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":1396.5,"connectEnd":1396.5,"connectStart":1396.5,"domainLookupEnd":1396.5,"domainLookupStart":1396.5,"fetchStart":1396.5,"redirectEnd":0,"redirectStart":0,"requestStart":1396.5,"responseEnd":1549.7999997138977,"responseStart":1549.7999997138977,"secureConnectionStart":1396.5},{"duration":164.40000009536743,"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":1396.8999996185303,"connectEnd":1396.8999996185303,"connectStart":1396.8999996185303,"domainLookupEnd":1396.8999996185303,"domainLookupStart":1396.8999996185303,"fetchStart":1396.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":1396.8999996185303,"responseEnd":1561.2999997138977,"responseStart":1561.2999997138977,"secureConnectionStart":1396.8999996185303},{"duration":194,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1455,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1455,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1649,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":370,"responseStart":536,"responseEnd":539,"domLoading":540,"domInteractive":1704,"domContentLoadedEventStart":1704,"domContentLoadedEventEnd":1755,"domComplete":3108,"loadEventStart":3108,"loadEventEnd":3108,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1659.3999996185303},{"name":"bigPipe.sidebar-id.end","time":1660.2999997138977},{"name":"bigPipe.activity-panel-pipe-id.start","time":1660.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":1662.5},{"name":"activityTabFullyLoaded","time":1772.0999999046326}],"measures":[],"correlationId":"5cb5818145d61f","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":107,"dbReadsTimeInMs":15,"dbConnsTimeInMs":25,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Blocker
Page Failed to load
Page Loading...
The scenario David.Hall mentioned should be re-tested when
MCOL-5306is tested.