Hi,
I tried to delete a database from the cluster when the entire cluster suddenly crashes due to a DROP DATABASE operation. The crash appeared on all nodes at the same time as u can see in the logfiles.
I added all logfiles and our my.cnf which is the same on all three nodes.
If you have any advices for our configuration, please let me know.
Best Regards,
Aljoscha
Aljoscha Dembowsky
made changes -
2018-07-02 08:40
Field
Original Value
New Value
Description
Hi,
I tried to delete a database from the cluster when the entire cluster suddenly crashes due to a DROP DATABASE operation. The crash appeared on all nodes at the same time as u can see in the logfiles.
I added all logfiles and our my.cnf which is the same on all three nodes.
If you have any advices for our configuration, please let me know, because this crash is a nogo for a production environment.
Best Regards,
Aljoscha
Hi,
I tried to delete a database from the cluster when the entire cluster suddenly crashes due to a DROP DATABASE operation. The crash appeared on all nodes at the same time as u can see in the logfiles.
I added all logfiles and our my.cnf which is the same on all three nodes.
If you have any advices for our configuration, please let me know.
Best Regards,
Aljoscha
Elena Stepanova
made changes -
2018-07-02 09:14
Fix Version/s
10.1
[ 16100
]
Assignee
Rasmus Johansson
[ ratzpo
]
Aljoscha Dembowsky
made changes -
2018-07-02 12:29
Environment
Ubuntu 16.04 LTS
Intel Xeon E5-2687Wv4 - 12/24t - 3GHz /3.5GHz
128GB DDR4 ECC 2400 MHz
10 Gbit/s Ethernet
450gb NVMe SSD
MaxScale/HA-Proxy for load balancing
Ubuntu 16.04 LTS
Intel Xeon E5-2687Wv4 - 12/24t - 3GHz /3.5GHz
128GB DDR4 ECC 2400 MHz
10 Gbit/s Ethernet
2x450gb NVMe SSD RAID 1
MaxScale/HA-Proxy for load balancing
Daniel Black
made changes -
2018-07-03 00:28
Labels
assertion crash galera need_feedback
assertion crash galera
Julius Goryavsky
made changes -
2018-09-18 13:20
Status
Open
[ 1
]
In Progress
[ 3
]
Jan Lindström (Inactive)
made changes -
2018-10-01 09:48
Fix Version/s
10.3.11
[ 23141
]
Fix Version/s
10.1.37
[ 23204
]
Fix Version/s
10.2.19
[ 23207
]
Fix Version/s
10.1
[ 16100
]
Resolution
Fixed
[ 1
]
Status
In Progress
[ 3
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2021-12-06 21:47
Workflow
MariaDB v3
[ 88175
]
MariaDB v4
[ 154609
]
{"report":{"fcp":892.5999999642372,"ttfb":237,"pageVisibility":"visible","entityId":68465,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"2dedfee4-d0b1-4b08-aa24-57c3ca83ce6f","navigationType":0,"readyForUser":976.5,"redirectCount":0,"resourceLoadedEnd":1089.300000011921,"resourceLoadedStart":242.69999998807907,"resourceTiming":[{"duration":96.69999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":242.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":242.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":339.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":97,"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":242.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":242.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":339.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":161.9000000357628,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":243.0999999642372,"connectEnd":243.0999999642372,"connectStart":243.0999999642372,"domainLookupEnd":243.0999999642372,"domainLookupStart":243.0999999642372,"fetchStart":243.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":243.0999999642372,"responseEnd":405,"responseStart":405,"secureConnectionStart":243.0999999642372},{"duration":247.79999995231628,"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":243.30000001192093,"connectEnd":243.30000001192093,"connectStart":243.30000001192093,"domainLookupEnd":243.30000001192093,"domainLookupStart":243.30000001192093,"fetchStart":243.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":243.30000001192093,"responseEnd":491.0999999642372,"responseStart":491.0999999642372,"secureConnectionStart":243.30000001192093},{"duration":251,"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":243.5,"connectEnd":243.5,"connectStart":243.5,"domainLookupEnd":243.5,"domainLookupStart":243.5,"fetchStart":243.5,"redirectEnd":0,"redirectStart":0,"requestStart":243.5,"responseEnd":494.5,"responseStart":494.5,"secureConnectionStart":243.5},{"duration":251.30000001192093,"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":243.69999998807907,"connectEnd":243.69999998807907,"connectStart":243.69999998807907,"domainLookupEnd":243.69999998807907,"domainLookupStart":243.69999998807907,"fetchStart":243.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":243.69999998807907,"responseEnd":495,"responseStart":495,"secureConnectionStart":243.69999998807907},{"duration":251.5,"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":243.89999997615814,"connectEnd":243.89999997615814,"connectStart":243.89999997615814,"domainLookupEnd":243.89999997615814,"domainLookupStart":243.89999997615814,"fetchStart":243.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":243.89999997615814,"responseEnd":495.39999997615814,"responseStart":495.39999997615814,"secureConnectionStart":243.89999997615814},{"duration":324.89999997615814,"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":244,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":244,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":568.8999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":251.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":244.0999999642372,"connectEnd":244.0999999642372,"connectStart":244.0999999642372,"domainLookupEnd":244.0999999642372,"domainLookupStart":244.0999999642372,"fetchStart":244.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":244.0999999642372,"responseEnd":495.89999997615814,"responseStart":495.89999997615814,"secureConnectionStart":244.0999999642372},{"duration":324.69999998807907,"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":244.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":244.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":569,"responseStart":0,"secureConnectionStart":0},{"duration":252,"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":244.5,"connectEnd":244.5,"connectStart":244.5,"domainLookupEnd":244.5,"domainLookupStart":244.5,"fetchStart":244.5,"redirectEnd":0,"redirectStart":0,"requestStart":244.5,"responseEnd":496.5,"responseStart":496.5,"secureConnectionStart":244.5},{"duration":629.5,"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":253.30000001192093,"connectEnd":253.30000001192093,"connectStart":253.30000001192093,"domainLookupEnd":253.30000001192093,"domainLookupStart":253.30000001192093,"fetchStart":253.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":253.30000001192093,"responseEnd":882.8000000119209,"responseStart":882.8000000119209,"secureConnectionStart":253.30000001192093},{"duration":835.9000000357628,"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":253.39999997615814,"connectEnd":253.39999997615814,"connectStart":253.39999997615814,"domainLookupEnd":253.39999997615814,"domainLookupStart":253.39999997615814,"fetchStart":253.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":253.39999997615814,"responseEnd":1089.300000011921,"responseStart":1089.300000011921,"secureConnectionStart":253.39999997615814},{"duration":302.80000001192093,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":580.3999999761581,"connectEnd":580.3999999761581,"connectStart":580.3999999761581,"domainLookupEnd":580.3999999761581,"domainLookupStart":580.3999999761581,"fetchStart":580.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":580.3999999761581,"responseEnd":883.1999999880791,"responseStart":883.1999999880791,"secureConnectionStart":580.3999999761581},{"duration":226.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":885.8000000119209,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":885.8000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1112.300000011921,"responseStart":0,"secureConnectionStart":0},{"duration":252.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/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":910.3000000119209,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":910.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1162.800000011921,"responseStart":0,"secureConnectionStart":0},{"duration":221.5999999642372,"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":911.3000000119209,"connectEnd":911.3000000119209,"connectStart":911.3000000119209,"domainLookupEnd":911.3000000119209,"domainLookupStart":911.3000000119209,"fetchStart":911.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":911.3000000119209,"responseEnd":1132.8999999761581,"responseStart":1132.8999999761581,"secureConnectionStart":911.3000000119209},{"duration":227.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/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":911.8000000119209,"connectEnd":911.8000000119209,"connectStart":911.8000000119209,"domainLookupEnd":911.8000000119209,"domainLookupStart":911.8000000119209,"fetchStart":911.8000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":911.8000000119209,"responseEnd":1139.0999999642372,"responseStart":1139.0999999642372,"secureConnectionStart":911.8000000119209}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":54,"responseStart":237,"responseEnd":251,"domLoading":241,"domInteractive":1118,"domContentLoadedEventStart":1118,"domContentLoadedEventEnd":1163,"domComplete":1322,"loadEventStart":1322,"loadEventEnd":1322,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1095.300000011921},{"name":"bigPipe.sidebar-id.end","time":1096.0999999642372},{"name":"bigPipe.activity-panel-pipe-id.start","time":1096.199999988079},{"name":"bigPipe.activity-panel-pipe-id.end","time":1099},{"name":"activityTabFullyLoaded","time":1181.699999988079}],"measures":[],"correlationId":"b9634b059e59ba","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":128,"dbReadsTimeInMs":20,"dbConnsTimeInMs":29,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}