-
Bug
-
-
Major
-
Resolution:
Fixed
-
None
-
-
-
Although MariaDB Galera Cluster does not support XA transactions but it still shouldn't crash server.
1. create a new db and a table
2. input a value
3. XA START 'test';
here where it crashed I received in the log
mariadbd: /home/jenkins/workspace/MariaDBE-Custom-bintar/label/rhel-7/wsrep-lib/src/transaction.cpp:123: int wsrep::transaction::start_transaction(const wsrep::transaction_id&): Assertion `active() == false' failed.
|
201208 13:46:06 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.4.15-9-MariaDB-enterprise-log
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=6
|
max_threads=1002
|
thread_count=15
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2336198 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7f2a980008c8
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f2a0c3accc0 thread_stack 0x49000
|
/MARIADB/MIN10020/bin/mariadb/bin/mariadbd(my_print_stacktrace+0x2e)[0x55ec5d1cc0be]
|
/MARIADB/MIN10020/bin/mariadb/bin/mariadbd(handle_fatal_signal+0x30f)[0x55ec5cc4ca1f]
|
sigaction.c:0(__restore_rt)[0x7f2d85aaa630]
|
:0(__GI_raise)[0x7f2d83d27387]
|
:0(__GI_abort)[0x7f2d83d28a78]
|
:0(__assert_fail_base)[0x7f2d83d201a6]
|
:0(__GI___assert_fail)[0x7f2d83d20252]
|
/MARIADB/MIN10020/bin/mariadb/bin/mariadbd(+0xeedd5e)[0x55ec5d26dd5e]
|
/MARIADB/MIN10020/bin/mariadb/bin/mariadbd(_Z11trans_beginP3THDj+0x2eb)[0x55ec5cb3a56b]
|
src/transaction.cpp:123(wsrep::transaction::start_transaction(wsrep::transaction_id const&))[0x55ec5cbce18e]
|
wsrep/client_state.hpp:290(wsrep::client_state::start_transaction(wsrep::transaction_id const&))[0x55ec5ca3e5c5]
|
sql/xa.cc:440(trans_xa_start(THD*))[0x55ec5ca44ddd]
|
sql/sql_parse.cc:5970(mysql_execute_command(THD*))[0x55ec5c92ec6c]
|
sql/sql_parse.cc:7926(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55ec5ca48757]
|
sql/sql_parse.cc:1353(do_command(THD*))[0x55ec5ca48c19]
|
sql/sql_connect.cc:1412(do_handle_one_connection(CONNECT*))[0x55ec5cb2b9fa]
|
sql/sql_connect.cc:1318(handle_one_connection)[0x55ec5cb2badd]
|
perfschema/pfs.cc:1872(pfs_spawn_thread)[0x55ec5d17d81d]
|
pthread_create.c:0(start_thread)[0x7f2d85aa2ea5]
|
/lib64/libc.so.6(clone+0x6d)[0x7f2d83def8dd]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f2a9802c050): XA START 'test'
|
Connection ID (thread ID): 205
|
Status: NOT_KILLED
|
|
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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on
|
|
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
|
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /MARIADB/MIN10020/data
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes
|
Max core file size 0 unlimited bytes
|
Max resident set unlimited unlimited bytes
|
Max processes 15711 15711 processes
|
Max open files 1048576 1048576 files
|
Max locked memory 65536 65536 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 15711 15711 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
Core pattern: core
|
Transition |
Time In Source Status |
Execution Times |
Open |
|
In Progress |
|
7d 16h 48m
|
1
|
In Progress |
|
Closed |
|
4d 13m
|
1
|
{"report":{"fcp":1178.7999997138977,"ttfb":413.59999990463257,"pageVisibility":"visible","entityId":94874,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"7b9fa974-e22e-4bc3-aeba-95f08b021896","navigationType":0,"readyForUser":1291,"redirectCount":0,"resourceLoadedEnd":875.6999998092651,"resourceLoadedStart":426.59999990463257,"resourceTiming":[{"duration":84.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":426.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":426.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":510.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":84.5,"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":426.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":426.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":511.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":280.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":427.19999980926514,"connectEnd":427.19999980926514,"connectStart":427.19999980926514,"domainLookupEnd":427.19999980926514,"domainLookupStart":427.19999980926514,"fetchStart":427.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":515.5,"responseEnd":707.4000000953674,"responseStart":535.7999997138977,"secureConnectionStart":427.19999980926514},{"duration":448.2999997138977,"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":427.40000009536743,"connectEnd":427.40000009536743,"connectStart":427.40000009536743,"domainLookupEnd":427.40000009536743,"domainLookupStart":427.40000009536743,"fetchStart":427.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":516.0999999046326,"responseEnd":875.6999998092651,"responseStart":564.7999997138977,"secureConnectionStart":427.40000009536743},{"duration":115,"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":427.59999990463257,"connectEnd":427.59999990463257,"connectStart":427.59999990463257,"domainLookupEnd":427.59999990463257,"domainLookupStart":427.59999990463257,"fetchStart":427.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":520.0999999046326,"responseEnd":542.5999999046326,"responseStart":539.5,"secureConnectionStart":427.59999990463257},{"duration":115.09999990463257,"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":427.69999980926514,"connectEnd":427.69999980926514,"connectStart":427.69999980926514,"domainLookupEnd":427.69999980926514,"domainLookupStart":427.69999980926514,"fetchStart":427.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":520.2999997138977,"responseEnd":542.7999997138977,"responseStart":540,"secureConnectionStart":427.69999980926514},{"duration":114.90000009536743,"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":428,"connectEnd":428,"connectStart":428,"domainLookupEnd":428,"domainLookupStart":428,"fetchStart":428,"redirectEnd":0,"redirectStart":0,"requestStart":520.6999998092651,"responseEnd":542.9000000953674,"responseStart":540.6999998092651,"secureConnectionStart":428},{"duration":90,"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":428.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":428.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":518.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":119.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":428.2999997138977,"connectEnd":428.2999997138977,"connectStart":428.2999997138977,"domainLookupEnd":428.2999997138977,"domainLookupStart":428.2999997138977,"fetchStart":428.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":521.7999997138977,"responseEnd":547.6999998092651,"responseStart":544.2999997138977,"secureConnectionStart":428.2999997138977},{"duration":91.5,"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":428.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":428.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":520,"responseStart":0,"secureConnectionStart":0},{"duration":208.59999990463257,"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":428.59999990463257,"connectEnd":428.59999990463257,"connectStart":428.59999990463257,"domainLookupEnd":428.59999990463257,"domainLookupStart":428.59999990463257,"fetchStart":428.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":579.2999997138977,"responseEnd":637.1999998092651,"responseStart":633.7999997138977,"secureConnectionStart":428.59999990463257},{"duration":442.2999997138977,"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":429.40000009536743,"connectEnd":429.40000009536743,"connectStart":429.40000009536743,"domainLookupEnd":429.40000009536743,"domainLookupStart":429.40000009536743,"fetchStart":429.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":698.2999997138977,"responseEnd":871.6999998092651,"responseStart":868.0999999046326,"secureConnectionStart":429.40000009536743},{"duration":442.69999980926514,"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":429.5,"connectEnd":429.5,"connectStart":429.5,"domainLookupEnd":429.5,"domainLookupStart":429.5,"fetchStart":429.5,"redirectEnd":0,"redirectStart":0,"requestStart":797.1999998092651,"responseEnd":872.1999998092651,"responseStart":870.4000000953674,"secureConnectionStart":429.5},{"duration":131.09999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":846.4000000953674,"connectEnd":846.4000000953674,"connectStart":846.4000000953674,"domainLookupEnd":846.4000000953674,"domainLookupStart":846.4000000953674,"fetchStart":846.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":942.2999997138977,"responseEnd":977.5,"responseStart":977,"secureConnectionStart":846.4000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":239,"responseStart":414,"responseEnd":421,"domLoading":424,"domInteractive":1416,"domContentLoadedEventStart":1416,"domContentLoadedEventEnd":1479,"domComplete":2113,"loadEventStart":2113,"loadEventEnd":2114,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1390.1999998092651},{"name":"bigPipe.sidebar-id.end","time":1391.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":1391.2999997138977},{"name":"bigPipe.activity-panel-pipe-id.end","time":1392.4000000953674},{"name":"activityTabFullyLoaded","time":1493.9000000953674}],"measures":[],"correlationId":"1dc1ca4e4817d5","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":96,"dbReadsTimeInMs":17,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}