-
Bug
-
-
Major
-
Resolution:
Unresolved
-
10.5
-
-
-
Remember to run with all usual S3 options and also with
--mysqld=--aria-encrypt-tables=1 --mysqld=--file-key-management --mysqld=--file-key-management-filename=`pwd`/std_data/keys.txt --mysqld=--plugin-load-add=file_key_management
|
Also remember to clean up the bucket between attempts.
CREATE TABLE t1 (a INT) ENGINE=Aria;
|
INSERT INTO t1 VALUES (1);
|
ALTER TABLE t1 ENGINE=S3;
|
ALTER TABLE t1 ENGINE=Aria;
|
|
# Cleanup
|
DROP TABLE t1;
|
On a non-debug build, the second ALTER causes ER_CRASHED_ON_USAGE:
10.5 46553c25 non-debug
|
mysqltest: At line 4: query 'ALTER TABLE t1 ENGINE=Aria' failed: 1194: Table 't1' is marked as crashed and should be repaired
|
On a debug build, it causes the assertion failure:
10.5 46553c25 debug
|
mysqld: /data/src/10.5/storage/maria/ma_blockrec.c:5468: _ma_scan_block_record: Assertion `!(end_of_data > info->scan.dir_end)' failed.
|
190809 16:05:42 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007ff2fce66f12 in __GI___assert_fail (assertion=0x561b212d3278 "!(end_of_data > info->scan.dir_end)", file=0x561b212d1c80 "/data/src/10.5/storage/maria/ma_blockrec.c", line=5468, function=0x561b212d3c30 <__PRETTY_FUNCTION__.16869> "_ma_scan_block_record") at assert.c:101
|
#8 0x0000561b20d65636 in _ma_scan_block_record (info=0x7ff2d028f7e0, record=0x7ff2d01395b0 "\377", record_pos=0, skip_deleted=1 '\001') at /data/src/10.5/storage/maria/ma_blockrec.c:5468
|
#9 0x0000561b20d5210d in maria_scan (info=0x7ff2d028f7e0, record=0x7ff2d01395b0 "\377") at /data/src/10.5/storage/maria/ma_scan.c:54
|
#10 0x0000561b20cf85ef in ha_maria::rnd_next (this=0x7ff2d0197958, buf=0x7ff2d01395b0 "\377") at /data/src/10.5/storage/maria/ha_maria.cc:2459
|
#11 0x0000561b2062b4a7 in handler::ha_rnd_next (this=0x7ff2d0197958, buf=0x7ff2d01395b0 "\377") at /data/src/10.5/sql/handler.cc:2794
|
#12 0x0000561b207bc4a6 in rr_sequential (info=0x7ff2f0064ce0) at /data/src/10.5/sql/records.cc:477
|
#13 0x0000561b2025ec6d in READ_RECORD::read_record (this=0x7ff2f0064ce0) at /data/src/10.5/sql/records.h:69
|
#14 0x0000561b20400c92 in copy_data_between_tables (thd=0x7ff2d0000b10, from=0x7ff2d00baa00, to=0x7ff2d0293ff0, create=..., ignore=false, order_num=0, order=0x0, copied=0x7ff2f0065708, deleted=0x7ff2f0065710, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x7ff2f0067140) at /data/src/10.5/sql/sql_table.cc:10690
|
#15 0x0000561b203fedc2 in mysql_alter_table (thd=0x7ff2d0000b10, new_db=0x7ff2d00052b8, new_name=0x7ff2d00056c0, create_info=0x7ff2f0067d20, table_list=0x7ff2d0013470, alter_info=0x7ff2f0067c60, order_num=0, order=0x0, ignore=false) at /data/src/10.5/sql/sql_table.cc:10144
|
#16 0x0000561b2049754b in Sql_cmd_alter_table::execute (this=0x7ff2d0013b28, thd=0x7ff2d0000b10) at /data/src/10.5/sql/sql_alter.cc:522
|
#17 0x0000561b20311504 in mysql_execute_command (thd=0x7ff2d0000b10) at /data/src/10.5/sql/sql_parse.cc:6059
|
#18 0x0000561b2031679e in mysql_parse (thd=0x7ff2d0000b10, rawbuf=0x7ff2d0013388 "ALTER TABLE t1 ENGINE=Aria", length=26, parser_state=0x7ff2f0069180, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7868
|
#19 0x0000561b20302b2b in dispatch_command (command=COM_QUERY, thd=0x7ff2d0000b10, packet=0x7ff2d0008321 "ALTER TABLE t1 ENGINE=Aria", packet_length=26, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1827
|
#20 0x0000561b203012e9 in do_command (thd=0x7ff2d0000b10) at /data/src/10.5/sql/sql_parse.cc:1360
|
#21 0x0000561b2048d8eb in do_handle_one_connection (connect=0x561b236f4050, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1413
|
#22 0x0000561b2048d62f in handle_one_connection (arg=0x561b236f4050) at /data/src/10.5/sql/sql_connect.cc:1309
|
#23 0x0000561b208b7c5f in pfs_spawn_thread (arg=0x561b2365e450) at /data/src/10.5/storage/perfschema/pfs.cc:1862
|
#24 0x00007ff2ff0164a4 in start_thread (arg=0x7ff2f006a700) at pthread_create.c:456
|
#25 0x00007ff2fcf23d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
Not reproducible without encryption.
{"report":{"fcp":739.2000000029802,"ttfb":167,"pageVisibility":"visible","entityId":78138,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"f3f41bad-d42c-4560-9448-b4fc1def22f7","navigationType":0,"readyForUser":821.7999999970198,"redirectCount":0,"resourceLoadedEnd":827.2000000029802,"resourceLoadedStart":172.6000000089407,"resourceTiming":[{"duration":6.799999997019768,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":172.6000000089407,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":172.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":179.40000000596046,"responseStart":0,"secureConnectionStart":0},{"duration":6.899999991059303,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":172.90000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":172.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":179.79999999701977,"responseStart":0,"secureConnectionStart":0},{"duration":66.09999999403954,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":173.1000000089407,"connectEnd":173.1000000089407,"connectStart":173.1000000089407,"domainLookupEnd":173.1000000089407,"domainLookupStart":173.1000000089407,"fetchStart":173.1000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":173.1000000089407,"responseEnd":239.20000000298023,"responseStart":239.20000000298023,"secureConnectionStart":173.1000000089407},{"duration":144.70000000298023,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":173.20000000298023,"connectEnd":173.20000000298023,"connectStart":173.20000000298023,"domainLookupEnd":173.20000000298023,"domainLookupStart":173.20000000298023,"fetchStart":173.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":173.20000000298023,"responseEnd":317.90000000596046,"responseStart":317.79999999701977,"secureConnectionStart":173.20000000298023},{"duration":148.59999999403954,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":173.40000000596046,"connectEnd":173.40000000596046,"connectStart":173.40000000596046,"domainLookupEnd":173.40000000596046,"domainLookupStart":173.40000000596046,"fetchStart":173.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":173.40000000596046,"responseEnd":322,"responseStart":322,"secureConnectionStart":173.40000000596046},{"duration":149.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":173.6000000089407,"connectEnd":173.6000000089407,"connectStart":173.6000000089407,"domainLookupEnd":173.6000000089407,"domainLookupStart":173.6000000089407,"fetchStart":173.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":173.6000000089407,"responseEnd":322.79999999701977,"responseStart":322.79999999701977,"secureConnectionStart":173.6000000089407},{"duration":206.79999999701977,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":173.90000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":173.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":380.70000000298023,"responseStart":0,"secureConnectionStart":0},{"duration":149.70000000298023,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":173.90000000596046,"connectEnd":173.90000000596046,"connectStart":173.90000000596046,"domainLookupEnd":173.90000000596046,"domainLookupStart":173.90000000596046,"fetchStart":173.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":173.90000000596046,"responseEnd":323.6000000089407,"responseStart":323.6000000089407,"secureConnectionStart":173.90000000596046},{"duration":150.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":174.1000000089407,"connectEnd":174.1000000089407,"connectStart":174.1000000089407,"domainLookupEnd":174.1000000089407,"domainLookupStart":174.1000000089407,"fetchStart":174.1000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":174.1000000089407,"responseEnd":324.29999999701977,"responseStart":324.29999999701977,"secureConnectionStart":174.1000000089407},{"duration":206.6000000089407,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":174.29999999701977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":174.29999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":380.90000000596046,"responseStart":0,"secureConnectionStart":0},{"duration":150.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":174.5,"connectEnd":174.5,"connectStart":174.5,"domainLookupEnd":174.5,"domainLookupStart":174.5,"fetchStart":174.5,"redirectEnd":0,"redirectStart":0,"requestStart":174.5,"responseEnd":325,"responseStart":325,"secureConnectionStart":174.5},{"duration":289,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":175.29999999701977,"connectEnd":175.29999999701977,"connectStart":175.29999999701977,"domainLookupEnd":175.29999999701977,"domainLookupStart":175.29999999701977,"fetchStart":175.29999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":175.29999999701977,"responseEnd":464.29999999701977,"responseStart":464.29999999701977,"secureConnectionStart":175.29999999701977},{"duration":651.7999999970198,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":175.40000000596046,"connectEnd":175.40000000596046,"connectStart":175.40000000596046,"domainLookupEnd":175.40000000596046,"domainLookupStart":175.40000000596046,"fetchStart":175.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":175.40000000596046,"responseEnd":827.2000000029802,"responseStart":827.2000000029802,"secureConnectionStart":175.40000000596046},{"duration":74.40000000596046,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":392.70000000298023,"connectEnd":392.70000000298023,"connectStart":392.70000000298023,"domainLookupEnd":392.70000000298023,"domainLookupStart":392.70000000298023,"fetchStart":392.70000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":392.70000000298023,"responseEnd":467.1000000089407,"responseStart":467.1000000089407,"secureConnectionStart":392.70000000298023}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":10,"responseStart":167,"responseEnd":170,"domLoading":170,"domInteractive":871,"domContentLoadedEventStart":871,"domContentLoadedEventEnd":909,"domComplete":1717,"loadEventStart":1717,"loadEventEnd":1719,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":860.2000000029802},{"name":"bigPipe.sidebar-id.end","time":860.7999999970198},{"name":"bigPipe.activity-panel-pipe-id.start","time":861},{"name":"bigPipe.activity-panel-pipe-id.end","time":863.2999999970198},{"name":"activityTabFullyLoaded","time":919.9000000059605}],"measures":[],"correlationId":"2a933a31d0a08f","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":88,"dbReadsTimeInMs":9,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}