Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
N/A
The test case is non-deterministic. It fails very quickly for me, usually from the first attempt, but it can vary on different machines and builds, run with --repeat=N if it doesn't fail right away.
I'm not sure the application period is important here, but I couldn't get rid of it.
The failure is rr-able.
Could not reproduce on the baseline.
--source include/have_log_bin.inc
--source include/have_binlog_format_row.inc
CREATE TABLE t (id INT , s DATE , e DATE , PERIOD FOR p(s,e), UNIQUE (id, p WITHOUT OVERLAPS)) ENGINE=Aria;
--connect (con1,localhost,root,,)
--send
ALTER TABLE t FORCE ;
--connection default
INSERT INTO t VALUES (1, '1971-01-01' , '1971-01-02' );
DELETE FROM t;
# Cleanup
--connection con1
--reap
DROP TABLE t;
--disconnect con1
bb-11.0-oalter fd06124e66
#5 0x00007fd459853df2 in __GI___assert_fail (assertion=0x5565e080d0f3 "share->now_transactional",
file=0x5565e0808888 "/src/storage/maria/ma_loghandler.c", line=6435,
function=0x5565e080f8b0 <__PRETTY_FUNCTION__.29> "translog_write_record") at ./assert/assert.c:101
#6 0x00005565df7f122f in translog_write_record (lsn=0x7fd44eff4430, type=LOGREC_INCOMPLETE_LOG, trn=0x5565e202c940 <dummy_transaction_object>,
tbl_info=0x7fd43c2cbca8, rec_len=2, part_no=3, parts_data=0x7fd44eff4460, store_share_id=0x7fd44eff442e "", hook_arg=0x0)
at /src/storage/maria/ma_loghandler.c:6435
#7 0x00005565df82c43b in _ma_tmp_disable_logging_for_table (info=0x7fd43c2cbca8, log_incomplete=1 '\001')
at /src/storage/maria/ma_recovery.c:3615
#8 0x00005565df7c2fd4 in ha_maria::external_lock (this=0x7fd43c0173d8, thd=0x7fd43c000dc8, lock_type=0)
at /src/storage/maria/ha_maria.cc:2958
#9 0x00005565df3f4822 in handler::ha_external_lock (this=0x7fd43c0173d8, thd=0x7fd43c000dc8, lock_type=0) at /src/sql/handler.cc:7324
#10 0x00005565df3da5c8 in handler::create_lookup_handler (this=0x7fd43c2546a0) at /src/sql/handler.cc:3276
#11 0x00005565df3f7e0a in handler::prepare_for_insert (this=0x7fd43c2546a0, do_create=true) at /src/sql/handler.cc:7773
#12 0x00005565df6d89d2 in Rows_log_event::do_apply_event (this=0x7fd43c073df8, rgi=0x7fd44eff5f60) at /src/sql/log_event_server.cc:5004
#13 0x00005565df6b0290 in Log_event::apply_event (this=0x7fd43c073df8, rgi=0x7fd44eff5f60) at /src/sql/log_event.cc:3856
#14 0x00005565deec5b39 in online_alter_read_from_binlog (thd=0x7fd43c000dc8, rgi=0x7fd44eff5f60, log=0x7fd43c25e1b0)
at /src/sql/sql_table.cc:11520
#15 0x00005565deec9430 in copy_data_between_tables (thd=0x7fd43c000dc8, from=0x7fd43c2bfe28, to=0x7fd43c253d98, create=..., ignore=false, order_num=0, order=0x0,
copied=0x7fd44eff9e50, deleted=0x7fd44eff9e58, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x7fd44effb420, online=true)
at /src/sql/sql_table.cc:11958
#16 0x00005565deec2106 in mysql_alter_table (thd=0x7fd43c000dc8, new_db=0x7fd43c005ae0, new_name=0x7fd43c005f28, create_info=0x7fd44effc240,
table_list=0x7fd43c0156c0, recreate_info=0x7fd44effc110, alter_info=0x7fd44effc150, order_num=0, order=0x0, ignore=false, if_exists=false)
at /src/sql/sql_table.cc:10986
#17 0x00005565df01ff0d in Sql_cmd_alter_table::execute (this=0x7fd43c015de0, thd=0x7fd43c000dc8) at /src/sql/sql_alter.cc:563
#18 0x00005565dec97965 in mysql_execute_command (thd=0x7fd43c000dc8, is_called_from_prepared_stmt=false) at /src/sql/sql_parse.cc:6001
#19 0x00005565deca3489 in mysql_parse (thd=0x7fd43c000dc8, rawbuf=0x7fd43c0155f0 "ALTER TABLE t FORCE", length=19, parser_state=0x7fd44effd370)
at /src/sql/sql_parse.cc:8000
#20 0x00005565dec79a3d in dispatch_command (command=COM_QUERY, thd=0x7fd43c000dc8, packet=0x7fd43c12b8e9 "", packet_length=19, blocking=true)
at /src/sql/sql_parse.cc:1894
#21 0x00005565dec76b82 in do_command (thd=0x7fd43c000dc8, blocking=true) at /src/sql/sql_parse.cc:1407
#22 0x00005565df00a395 in do_handle_one_connection (connect=0x5565e39a1c38, put_in_cache=true) at /src/sql/sql_connect.cc:1416
#23 0x00005565df009dc0 in handle_one_connection (arg=0x5565e39b0198) at /src/sql/sql_connect.cc:1318
#24 0x00005565df944af7 in pfs_spawn_thread (arg=0x5565e3962d48) at /src/storage/perfschema/pfs.cc:2201
--Type <RET> for more, q to quit, c to continue without paging--
#25 0x00007fd4598a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#26 0x00007fd4599278d0 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
{"report":{"fcp":1493.1000001430511,"ttfb":329,"pageVisibility":"visible","entityId":120501,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"8e51b6b4-4014-42fa-8fd1-35b2863d8ea7","navigationType":0,"readyForUser":1598.6000001430511,"redirectCount":0,"resourceLoadedEnd":1375.9000000953674,"resourceLoadedStart":337.7999999523163,"resourceTiming":[{"duration":160.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":337.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":337.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":498.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":160.89999985694885,"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":338.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":338.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":499,"responseStart":0,"secureConnectionStart":0},{"duration":543.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":338.2999999523163,"connectEnd":501.5,"connectStart":501.5,"domainLookupEnd":501.5,"domainLookupStart":501.5,"fetchStart":338.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":502.10000014305115,"responseEnd":881.7999999523163,"responseStart":516.7000000476837,"secureConnectionStart":501.5},{"duration":787.7000000476837,"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":338.90000009536743,"connectEnd":338.90000009536743,"connectStart":338.90000009536743,"domainLookupEnd":338.90000009536743,"domainLookupStart":338.90000009536743,"fetchStart":338.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":503.2000000476837,"responseEnd":1126.6000001430511,"responseStart":520.6000001430511,"secureConnectionStart":338.90000009536743},{"duration":184.29999995231628,"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":339.10000014305115,"connectEnd":339.10000014305115,"connectStart":339.10000014305115,"domainLookupEnd":339.10000014305115,"domainLookupStart":339.10000014305115,"fetchStart":339.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":504.2999999523163,"responseEnd":523.4000000953674,"responseStart":519.7999999523163,"secureConnectionStart":339.10000014305115},{"duration":190.29999995231628,"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":339.40000009536743,"connectEnd":339.40000009536743,"connectStart":339.40000009536743,"domainLookupEnd":339.40000009536743,"domainLookupStart":339.40000009536743,"fetchStart":339.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":505.2999999523163,"responseEnd":529.7000000476837,"responseStart":528.7999999523163,"secureConnectionStart":339.40000009536743},{"duration":193.89999985694885,"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":339.60000014305115,"connectEnd":339.60000014305115,"connectStart":339.60000014305115,"domainLookupEnd":339.60000014305115,"domainLookupStart":339.60000014305115,"fetchStart":339.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":511.10000014305115,"responseEnd":533.5,"responseStart":532.2000000476837,"secureConnectionStart":339.60000014305115},{"duration":169.30000019073486,"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":339.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":339.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":509.10000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":209,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":340,"connectEnd":340,"connectStart":340,"domainLookupEnd":340,"domainLookupStart":340,"fetchStart":340,"redirectEnd":0,"redirectStart":0,"requestStart":516.1000001430511,"responseEnd":549,"responseStart":537.9000000953674,"secureConnectionStart":340},{"duration":170.70000004768372,"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":340.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":340.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":510.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":209.09999990463257,"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":340.2000000476837,"connectEnd":340.2000000476837,"connectStart":340.2000000476837,"domainLookupEnd":340.2000000476837,"domainLookupStart":340.2000000476837,"fetchStart":340.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":516.5,"responseEnd":549.2999999523163,"responseStart":538.7000000476837,"secureConnectionStart":340.2000000476837},{"duration":816.0999999046326,"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":350.60000014305115,"connectEnd":350.60000014305115,"connectStart":350.60000014305115,"domainLookupEnd":350.60000014305115,"domainLookupStart":350.60000014305115,"fetchStart":350.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":999.1000001430511,"responseEnd":1166.7000000476837,"responseStart":1161.9000000953674,"secureConnectionStart":350.60000014305115},{"duration":1025.2000000476837,"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":350.7000000476837,"connectEnd":350.7000000476837,"connectStart":350.7000000476837,"domainLookupEnd":350.7000000476837,"domainLookupStart":350.7000000476837,"fetchStart":350.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1364.5,"responseEnd":1375.9000000953674,"responseStart":1375.1000001430511,"secureConnectionStart":350.7000000476837},{"duration":324.2999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1075.1000001430511,"connectEnd":1075.1000001430511,"connectStart":1075.1000001430511,"domainLookupEnd":1075.1000001430511,"domainLookupStart":1075.1000001430511,"fetchStart":1075.1000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":1365.6000001430511,"responseEnd":1399.4000000953674,"responseStart":1398.5,"secureConnectionStart":1075.1000001430511}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":156,"responseStart":329,"responseEnd":350,"domLoading":333,"domInteractive":1700,"domContentLoadedEventStart":1700,"domContentLoadedEventEnd":1746,"domComplete":3187,"loadEventStart":3187,"loadEventEnd":3187,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1665.6000001430511},{"name":"bigPipe.sidebar-id.end","time":1666.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1666.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":1667.4000000953674},{"name":"activityTabFullyLoaded","time":1761.2999999523163}],"measures":[],"correlationId":"13abd2f5653b6c","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":107,"dbReadsTimeInMs":13,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
OK to push after fixing commit comment according last findings