On a server started with encrypt-tmp-files=ON and binlog-format=row
ROLLBACK TO sp
causes server to crash in the follow-up COMMIT
CREATE TABLE t (a TEXT) ENGINE = InnoDB;
|
BEGIN;
|
INSERT INTO t VALUES (REPEAT('a', 20000));
|
SAVEPOINT sp;
|
INSERT INTO t VALUES (REPEAT('a', 20000));
|
ROLLBACK TO sp;
|
COMMIT;
|
#0 0x00007ffff63011f7 in raise () from /lib64/libc.so.6
|
#1 0x00007ffff63028e8 in abort () from /lib64/libc.so.6
|
#2 0x00007ffff62fa266 in __assert_fail_base () from /lib64/libc.so.6
|
#3 0x00007ffff62fa312 in __assert_fail () from /lib64/libc.so.6
|
#4 0x0000555555dce308 in MYSQL_BIN_LOG::write_cache (this=this@entry=0x555556edc200 <mysql_bin_log>, thd=<optimized out>, cache=cache@entry=0x7fff9402ffc8) at /mnt/hgfs/repos/mariadb-server/sql/log.cc:7051
|
#5 0x0000555555dcea9e in MYSQL_BIN_LOG::write_transaction_or_stmt (this=this@entry=0x555556edc200 <mysql_bin_log>, entry=entry@entry=0x7fffec271110, commit_id=commit_id@entry=0) at /mnt/hgfs/repos/mariadb-server/sql/log.cc:8059
|
#6 0x0000555555dd6c60 in MYSQL_BIN_LOG::trx_group_commit_leader (this=this@entry=0x555556edc200 <mysql_bin_log>, leader=leader@entry=0x7fffec271110) at /mnt/hgfs/repos/mariadb-server/sql/log.cc:7796
|
#7 0x0000555555dd7469 in MYSQL_BIN_LOG::write_transaction_to_binlog_events (this=this@entry=0x555556edc200 <mysql_bin_log>, entry=entry@entry=0x7fffec271110) at /mnt/hgfs/repos/mariadb-server/sql/log.cc:7593
|
#8 0x0000555555dd79f2 in MYSQL_BIN_LOG::write_transaction_to_binlog (this=this@entry=0x555556edc200 <mysql_bin_log>, thd=thd@entry=0x7fff94000b00, cache_mngr=cache_mngr@entry=0x7fff9402fe20, end_ev=end_ev@entry=0x7fffec2712a0, all=all@entry=true, using_stmt_cache=using_stmt_cache@entry=true, using_trx_cache=using_trx_cache@entry=true) at /mnt/hgfs/repos/mariadb-server/sql/log.cc:7267
|
#9 0x0000555555dd7ba2 in binlog_flush_cache (thd=thd@entry=0x7fff94000b00, cache_mngr=cache_mngr@entry=0x7fff9402fe20, end_ev=end_ev@entry=0x7fffec2712a0, all=all@entry=true, using_stmt=using_stmt@entry=true, using_trx=using_trx@entry=true) at /mnt/hgfs/repos/mariadb-server/sql/log.cc:1785
|
#10 0x0000555555dd7dc8 in binlog_commit_flush_xid_caches (thd=thd@entry=0x7fff94000b00, cache_mngr=cache_mngr@entry=0x7fff9402fe20, all=all@entry=true, xid=xid@entry=9) at /mnt/hgfs/repos/mariadb-server/sql/log.cc:1891
|
#11 0x0000555555dd7fde in MYSQL_BIN_LOG::log_and_order (this=<optimized out>, thd=0x7fff94000b00, xid=9, all=<optimized out>, need_prepare_ordered=<optimized out>, need_commit_ordered=<optimized out>) at /mnt/hgfs/repos/mariadb-server/sql/log.cc:9530
|
#12 0x0000555555cd3d59 in ha_commit_trans (thd=thd@entry=0x7fff94000b00, all=all@entry=true) at /mnt/hgfs/repos/mariadb-server/sql/handler.cc:1465
|
#13 0x0000555555bc4dd7 in trans_commit (thd=thd@entry=0x7fff94000b00) at /mnt/hgfs/repos/mariadb-server/sql/transaction.cc:306
|
#14 0x0000555555ac745b in mysql_execute_command (thd=thd@entry=0x7fff94000b00) at /mnt/hgfs/repos/mariadb-server/sql/sql_parse.cc:5756
|
#15 0x0000555555aca3bd in mysql_parse (thd=thd@entry=0x7fff94000b00, rawbuf=<optimized out>, length=6, parser_state=parser_state@entry=0x7fffec273510, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /mnt/hgfs/repos/mariadb-server/sql/sql_parse.cc:7966
|
#16 0x0000555555acc20f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fff94000b00, packet=packet@entry=0x7fff9400b161 "COMMIT", packet_length=packet_length@entry=6, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /mnt/hgfs/repos/mariadb-server/sql/sql_parse.cc:1824
|
#17 0x0000555555ace3d6 in do_command (thd=0x7fff94000b00) at /mnt/hgfs/repos/mariadb-server/sql/sql_parse.cc:1369
|
#18 0x0000555555bb7828 in do_handle_one_connection (connect=connect@entry=0x555557ec5390) at /mnt/hgfs/repos/mariadb-server/sql/sql_connect.cc:1420
|
#19 0x0000555555bb7955 in handle_one_connection (arg=arg@entry=0x555557ec5390) at /mnt/hgfs/repos/mariadb-server/sql/sql_connect.cc:1326
|
#20 0x000055555636dd8a in pfs_spawn_thread (arg=0x555557ecdb90) at /mnt/hgfs/repos/mariadb-server/storage/perfschema/pfs.cc:1863
|
#21 0x00007ffff7bc6e25 in start_thread () from /lib64/libpthread.so.0
|
#22 0x00007ffff63c434d in clone () from /lib64/libc.so.6
|
Steps to reproduce:
- put the attached files `a000.test` and `a000-master.opt` into `encryption` MTR test suite (`mysql-test/suite/encryption/t`)
- run `./mysql-test/mtr --debug-server encryption.a000`
- is blocked by
-
MDEV-10259
mysqld crash with certain statement length and order with Galera and encrypt-tmp-files=1
-
-
Closed
{"report":{"fcp":1613.699999988079,"ttfb":569.2999999523163,"pageVisibility":"visible","entityId":65122,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"6f8e3693-cfef-45ba-a931-eac32687b9a9","navigationType":0,"readyForUser":1721.199999988079,"redirectCount":0,"resourceLoadedEnd":1894.3999999761581,"resourceLoadedStart":576.8999999761581,"resourceTiming":[{"duration":455.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":576.8999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":576.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1032.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":455.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":577.1999999880791,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":577.1999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1032.699999988079,"responseStart":0,"secureConnectionStart":0},{"duration":516.3000000119209,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":577.3999999761581,"connectEnd":577.3999999761581,"connectStart":577.3999999761581,"domainLookupEnd":577.3999999761581,"domainLookupStart":577.3999999761581,"fetchStart":577.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":577.3999999761581,"responseEnd":1093.699999988079,"responseStart":1093.699999988079,"secureConnectionStart":577.3999999761581},{"duration":608.3999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":577.6999999880791,"connectEnd":577.6999999880791,"connectStart":577.6999999880791,"domainLookupEnd":577.6999999880791,"domainLookupStart":577.6999999880791,"fetchStart":577.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":577.6999999880791,"responseEnd":1186.0999999642372,"responseStart":1186.0999999642372,"secureConnectionStart":577.6999999880791},{"duration":612.6999999880791,"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":577.8999999761581,"connectEnd":577.8999999761581,"connectStart":577.8999999761581,"domainLookupEnd":577.8999999761581,"domainLookupStart":577.8999999761581,"fetchStart":577.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":577.8999999761581,"responseEnd":1190.5999999642372,"responseStart":1190.5999999642372,"secureConnectionStart":577.8999999761581},{"duration":613.9000000357628,"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":578.0999999642372,"connectEnd":578.0999999642372,"connectStart":578.0999999642372,"domainLookupEnd":578.0999999642372,"domainLookupStart":578.0999999642372,"fetchStart":578.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":578.0999999642372,"responseEnd":1192,"responseStart":1192,"secureConnectionStart":578.0999999642372},{"duration":614.8000000119209,"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":578.2999999523163,"connectEnd":578.2999999523163,"connectStart":578.2999999523163,"domainLookupEnd":578.2999999523163,"domainLookupStart":578.2999999523163,"fetchStart":578.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":578.2999999523163,"responseEnd":1193.0999999642372,"responseStart":1193.0999999642372,"secureConnectionStart":578.2999999523163},{"duration":697.0999999642372,"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":578.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":578.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1275.5999999642372,"responseStart":0,"secureConnectionStart":0},{"duration":616,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":578.5999999642372,"connectEnd":578.5999999642372,"connectStart":578.5999999642372,"domainLookupEnd":578.5999999642372,"domainLookupStart":578.5999999642372,"fetchStart":578.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":578.5999999642372,"responseEnd":1194.5999999642372,"responseStart":1194.5999999642372,"secureConnectionStart":578.5999999642372},{"duration":696.9000000357628,"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":578.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":578.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1275.699999988079,"responseStart":0,"secureConnectionStart":0},{"duration":617.2999999523163,"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":579,"connectEnd":579,"connectStart":579,"domainLookupEnd":579,"domainLookupStart":579,"fetchStart":579,"redirectEnd":0,"redirectStart":0,"requestStart":579,"responseEnd":1196.2999999523163,"responseStart":1196.2999999523163,"secureConnectionStart":579},{"duration":927.9000000357628,"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":588.7999999523163,"connectEnd":588.7999999523163,"connectStart":588.7999999523163,"domainLookupEnd":588.7999999523163,"domainLookupStart":588.7999999523163,"fetchStart":588.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":588.7999999523163,"responseEnd":1516.699999988079,"responseStart":1516.699999988079,"secureConnectionStart":588.7999999523163},{"duration":1270.1000000238419,"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":598.0999999642372,"connectEnd":598.0999999642372,"connectStart":598.0999999642372,"domainLookupEnd":598.0999999642372,"domainLookupStart":598.0999999642372,"fetchStart":598.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":598.0999999642372,"responseEnd":1868.199999988079,"responseStart":1868.199999988079,"secureConnectionStart":598.0999999642372},{"duration":249.60000002384186,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1302.2999999523163,"connectEnd":1302.2999999523163,"connectStart":1302.2999999523163,"domainLookupEnd":1302.2999999523163,"domainLookupStart":1302.2999999523163,"fetchStart":1302.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":1302.2999999523163,"responseEnd":1551.8999999761581,"responseStart":1551.8999999761581,"secureConnectionStart":1302.2999999523163},{"duration":307.0999999642372,"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","startTime":1562,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1562,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1869.0999999642372,"responseStart":0,"secureConnectionStart":0},{"duration":308.69999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/50bc9be5bfead1a25e72c1a9338c94f6-CDN/lu2cib/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/css/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1562.699999988079,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1562.699999988079,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1871.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":322.60000002384186,"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","startTime":1563.5999999642372,"connectEnd":1563.5999999642372,"connectStart":1563.5999999642372,"domainLookupEnd":1563.5999999642372,"domainLookupStart":1563.5999999642372,"fetchStart":1563.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":1563.5999999642372,"responseEnd":1886.199999988079,"responseStart":1886.199999988079,"secureConnectionStart":1563.5999999642372},{"duration":328.69999998807907,"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","startTime":1564.0999999642372,"connectEnd":1564.0999999642372,"connectStart":1564.0999999642372,"domainLookupEnd":1564.0999999642372,"domainLookupStart":1564.0999999642372,"fetchStart":1564.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":1564.0999999642372,"responseEnd":1892.7999999523163,"responseStart":1892.7999999523163,"secureConnectionStart":1564.0999999642372},{"duration":329.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/e0bf5781d46ea69fb123572974cf39de-CDN/lu2cib/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/js/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":1564.5,"connectEnd":1564.5,"connectStart":1564.5,"domainLookupEnd":1564.5,"domainLookupStart":1564.5,"fetchStart":1564.5,"redirectEnd":0,"redirectStart":0,"requestStart":1564.5,"responseEnd":1894.3999999761581,"responseStart":1894.3999999761581,"secureConnectionStart":1564.5}],"fetchStart":0,"domainLookupStart":368,"domainLookupEnd":375,"connectStart":375,"connectEnd":394,"secureConnectionStart":383,"requestStart":395,"responseStart":569,"responseEnd":597,"domLoading":572,"domInteractive":1906,"domContentLoadedEventStart":1906,"domContentLoadedEventEnd":1967,"domComplete":2663,"loadEventStart":2663,"loadEventEnd":2664,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1875.7999999523163},{"name":"bigPipe.sidebar-id.end","time":1876.5999999642372},{"name":"bigPipe.activity-panel-pipe-id.start","time":1876.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":1879.5999999642372},{"name":"activityTabFullyLoaded","time":1986.2999999523163}],"measures":[],"correlationId":"2a520465920cd3","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":107,"dbReadsTimeInMs":12,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Thanks for the report and test case.
The assertion failure is reproducible on 10.3 as initially reported, and also 10.2 debug servers.
Release servers and 10.1 instead produce an error, which probably shouldn't happen either: