-
Bug
-
-
Major
-
Resolution:
Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
-
-
-
Start 2 node cluster using TLS mariabackup SST encryption built into socat.
config info
|
|
wsrep_provider_options='gmcast.listen_addr=tcp://127.0.0.1:4808;'
|
ssl-ca = /dev/shm/qa/cert/ca.pem
|
ssl-cert = /dev/shm/qa/cert/server-cert.pem
|
ssl-key = /dev/shm/qa/cert/server-key.pem
|
[sst]
|
encrypt = 2
|
tca = /dev/shm/qa/cert/sst_encypt2.crt
|
tcert = /dev/shm/qa/cert/sst_encypt2.pem
|
$
|
Error info from donor node.
2021-07-21 16:49:12 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'donor' --address 'ax3win:4444/xtrabackup_sst//1' --local-port '4800' --socket '/dev/shm/qa/node1/mysql.sock' --datadir '/dev/shm/qa/node1/' --defaults-file '/dev/shm/qa/conf/node1.cnf' --gtid '92245b05-ea43-11eb-89cc-ba6f0392455f:0' --gtid-domain-id '0' --mysqld-args --defaults-file=/dev/shm/qa/conf/node1.cnf --wsrep-new-cluster'
|
2021-07-21 16:49:12 2 [Note] WSREP: sst_donor_thread signaled with 0
|
WSREP_SST: [INFO] SSL configuration: CA='/dev/shm/qa/cert/sst_encypt2.crt', CERT='/dev/shm/qa/cert/sst_encypt2.pem', KEY='', MODE='DISABLED', encrypt='2' (20210721 16:49:12.800)
|
WSREP_SST: [INFO] Streaming with mbstream (20210721 16:49:12.950)
|
WSREP_SST: [INFO] Using socat as streamer (20210721 16:49:12.952)
|
WSREP_SST: [INFO] Using openssl based encryption with socat: with crt and pem (20210721 16:49:12.959)
|
WSREP_SST: [INFO] Encrypting with cert=/dev/shm/qa/cert/sst_encypt2.pem, cafile=/dev/shm/qa/cert/sst_encypt2.crt (20210721 16:49:12.968)
|
WSREP_SST: [INFO] Using '/tmp/tmp.PqLfYMKEGR' as mariabackup temporary directory (20210721 16:49:12.990)
|
WSREP_SST: [INFO] Using '/tmp/tmp.wt3mCpRqiI' as mariabackup working directory (20210721 16:49:12.995)
|
WSREP_SST: [INFO] Streaming GTID file before SST (20210721 16:49:12.999)
|
WSREP_SST: [INFO] Evaluating '/home/ramesh/framework/GAL_MD200721-mariadb-10.3.30-linux-x86_64-opt//bin/mbstream' -c 'xtrabackup_galera_info' | socat -u stdio openssl-connect:ax3win:4444,cert='/dev/shm/qa/cert/sst_encypt2.pem',cafile='/dev/shm/qa/cert/sst_encypt2.crt'; RC=( ${PIPESTATUS[@]} ) (20210721 16:49:13.002)
|
2021/07/21 16:49:13 socat[2709097] E certificate is valid but its commonName does not match hostname
|
WSREP_SST: [ERROR] Error while sending data to joiner node: exit codes: 0 1 (20210721 16:49:13.020)
|
WSREP_SST: [ERROR] Cleanup after exit with status:32 (20210721 16:49:13.022)
|
WSREP_SST: [INFO] Cleaning up temporary directories (20210721 16:49:13.025)
|
{"report":{"fcp":919,"ttfb":276.7999999523163,"pageVisibility":"visible","entityId":101440,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"717ccf98-953d-4355-b2a0-b5ebe4543044","navigationType":0,"readyForUser":1024.2999999523163,"redirectCount":0,"resourceLoadedEnd":906,"resourceLoadedStart":283,"resourceTiming":[{"duration":33.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":283,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":283,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":316.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":34.40000009536743,"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":283.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":283.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":317.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":86,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":283.5,"connectEnd":283.5,"connectStart":283.5,"domainLookupEnd":283.5,"domainLookupStart":283.5,"fetchStart":283.5,"redirectEnd":0,"redirectStart":0,"requestStart":283.5,"responseEnd":369.5,"responseStart":369.5,"secureConnectionStart":283.5},{"duration":310.2999999523163,"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":283.5,"connectEnd":283.5,"connectStart":283.5,"domainLookupEnd":283.5,"domainLookupStart":283.5,"fetchStart":283.5,"redirectEnd":0,"redirectStart":0,"requestStart":283.5,"responseEnd":593.7999999523163,"responseStart":593.7999999523163,"secureConnectionStart":283.5},{"duration":313.90000009536743,"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":283.7000000476837,"connectEnd":283.7000000476837,"connectStart":283.7000000476837,"domainLookupEnd":283.7000000476837,"domainLookupStart":283.7000000476837,"fetchStart":283.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":283.7000000476837,"responseEnd":597.6000001430511,"responseStart":597.6000001430511,"secureConnectionStart":283.7000000476837},{"duration":314.10000014305115,"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":283.7999999523163,"connectEnd":283.7999999523163,"connectStart":283.7999999523163,"domainLookupEnd":283.7999999523163,"domainLookupStart":283.7999999523163,"fetchStart":283.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":283.7999999523163,"responseEnd":597.9000000953674,"responseStart":597.9000000953674,"secureConnectionStart":283.7999999523163},{"duration":314.7000000476837,"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":283.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":283.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":598.6000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":314.2999999523163,"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":283.90000009536743,"connectEnd":283.90000009536743,"connectStart":283.90000009536743,"domainLookupEnd":283.90000009536743,"domainLookupStart":283.90000009536743,"fetchStart":283.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":283.90000009536743,"responseEnd":598.2000000476837,"responseStart":598.2000000476837,"secureConnectionStart":283.90000009536743},{"duration":314.60000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":284,"connectEnd":284,"connectStart":284,"domainLookupEnd":284,"domainLookupStart":284,"fetchStart":284,"redirectEnd":0,"redirectStart":0,"requestStart":284,"responseEnd":598.6000001430511,"responseStart":598.6000001430511,"secureConnectionStart":284},{"duration":314.90000009536743,"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":284.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":284.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":599.1000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":314.89999985694885,"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":284.40000009536743,"connectEnd":284.40000009536743,"connectStart":284.40000009536743,"domainLookupEnd":284.40000009536743,"domainLookupStart":284.40000009536743,"fetchStart":284.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":284.40000009536743,"responseEnd":599.2999999523163,"responseStart":599.2999999523163,"secureConnectionStart":284.40000009536743},{"duration":527.5999999046326,"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":284.90000009536743,"connectEnd":284.90000009536743,"connectStart":284.90000009536743,"domainLookupEnd":284.90000009536743,"domainLookupStart":284.90000009536743,"fetchStart":284.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":284.90000009536743,"responseEnd":812.5,"responseStart":812.5,"secureConnectionStart":284.90000009536743},{"duration":610.0999999046326,"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":285.10000014305115,"connectEnd":285.10000014305115,"connectStart":285.10000014305115,"domainLookupEnd":285.10000014305115,"domainLookupStart":285.10000014305115,"fetchStart":285.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":285.10000014305115,"responseEnd":895.2000000476837,"responseStart":895.2000000476837,"secureConnectionStart":285.10000014305115},{"duration":295.2999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":516,"connectEnd":516,"connectStart":516,"domainLookupEnd":516,"domainLookupStart":516,"fetchStart":516,"redirectEnd":0,"redirectStart":0,"requestStart":516,"responseEnd":811.2999999523163,"responseStart":811.2999999523163,"secureConnectionStart":516},{"duration":46.799999952316284,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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","startTime":859.2000000476837,"connectEnd":859.2000000476837,"connectStart":859.2000000476837,"domainLookupEnd":859.2000000476837,"domainLookupStart":859.2000000476837,"fetchStart":859.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":859.2000000476837,"responseEnd":906,"responseStart":906,"secureConnectionStart":859.2000000476837},{"duration":48.19999980926514,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":910.6000001430511,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":910.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":958.7999999523163,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":154,"responseStart":277,"responseEnd":278,"domLoading":280,"domInteractive":1079,"domContentLoadedEventStart":1079,"domContentLoadedEventEnd":1125,"domComplete":1786,"loadEventStart":1786,"loadEventEnd":1786,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1061.1000001430511},{"name":"bigPipe.sidebar-id.end","time":1061.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1061.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1064.4000000953674},{"name":"activityTabFullyLoaded","time":1130.5}],"measures":[],"correlationId":"dd7baf612a4da1","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":67,"dbReadsTimeInMs":10,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}