--source include/have_innodb.inc
CREATE TABLE t1 (
a INT ,
va INT AS (a) VIRTUAL,
b INT ,
vb INT AS (b) VIRTUAL,
c INT ,
vc INT AS (c) VIRTUAL,
d INT ,
e INT ,
INDEX (va)
) ENGINE=InnoDB WITH SYSTEM VERSIONING;
REPLACE INTO t1 () VALUES (),();
SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t1 DROP e;
ALTER TABLE t1 ALGORITHM=INPLACE, DROP SYSTEM VERSIONING;
# Cleanup
DROP TABLE t1;
10.4 fe4a4bb0
mysqld: /data/src/10.4/storage/innobase/dict/dict0mem.cc:1280: bool dict_index_t::vers_history_row(const rec_t*, const ulint*): Assertion `col.vers_sys_end()' failed.
190910 13:41:11 [ERROR] mysqld got signal 6 ;
#7 0x00007f83bca0ff12 in __GI___assert_fail (assertion=0x564ea66151a5 "col.vers_sys_end()", file=0x564ea6614ca0 "/data/src/10.4/storage/innobase/dict/dict0mem.cc", line=1280, function=0x564ea66167e0 <dict_index_t::vers_history_row(unsigned char const*, unsigned long const*)::__PRETTY_FUNCTION__> "bool dict_index_t::vers_history_row(const rec_t*, const ulint*)") at assert.c:101
#8 0x0000564ea5f33408 in dict_index_t::vers_history_row (this=0x7f836c0816c8, rec=0x7f83b65bc07e "", offsets=0x7f836c3b1e38) at /data/src/10.4/storage/innobase/dict/dict0mem.cc:1280
#9 0x0000564ea5d2c597 in row_merge_read_clustered_index (trx=0x7f83b6879140, table=0x7f83b5ddc830, old_table=0x7f836c07df68, new_table=0x7f836c070748, online=false, index=0x7f836c15d7a8, fts_sort_idx=0x0, psort_info=0x0, files=0x7f836c191720, key_numbers=0x7f836c15d7b8, n_index=2, defaults=0x0, add_v=0x0, col_map=0x7f836c15d840, add_autoinc=18446744073709551615, sequence=..., block=0x7f83ac4f9000 <error: Cannot access memory at address 0x7f83ac4f9000>, skip_pk_sort=true, tmpfd=0x7f83b5ddb970, stage=0x7f836c0e8fe0, pct_cost=33.333333333333336, crypt_block=0x0, eval_table=0x7f83b5ddc830, allow_not_null=false) at /data/src/10.4/storage/innobase/row/row0merge.cc:2308
#10 0x0000564ea5d34583 in row_merge_build_indexes (trx=0x7f83b6879140, old_table=0x7f836c07df68, new_table=0x7f836c070748, online=false, indexes=0x7f836c15d7a8, key_numbers=0x7f836c15d7b8, n_indexes=2, table=0x7f83b5ddc830, defaults=0x0, col_map=0x7f836c15d840, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=true, stage=0x7f836c0e8fe0, add_v=0x0, eval_table=0x7f83b5ddc830, allow_not_null=false) at /data/src/10.4/storage/innobase/row/row0merge.cc:4718
#11 0x0000564ea5bdcdbe in ha_innobase::inplace_alter_table (this=0x7f836c1a1f68, altered_table=0x7f83b5ddc830, ha_alter_info=0x7f83b5ddc7a0) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:8381
#12 0x0000564ea56d32ed in handler::ha_inplace_alter_table (this=0x7f836c1a1f68, altered_table=0x7f83b5ddc830, ha_alter_info=0x7f83b5ddc7a0) at /data/src/10.4/sql/handler.h:4324
#13 0x0000564ea56c7496 in mysql_inplace_alter_table (thd=0x7f836c000b00, table_list=0x7f836c013238, table=0x7f836c1a1100, altered_table=0x7f83b5ddc830, ha_alter_info=0x7f83b5ddc7a0, inplace_supported=HA_ALTER_INPLACE_COPY_LOCK, target_mdl_request=0x7f83b5ddd600, alter_ctx=0x7f83b5dde130) at /data/src/10.4/sql/sql_table.cc:7715
#14 0x0000564ea56ce2af in mysql_alter_table (thd=0x7f836c000b00, new_db=0x7f836c0052b8, new_name=0x7f836c0056c0, create_info=0x7f83b5dded10, table_list=0x7f836c013238, alter_info=0x7f83b5ddec50, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:10092
#15 0x0000564ea5766683 in Sql_cmd_alter_table::execute (this=0x7f836c0138f8, thd=0x7f836c000b00) at /data/src/10.4/sql/sql_alter.cc:508
#16 0x0000564ea55e4369 in mysql_execute_command (thd=0x7f836c000b00) at /data/src/10.4/sql/sql_parse.cc:6099
#17 0x0000564ea55e9ab2 in mysql_parse (thd=0x7f836c000b00, rawbuf=0x7f836c013118 "ALTER TABLE t1 ALGORITHM=INPLACE, DROP SYSTEM VERSIONING", length=56, parser_state=0x7f83b5de0170, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7909
#18 0x0000564ea55d4ab2 in dispatch_command (command=COM_QUERY, thd=0x7f836c000b00, packet=0x7f836c1379d1 "ALTER TABLE t1 ALGORITHM=INPLACE, DROP SYSTEM VERSIONING", packet_length=56, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1843
#19 0x0000564ea55d30fc in do_command (thd=0x7f836c000b00) at /data/src/10.4/sql/sql_parse.cc:1360
#20 0x0000564ea575ce45 in do_handle_one_connection (connect=0x564ea98e7960) at /data/src/10.4/sql/sql_connect.cc:1412
#21 0x0000564ea575cb94 in handle_one_connection (arg=0x564ea98e7960) at /data/src/10.4/sql/sql_connect.cc:1316
#22 0x0000564ea6194173 in pfs_spawn_thread (arg=0x564ea98662d0) at /data/src/10.4/storage/perfschema/pfs.cc:1862
#23 0x00007f83be5844a4 in start_thread (arg=0x7f83b5de1700) at pthread_create.c:456
#24 0x00007f83bcaccd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
Not reproducible on 10.3.
No obvious effect on a non-debug build.
Aleksey Midenkov
made changes -
2020-03-12 17:52
Field
Original Value
New Value
Component/s
Storage Engine - InnoDB
[ 10129
]
Sergei Golubchik
made changes -
2021-12-06 21:34
Workflow
MariaDB v3
[ 99549
]
MariaDB v4
[ 141528
]
Aleksey Midenkov
made changes -
2023-07-26 18:15
Summary
Assertion `col.vers_sys_end()' failed in dict_index_t::vers_history_row
Assertion (col.vers_sys_end()) upon inplace ALTER
Aleksey Midenkov
made changes -
2023-07-26 18:16
Summary
Assertion (col.vers_sys_end()) upon inplace ALTER
Assertion (col.vers_sys_end()) upon inplace ALTER with virtual columns
Aleksey Midenkov
made changes -
2023-07-26 18:57
Status
Open
[ 1
]
In Progress
[ 3
]
Aleksey Midenkov
made changes -
2023-07-26 18:57
Assignee
Aleksey Midenkov
[ midenok
]
Nikita Malyavin
[ nikitamalyavin
]
Status
In Progress
[ 3
]
In Review
[ 10002
]
Aleksey Midenkov
made changes -
2023-10-05 11:59
Assignee
Nikita Malyavin
[ nikitamalyavin
]
Marko Mäkelä
[ marko
]
Marko Mäkelä
made changes -
2023-10-11 14:59
Assignee
Marko Mäkelä
[ marko
]
Nikita Malyavin
[ nikitamalyavin
]
Nikita Malyavin
made changes -
2023-10-19 11:57
Assignee
Nikita Malyavin
[ nikitamalyavin
]
Aleksey Midenkov
[ midenok
]
Status
In Review
[ 10002
]
Stalled
[ 10000
]
Aleksey Midenkov
made changes -
2023-11-02 15:52
Status
Stalled
[ 10000
]
In Progress
[ 3
]
Aleksey Midenkov
made changes -
2023-11-10 13:44
Fix Version/s
10.4.32
[ 29300
]
Fix Version/s
10.4
[ 22408
]
Resolution
Fixed
[ 1
]
Status
In Progress
[ 3
]
Closed
[ 6
]
Julien Fritsch
made changes -
2023-11-10 15:38
Fix Version/s
10.5.23
[ 29012
]
Fix Version/s
10.6.16
[ 29014
]
Fix Version/s
10.10.7
[ 29018
]
Fix Version/s
10.11.6
[ 29020
]
Fix Version/s
11.0.4
[ 29021
]
Fix Version/s
11.1.3
[ 29023
]
Fix Version/s
11.2.2
[ 29035
]
Daniel Bartholomew
made changes -
2023-11-13 16:05
Fix Version/s
10.4.33
[ 29516
]
Fix Version/s
10.5.24
[ 29517
]
Fix Version/s
10.6.17
[ 29518
]
Fix Version/s
10.11.7
[ 29519
]
Fix Version/s
11.0.5
[ 29520
]
Fix Version/s
11.1.4
[ 29024
]
Fix Version/s
11.2.3
[ 29521
]
Fix Version/s
10.5.23
[ 29012
]
Fix Version/s
10.6.16
[ 29014
]
Fix Version/s
10.10.7
[ 29018
]
Fix Version/s
10.11.6
[ 29020
]
Fix Version/s
11.0.4
[ 29021
]
Fix Version/s
11.1.3
[ 29023
]
Fix Version/s
11.2.2
[ 29035
]
Fix Version/s
10.4.32
[ 29300
]
{"report":{"fcp":1568.4000000953674,"ttfb":536.2000002861023,"pageVisibility":"visible","entityId":78847,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"a69809e0-a277-4c4b-93cd-a0e7c4529412","navigationType":0,"readyForUser":1686.4000000953674,"redirectCount":0,"resourceLoadedEnd":2053.800000190735,"resourceLoadedStart":541.5,"resourceTiming":[{"duration":396.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":541.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":541.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":938.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":396.90000009536743,"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":541.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":541.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":938.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":406.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":542,"connectEnd":542,"connectStart":542,"domainLookupEnd":542,"domainLookupStart":542,"fetchStart":542,"redirectEnd":0,"redirectStart":0,"requestStart":542,"responseEnd":948.1000003814697,"responseStart":948.1000003814697,"secureConnectionStart":542},{"duration":461.40000009536743,"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":542.3000001907349,"connectEnd":542.3000001907349,"connectStart":542.3000001907349,"domainLookupEnd":542.3000001907349,"domainLookupStart":542.3000001907349,"fetchStart":542.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":542.3000001907349,"responseEnd":1003.7000002861023,"responseStart":1003.7000002861023,"secureConnectionStart":542.3000001907349},{"duration":465.5,"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":542.4000000953674,"connectEnd":542.4000000953674,"connectStart":542.4000000953674,"domainLookupEnd":542.4000000953674,"domainLookupStart":542.4000000953674,"fetchStart":542.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":542.4000000953674,"responseEnd":1007.9000000953674,"responseStart":1007.9000000953674,"secureConnectionStart":542.4000000953674},{"duration":465.69999980926514,"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":542.7000002861023,"connectEnd":542.7000002861023,"connectStart":542.7000002861023,"domainLookupEnd":542.7000002861023,"domainLookupStart":542.7000002861023,"fetchStart":542.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":542.7000002861023,"responseEnd":1008.4000000953674,"responseStart":1008.4000000953674,"secureConnectionStart":542.7000002861023},{"duration":466.09999990463257,"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":542.8000001907349,"connectEnd":542.8000001907349,"connectStart":542.8000001907349,"domainLookupEnd":542.8000001907349,"domainLookupStart":542.8000001907349,"fetchStart":542.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":542.8000001907349,"responseEnd":1008.9000000953674,"responseStart":1008.9000000953674,"secureConnectionStart":542.8000001907349},{"duration":570.5999999046326,"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":543.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":543.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1113.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":466,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":543.3000001907349,"connectEnd":543.3000001907349,"connectStart":543.3000001907349,"domainLookupEnd":543.3000001907349,"domainLookupStart":543.3000001907349,"fetchStart":543.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":543.3000001907349,"responseEnd":1009.3000001907349,"responseStart":1009.3000001907349,"secureConnectionStart":543.3000001907349},{"duration":570.7000002861023,"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":543.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":543.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1114.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":466.3999996185303,"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":543.6000003814697,"connectEnd":543.6000003814697,"connectStart":543.6000003814697,"domainLookupEnd":543.6000003814697,"domainLookupStart":543.6000003814697,"fetchStart":543.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":543.6000003814697,"responseEnd":1010,"responseStart":1010,"secureConnectionStart":543.6000003814697},{"duration":707.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":549.8000001907349,"connectEnd":549.8000001907349,"connectStart":549.8000001907349,"domainLookupEnd":549.8000001907349,"domainLookupStart":549.8000001907349,"fetchStart":549.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":549.8000001907349,"responseEnd":1256.9000000953674,"responseStart":1256.9000000953674,"secureConnectionStart":549.8000001907349},{"duration":1468.9000000953674,"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":552.7000002861023,"connectEnd":552.7000002861023,"connectStart":552.7000002861023,"domainLookupEnd":552.7000002861023,"domainLookupStart":552.7000002861023,"fetchStart":552.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":552.7000002861023,"responseEnd":2021.6000003814697,"responseStart":2021.6000003814697,"secureConnectionStart":552.7000002861023},{"duration":132.2000002861023,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1129,"connectEnd":1129,"connectStart":1129,"domainLookupEnd":1129,"domainLookupStart":1129,"fetchStart":1129,"redirectEnd":0,"redirectStart":0,"requestStart":1129,"responseEnd":1261.2000002861023,"responseStart":1261.2000002861023,"secureConnectionStart":1129},{"duration":595.6000003814697,"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&whisper-enabled=true","startTime":1427,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1427,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2022.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":606.1999998092651,"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&whisper-enabled=true","startTime":1430.7000002861023,"connectEnd":1430.7000002861023,"connectStart":1430.7000002861023,"domainLookupEnd":1430.7000002861023,"domainLookupStart":1430.7000002861023,"fetchStart":1430.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":1430.7000002861023,"responseEnd":2036.9000000953674,"responseStart":2036.9000000953674,"secureConnectionStart":1430.7000002861023},{"duration":622.5,"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&whisper-enabled=true","startTime":1431.3000001907349,"connectEnd":1431.3000001907349,"connectStart":1431.3000001907349,"domainLookupEnd":1431.3000001907349,"domainLookupStart":1431.3000001907349,"fetchStart":1431.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1431.3000001907349,"responseEnd":2053.800000190735,"responseStart":2053.800000190735,"secureConnectionStart":1431.3000001907349}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":290,"responseStart":536,"responseEnd":552,"domLoading":539,"domInteractive":2067,"domContentLoadedEventStart":2067,"domContentLoadedEventEnd":2123,"domComplete":3039,"loadEventStart":3039,"loadEventEnd":3040,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2025.7000002861023},{"name":"bigPipe.sidebar-id.end","time":2026.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":2026.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":2032.9000000953674},{"name":"activityTabFullyLoaded","time":2147.4000000953674}],"measures":[],"correlationId":"8d5ea967c26e8e","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":181,"dbReadsTimeInMs":37,"dbConnsTimeInMs":48,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Please review bb-10.4-midenok