Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
N/A
--source include/have_innodb.inc
--source include/have_debug_sync.inc
CREATE TABLE t (a INT ) ENGINE=InnoDB;
INSERT INTO t VALUES (1);
XA BEGIN 'xid' ;
--send
set debug_sync= 'now wait_for downgraded' ;
--connect (con1,localhost,root,,test)
set debug_sync= 'alter_table_online_downgraded signal downgraded wait_for goforit' ;
--send
ALTER TABLE t FORCE , ALGORITHM=COPY, LOCK=NONE;
--connection default
--reap
INSERT INTO t VALUES (2);
set debug_sync= 'now signal goforit' ;
XA END 'xid' ;
XA ROLLBACK 'xid' ;
# Cleanup
DROP TABLE t;
set debug_sync= reset;
bb-10.10-MDEV-16329 49ad875902
mariadbd: /data/src/preview-10.10-online-alter-gcov/sql/log.cc:2417: int binlog_rollback(handlerton*, THD*, bool): Assertion `thd->lex->sql_command != SQLCOM_XA_ROLLBACK' failed.
220706 0:59:39 [ERROR] mysqld got signal 6 ;
#7 0x00007f835f890662 in __GI___assert_fail (assertion=0x55eae0e2e1e0 "thd->lex->sql_command != SQLCOM_XA_ROLLBACK", file=0x55eae0e2cd80 "/data/src/preview-10.10-online-alter-gcov/sql/log.cc", line=2417, function=0x55eae0e2e160 "int binlog_rollback(handlerton*, THD*, bool)") at assert.c:101
No locals.
#8 0x000055eadfd0082b in binlog_rollback (hton=0x55eae48f4688, thd=0x7f8308000db8, all=true) at /data/src/preview-10.10-online-alter-gcov/sql/log.cc:2417
_db_stack_frame_ = {func = 0x55eae0df8f02 "ha_rollback_trans", file = 0x55eae0df8080 "/data/src/preview-10.10-online-alter-gcov/sql/handler.cc", level = 2147483655, line = -1, prev = 0x7f83485f1b10}
is_ending_trans = true
rollback_online = true
error = 0
cache_mngr = 0x0
__PRETTY_FUNCTION__ = "int binlog_rollback(handlerton*, THD*, bool)"
#9 0x000055eadfa90a6f in ha_rollback_trans (thd=0x7f8308000db8, all=true) at /data/src/preview-10.10-online-alter-gcov/sql/handler.cc:2180
err = 2046882558
ht = 0x55eae48f4688
error = 0
trans = 0x7f8308004770
ha_info = 0x7f83080037e8
ha_info_next = 0x55eae0caff60
is_real_trans = true
_db_stack_frame_ = {func = 0x55eae0cb0408 "trans_xa_rollback", file = 0x55eae0cb0018 "/data/src/preview-10.10-online-alter-gcov/sql/xa.cc", level = 2147483654, line = -1, prev = 0x7f83485f1ba0}
__PRETTY_FUNCTION__ = "int ha_rollback_trans(THD*, bool)"
#10 0x000055eadf900ca3 in xa_trans_force_rollback (thd=0x7f8308000db8) at /data/src/preview-10.10-online-alter-gcov/sql/xa.cc:393
rc = false
#11 0x000055eadf903e6e in trans_xa_rollback (thd=0x7f8308000db8) at /data/src/preview-10.10-online-alter-gcov/sql/xa.cc:821
xid_state = @0x7f83080047a8: {xid_cache_element = 0x7f830819fd78}
_db_stack_frame_ = {func = 0x55eae0c06038 "mysql_execute_command", file = 0x55eae0c052e0 "/data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc", level = 2147483653, line = 821, prev = 0x7f83485f1f30}
__PRETTY_FUNCTION__ = "bool trans_xa_rollback(THD*)"
mdl_request = {type = 13, duration = MDL_STATEMENT, next_in_list = 0x21, prev_in_list = 0x7f835ef0b640, ticket = 0x7f83081824d0, key = {m_length = 3, m_db_name_length = 0, m_hash_value = 65537, m_ptr = "\000\000\000\340\352U\000\000 \034_H\203\177\000\000\024\002\000\000\000\000\000\000!\000\000\000\000\000\000\000\230\063\341\344\352U\000\000\023\000\000\000\366\005\000\000\236\020\242\340\352U\000\000@\034_H\203\177\000\000\275\022\242\340\352U\000\000@\034_H\203\177\000\000\ba\000\b\203\177\000\000\240\035_H\203\177\000\000\231n8\337\352U\000\000\000Q\000\b\203\177\000\000\270\r\000\b\203\177\000\000\220\034_H\203\177\000\000`\v\000\b\203\177\000\000\220\034_H\203\177\000\000\324\262\242\340\352U\000\000h\206\031_\203\177\000\000\300Y{\344\000\000\000\000#0\301\340\352U\000\000\000\000\000\000\000\000\000\000\300\034_H\203\177\000\000\275\022\242\340\000\000\001\000"...}, m_src_file = 0x55eae0cb0018 "/data/src/preview-10.10-online-alter-gcov/sql/xa.cc", m_src_line = 807}
#12 0x000055eadf39b065 in mysql_execute_command (thd=0x7f8308000db8, is_called_from_prepared_stmt=false) at /data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc:5879
rollback_failed = 32
res = 0
up_result = 0
lex = 0x7f8308005100
select_lex = 0x7f83080059d8
first_table = 0x0
all_tables = 0x0
unit = 0x7f83080051d8
have_table_map_for_update = false
rpl_filter = 0x55eae155d270 <vtable for Internal_error_handler+16>
_db_stack_frame_ = {func = 0x55eae0c073cf "mysql_parse", file = 0x55eae0c052e0 "/data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f83485f2380}
__PRETTY_FUNCTION__ = "int mysql_execute_command(THD*, bool)"
ots = {ctx = 0x7f8308004d98, traceable = false}
orig_binlog_format = BINLOG_FORMAT_MIXED
orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
#13 0x000055eadf3a7c10 in mysql_parse (thd=0x7f8308000db8, rawbuf=0x7f8308015460 "XA ROLLBACK 'xid'", length=17, parser_state=0x7f83485f2500) at /data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc:8036
found_semicolon = 0x0
error = 32643
lex = 0x7f8308005100
err = false
_db_stack_frame_ = {func = 0x55eae0c05879 "dispatch_command", file = 0x55eae0c052e0 "/data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f83485f24e0}
__PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)"
#14 0x000055eadf37ef11 in dispatch_command (command=COM_QUERY, thd=0x7f8308000db8, packet=0x7f830800b9e9 "XA ROLLBACK 'xid'", packet_length=17, blocking=true) at /data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc:1894
packet_end = 0x7f8308015471 ""
parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7f8308000db8, m_ptr = 0x7f8308015472 "\004", m_tok_start = 0x7f8308015472 "\004", m_tok_end = 0x7f8308015472 "\004", m_end_of_query = 0x7f8308015471 "", m_tok_start_prev = 0x7f8308015471 "", m_buf = 0x7f8308015460 "XA ROLLBACK 'xid'", m_buf_length = 17, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7f83080154c8 "XA ROLLBACK 'xid'", m_cpp_ptr = 0x7f83080154d9 "", m_cpp_tok_start = 0x7f83080154d9 "", m_cpp_tok_start_prev = 0x7f83080154d9 "", m_cpp_tok_end = 0x7f83080154d9 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x108000cb8 <error: Cannot access memory at address 0x108000cb8>, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 1, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = (unknown: 0x10000), m_cpp_text_start = 0x7f83080154d5 "xid'", m_cpp_text_end = 0x7f83080154d8 "'", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 13 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7f8308004b28}
net = 0x7f83080010f0
error = false
do_end_of_statement = true
_db_stack_frame_ = {func = 0x55eae0c054fd "do_command", file = 0x55eae0c052e0 "/data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f83485f2dc0}
drop_more_results = false
__PRETTY_FUNCTION__ = "dispatch_command_return dispatch_command(enum_server_command, THD*, char*, uint, bool)"
__FUNCTION__ = "dispatch_command"
res = <optimized out>
#15 0x000055eadf37c0ea in do_command (thd=0x7f8308000db8, blocking=true) at /data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc:1407
return_value = DISPATCH_COMMAND_SUCCESS
packet = 0x7f830800b9e8 "\003XA ROLLBACK 'xid'"
packet_length = 18
net = 0x7f83080010f0
command = COM_QUERY
_db_stack_frame_ = {func = 0x55eae107d52b "?func", file = 0x55eae107d531 "?file", level = 2147483649, line = -1, prev = 0x0}
__PRETTY_FUNCTION__ = "dispatch_command_return do_command(THD*, bool)"
__FUNCTION__ = "do_command"
#16 0x000055eadf6e821b in do_handle_one_connection (connect=0x55eae50438b8, put_in_cache=true) at /data/src/preview-10.10-online-alter-gcov/sql/sql_connect.cc:1418
create_user = true
thr_create_utime = 3480491481792
thd = 0x7f8308000db8
__PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*, bool)"
#17 0x000055eadf6e7a22 in handle_one_connection (arg=0x55eae5059308) at /data/src/preview-10.10-online-alter-gcov/sql/sql_connect.cc:1312
connect = 0x55eae5059308
#18 0x000055eadfff6113 in pfs_spawn_thread (arg=0x55eae5043428) at /data/src/preview-10.10-online-alter-gcov/storage/perfschema/pfs.cc:2201
typed_arg = 0x55eae5043428
user_arg = 0x55eae5059308
user_start_routine = 0x55eadf6e796d <handle_one_connection(void*)>
pfs = 0x7f835f196700
klass = 0x55eae47d3580
#19 0x00007f835fd5aea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
ret = <optimized out>
pd = <optimized out>
unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140201831642880, 6759536943321734637, 140736881142638, 140736881142639, 140201831640960, 311296, -6717079575113605651, -6717104954092790291}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
not_first_call = 0
#20 0x00007f835f959def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Same in binlog_commit with COMMIT 'xid' ONE PHASE instead of ROLLBACK .
{"report":{"fcp":1736.3000001907349,"ttfb":632.3000001907349,"pageVisibility":"visible","entityId":112487,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"c634756e-3921-40c9-a738-a95025aad18f","navigationType":0,"readyForUser":1965.4000000953674,"redirectCount":0,"resourceLoadedEnd":2708.100000143051,"resourceLoadedStart":641.3000001907349,"resourceTiming":[{"duration":428.2999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":641.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":641.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1069.6000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":428.2000000476837,"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":641.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":641.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1069.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":511.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":641.9000000953674,"connectEnd":641.9000000953674,"connectStart":641.9000000953674,"domainLookupEnd":641.9000000953674,"domainLookupStart":641.9000000953674,"fetchStart":641.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":641.9000000953674,"responseEnd":1153.7000000476837,"responseStart":1153.7000000476837,"secureConnectionStart":641.9000000953674},{"duration":593.7999999523163,"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":642.1000001430511,"connectEnd":642.1000001430511,"connectStart":642.1000001430511,"domainLookupEnd":642.1000001430511,"domainLookupStart":642.1000001430511,"fetchStart":642.1000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":642.1000001430511,"responseEnd":1235.9000000953674,"responseStart":1235.9000000953674,"secureConnectionStart":642.1000001430511},{"duration":597.8999998569489,"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":642.3000001907349,"connectEnd":642.3000001907349,"connectStart":642.3000001907349,"domainLookupEnd":642.3000001907349,"domainLookupStart":642.3000001907349,"fetchStart":642.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":642.3000001907349,"responseEnd":1240.2000000476837,"responseStart":1240.2000000476837,"secureConnectionStart":642.3000001907349},{"duration":596.7999999523163,"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":644.4000000953674,"connectEnd":644.4000000953674,"connectStart":644.4000000953674,"domainLookupEnd":644.4000000953674,"domainLookupStart":644.4000000953674,"fetchStart":644.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":644.4000000953674,"responseEnd":1241.2000000476837,"responseStart":1241.1000001430511,"secureConnectionStart":644.4000000953674},{"duration":596.5999999046326,"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":645.1000001430511,"connectEnd":645.1000001430511,"connectStart":645.1000001430511,"domainLookupEnd":645.1000001430511,"domainLookupStart":645.1000001430511,"fetchStart":645.1000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":645.1000001430511,"responseEnd":1241.7000000476837,"responseStart":1241.6000001430511,"secureConnectionStart":645.1000001430511},{"duration":668.8999998569489,"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":645.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":645.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1314.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":597.5999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":645.6000001430511,"connectEnd":645.6000001430511,"connectStart":645.6000001430511,"domainLookupEnd":645.6000001430511,"domainLookupStart":645.6000001430511,"fetchStart":645.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":645.6000001430511,"responseEnd":1243.2000000476837,"responseStart":1243.2000000476837,"secureConnectionStart":645.6000001430511},{"duration":668.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":645.9000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":645.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1314.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":597.9000000953674,"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":646,"connectEnd":646,"connectStart":646,"domainLookupEnd":646,"domainLookupStart":646,"fetchStart":646,"redirectEnd":0,"redirectStart":0,"requestStart":646,"responseEnd":1243.9000000953674,"responseStart":1243.9000000953674,"secureConnectionStart":646},{"duration":1683.7000000476837,"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":647.2000000476837,"connectEnd":647.2000000476837,"connectStart":647.2000000476837,"domainLookupEnd":647.2000000476837,"domainLookupStart":647.2000000476837,"fetchStart":647.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":647.2000000476837,"responseEnd":2330.9000000953674,"responseStart":2330.9000000953674,"secureConnectionStart":647.2000000476837},{"duration":2055.9000000953674,"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":652.2000000476837,"connectEnd":652.2000000476837,"connectStart":652.2000000476837,"domainLookupEnd":652.2000000476837,"domainLookupStart":652.2000000476837,"fetchStart":652.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":652.2000000476837,"responseEnd":2708.100000143051,"responseStart":2708.100000143051,"secureConnectionStart":652.2000000476837},{"duration":1000.8000001907349,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1330.5,"connectEnd":1330.5,"connectStart":1330.5,"domainLookupEnd":1330.5,"domainLookupStart":1330.5,"fetchStart":1330.5,"redirectEnd":0,"redirectStart":0,"requestStart":1330.5,"responseEnd":2331.300000190735,"responseStart":2331.300000190735,"secureConnectionStart":1330.5},{"duration":1119.8999998569489,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1724.6000001430511,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1724.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2844.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":424,"responseStart":632,"responseEnd":643,"domLoading":638,"domInteractive":2779,"domContentLoadedEventStart":2779,"domContentLoadedEventEnd":2840,"domComplete":4202,"loadEventStart":4202,"loadEventEnd":4203,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2710.2000000476837},{"name":"bigPipe.sidebar-id.end","time":2711.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":2711.300000190735},{"name":"bigPipe.activity-panel-pipe-id.end","time":2713.100000143051},{"name":"activityTabFullyLoaded","time":2858.600000143051}],"measures":[],"correlationId":"e50d0ca0d01ef7","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":127,"dbReadsTimeInMs":32,"dbConnsTimeInMs":42,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}