Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
N/A
Note: The test case seems to be very similar to MDEV-14649 , probably the issues are related or even have the same cause; but the assertion failure and stack trace are different, so I'm filing it separately just in case.
--source include/have_innodb.inc
--source include/have_partition.inc
CREATE TABLE t1 (i INT ) ENGINE=InnoDB PARTITION BY KEY (i) PARTITIONS 2;
INSERT INTO t1 VALUES (1);
ALTER TABLE t1 ADD SYSTEM VERSIONING;
# Cleanup
DROP TABLE t1;
bb-10.3-temporal 8e8363bb754
mysqld: /data/src/bb-10.3-temporal/storage/innobase/row/row0merge.cc:761: ulint row_merge_buf_add(row_merge_buf_t*, dict_index_t*, const dict_table_t*, const dict_table_t*, fts_psort_t*, const dtuple_t*, const row_ext_t*, doc_id_t*, mem_heap_t*, dberr_t*, mem_heap_t**, TABLE*, trx_t*): Assertion `len <= col->len || ((col->mtype) == 5 || (col->mtype) == 14)' failed.
171214 16:55:02 [ERROR] mysqld got signal 6 ;
#7 0x00007f118d88bee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x000055be6c7c0a6e in row_merge_buf_add (buf=0x7f112c041398, fts_index=0x0, old_table=0x7f112c00ebf8, new_table=0x7f112c03e618, psort_info=0x0, row=0x7f112c043f10, ext=0x0, doc_id=0x7f11880f17b0, conv_heap=0x0, err=0x7f11880f178c, v_heap=0x7f11880f17a8, my_table=0x7f112c08ccb0, trx=0x7f11833ff0d8) at /data/src/bb-10.3-temporal/storage/innobase/row/row0merge.cc:760
#9 0x000055be6c7c6692 in row_merge_read_clustered_index (trx=0x7f11833ff0d8, table=0x7f112c08ccb0, old_table=0x7f112c00ebf8, new_table=0x7f112c03e618, online=false, index=0x7f112c03e178, fts_sort_idx=0x0, psort_info=0x0, files=0x7f112c09abb0, key_numbers=0x7f112c03e180, n_index=1, add_cols=0x7f112c03e230, add_v=0x0, col_map=0x7f112c03e308, add_autoinc=18446744073709551615, sequence=..., block=0x7f1180095000 <error: Cannot access memory at address 0x7f1180095000>, skip_pk_sort=true, tmpfd=0x7f11880f2308, stage=0x7f112c18dbc0, pct_cost=50, crypt_block=0x0, eval_table=0x7f112c08ccb0, drop_historical=false) at /data/src/bb-10.3-temporal/storage/innobase/row/row0merge.cc:2385
#10 0x000055be6c7cd107 in row_merge_build_indexes (trx=0x7f11833ff0d8, old_table=0x7f112c00ebf8, new_table=0x7f112c03e618, online=false, indexes=0x7f112c03e178, key_numbers=0x7f112c03e180, n_indexes=1, table=0x7f112c08ccb0, add_cols=0x7f112c03e230, col_map=0x7f112c03e308, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=true, stage=0x7f112c18dbc0, add_v=0x0, eval_table=0x7f112c08ccb0, drop_historical=false) at /data/src/bb-10.3-temporal/storage/innobase/row/row0merge.cc:4786
#11 0x000055be6c6b9de6 in ha_innobase::inplace_alter_table (this=0x7f112c06ca18, altered_table=0x7f112c08ccb0, ha_alter_info=0x7f11880f3260) at /data/src/bb-10.3-temporal/storage/innobase/handler/handler0alter.cc:7091
#12 0x000055be6c144537 in handler::ha_inplace_alter_table (this=0x7f112c06ca18, altered_table=0x7f112c08ccb0, ha_alter_info=0x7f11880f3260) at /data/src/bb-10.3-temporal/sql/handler.h:4108
#13 0x000055be6caef56f in ha_partition::inplace_alter_table (this=0x7f112c00d708, altered_table=0x7f112c08ccb0, ha_alter_info=0x7f11880f3260) at /data/src/bb-10.3-temporal/sql/ha_partition.cc:9872
#14 0x000055be6c144537 in handler::ha_inplace_alter_table (this=0x7f112c00d708, altered_table=0x7f112c08ccb0, ha_alter_info=0x7f11880f3260) at /data/src/bb-10.3-temporal/sql/handler.h:4108
#15 0x000055be6c13a7ef in mysql_inplace_alter_table (thd=0x7f112c000b00, table_list=0x7f112c014d30, table=0x7f112c00cac0, altered_table=0x7f112c08ccb0, ha_alter_info=0x7f11880f3260, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f11880f33d0, alter_ctx=0x7f11880f4070) at /data/src/bb-10.3-temporal/sql/sql_table.cc:7416
#16 0x000055be6c1402fb in mysql_alter_table (thd=0x7f112c000b00, new_db=0x7f112c015368 "test", new_name=0x0, create_info=0x7f11880f4c90, table_list=0x7f112c014d30, alter_info=0x7f11880f4be0, order_num=0, order=0x0, ignore=false) at /data/src/bb-10.3-temporal/sql/sql_table.cc:9509
#17 0x000055be6c1c8ad3 in Sql_cmd_alter_table::execute (this=0x7f112c015370, thd=0x7f112c000b00) at /data/src/bb-10.3-temporal/sql/sql_alter.cc:331
#18 0x000055be6c06c936 in mysql_execute_command (thd=0x7f112c000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:6255
#19 0x000055be6c071468 in mysql_parse (thd=0x7f112c000b00, rawbuf=0x7f112c014c38 "ALTER TABLE t1 ADD SYSTEM VERSIONING", length=36, parser_state=0x7f11880f65f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7984
#20 0x000055be6c05ebd4 in dispatch_command (command=COM_QUERY, thd=0x7f112c000b00, packet=0x7f112c160011 "ALTER TABLE t1 ADD SYSTEM VERSIONING", packet_length=36, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1829
#21 0x000055be6c05d5f5 in do_command (thd=0x7f112c000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1371
#22 0x000055be6c1c364c in do_handle_one_connection (connect=0x55be6f1497b0) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
#23 0x000055be6c1c33d9 in handle_one_connection (arg=0x55be6f1497b0) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
#24 0x000055be6c659456 in pfs_spawn_thread (arg=0x55be6f1f3030) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
#25 0x00007f118f562494 in start_thread (arg=0x7f11880f7700) at pthread_create.c:333
#26 0x00007f118d94893f in clone () from /lib/x86_64-linux-gnu/libc.so.6
relates to
MDEV-14649
Assertion `t->mysql_col_len == 8' failed in row_insert_for_mysql
Closed
Aleksey Midenkov
made changes -
2017-12-14 14:58
Assignee
Aleksey Midenkov
[ midenok
]
Eugene Kosov
[ kevg
]
Eugene Kosov (Inactive)
made changes -
2017-12-18 19:27
Fix Version/s
10.3.3
[ 22644
]
Fix Version/s
10.3
[ 22126
]
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2017-12-27 14:10
Fix Version/s
10.3.4
[ 22904
]
Fix Version/s
10.3.3
[ 22644
]
Sergei Golubchik
made changes -
2021-12-06 21:46
Workflow
MariaDB v3
[ 84430
]
MariaDB v4
[ 153354
]
{"report":{"fcp":1907.3999999761581,"ttfb":646.8999999761581,"pageVisibility":"visible","entityId":64828,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"55ec80e2-de40-4c86-bc47-3becfc314c0f","navigationType":0,"readyForUser":2002.1000000238419,"redirectCount":0,"resourceLoadedEnd":2266,"resourceLoadedStart":658.6000000238419,"resourceTiming":[{"duration":367.60000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":658.6000000238419,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":658.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1026.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":368.10000002384186,"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":658.8999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":658.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1027,"responseStart":0,"secureConnectionStart":0},{"duration":375.6999999284744,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":659.1000000238419,"connectEnd":659.1000000238419,"connectStart":659.1000000238419,"domainLookupEnd":659.1000000238419,"domainLookupStart":659.1000000238419,"fetchStart":659.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":659.1000000238419,"responseEnd":1034.7999999523163,"responseStart":1034.7999999523163,"secureConnectionStart":659.1000000238419},{"duration":795.4000000953674,"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":659.2999999523163,"connectEnd":659.2999999523163,"connectStart":659.2999999523163,"domainLookupEnd":659.2999999523163,"domainLookupStart":659.2999999523163,"fetchStart":659.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":659.2999999523163,"responseEnd":1454.7000000476837,"responseStart":1454.7000000476837,"secureConnectionStart":659.2999999523163},{"duration":842,"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":659.5,"connectEnd":659.5,"connectStart":659.5,"domainLookupEnd":659.5,"domainLookupStart":659.5,"fetchStart":659.5,"redirectEnd":0,"redirectStart":0,"requestStart":659.5,"responseEnd":1501.5,"responseStart":1501.5,"secureConnectionStart":659.5},{"duration":842.4000000953674,"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":659.7999999523163,"connectEnd":659.7999999523163,"connectStart":659.7999999523163,"domainLookupEnd":659.7999999523163,"domainLookupStart":659.7999999523163,"fetchStart":659.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":659.7999999523163,"responseEnd":1502.2000000476837,"responseStart":1502.2000000476837,"secureConnectionStart":659.7999999523163},{"duration":843.6000000238419,"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":659.8999999761581,"connectEnd":659.8999999761581,"connectStart":659.8999999761581,"domainLookupEnd":659.8999999761581,"domainLookupStart":659.8999999761581,"fetchStart":659.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":659.8999999761581,"responseEnd":1503.5,"responseStart":1503.5,"secureConnectionStart":659.8999999761581},{"duration":844.1999999284744,"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":660.1000000238419,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":660.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1504.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":843.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":660.2999999523163,"connectEnd":660.2999999523163,"connectStart":660.2999999523163,"domainLookupEnd":660.2999999523163,"domainLookupStart":660.2999999523163,"fetchStart":660.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":660.2999999523163,"responseEnd":1504,"responseStart":1504,"secureConnectionStart":660.2999999523163},{"duration":845.3999999761581,"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":660.3999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":660.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1505.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":844.2999999523163,"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":660.6000000238419,"connectEnd":660.6000000238419,"connectStart":660.6000000238419,"domainLookupEnd":660.6000000238419,"domainLookupStart":660.6000000238419,"fetchStart":660.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":660.6000000238419,"responseEnd":1504.8999999761581,"responseStart":1504.8999999761581,"secureConnectionStart":660.6000000238419},{"duration":1432.5,"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":661.3999999761581,"connectEnd":661.3999999761581,"connectStart":661.3999999761581,"domainLookupEnd":661.3999999761581,"domainLookupStart":661.3999999761581,"fetchStart":661.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":661.3999999761581,"responseEnd":2093.899999976158,"responseStart":2093.899999976158,"secureConnectionStart":661.3999999761581},{"duration":1604.5,"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":661.5,"connectEnd":661.5,"connectStart":661.5,"domainLookupEnd":661.5,"domainLookupStart":661.5,"fetchStart":661.5,"redirectEnd":0,"redirectStart":0,"requestStart":661.5,"responseEnd":2266,"responseStart":2266,"secureConnectionStart":661.5},{"duration":531.2000000476837,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1341.8999999761581,"connectEnd":1341.8999999761581,"connectStart":1341.8999999761581,"domainLookupEnd":1341.8999999761581,"domainLookupStart":1341.8999999761581,"fetchStart":1341.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":1341.8999999761581,"responseEnd":1873.1000000238419,"responseStart":1873,"secureConnectionStart":1341.8999999761581},{"duration":393.60000002384186,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1900.3999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1900.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2294,"responseStart":0,"secureConnectionStart":0},{"duration":447.6999999284744,"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":1923.2000000476837,"connectEnd":1923.2000000476837,"connectStart":1923.2000000476837,"domainLookupEnd":1923.2000000476837,"domainLookupStart":1923.2000000476837,"fetchStart":1923.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1923.2000000476837,"responseEnd":2370.899999976158,"responseStart":2370.899999976158,"secureConnectionStart":1923.2000000476837}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":468,"responseStart":647,"responseEnd":651,"domLoading":655,"domInteractive":2296,"domContentLoadedEventStart":2296,"domContentLoadedEventEnd":2357,"domComplete":2771,"loadEventStart":2771,"loadEventEnd":2772,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2271.5},{"name":"bigPipe.sidebar-id.end","time":2272.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":2272.600000023842},{"name":"bigPipe.activity-panel-pipe-id.end","time":2275},{"name":"activityTabFullyLoaded","time":2376.5}],"measures":[],"correlationId":"a98ea63779acfb","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":112,"dbReadsTimeInMs":17,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Same problem as with
MDEV-14649: `ALTER TABLE` add `sys_trx_` fields of wrong type. This bug is a kind of a duplicate.