The test innodb_fts.versioning that was added in MDEV-25004 performs some dirty tricks. It replaces part of the data directory contents with the copy of an archived 10.3 data directory. On the merge to 10.7, I had to tweak the test. If the tweaks are reverted, the test will fail in a strange way:
diff --git a/mysql-test/suite/innodb_fts/t/versioning.test b/mysql-test/suite/innodb_fts/t/versioning.test
|
index f615f58e0d2..286597fba39 100644
|
--- a/mysql-test/suite/innodb_fts/t/versioning.test
|
+++ b/mysql-test/suite/innodb_fts/t/versioning.test
|
@@ -75,18 +75,6 @@ call mtr.add_suppression("InnoDB: Table `mysql`.\`innodb_(table|index)_stats`");
|
let $restart_bindir=;
|
--source include/start_mysqld.inc
|
|
-if ($MTR_COMBINATION_UPGRADE)
|
-{
|
-# The system tablespace was replaced with a 10.3 one that contains
|
-# the InnoDB statistics tables. These tables are corrupted from our
|
-# point of view. Drop the tables, but retain the .frm files to keep
|
-# mtr.check_testcase() happy.
|
---move_file $datadir/mysql/innodb_index_stats.frm $datadir/iis.frm
|
---move_file $datadir/mysql/innodb_table_stats.frm $datadir/its.frm
|
-DROP TABLE mysql.innodb_table_stats, mysql.innodb_index_stats;
|
---move_file $datadir/its.frm $datadir/mysql/innodb_table_stats.frm
|
---move_file $datadir/iis.frm $datadir/mysql/innodb_index_stats.frm
|
-}
|
--error ER_INDEX_CORRUPT
|
SELECT * FROM articles WHERE MATCH (title,body)
|
AGAINST ('Database' IN NATURAL LANGUAGE MODE);
|
10.7 8356fb68c366b7f515f9060d964ee598653756a6 with the 10.6 test
|
innodb_fts.versioning 'innodb,upgrade' [ fail ]
|
Test ended at 2023-01-04 15:20:39
|
|
CURRENT_TEST: innodb_fts.versioning
|
mysqltest: At line 79: query 'SELECT * FROM articles WHERE MATCH (title,body)
|
AGAINST ('Database' IN NATURAL LANGUAGE MODE)' failed with wrong errno ER_TABLE_CORRUPT (1877): 'Table mysql/innodb_table_stats is corrupted. Please drop the table and recreate.', instead of ER_INDEX_CORRUPT (1712)...
|
This error can be worked around as follows:
diff --git a/mysql-test/suite/innodb_fts/t/versioning.test b/mysql-test/suite/innodb_fts/t/versioning.test
|
index 286597fba39..a88c984df98 100644
|
--- a/mysql-test/suite/innodb_fts/t/versioning.test
|
+++ b/mysql-test/suite/innodb_fts/t/versioning.test
|
@@ -75,6 +75,7 @@ call mtr.add_suppression("InnoDB: Table `mysql`.\`innodb_(table|index)_stats`");
|
let $restart_bindir=;
|
--source include/start_mysqld.inc
|
|
+SET GLOBAL innodb_stats_persistent=0;
|
--error ER_INDEX_CORRUPT
|
SELECT * FROM articles WHERE MATCH (title,body)
|
AGAINST ('Database' IN NATURAL LANGUAGE MODE);
|
But then the server will crash later on:
10.7 8356fb68c366b7f515f9060d964ee598653756a6 with statistics disabled
|
innodb_fts.versioning 'innodb,upgrade' [ fail ]
|
Test ended at 2023-01-04 15:22:13
|
|
CURRENT_TEST: innodb_fts.versioning
|
mysqltest: At line 84: query 'alter table articles force' failed: <Unknown> (2013): Lost connection to server during query
|
…
|
2023-01-04 15:22:12 3 [ERROR] mariadbd: Table mysql/innodb_table_stats is corrupted. Please drop the table and recreate.
|
2023-01-04 15:22:12 3 [ERROR] mariadbd: Table mysql/innodb_index_stats is corrupted. Please drop the table and recreate.
|
2023-01-04 15:22:12 3 [ERROR] mariadbd: Table mysql/innodb_table_stats is corrupted. Please drop the table and recreate.
|
2023-01-04 15:22:12 3 [ERROR] mariadbd: Table mysql/innodb_index_stats is corrupted. Please drop the table and recreate.
|
mariadbd: /mariadb/10.7/sql/sql_error.cc:335: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.
|
…
|
#11 0x000056274a388338 in Diagnostics_area::set_ok_status (this=0x7f92dc006cf0, affected_rows=10, last_insert_id=0, message=0x7f930823e7a0 "Records: 10 Duplicates: 0 Warnings: 5") at /mariadb/10.7/sql/sql_error.cc:335
|
#12 0x000056274a3234f2 in my_ok (thd=<optimized out>, affected_rows_arg=<optimized out>, id=<optimized out>, message=<optimized out>) at /mariadb/10.7/sql/sql_class.h:5601
|
#13 0x000056274a47d623 in mysql_alter_table (thd=thd@entry=0x7f92dc000d58, new_db=new_db@entry=0x7f92dc005a28, new_name=<optimized out>, create_info=create_info@entry=0x7f930823f4d0, table_list=<optimized out>, table_list@entry=0x7f92dc016b30, alter_info=alter_info@entry=0x7f930823f3e0, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /mariadb/10.7/sql/sql_table.cc:10969
|
The offending error was flagged during a RENAME operation that was part of the ALTER TABLE…ALGORITHM=COPY operation:
10.7 8356fb68c366b7f515f9060d964ee598653756a6
|
#3 0x0000558215aa3f6f in my_message_sql (error=1877,
|
str=0x7fd9a005fe70 "Table mysql/innodb_table_stats is corrupted. Please drop the table and recreate.", MyFlags=64) at /mariadb/10.7/sql/mysqld.cc:3322
|
#4 0x0000558216324198 in my_printf_error (error=1877, format=<optimized out>,
|
MyFlags=64) at /mariadb/10.7/mysys/my_error.c:153
|
#5 0x000055821607b562 in dict_table_open_on_name (
|
table_name=table_name@entry=0x55821534af46 "mysql/innodb_table_stats",
|
dict_locked=dict_locked@entry=false,
|
ignore_err=ignore_err@entry=DICT_ERR_IGNORE_NONE)
|
at /mariadb/10.7/storage/innobase/dict/dict0dict.cc:1090
|
#6 0x000055821604b1f6 in ha_innobase::rename_table (this=<optimized out>,
|
from=0x7fd9a0060990 "./test/articles",
|
to=0x7fd9a0060b90 "./test/#sql-backup-21235e-3")
|
For some reason, the merge of MDEV-25004 to 10.6 did not require such tweaks, and it will not crash if this tweak is added.
- relates to
-
MDEV-25004
Missing row in FTS_DOC_ID_INDEX during DELETE HISTORY
-
-
Closed
{"report":{"fcp":967.7999999523163,"ttfb":144,"pageVisibility":"visible","entityId":117985,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"b07307e5-22d6-4936-92cf-2d3c43bf451f","navigationType":0,"readyForUser":1040.2999999523163,"redirectCount":0,"resourceLoadedEnd":1134.5999999046326,"resourceLoadedStart":149.39999985694885,"resourceTiming":[{"duration":336.10000014305115,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":149.39999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":149.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":485.5,"responseStart":0,"secureConnectionStart":0},{"duration":335.80000019073486,"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":149.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":149.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":485.5,"responseStart":0,"secureConnectionStart":0},{"duration":345,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":149.69999980926514,"connectEnd":149.69999980926514,"connectStart":149.69999980926514,"domainLookupEnd":149.69999980926514,"domainLookupStart":149.69999980926514,"fetchStart":149.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":149.69999980926514,"responseEnd":494.69999980926514,"responseStart":494.69999980926514,"secureConnectionStart":149.69999980926514},{"duration":369.7000000476837,"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":149.89999985694885,"connectEnd":149.89999985694885,"connectStart":149.89999985694885,"domainLookupEnd":149.89999985694885,"domainLookupStart":149.89999985694885,"fetchStart":149.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":149.89999985694885,"responseEnd":519.5999999046326,"responseStart":519.5999999046326,"secureConnectionStart":149.89999985694885},{"duration":373.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":150,"connectEnd":150,"connectStart":150,"domainLookupEnd":150,"domainLookupStart":150,"fetchStart":150,"redirectEnd":0,"redirectStart":0,"requestStart":150,"responseEnd":523.5,"responseStart":523.5,"secureConnectionStart":150},{"duration":373.7999999523163,"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":150.09999990463257,"connectEnd":150.09999990463257,"connectStart":150.09999990463257,"domainLookupEnd":150.09999990463257,"domainLookupStart":150.09999990463257,"fetchStart":150.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":150.09999990463257,"responseEnd":523.8999998569489,"responseStart":523.8999998569489,"secureConnectionStart":150.09999990463257},{"duration":374,"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":150.19999980926514,"connectEnd":150.19999980926514,"connectStart":150.19999980926514,"domainLookupEnd":150.19999980926514,"domainLookupStart":150.19999980926514,"fetchStart":150.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":150.19999980926514,"responseEnd":524.1999998092651,"responseStart":524.1999998092651,"secureConnectionStart":150.19999980926514},{"duration":374.39999985694885,"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":150.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":150.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":524.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":374.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":150.29999995231628,"connectEnd":150.29999995231628,"connectStart":150.29999995231628,"domainLookupEnd":150.29999995231628,"domainLookupStart":150.29999995231628,"fetchStart":150.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":150.29999995231628,"responseEnd":524.5999999046326,"responseStart":524.5,"secureConnectionStart":150.29999995231628},{"duration":374.39999985694885,"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":150.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":150.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":524.8999998569489,"responseStart":0,"secureConnectionStart":0},{"duration":374.59999990463257,"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":150.5,"connectEnd":150.5,"connectStart":150.5,"domainLookupEnd":150.5,"domainLookupStart":150.5,"fetchStart":150.5,"redirectEnd":0,"redirectStart":0,"requestStart":150.5,"responseEnd":525.0999999046326,"responseStart":525.0999999046326,"secureConnectionStart":150.5},{"duration":519.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":156,"connectEnd":156,"connectStart":156,"domainLookupEnd":156,"domainLookupStart":156,"fetchStart":156,"redirectEnd":0,"redirectStart":0,"requestStart":156,"responseEnd":675.7999999523163,"responseStart":675.7999999523163,"secureConnectionStart":156},{"duration":978.4000000953674,"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":156.19999980926514,"connectEnd":156.19999980926514,"connectStart":156.19999980926514,"domainLookupEnd":156.19999980926514,"domainLookupStart":156.19999980926514,"fetchStart":156.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":156.19999980926514,"responseEnd":1134.5999999046326,"responseStart":1134.5999999046326,"secureConnectionStart":156.19999980926514},{"duration":368.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":729.0999999046326,"connectEnd":729.0999999046326,"connectStart":729.0999999046326,"domainLookupEnd":729.0999999046326,"domainLookupStart":729.0999999046326,"fetchStart":729.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":729.0999999046326,"responseEnd":1097.5,"responseStart":1097.5,"secureConnectionStart":729.0999999046326}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":12,"responseStart":144,"responseEnd":149,"domLoading":147,"domInteractive":1149,"domContentLoadedEventStart":1149,"domContentLoadedEventEnd":1187,"domComplete":2143,"loadEventStart":2143,"loadEventEnd":2145,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1136.6999998092651},{"name":"bigPipe.sidebar-id.end","time":1137.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":1137.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1140},{"name":"activityTabFullyLoaded","time":1196.7999999523163}],"measures":[],"correlationId":"db0da5c4c9a06d","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":73,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}