Hi Support Team,
We have a 3-node cluster, 2 of which are DB (service IP addr: 172.17.153.82 and 172.21.153.82) and 1 is Galera witness (IP addr: 172.18.16.82). The application connects to DB via an HA proxy located at the same site as the DB, which will hunt between the 2 DB nodes and connect to the healthy one.
All 3 nodes (2 DBs + 1 witness) are at different sites. There was a network maintenance at the site 172.17.x.x and we expected that the DB on that site would be inaccessible while the other 2 nodes will still form a cluster, and applications can still write to the DB node at 172.21.x.x. However, the application failed to connect to the remaining DB node (Lost connection to server at 'handshake: reading initial communication packet', system error: 11).
We needed to bootstrap after the network maintenance was over.
At node 1, the following error was observed:
exception from gcomm, backend must be restarted: evs::proto(fac95f38-8d6b, GATHER, view_id(REG,15b6ecac-8b9b,58)) failed to form singleton view after exceeding max_install_timeouts 3, giving up (FATAL) at /home/buildbot/buildbot/build/gcomm/src/evs_proto.cpp:handle_install_timer():728
On the other hand, the log files at the other nodes appeared to be the expected ones. We would like to know:
1. Why bootstraping was needed to resume?
2. Is the above error message normal and what is its meaning? A similar ticket MDEV-32110 has been raised by someone else but there is no feedback so far.
Please advise.
Thanks and best regards,
Lawrence
Sergei Golubchik
made changes -
2025-01-12 19:44
Field
Original Value
New Value
Assignee
Jan Lindström
[ JIRAUSER53125
]
Elena Stepanova
made changes -
2025-02-12 16:03
Fix Version/s
10.6
[ 24028
]
Elena Stepanova
made changes -
2025-02-12 16:04
Fix Version/s
10.11
[ 27614
]
Fix Version/s
10.6
[ 24028
]
{"report":{"fcp":1130.6999998092651,"ttfb":359.5,"pageVisibility":"visible","entityId":132337,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"d7c234af-34cb-4fb3-aa3f-874c6d0c434f","navigationType":0,"readyForUser":1205.3000001907349,"redirectCount":0,"resourceLoadedEnd":1246.8000001907349,"resourceLoadedStart":365.69999980926514,"resourceTiming":[{"duration":196.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":365.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":365.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":562,"responseStart":0,"secureConnectionStart":0},{"duration":196.30000019073486,"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":366,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":366,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":562.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":251.60000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":366.19999980926514,"connectEnd":366.19999980926514,"connectStart":366.19999980926514,"domainLookupEnd":366.19999980926514,"domainLookupStart":366.19999980926514,"fetchStart":366.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":366.19999980926514,"responseEnd":617.8000001907349,"responseStart":617.8000001907349,"secureConnectionStart":366.19999980926514},{"duration":371.19999980926514,"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":366.30000019073486,"connectEnd":366.30000019073486,"connectStart":366.30000019073486,"domainLookupEnd":366.30000019073486,"domainLookupStart":366.30000019073486,"fetchStart":366.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":366.30000019073486,"responseEnd":737.5,"responseStart":737.5,"secureConnectionStart":366.30000019073486},{"duration":374.90000009536743,"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":366.59999990463257,"connectEnd":366.59999990463257,"connectStart":366.59999990463257,"domainLookupEnd":366.59999990463257,"domainLookupStart":366.59999990463257,"fetchStart":366.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":366.59999990463257,"responseEnd":741.5,"responseStart":741.5,"secureConnectionStart":366.59999990463257},{"duration":375.2999997138977,"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":366.80000019073486,"connectEnd":366.80000019073486,"connectStart":366.80000019073486,"domainLookupEnd":366.80000019073486,"domainLookupStart":366.80000019073486,"fetchStart":366.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":366.80000019073486,"responseEnd":742.0999999046326,"responseStart":742.0999999046326,"secureConnectionStart":366.80000019073486},{"duration":375.40000009536743,"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":367,"connectEnd":367,"connectStart":367,"domainLookupEnd":367,"domainLookupStart":367,"fetchStart":367,"redirectEnd":0,"redirectStart":0,"requestStart":367,"responseEnd":742.4000000953674,"responseStart":742.4000000953674,"secureConnectionStart":367},{"duration":410.40000009536743,"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":367.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":367.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":777.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":375.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":367.40000009536743,"connectEnd":367.40000009536743,"connectStart":367.40000009536743,"domainLookupEnd":367.40000009536743,"domainLookupStart":367.40000009536743,"fetchStart":367.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":367.40000009536743,"responseEnd":743.0999999046326,"responseStart":743.0999999046326,"secureConnectionStart":367.40000009536743},{"duration":410.2000002861023,"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":367.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":367.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":777.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":376.1000003814697,"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":367.69999980926514,"connectEnd":367.69999980926514,"connectStart":367.69999980926514,"domainLookupEnd":367.69999980926514,"domainLookupStart":367.69999980926514,"fetchStart":367.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":367.69999980926514,"responseEnd":743.8000001907349,"responseStart":743.8000001907349,"secureConnectionStart":367.69999980926514},{"duration":850.9000000953674,"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":368.59999990463257,"connectEnd":368.59999990463257,"connectStart":368.59999990463257,"domainLookupEnd":368.59999990463257,"domainLookupStart":368.59999990463257,"fetchStart":368.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":368.59999990463257,"responseEnd":1219.5,"responseStart":1219.5,"secureConnectionStart":368.59999990463257},{"duration":852.2000002861023,"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":368.59999990463257,"connectEnd":368.59999990463257,"connectStart":368.59999990463257,"domainLookupEnd":368.59999990463257,"domainLookupStart":368.59999990463257,"fetchStart":368.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":368.59999990463257,"responseEnd":1220.8000001907349,"responseStart":1220.8000001907349,"secureConnectionStart":368.59999990463257},{"duration":219.2000002861023,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":793.0999999046326,"connectEnd":793.0999999046326,"connectStart":793.0999999046326,"domainLookupEnd":793.0999999046326,"domainLookupStart":793.0999999046326,"fetchStart":793.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":793.0999999046326,"responseEnd":1012.3000001907349,"responseStart":1012.3000001907349,"secureConnectionStart":793.0999999046326},{"duration":170.89999961853027,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/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","startTime":1059.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1059.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1230.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":180,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/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":1060.8000001907349,"connectEnd":1060.8000001907349,"connectStart":1060.8000001907349,"domainLookupEnd":1060.8000001907349,"domainLookupStart":1060.8000001907349,"fetchStart":1060.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1060.8000001907349,"responseEnd":1240.8000001907349,"responseStart":1240.8000001907349,"secureConnectionStart":1060.8000001907349},{"duration":158.7999997138977,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1122.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1122.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1281.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":185.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/53a43b6764f587426c7bb9a150184c00-CDN/lu2bv2/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","startTime":1061.3000001907349,"connectEnd":1061.3000001907349,"connectStart":1061.3000001907349,"domainLookupEnd":1061.3000001907349,"domainLookupStart":1061.3000001907349,"fetchStart":1061.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1061.3000001907349,"responseEnd":1246.8000001907349,"responseStart":1246.8000001907349,"secureConnectionStart":1061.3000001907349}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":182,"responseStart":359,"responseEnd":363,"domLoading":363,"domInteractive":1325,"domContentLoadedEventStart":1325,"domContentLoadedEventEnd":1367,"domComplete":1636,"loadEventStart":1636,"loadEventEnd":1636,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1287.5},{"name":"bigPipe.sidebar-id.end","time":1288.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1288.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1290.9000000953674},{"name":"activityTabFullyLoaded","time":1383}],"measures":[],"correlationId":"963d2997ce0be5","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":113,"dbReadsTimeInMs":18,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
The mariadb-error.log for 2 nodes and the Galera log file are uploaded for your ref.