Type:
Bug
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
10.5 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL)
--source include/have_innodb.inc
CREATE TABLE t (f INT , s BIGINT UNSIGNED GENERATED ALWAYS AS ROW START, e BIGINT UNSIGNED GENERATED ALWAYS AS ROW END , PERIOD FOR SYSTEM_TIME (s,e)) WITH SYSTEM VERSIONING ENGINE=InnoDB;
INSERT INTO t (f) VALUES (1);
DELETE HISTORY FROM t BEFORE SYSTEM_TIME 101;
# Cleanup
DROP TABLE t;
10.5 2154a1fc
mariadbd: /data/src/10.5/sql/sql_type.h:2305: bool Datetime::is_valid_datetime_slow() const: Assertion `time_type == MYSQL_TIMESTAMP_DATETIME' failed.
221006 19:06:27 [ERROR] mysqld got signal 6 ;
#7 0x00007f717bdc5662 in __GI___assert_fail (assertion=0x563adbc55a80 "time_type == MYSQL_TIMESTAMP_DATETIME", file=0x563adbc55860 "/data/src/10.5/sql/sql_type.h", line=2305, function=0x563adbc55ae0 "bool Datetime::is_valid_datetime_slow() const") at assert.c:101
#8 0x0000563ad9ade865 in Datetime::is_valid_datetime_slow (this=0x7f716733cdc0) at /data/src/10.5/sql/sql_type.h:2305
#9 0x0000563ad9f2b9de in Datetime::Datetime (this=0x7f716733cdc0, from=0x7f716733d8b0) at /data/src/10.5/sql/sql_type.h:2457
#10 0x0000563ada118a89 in TR_table::query (this=0x7f716733d090, commit_time=..., backwards=true) at /data/src/10.5/sql/table.cc:9881
#11 0x0000563ada3b4b55 in Item_func_trt_id::get_by_commit_ts (this=0x62b000085fd0, commit_ts=..., backwards=true) at /data/src/10.5/sql/item_vers.cc:136
#12 0x0000563ada3b551b in Item_func_trt_id::val_int (this=0x62b000085fd0) at /data/src/10.5/sql/item_vers.cc:170
#13 0x0000563ad9b645ac in Item::val_uint (this=0x62b000085fd0) at /data/src/10.5/sql/item.h:1294
#14 0x0000563ada3b5b7a in Item_func_trt_trx_sees::val_int (this=0x62b000086180) at /data/src/10.5/sql/item_vers.cc:189
#15 0x0000563ada3490e6 in Type_handler_int_result::Item_val_bool (this=0x563ade042560 <type_handler_bool>, item=0x62b000086180) at /data/src/10.5/sql/sql_type.cc:5082
#16 0x0000563ad9ae0334 in Item::val_bool (this=0x62b000086180) at /data/src/10.5/sql/item.h:1489
#17 0x0000563ada683960 in Item_cond_and::val_int (this=0x62b000086260) at /data/src/10.5/sql/item_cmpfunc.cc:5446
#18 0x0000563ada0b64eb in SQL_SELECT::skip_record (this=0x62b0000863d0, thd=0x62b00007e218) at /data/src/10.5/sql/opt_range.h:1728
#19 0x0000563adaa27e62 in record_should_be_deleted (thd=0x62b00007e218, table=0x6190000df298, sel=0x62b0000863d0, explain=0x62b0000865a8, truncate_history=true) at /data/src/10.5/sql/sql_delete.cc:220
#20 0x0000563adaa2cfaa in mysql_delete (thd=0x62b00007e218, table_list=0x62b000085368, conds=0x62b000086260, order_list=0x62b000082ea0, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.5/sql/sql_delete.cc:788
#21 0x0000563ad9da660d in mysql_execute_command (thd=0x62b00007e218) at /data/src/10.5/sql/sql_parse.cc:4867
#22 0x0000563ad9dbc202 in mysql_parse (thd=0x62b00007e218, rawbuf=0x62b000085238 "DELETE HISTORY FROM t BEFORE SYSTEM_TIME 101", length=44, parser_state=0x7f716733fc30, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:8087
#23 0x0000563ad9d928cc in dispatch_command (command=COM_QUERY, thd=0x62b00007e218, packet=0x62900028a219 "DELETE HISTORY FROM t BEFORE SYSTEM_TIME 101", packet_length=44, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1891
#24 0x0000563ad9d8f2e9 in do_command (thd=0x62b00007e218) at /data/src/10.5/sql/sql_parse.cc:1375
#25 0x0000563ada1ca6c1 in do_handle_one_connection (connect=0x608000003238, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1416
#26 0x0000563ada1ca05e in handle_one_connection (arg=0x6080000031b8) at /data/src/10.5/sql/sql_connect.cc:1318
#27 0x0000563adadeef22 in pfs_spawn_thread (arg=0x61500000c898) at /data/src/10.5/storage/perfschema/pfs.cc:2201
#28 0x00007f717c2a3ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
#29 0x00007f717be90aef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Reproducible on 10.5+, including older minor releases.
No obvious immediate failure on a non-debug build.
The failure appeared in 10.5 after this merge:
commit 97a4a3872e5037b8db1e8c27152740190330ab9c (HEAD)
Merge: 8f8f2aea938 1e08e08ccb8
Author: Marko Mäkelä
Date: Wed Aug 26 12:02:07 2020 +0300
Merge 10.4 into 10.5
Since it's not reproducible on 10.4, I can't point at the exact commit. However, there was a fix of the same assertion failure on a different scenario in that merge (MDEV-23562 ), so I suppose it may be related.
Same assertion fails with SELECT ... AS OF
--source include/have_innodb.inc
CREATE TABLE t (f INT , s BIGINT UNSIGNED GENERATED ALWAYS AS ROW START, e BIGINT UNSIGNED GENERATED ALWAYS AS ROW END , PERIOD FOR SYSTEM_TIME (s,e)) WITH SYSTEM VERSIONING ENGINE=InnoDB;
INSERT INTO t (f) VALUES (1);
SELECT * FROM t FOR SYSTEM_TIME AS OF 101;
# Cleanup
DROP TABLE t;
10.4 produces ER_VERS_NO_TRX_ID instead.
There are no comments yet on this issue.
{"report":{"fcp":637.1000001430511,"ttfb":156,"pageVisibility":"visible","entityId":115290,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"4e53efce-10da-49d9-b5a6-a50e7a2e09a1","navigationType":0,"readyForUser":768.2000000476837,"redirectCount":0,"resourceLoadedEnd":818.7999999523163,"resourceLoadedStart":161.79999995231628,"resourceTiming":[{"duration":6.300000190734863,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":161.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":161.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":168.10000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":6.400000095367432,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":162,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":162,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":168.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":64.60000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":162,"connectEnd":162,"connectStart":162,"domainLookupEnd":162,"domainLookupStart":162,"fetchStart":162,"redirectEnd":0,"redirectStart":0,"requestStart":162,"responseEnd":226.60000014305115,"responseStart":226.60000014305115,"secureConnectionStart":162},{"duration":138.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":162.20000004768372,"connectEnd":162.20000004768372,"connectStart":162.20000004768372,"domainLookupEnd":162.20000004768372,"domainLookupStart":162.20000004768372,"fetchStart":162.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":162.20000004768372,"responseEnd":301.10000014305115,"responseStart":301.10000014305115,"secureConnectionStart":162.20000004768372},{"duration":142.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":162.29999995231628,"connectEnd":162.29999995231628,"connectStart":162.29999995231628,"domainLookupEnd":162.29999995231628,"domainLookupStart":162.29999995231628,"fetchStart":162.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":162.29999995231628,"responseEnd":304.7999999523163,"responseStart":304.7999999523163,"secureConnectionStart":162.29999995231628},{"duration":143,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":162.29999995231628,"connectEnd":162.29999995231628,"connectStart":162.29999995231628,"domainLookupEnd":162.29999995231628,"domainLookupStart":162.29999995231628,"fetchStart":162.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":162.29999995231628,"responseEnd":305.2999999523163,"responseStart":305.2999999523163,"secureConnectionStart":162.29999995231628},{"duration":143.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":162.40000009536743,"connectEnd":162.40000009536743,"connectStart":162.40000009536743,"domainLookupEnd":162.40000009536743,"domainLookupStart":162.40000009536743,"fetchStart":162.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":162.40000009536743,"responseEnd":305.90000009536743,"responseStart":305.90000009536743,"secureConnectionStart":162.40000009536743},{"duration":143.79999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":162.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":162.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":306.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":143.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":162.60000014305115,"connectEnd":162.60000014305115,"connectStart":162.60000014305115,"domainLookupEnd":162.60000014305115,"domainLookupStart":162.60000014305115,"fetchStart":162.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":162.60000014305115,"responseEnd":306.2999999523163,"responseStart":306.2999999523163,"secureConnectionStart":162.60000014305115},{"duration":144,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":162.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":162.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":306.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":143.89999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":162.90000009536743,"connectEnd":162.90000009536743,"connectStart":162.90000009536743,"domainLookupEnd":162.90000009536743,"domainLookupStart":162.90000009536743,"fetchStart":162.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":162.90000009536743,"responseEnd":306.7999999523163,"responseStart":306.7999999523163,"secureConnectionStart":162.90000009536743},{"duration":435,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":163.60000014305115,"connectEnd":163.60000014305115,"connectStart":163.60000014305115,"domainLookupEnd":163.60000014305115,"domainLookupStart":163.60000014305115,"fetchStart":163.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":163.60000014305115,"responseEnd":598.6000001430511,"responseStart":598.6000001430511,"secureConnectionStart":163.60000014305115},{"duration":447.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":163.79999995231628,"connectEnd":163.79999995231628,"connectStart":163.79999995231628,"domainLookupEnd":163.79999995231628,"domainLookupStart":163.79999995231628,"fetchStart":163.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":163.79999995231628,"responseEnd":611.6000001430511,"responseStart":611.6000001430511,"secureConnectionStart":163.79999995231628},{"duration":165.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":440.7000000476837,"connectEnd":440.7000000476837,"connectStart":440.7000000476837,"domainLookupEnd":440.7000000476837,"domainLookupStart":440.7000000476837,"fetchStart":440.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":440.7000000476837,"responseEnd":606.1000001430511,"responseStart":606,"secureConnectionStart":440.7000000476837},{"duration":4.300000190734863,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":614.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":614.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":619.1000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":125.29999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/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":688.9000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":688.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":814.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":124.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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":689.7999999523163,"connectEnd":689.7999999523163,"connectStart":689.7999999523163,"domainLookupEnd":689.7999999523163,"domainLookupStart":689.7999999523163,"fetchStart":689.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":689.7999999523163,"responseEnd":814.7000000476837,"responseStart":814.7000000476837,"secureConnectionStart":689.7999999523163},{"duration":128.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/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":690.1000001430511,"connectEnd":690.1000001430511,"connectStart":690.1000001430511,"domainLookupEnd":690.1000001430511,"domainLookupStart":690.1000001430511,"fetchStart":690.1000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":690.1000001430511,"responseEnd":818.7999999523163,"responseStart":818.7999999523163,"secureConnectionStart":690.1000001430511}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":24,"responseStart":156,"responseEnd":157,"domLoading":159,"domInteractive":830,"domContentLoadedEventStart":830,"domContentLoadedEventEnd":870,"domComplete":1042,"loadEventStart":1042,"loadEventEnd":1043,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":808.4000000953674},{"name":"bigPipe.sidebar-id.end","time":809.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":809.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":809.7999999523163},{"name":"activityTabFullyLoaded","time":878.7999999523163}],"measures":[],"correlationId":"d1b6dc3239e8b3","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":74,"dbReadsTimeInMs":15,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}