Type:
Bug
Priority:
Major
Resolution:
Duplicate
Affects Version/s:
N/A
--source include/have_partition.inc
CREATE OR REPLACE TABLE t1 (i INT ) WITH SYSTEM VERSIONING PARTITION BY system_time LIMIT 10 (PARTITION p1 HISTORY, PARTITION pn CURRENT );
CREATE OR REPLACE VIEW v1 AS SELECT * FROM t1;
INSERT INTO t1 VALUES (1),(2);
DELETE FROM v1;
# Cleanup
DROP VIEW v1;
DROP TABLE t1;
bb-10.3-temporal a3a15126f260e26b715ae9a790135df1822b74d8
mysqld: /data/src/bb-10.3-temporal/sql/ha_partition.h:1489: virtual ha_rows ha_partition::part_records(void*): Assertion `bitmap_is_set(&(m_part_info->read_partitions), part_id)' failed.
171231 18:25:24 [ERROR] mysqld got signal 6 ;
#7 0x00007f3c0bc94ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x000055a05209e870 in ha_partition::part_records (this=0x7f3bf4094048, _part_elem=0x7f3bf406e3a8) at /data/src/bb-10.3-temporal/sql/ha_partition.h:1489
#9 0x000055a051abfdc0 in partition_info::vers_limit_exceed (this=0x7f3bf406e538, part=0x7f3bf406e3a8) at /data/src/bb-10.3-temporal/sql/partition_info.h:471
#10 0x000055a051ab45e1 in vers_get_partition_id (part_info=0x7f3bf406e538, part_id=0x7f3c05f01a9c, func_value=0x7f3c05f01ab0) at /data/src/bb-10.3-temporal/sql/sql_partition.cc:3205
#11 0x000055a051aae35e in get_parts_for_update (old_data=0x7f3bf40948e8 "\361\001", new_data=0x7f3bf40948d0 "\361\001", rec0=0x7f3bf40948d0 "\361\001", part_info=0x7f3bf406e538, old_part_id=0x7f3c05f01aa0, new_part_id=0x7f3c05f01a9c, new_func_value=0x7f3c05f01ab0) at /data/src/bb-10.3-temporal/sql/sql_partition.cc:290
#12 0x000055a05208bbfd in ha_partition::update_row (this=0x7f3bf4094048, old_data=0x7f3bf40948e8 "\361\001", new_data=0x7f3bf40948d0 "\361\001") at /data/src/bb-10.3-temporal/sql/ha_partition.cc:4323
#13 0x000055a0518f91b8 in handler::ha_update_row (this=0x7f3bf4094048, old_data=0x7f3bf40948e8 "\361\001", new_data=0x7f3bf40948d0 "\361\001") at /data/src/bb-10.3-temporal/sql/handler.cc:6238
#14 0x000055a051aa1a8b in TABLE::delete_row (this=0x7f3bf4093400) at /data/src/bb-10.3-temporal/sql/sql_delete.cc:257
#15 0x000055a051a9edf8 in mysql_delete (thd=0x7f3bf4000b00, table_list=0x7f3bf4014d10, conds=0x7f3bf4017858, order_list=0x7f3bf4005260, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.3-temporal/sql/sql_delete.cc:752
#16 0x000055a051609935 in mysql_execute_command (thd=0x7f3bf4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:4905
#17 0x000055a0516133f6 in mysql_parse (thd=0x7f3bf4000b00, rawbuf=0x7f3bf4014c48 "DELETE FROM v1", length=14, parser_state=0x7f3c05f035f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7991
#18 0x000055a051600b97 in dispatch_command (command=COM_QUERY, thd=0x7f3bf4000b00, packet=0x7f3bf411f161 "DELETE FROM v1", packet_length=14, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1825
#19 0x000055a0515ff5cb in do_command (thd=0x7f3bf4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1370
#20 0x000055a051767354 in do_handle_one_connection (connect=0x55a054d482a0) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
#21 0x000055a0517670e1 in handle_one_connection (arg=0x55a054d482a0) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
#22 0x000055a051c01c5a in pfs_spawn_thread (arg=0x55a054d63680) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
#23 0x00007f3c0d96b494 in start_thread (arg=0x7f3c05f04700) at pthread_create.c:333
#24 0x00007f3c0bd5193f in clone () from /lib/x86_64-linux-gnu/libc.so.6
Reproducible with at least InnoDB and MyISAM.
Also reproducible on tempesta-tech/mariadb 6d2583f59553.
{"report":{"fcp":762,"ttfb":180.29999995231628,"pageVisibility":"visible","entityId":65070,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"042baded-7518-44b2-8492-616203654874","navigationType":0,"readyForUser":848.1999999284744,"redirectCount":0,"resourceLoadedEnd":671.6999999284744,"resourceLoadedStart":186.19999992847443,"resourceTiming":[{"duration":25.300000071525574,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":186.19999992847443,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":186.19999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":211.5,"responseStart":0,"secureConnectionStart":0},{"duration":25.09999990463257,"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":186.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":186.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":211.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":87.69999992847443,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":186.5,"connectEnd":186.5,"connectStart":186.5,"domainLookupEnd":186.5,"domainLookupStart":186.5,"fetchStart":186.5,"redirectEnd":0,"redirectStart":0,"requestStart":186.5,"responseEnd":274.1999999284744,"responseStart":274.1999999284744,"secureConnectionStart":186.5},{"duration":203.70000004768372,"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":186.59999990463257,"connectEnd":186.59999990463257,"connectStart":186.59999990463257,"domainLookupEnd":186.59999990463257,"domainLookupStart":186.59999990463257,"fetchStart":186.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":186.59999990463257,"responseEnd":390.2999999523163,"responseStart":390.2999999523163,"secureConnectionStart":186.59999990463257},{"duration":207.60000002384186,"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":186.69999992847443,"connectEnd":186.69999992847443,"connectStart":186.69999992847443,"domainLookupEnd":186.69999992847443,"domainLookupStart":186.69999992847443,"fetchStart":186.69999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":186.69999992847443,"responseEnd":394.2999999523163,"responseStart":394.2999999523163,"secureConnectionStart":186.69999992847443},{"duration":207.79999995231628,"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":186.89999997615814,"connectEnd":186.89999997615814,"connectStart":186.89999997615814,"domainLookupEnd":186.89999997615814,"domainLookupStart":186.89999997615814,"fetchStart":186.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":186.89999997615814,"responseEnd":394.6999999284744,"responseStart":394.6999999284744,"secureConnectionStart":186.89999997615814},{"duration":208.09999990463257,"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":187,"connectEnd":187,"connectStart":187,"domainLookupEnd":187,"domainLookupStart":187,"fetchStart":187,"redirectEnd":0,"redirectStart":0,"requestStart":187,"responseEnd":395.09999990463257,"responseStart":395.09999990463257,"secureConnectionStart":187},{"duration":208.70000004768372,"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":187.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":187.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":395.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":208.80000007152557,"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":187.19999992847443,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":187.19999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":396,"responseStart":0,"secureConnectionStart":0},{"duration":208.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":187.19999992847443,"connectEnd":187.19999992847443,"connectStart":187.19999992847443,"domainLookupEnd":187.19999992847443,"domainLookupStart":187.19999992847443,"fetchStart":187.19999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":187.19999992847443,"responseEnd":395.59999990463257,"responseStart":395.59999990463257,"secureConnectionStart":187.19999992847443},{"duration":208.89999997615814,"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":187.29999995231628,"connectEnd":187.29999995231628,"connectStart":187.29999995231628,"domainLookupEnd":187.29999995231628,"domainLookupStart":187.29999995231628,"fetchStart":187.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":187.29999995231628,"responseEnd":396.1999999284744,"responseStart":396.1999999284744,"secureConnectionStart":187.29999995231628},{"duration":370.2000000476837,"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":195.09999990463257,"connectEnd":195.09999990463257,"connectStart":195.09999990463257,"domainLookupEnd":195.09999990463257,"domainLookupStart":195.09999990463257,"fetchStart":195.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":195.09999990463257,"responseEnd":565.2999999523163,"responseStart":565.2999999523163,"secureConnectionStart":195.09999990463257},{"duration":467.39999997615814,"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":195.19999992847443,"connectEnd":195.19999992847443,"connectStart":195.19999992847443,"domainLookupEnd":195.19999992847443,"domainLookupStart":195.19999992847443,"fetchStart":195.19999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":195.19999992847443,"responseEnd":662.5999999046326,"responseStart":662.5999999046326,"secureConnectionStart":195.19999992847443},{"duration":136.89999997615814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":428.89999997615814,"connectEnd":428.89999997615814,"connectStart":428.89999997615814,"domainLookupEnd":428.89999997615814,"domainLookupStart":428.89999997615814,"fetchStart":428.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":428.89999997615814,"responseEnd":565.7999999523163,"responseStart":565.7999999523163,"secureConnectionStart":428.89999997615814},{"duration":4.699999928474426,"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":663,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":663,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":667.6999999284744,"responseStart":0,"secureConnectionStart":0},{"duration":8.299999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/50bc9be5bfead1a25e72c1a9338c94f6-CDN/lu2bu7/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":663.3999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":663.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":671.6999999284744,"responseStart":0,"secureConnectionStart":0},{"duration":267.7000000476837,"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":664.2999999523163,"connectEnd":664.2999999523163,"connectStart":664.2999999523163,"domainLookupEnd":664.2999999523163,"domainLookupStart":664.2999999523163,"fetchStart":664.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":664.2999999523163,"responseEnd":932,"responseStart":932,"secureConnectionStart":664.2999999523163}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":49,"responseStart":181,"responseEnd":187,"domLoading":184,"domInteractive":905,"domContentLoadedEventStart":905,"domContentLoadedEventEnd":948,"domComplete":1552,"loadEventStart":1552,"loadEventEnd":1554,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":885},{"name":"bigPipe.sidebar-id.end","time":885.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":885.8999999761581},{"name":"bigPipe.activity-panel-pipe-id.end","time":888.6999999284744},{"name":"activityTabFullyLoaded","time":956.3999999761581}],"measures":[],"correlationId":"3c00179d98b8d4","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":74,"dbReadsTimeInMs":13,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}