I have two hosts running MariaDB with Galera Cluster.
This DB is used by the Monitoring Application Zabbix.
The database is very big, more than 200GB of data.
I have a script to make partitioning in some tables of the database.
Sometimes, during the partitioning process, MariaDB crashes, with the messages in attachment.
The partitioning script and my.cnf are also in attachment.
Any help?
Thanks
- is duplicated by
-
MDEV-9416
MariaDB galera got signal 11 when altering table add unique index
-
-
Closed
{"report":{"fcp":784.9000000953674,"ttfb":174.40000009536743,"pageVisibility":"visible","entityId":58689,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"8dbbca45-abe4-48fe-b476-af85f3a67ea0","navigationType":0,"readyForUser":859.2000000476837,"redirectCount":0,"resourceLoadedEnd":501.2999999523163,"resourceLoadedStart":182.10000014305115,"resourceTiming":[{"duration":18.299999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":182.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":182.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":200.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":18.200000047683716,"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":182.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":182.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":200.5,"responseStart":0,"secureConnectionStart":0},{"duration":137.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":182.5,"connectEnd":182.5,"connectStart":182.5,"domainLookupEnd":182.5,"domainLookupStart":182.5,"fetchStart":182.5,"redirectEnd":0,"redirectStart":0,"requestStart":206.60000014305115,"responseEnd":319.7000000476837,"responseStart":286.10000014305115,"secureConnectionStart":182.5},{"duration":47.299999952316284,"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":182.60000014305115,"connectEnd":182.60000014305115,"connectStart":182.60000014305115,"domainLookupEnd":182.60000014305115,"domainLookupStart":182.60000014305115,"fetchStart":182.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":209.40000009536743,"responseEnd":229.90000009536743,"responseStart":226.90000009536743,"secureConnectionStart":182.60000014305115},{"duration":306.19999980926514,"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":182.60000014305115,"connectEnd":204.70000004768372,"connectStart":204.70000004768372,"domainLookupEnd":204.70000004768372,"domainLookupStart":204.70000004768372,"fetchStart":182.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":208.90000009536743,"responseEnd":488.7999999523163,"responseStart":222.20000004768372,"secureConnectionStart":204.70000004768372},{"duration":56.299999952316284,"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":182.70000004768372,"connectEnd":182.70000004768372,"connectStart":182.70000004768372,"domainLookupEnd":182.70000004768372,"domainLookupStart":182.70000004768372,"fetchStart":182.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":209.90000009536743,"responseEnd":239,"responseStart":235.90000009536743,"secureConnectionStart":182.70000004768372},{"duration":55.200000047683716,"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":182.90000009536743,"connectEnd":182.90000009536743,"connectStart":182.90000009536743,"domainLookupEnd":182.90000009536743,"domainLookupStart":182.90000009536743,"fetchStart":182.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":210.10000014305115,"responseEnd":238.10000014305115,"responseStart":235,"secureConnectionStart":182.90000009536743},{"duration":23.100000143051147,"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":183,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":183,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":206.10000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":75.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":183.10000014305115,"connectEnd":183.10000014305115,"connectStart":183.10000014305115,"domainLookupEnd":183.10000014305115,"domainLookupStart":183.10000014305115,"fetchStart":183.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":210.29999995231628,"responseEnd":258.90000009536743,"responseStart":254.20000004768372,"secureConnectionStart":183.10000014305115},{"duration":23.700000047683716,"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":183.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":183.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":206.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":50.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":183.20000004768372,"connectEnd":183.20000004768372,"connectStart":183.20000004768372,"domainLookupEnd":183.20000004768372,"domainLookupStart":183.20000004768372,"fetchStart":183.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":210.40000009536743,"responseEnd":233.70000004768372,"responseStart":230.29999995231628,"secureConnectionStart":183.20000004768372},{"duration":310.09999990463257,"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":190.90000009536743,"connectEnd":190.90000009536743,"connectStart":190.90000009536743,"domainLookupEnd":190.90000009536743,"domainLookupStart":190.90000009536743,"fetchStart":190.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":271.10000014305115,"responseEnd":501,"responseStart":493.7999999523163,"secureConnectionStart":190.90000009536743},{"duration":305.89999985694885,"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":195.40000009536743,"connectEnd":195.40000009536743,"connectStart":195.40000009536743,"domainLookupEnd":195.40000009536743,"domainLookupStart":195.40000009536743,"fetchStart":195.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":301.40000009536743,"responseEnd":501.2999999523163,"responseStart":494.60000014305115,"secureConnectionStart":195.40000009536743},{"duration":112.60000014305115,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":462.5,"connectEnd":462.5,"connectStart":462.5,"domainLookupEnd":462.5,"domainLookupStart":462.5,"fetchStart":462.5,"redirectEnd":0,"redirectStart":0,"requestStart":545.6000001430511,"responseEnd":575.1000001430511,"responseStart":573.6000001430511,"secureConnectionStart":462.5},{"duration":72.79999995231628,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":706.2000000476837,"connectEnd":706.2000000476837,"connectStart":706.2000000476837,"domainLookupEnd":706.2000000476837,"domainLookupStart":706.2000000476837,"fetchStart":706.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":750.2000000476837,"responseEnd":779,"responseStart":777.7999999523163,"secureConnectionStart":706.2000000476837}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":30,"responseStart":175,"responseEnd":195,"domLoading":178,"domInteractive":920,"domContentLoadedEventStart":920,"domContentLoadedEventEnd":966,"domComplete":1179,"loadEventStart":1179,"loadEventEnd":1179,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":895.7000000476837},{"name":"bigPipe.sidebar-id.end","time":896.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":896.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":898.5},{"name":"activityTabFullyLoaded","time":980.5}],"measures":[],"correlationId":"a0c363782c6415","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":83,"dbReadsTimeInMs":13,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
From the error log:
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x38d) [0x7f9302c7ff0d]
Oct 26 10:30:05 npaa2629 mysqld: /lib64/libpthread.so.0(+0xf100) [0x7f930229e100]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(ha_abort_transaction(THD*, THD*, char)+0x9f) [0x7f9302c8a8bf]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(wsrep_abort_thd(void*, void*, char)+0x139) [0x7f9302c315f9]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(wsrep_grant_mdl_exception(MDL_context*, MDL_ticket*, MDL_key const*)+0x2a7) [0x7f9302c22687]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(MDL_lock::can_grant_lock(enum_mdl_type, MDL_context*, bool) const+0x11f) [0x7f9302bd649f]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(MDL_context::try_acquire_lock_impl(MDL_request*, MDL_ticket**)+0xf1) [0x7f9302bd7121]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(MDL_context::acquire_lock(MDL_request*, double)+0x2e) [0x7f9302bd768e]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(MDL_context::upgrade_shared_lock(MDL_ticket*, enum_mdl_type, double)+0xae) [0x7f9302bd837e]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(mysql_alter_table(THD*, char*, char*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool)+0x12fd) [0x7f9302b8a22d]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(Sql_cmd_alter_table::execute(THD*)+0x61a) [0x7f9302bd135a]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0x1206) [0x7f9302afeb16]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x28e) [0x7f9302b0717e]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(+0x438989) [0x7f9302b07989]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x1fb0) [0x7f9302b0a010]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(do_command(THD*)+0x169) [0x7f9302b0aeb9]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(do_handle_one_connection(THD*)+0x18a) [0x7f9302bce62a]
Oct 26 10:30:05 npaa2629 mysqld: /usr/sbin/mysqld(handle_one_connection+0x40) [0x7f9302bce800]
Oct 26 10:30:05 npaa2629 mysqld: /lib64/libpthread.so.0(+0x7dc5) [0x7f9302296dc5]
Oct 26 10:30:05 npaa2629 mysqld: /lib64/libc.so.6(clone+0x6d) [0x7f93006b8ced]
Oct 26 10:30:05 npaa2629 mysqld: Trying to get some variables.
Oct 26 10:30:05 npaa2629 mysqld: Some pointers may be invalid and cause the dump to abort.
Oct 26 10:30:05 npaa2629 mysqld: Query (0x7f8f41bf8020): ALTER TABLE zabbix.history DROP PARTITION p2016_10_17
Oct 26 10:30:05 npaa2629 mysqld: Connection ID (thread ID): 501884
Oct 26 10:30:05 npaa2629 mysqld: Status: NOT_KILLED