--source include/have_innodb.inc
|
|
CREATE TABLE t1 (FTS_DOC_ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, c TEXT, KEY (FTS_DOC_ID), FULLTEXT fk (c)) ENGINE=InnoDB;
|
INSERT INTO t1 (c) VALUES ('foo');
|
ALTER TABLE t1 ADD d GEOMETRY DEFAULT ST_GEOMFROMTEXT('Point(1 1)');
|
REPLACE INTO t1 (d) VALUES (NULL);
|
|
# Cleanup
|
DROP TABLE t1;
|
10.3 e1e142e7
|
mysqld: /data/src/10.3/storage/innobase/fts/fts0fts.cc:3228: void fts_fetch_doc_from_rec(fts_get_doc_t*, dict_index_t*, btr_pcur_t*, ulint*, fts_doc_t*): Assertion `!page_rec_is_comp(clust_rec) || rec_get_status(clust_rec) == REC_STATUS_ORDINARY' failed.
|
190802 17:08:54 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f0cf5864f12 in __GI___assert_fail (assertion=0x560c450ce008 "!page_rec_is_comp(clust_rec) || rec_get_status(clust_rec) == REC_STATUS_ORDINARY", file=0x560c450cd500 "/data/src/10.3/storage/innobase/fts/fts0fts.cc", line=3228, function=0x560c450d05e0 <fts_fetch_doc_from_rec(fts_get_doc_t*, dict_index_t*, btr_pcur_t*, unsigned long*, fts_doc_t*)::__PRETTY_FUNCTION__> "void fts_fetch_doc_from_rec(fts_get_doc_t*, dict_index_t*, btr_pcur_t*, ulint*, fts_doc_t*)") at assert.c:101
|
#8 0x0000560c44ae80f2 in fts_fetch_doc_from_rec (get_doc=0x7f0c9c03d6c8, clust_index=0x7f0c9c0a8258, pcur=0x7f0cf0062500, offsets=0x7f0c9c050478, doc=0x7f0cf00623b0) at /data/src/10.3/storage/innobase/fts/fts0fts.cc:3228
|
#9 0x0000560c44ae8df1 in fts_add_doc_by_id (ftt=0x7f0c9c0450d8, doc_id=2, fts_indexes=0x0) at /data/src/10.3/storage/innobase/fts/fts0fts.cc:3540
|
#10 0x0000560c44ae743e in fts_add (ftt=0x7f0c9c0450d8, row=0x7f0c9c010f80) at /data/src/10.3/storage/innobase/fts/fts0fts.cc:2847
|
#11 0x0000560c44ae7be5 in fts_commit_table (ftt=0x7f0c9c0450d8) at /data/src/10.3/storage/innobase/fts/fts0fts.cc:3019
|
#12 0x0000560c44ae7cd9 in fts_commit (trx=0x7f0ceb3ff0f0) at /data/src/10.3/storage/innobase/fts/fts0fts.cc:3068
|
#13 0x0000560c449a58b2 in trx_commit_low (trx=0x7f0ceb3ff0f0, mtr=0x7f0cf0062c50) at /data/src/10.3/storage/innobase/trx/trx0trx.cc:1445
|
#14 0x0000560c449a5a7d in trx_commit (trx=0x7f0ceb3ff0f0) at /data/src/10.3/storage/innobase/trx/trx0trx.cc:1534
|
#15 0x0000560c449a5e86 in trx_commit_for_mysql (trx=0x7f0ceb3ff0f0) at /data/src/10.3/storage/innobase/trx/trx0trx.cc:1670
|
#16 0x0000560c447811fd in innobase_commit_low (trx=0x7f0ceb3ff0f0) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:4407
|
#17 0x0000560c44781592 in innobase_commit_ordered_2 (trx=0x7f0ceb3ff0f0, thd=0x7f0c9c000b00) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:4521
|
#18 0x0000560c44781a80 in innobase_commit (hton=0x560c47b1f910, thd=0x7f0c9c000b00, commit_trx=false) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:4637
|
#19 0x0000560c445765ec in commit_one_phase_2 (thd=0x7f0c9c000b00, all=false, trans=0x7f0c9c004030, is_real_trans=true) at /data/src/10.3/sql/handler.cc:1641
|
#20 0x0000560c445764e8 in ha_commit_one_phase (thd=0x7f0c9c000b00, all=false) at /data/src/10.3/sql/handler.cc:1621
|
#21 0x0000560c44575c81 in ha_commit_trans (thd=0x7f0c9c000b00, all=false) at /data/src/10.3/sql/handler.cc:1483
|
#22 0x0000560c443ef006 in trans_commit_stmt (thd=0x7f0c9c000b00) at /data/src/10.3/sql/transaction.cc:505
|
#23 0x0000560c4427f90b in mysql_execute_command (thd=0x7f0c9c000b00) at /data/src/10.3/sql/sql_parse.cc:6098
|
#24 0x0000560c44284602 in mysql_parse (thd=0x7f0c9c000b00, rawbuf=0x7f0c9c012818 "REPLACE INTO t1 (d) VALUES (NULL)", length=33, parser_state=0x7f0cf00645e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7829
|
#25 0x0000560c44272200 in dispatch_command (command=COM_QUERY, thd=0x7f0c9c000b00, packet=0x7f0c9c160121 "REPLACE INTO t1 (d) VALUES (NULL)", packet_length=33, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1856
|
#26 0x0000560c44270c23 in do_command (thd=0x7f0c9c000b00) at /data/src/10.3/sql/sql_parse.cc:1401
|
#27 0x0000560c443daa4c in do_handle_one_connection (connect=0x560c47e553b0) at /data/src/10.3/sql/sql_connect.cc:1403
|
#28 0x0000560c443da7ae in handle_one_connection (arg=0x560c47e553b0) at /data/src/10.3/sql/sql_connect.cc:1308
|
#29 0x0000560c44cb5ed8 in pfs_spawn_thread (arg=0x560c47d9daa0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#30 0x00007f0cf73d94a4 in start_thread (arg=0x7f0cf0065700) at pthread_create.c:456
|
#31 0x00007f0cf5921d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
Not reproducible on 10.2 and 10.4.
No obvious problem on a non-debug build.
- relates to
-
MDEV-17459
Allow instant ALTER TABLE even if FULLTEXT INDEX exists
-
-
Stalled
{"report":{"fcp":851.7000000476837,"ttfb":192.70000004768372,"pageVisibility":"visible","entityId":77974,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"c899c2eb-4188-41fd-b681-118cf0f79f8e","navigationType":0,"readyForUser":934.6000000238419,"redirectCount":0,"resourceLoadedEnd":568.6000000238419,"resourceLoadedStart":202.39999997615814,"resourceTiming":[{"duration":7.800000071525574,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":202.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":202.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":210.20000004768372,"responseStart":0,"secureConnectionStart":0},{"duration":7.899999976158142,"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":202.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":202.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":210.60000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":255.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":202.79999995231628,"connectEnd":202.79999995231628,"connectStart":202.79999995231628,"domainLookupEnd":202.79999995231628,"domainLookupStart":202.79999995231628,"fetchStart":202.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":213.10000002384186,"responseEnd":458.7000000476837,"responseStart":245.60000002384186,"secureConnectionStart":202.79999995231628},{"duration":365.8000000715256,"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":202.79999995231628,"connectEnd":202.79999995231628,"connectStart":202.79999995231628,"domainLookupEnd":202.79999995231628,"domainLookupStart":202.79999995231628,"fetchStart":202.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":214.70000004768372,"responseEnd":568.6000000238419,"responseStart":247.20000004768372,"secureConnectionStart":202.79999995231628},{"duration":11.100000023841858,"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":202.89999997615814,"connectEnd":202.89999997615814,"connectStart":202.89999997615814,"domainLookupEnd":202.89999997615814,"domainLookupStart":202.89999997615814,"fetchStart":202.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":202.89999997615814,"responseEnd":214,"responseStart":214,"secureConnectionStart":202.89999997615814},{"duration":47,"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":203.10000002384186,"connectEnd":203.10000002384186,"connectStart":203.10000002384186,"domainLookupEnd":203.10000002384186,"domainLookupStart":203.10000002384186,"fetchStart":203.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":216.10000002384186,"responseEnd":250.10000002384186,"responseStart":248.79999995231628,"secureConnectionStart":203.10000002384186},{"duration":50.39999997615814,"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":203.10000002384186,"connectEnd":203.10000002384186,"connectStart":203.10000002384186,"domainLookupEnd":203.10000002384186,"domainLookupStart":203.10000002384186,"fetchStart":203.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":216.70000004768372,"responseEnd":253.5,"responseStart":250.20000004768372,"secureConnectionStart":203.10000002384186},{"duration":13.700000047683716,"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":203.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":203.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":217,"responseStart":0,"secureConnectionStart":0},{"duration":50.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":203.29999995231628,"connectEnd":203.29999995231628,"connectStart":203.29999995231628,"domainLookupEnd":203.29999995231628,"domainLookupStart":203.29999995231628,"fetchStart":203.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":219.79999995231628,"responseEnd":253.79999995231628,"responseStart":251.5,"secureConnectionStart":203.29999995231628},{"duration":15.399999976158142,"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":203.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":203.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":218.79999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":50.60000002384186,"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":203.5,"connectEnd":203.5,"connectStart":203.5,"domainLookupEnd":203.5,"domainLookupStart":203.5,"fetchStart":203.5,"redirectEnd":0,"redirectStart":0,"requestStart":221.5,"responseEnd":254.10000002384186,"responseStart":252.10000002384186,"secureConnectionStart":203.5},{"duration":358.7999999523163,"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":206.70000004768372,"connectEnd":206.70000004768372,"connectStart":206.70000004768372,"domainLookupEnd":206.70000004768372,"domainLookupStart":206.70000004768372,"fetchStart":206.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":242.5,"responseEnd":565.5,"responseStart":559.8999999761581,"secureConnectionStart":206.70000004768372},{"duration":357.90000009536743,"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":206.79999995231628,"connectEnd":206.79999995231628,"connectStart":206.79999995231628,"domainLookupEnd":206.79999995231628,"domainLookupStart":206.79999995231628,"fetchStart":206.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":243.29999995231628,"responseEnd":564.7000000476837,"responseStart":557.7999999523163,"secureConnectionStart":206.79999995231628},{"duration":174.10000002384186,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":607.6000000238419,"connectEnd":607.6000000238419,"connectStart":607.6000000238419,"domainLookupEnd":607.6000000238419,"domainLookupStart":607.6000000238419,"fetchStart":607.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":749.3999999761581,"responseEnd":781.7000000476837,"responseStart":780.7000000476837,"secureConnectionStart":607.6000000238419},{"duration":64.10000002384186,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":844.3999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":844.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":908.5,"responseStart":0,"secureConnectionStart":0},{"duration":101.60000002384186,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":851.2999999523163,"connectEnd":851.2999999523163,"connectStart":851.2999999523163,"domainLookupEnd":851.2999999523163,"domainLookupStart":851.2999999523163,"fetchStart":851.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":912.2000000476837,"responseEnd":952.8999999761581,"responseStart":951.3999999761581,"secureConnectionStart":851.2999999523163}],"fetchStart":0,"domainLookupStart":10,"domainLookupEnd":16,"connectStart":16,"connectEnd":37,"secureConnectionStart":25,"requestStart":37,"responseStart":193,"responseEnd":205,"domLoading":196,"domInteractive":1040,"domContentLoadedEventStart":1040,"domContentLoadedEventEnd":1088,"domComplete":1342,"loadEventStart":1342,"loadEventEnd":1343,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1014.8999999761581},{"name":"bigPipe.sidebar-id.end","time":1015.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":1015.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":1017.7999999523163},{"name":"activityTabFullyLoaded","time":1106.8999999761581}],"measures":[],"correlationId":"1ad5763a7f61c7","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":87,"dbReadsTimeInMs":10,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
I think that we should also require ADD FULLTEXT INDEX to rebuild the table if the table is already in instant ALTER format.
Alternatively, we can rewrite the fulltext search code and test (with RQG) that it can deal with records that contain or lack instantly added columns. (For missing columns, the default values must be substituted from the metadata record.) This should be tested also in the case where FTS_DOC_ID or a fulltext-indexed column was added instantly.