I use sakila database for my test. http://dev.mysql.com/doc/index-other.html (I joinned my files to this Issue)
I run it on non clustured MariaDB and all work greats.
When I run the same Shema creation SQL file on MariaDB Galera, the node crash at the CREATE DEFINER line with this message in syslog;
Nov 26 12:36:22 ubuntuserver1 mysqld: 141126 12:36:22 [ERROR] mysqld got signal 11 ;
|
Nov 26 12:36:22 ubuntuserver1 mysqld: This could be because you hit a bug. It is also possible that this binary
|
Nov 26 12:36:22 ubuntuserver1 mysqld: or one of the libraries it was linked against is corrupt, improperly built,
|
Nov 26 12:36:22 ubuntuserver1 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
|
Nov 26 12:36:22 ubuntuserver1 mysqld:
|
Nov 26 12:36:22 ubuntuserver1 mysqld: To report this bug, see http://kb.askmonty.org/en/reporting-bugs
|
Nov 26 12:36:22 ubuntuserver1 mysqld:
|
Nov 26 12:36:22 ubuntuserver1 mysqld: We will try our best to scrape up some info that will hopefully help
|
Nov 26 12:36:22 ubuntuserver1 mysqld: diagnose the problem, but since we have already crashed,
|
Nov 26 12:36:22 ubuntuserver1 mysqld: something is definitely wrong and this may fail.
|
Nov 26 12:36:22 ubuntuserver1 mysqld:
|
Nov 26 12:36:22 ubuntuserver1 mysqld: Server version: 10.0.14-MariaDB-1~trusty-wsrep-log
|
Nov 26 12:36:22 ubuntuserver1 mysqld: key_buffer_size=134217728
|
Nov 26 12:36:22 ubuntuserver1 mysqld: read_buffer_size=2097152
|
Nov 26 12:36:22 ubuntuserver1 mysqld: max_used_connections=1
|
Nov 26 12:36:22 ubuntuserver1 mysqld: max_threads=102
|
Nov 26 12:36:22 ubuntuserver1 mysqld: thread_count=3
|
Nov 26 12:36:22 ubuntuserver1 mysqld: It is possible that mysqld could use up to
|
Nov 26 12:36:22 ubuntuserver1 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 759897 K bytes of memory
|
Nov 26 12:36:22 ubuntuserver1 mysqld: Hope that's ok; if not, decrease some variables in the equation.
|
Nov 26 12:36:22 ubuntuserver1 mysqld:
|
Nov 26 12:36:22 ubuntuserver1 mysqld: Thread pointer: 0x0x7f62d0e9b008
|
Nov 26 12:36:22 ubuntuserver1 mysqld: Attempting backtrace. You can use the following information to find out
|
Nov 26 12:36:22 ubuntuserver1 mysqld: where mysqld died. If you see no messages after this, something went
|
Nov 26 12:36:22 ubuntuserver1 mysqld: terribly wrong...
|
Nov 26 12:36:22 ubuntuserver1 mysqld: stack_bottom = 0x7f6309ff0df0 thread_stack 0x48000
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7f630abb6d8e]
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x457)[0x7f630a6f33e7]
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x10340)[0x7f6308ea2340]
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /usr/sbin/mysqld(_Z18view_store_optionsP3THDP10TABLE_LISTP6String+0x84)[0x7f630a5cf994]
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /usr/sbin/mysqld(_Z24wsrep_to_isolation_beginP3THDPcS1_PK10TABLE_LIST+0x822)[0x7f630a6921b2]
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6fea)[0x7f630a56fd8a]
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /usr/sbin/mysqld(+0x40d977)[0x7f630a572977]
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x217f)[0x7f630a57519f]
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x20f)[0x7f630a575a8f]
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x1fb)[0x7f630a643deb]
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /usr/sbin/mysqld(handle_one_connection+0x40)[0x7f630a643fd0]
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x8182)[0x7f6308e9a182]
|
Nov 26 12:36:22 ubuntuserver1 mysqld: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f63085bcfbd]
|
Nov 26 12:36:22 ubuntuserver1 mysqld:
|
Nov 26 12:36:22 ubuntuserver1 mysqld: Trying to get some variables.
|
Nov 26 12:36:22 ubuntuserver1 mysqld: Some pointers may be invalid and cause the dump to abort.
|
Nov 26 12:36:22 ubuntuserver1 mysqld: Query (0x7f62d0f38106): is an invalid pointer
|
Nov 26 12:36:22 ubuntuserver1 mysqld: Connection ID (thread ID): 48
|
Nov 26 12:36:22 ubuntuserver1 mysqld: Status: NOT_KILLED
|
Nov 26 12:36:22 ubuntuserver1 mysqld:
|
Nov 26 12:36:22 ubuntuserver1 mysqld: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on
|
Nov 26 12:36:22 ubuntuserver1 mysqld:
|
Nov 26 12:36:22 ubuntuserver1 mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
Nov 26 12:36:22 ubuntuserver1 mysqld: information that should help you find out what is causing the crash.
|
Nov 26 12:36:22 ubuntuserver1 mysqld_safe: Number of processes running now: 0
|
Nov 26 12:36:22 ubuntuserver1 mysqld_safe: WSREP: not restarting wsrep node automatically
|
Nov 26 12:36:22 ubuntuserver1 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
|
I'm not an expert but it probably only an unsupported SQL statement on Galera cluster.
{"report":{"fcp":1014.8000001907349,"ttfb":210,"pageVisibility":"visible","entityId":49142,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"bcd09320-acd7-43a3-bb00-3699b9544e57","navigationType":0,"readyForUser":1119.7000002861023,"redirectCount":0,"resourceLoadedEnd":1169,"resourceLoadedStart":216.09999990463257,"resourceTiming":[{"duration":192.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":216.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":216.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":408.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":192.30000019073486,"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":216.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":216.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":408.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":201.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":216.80000019073486,"connectEnd":216.80000019073486,"connectStart":216.80000019073486,"domainLookupEnd":216.80000019073486,"domainLookupStart":216.80000019073486,"fetchStart":216.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":216.80000019073486,"responseEnd":418,"responseStart":417.90000009536743,"secureConnectionStart":216.80000019073486},{"duration":331.09999990463257,"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":217,"connectEnd":217,"connectStart":217,"domainLookupEnd":217,"domainLookupStart":217,"fetchStart":217,"redirectEnd":0,"redirectStart":0,"requestStart":217,"responseEnd":548.0999999046326,"responseStart":548.0999999046326,"secureConnectionStart":217},{"duration":334.7999997138977,"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":217.30000019073486,"connectEnd":217.30000019073486,"connectStart":217.30000019073486,"domainLookupEnd":217.30000019073486,"domainLookupStart":217.30000019073486,"fetchStart":217.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":217.30000019073486,"responseEnd":552.0999999046326,"responseStart":552.0999999046326,"secureConnectionStart":217.30000019073486},{"duration":335,"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":217.5,"connectEnd":217.5,"connectStart":217.5,"domainLookupEnd":217.5,"domainLookupStart":217.5,"fetchStart":217.5,"redirectEnd":0,"redirectStart":0,"requestStart":217.5,"responseEnd":552.5,"responseStart":552.5,"secureConnectionStart":217.5},{"duration":335.30000019073486,"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":217.59999990463257,"connectEnd":217.59999990463257,"connectStart":217.59999990463257,"domainLookupEnd":217.59999990463257,"domainLookupStart":217.59999990463257,"fetchStart":217.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":217.59999990463257,"responseEnd":552.9000000953674,"responseStart":552.9000000953674,"secureConnectionStart":217.59999990463257},{"duration":355,"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":217.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":217.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":572.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":335.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":217.90000009536743,"connectEnd":217.90000009536743,"connectStart":217.90000009536743,"domainLookupEnd":217.90000009536743,"domainLookupStart":217.90000009536743,"fetchStart":217.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":217.90000009536743,"responseEnd":553.4000000953674,"responseStart":553.4000000953674,"secureConnectionStart":217.90000009536743},{"duration":355,"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":218.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":218.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":573.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":335.7999997138977,"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":218.2000002861023,"connectEnd":218.2000002861023,"connectStart":218.2000002861023,"domainLookupEnd":218.2000002861023,"domainLookupStart":218.2000002861023,"fetchStart":218.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":218.2000002861023,"responseEnd":554,"responseStart":554,"secureConnectionStart":218.2000002861023},{"duration":558.8000001907349,"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":219,"connectEnd":219,"connectStart":219,"domainLookupEnd":219,"domainLookupStart":219,"fetchStart":219,"redirectEnd":0,"redirectStart":0,"requestStart":219,"responseEnd":777.8000001907349,"responseStart":777.8000001907349,"secureConnectionStart":219},{"duration":805.1999998092651,"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":223.40000009536743,"connectEnd":223.40000009536743,"connectStart":223.40000009536743,"domainLookupEnd":223.40000009536743,"domainLookupStart":223.40000009536743,"fetchStart":223.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":223.40000009536743,"responseEnd":1028.5999999046326,"responseStart":1028.5999999046326,"secureConnectionStart":223.40000009536743},{"duration":178.2000002861023,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":600.0999999046326,"connectEnd":600.0999999046326,"connectStart":600.0999999046326,"domainLookupEnd":600.0999999046326,"domainLookupStart":600.0999999046326,"fetchStart":600.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":600.0999999046326,"responseEnd":778.3000001907349,"responseStart":778.3000001907349,"secureConnectionStart":600.0999999046326},{"duration":276.5,"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":892.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":892.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1169,"responseStart":0,"secureConnectionStart":0},{"duration":363.59999990463257,"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":893.4000000953674,"connectEnd":893.4000000953674,"connectStart":893.4000000953674,"domainLookupEnd":893.4000000953674,"domainLookupStart":893.4000000953674,"fetchStart":893.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":893.4000000953674,"responseEnd":1257,"responseStart":1257,"secureConnectionStart":893.4000000953674},{"duration":367.80000019073486,"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":893.9000000953674,"connectEnd":893.9000000953674,"connectStart":893.9000000953674,"domainLookupEnd":893.9000000953674,"domainLookupStart":893.9000000953674,"fetchStart":893.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":893.9000000953674,"responseEnd":1261.7000002861023,"responseStart":1261.7000002861023,"secureConnectionStart":893.9000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":51,"responseStart":210,"responseEnd":215,"domLoading":214,"domInteractive":1206,"domContentLoadedEventStart":1206,"domContentLoadedEventEnd":1261,"domComplete":2335,"loadEventStart":2335,"loadEventEnd":2337,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1183.9000000953674},{"name":"bigPipe.sidebar-id.end","time":1184.7000002861023},{"name":"bigPipe.activity-panel-pipe-id.start","time":1184.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1192.0999999046326},{"name":"activityTabFullyLoaded","time":1275.7000002861023}],"measures":[],"correlationId":"eca160b8ccc9f3","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":90,"dbReadsTimeInMs":10,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}