file=file@entry=0x5571437ef958 "/mariadb/10.6/storage/innobase/dict/dict0dict.cc", line=line@entry=1844) at /mariadb/10.6/storage/innobase/ut/ut0dbg.cc:60
#7 0x000055714331011f in dict_sys_t::remove (this=0x557143e9fc40 <dict_sys>,
at /mariadb/10.6/storage/innobase/dict/dict0dict.cc:1844
#8 0x0000557143330cb4 in trx_t::commit (this=this@entry=0x7fd40e967680,
...
Thread 55 (Thread 0x7fd32ffff640 (LWP 2881184)):
...
#8 0x0000557143120b44 in dict_sys_t::lock (this=this@entry=0x557143e9fc40 <dict_sys>, file=file@entry=0x5571437ef958 "/mariadb/10.6/storage/innobase/dict/dict0dict.cc", line=line@entry=225) at /mariadb/10.6/storage/innobase/include/dict0dict.h:1532
#9 0x000055714330d54f in dict_table_close (table=table@entry=0x7fd36c11a338) at /mariadb/10.6/storage/innobase/dict/dict0dict.cc:225
#10 0x000055714330d5a6 in dict_table_close (table=0x7fd36c11a338, dict_locked=dict_locked@entry=false, thd=0x557145271ac8, mdl=0x7fd31c0016c0) at /mariadb/10.6/storage/innobase/dict/dict0dict.cc:253
#11 0x0000557143235002 in purge_node_t::close_table (this=this@entry=0x557144f2d6f8) at /mariadb/10.6/storage/innobase/include/row0purge.h:229
#12 0x000055714323509b in purge_node_t::retain_mdl (this=this@entry=0x557144f2d6f8, table_id=57) at /mariadb/10.6/storage/innobase/include/row0purge.h:249
#13 0x0000557143232392 in row_purge_parse_undo_rec (node=node@entry=0x557144f2d6f8, undo_rec=undo_rec@entry=0x557144f3dc18 "", thr=thr@entry=0x557144f2d508, updated_extern=updated_extern@entry=0x7fd32fffea57) at /mariadb/10.6/storage/innobase/row/row0purge.cc:932
#14 0x0000557143234c7c in row_purge (node=node@entry=0x557144f2d6f8, undo_rec=undo_rec@entry=0x557144f3dc18 "", thr=thr@entry=0x557144f2d508) at /mariadb/10.6/storage/innobase/row/row0purge.cc:1120
#15 0x0000557143234d1b in row_purge_step (thr=thr@entry=0x557144f2d508) at /mariadb/10.6/storage/innobase/row/row0purge.cc:1172
#16 0x00005571431da5e1 in que_thr_step (thr=thr@entry=0x557144f2d508) at /mariadb/10.6/storage/innobase/que/que0que.cc:653
#17 0x00005571431da7c2 in que_run_threads_low (thr=thr@entry=0x557144f2d508) at /mariadb/10.6/storage/innobase/que/que0que.cc:709
#18 0x00005571431da87f in que_run_threads (thr=thr@entry=0x557144f2d508) at /mariadb/10.6/storage/innobase/que/que0que.cc:729
#19 0x00005571432610ac in srv_task_execute () at /mariadb/10.6/storage/innobase/srv/srv0srv.cc:1656
#20 0x0000557143261794 in purge_worker_callback () at /mariadb/10.6/storage/innobase/srv/srv0srv.cc:1899
I think that a similar problem (crash of a non-debug server) may affect DROP TABLE as well as any table rebuild operation (including OPTIMIZE TABLE and TRUNCATE TABLE) on tables that contain FULLTEXT INDEX.
Attachments
Issue Links
relates to
MDEV-29277On error, fts_sync_table() fails to release a table handle
Closed
MDEV-27783InnoDB: Failing assertion: table->get_ref_count() == 0 upon ALTER TABLE ... MODIFY COLUMN
So far, I failed to reproduce the crash with the following test, which is based on the failing section of the main.alter_table test:
--source include/have_innodb.inc
CREATETABLE ti1(a INTNOTNULL, b INT, c INT) engine=InnoDB;
ALTERTABLE ti1 ADDCOLUMN d VARCHAR(200);
ALTERTABLE ti1 ADDCOLUMN d2 VARCHAR(200);
ALTERTABLE ti1 ADDCOLUMN e ENUM('a', 'b') FIRST;
ALTERTABLE ti1 ADDCOLUMN f INTAFTER a;
ALTERTABLE ti1 ADD FULLTEXT INDEX ii3 (d), ALGORITHM=INPLACE;
ALTERTABLE ti1 ADD FULLTEXT INDEX ii4 (d2);
ALTERTABLE ti1 ADDPRIMARYKEY(a);
DROPTABLE ti1;
I think that purge is running on the table because of the hidden metadata records for instant ADD COLUMN. I believe that the following test should be equivalent, but also it fails to fail for me:
--source include/have_innodb.inc
CREATETABLE ti1(a SERIAL, d VARCHAR(200), FULLTEXT INDEX(d)) ENGINE=InnoDB;
let $N=10;
while ($N) {
INSERTINTO ti1 SET a=NULL;
dec $N;
}
let $N=10;
while ($N) {
DELETEFROM ti1 LIMIT 1;
dec $N;
}
ALTERTABLE ti1 FORCE, ALGORITHM=COPY;
DROPTABLE ti1;
Marko Mäkelä
added a comment - So far, I failed to reproduce the crash with the following test, which is based on the failing section of the main.alter_table test:
--source include/have_innodb.inc
CREATE TABLE ti1(a INT NOT NULL , b INT , c INT ) engine=InnoDB;
ALTER TABLE ti1 ADD COLUMN d VARCHAR (200);
ALTER TABLE ti1 ADD COLUMN d2 VARCHAR (200);
ALTER TABLE ti1 ADD COLUMN e ENUM( 'a' , 'b' ) FIRST ;
ALTER TABLE ti1 ADD COLUMN f INT AFTER a;
ALTER TABLE ti1 ADD FULLTEXT INDEX ii3 (d), ALGORITHM=INPLACE;
ALTER TABLE ti1 ADD FULLTEXT INDEX ii4 (d2);
ALTER TABLE ti1 ADD PRIMARY KEY (a);
DROP TABLE ti1;
I think that purge is running on the table because of the hidden metadata records for instant ADD COLUMN . I believe that the following test should be equivalent, but also it fails to fail for me:
--source include/have_innodb.inc
CREATE TABLE ti1(a SERIAL, d VARCHAR (200), FULLTEXT INDEX (d)) ENGINE=InnoDB;
let $N=10;
while ($N) {
INSERT INTO ti1 SET a= NULL ;
dec $N;
}
let $N=10;
while ($N) {
DELETE FROM ti1 LIMIT 1;
dec $N;
}
ALTER TABLE ti1 FORCE , ALGORITHM=COPY;
DROP TABLE ti1;
With the following code patch, I finally had some success, on the 38th round when running 115 concurrent tests and --innodb-purge-threads=20. This was with the last test variant (CREATE, INSERT, DELETE, ALTER, DROP):
mysqltest: At line 16: query 'DROP TABLE ti1' failed: <Unknown> (2013): Lost connection to server during query
I think that it could have failed in a similar way during the ALTER TABLE, but I may be mistaken.
The patch introduces a sleep and disables a condition that could prevent the problem from reproducing with the reduced test.
Marko Mäkelä
added a comment - With the following code patch, I finally had some success, on the 38th round when running 115 concurrent tests and --innodb-purge-threads=20 . This was with the last test variant ( CREATE , INSERT , DELETE , ALTER , DROP ):
mysqltest: At line 16: query 'DROP TABLE ti1' failed: <Unknown> (2013): Lost connection to server during query
I think that it could have failed in a similar way during the ALTER TABLE , but I may be mistaken.
The patch introduces a sleep and disables a condition that could prevent the problem from reproducing with the reduced test.
diff --git a/storage/innobase/include/row0purge.h b/storage/innobase/include/row0purge.h
index 34af658cb12..8681b64cee9 100644
--- a/storage/innobase/include/row0purge.h
+++ b/storage/innobase/include/row0purge.h
@@ -238,7 +238,8 @@ struct purge_node_t{
bool retain_mdl(table_id_t table_id)
{
ut_ad(table_id);
- if (last_table_id == table_id && mdl_hold_recs < 100)
+ std::this_thread::sleep_for(std::chrono::milliseconds(1));
+ if (0 && last_table_id == table_id && mdl_hold_recs < 100)
{
ut_ad(table);
mdl_hold_recs++;
The revised patch looks correct to me. OK to push after addressing my comments, and after this has passed stress testing.
Marko Mäkelä
added a comment - The revised patch looks correct to me. OK to push after addressing my comments, and after this has passed stress testing.
is not caused by the modifications for MDEV-29250 I vote for pushing MDEV-29250.
Matthias Leich
added a comment -
origin/bb-10.6-MDEV-29250 d3d8e91f51ed289d43ac91eb1d8ba9d11c904cb5 2022-08-18T16:24:26+05:30
performed quite well in RQG testing.
Especially remarkable is the clear smaller amount of failing crash recovery tests compared to
origin/10.6 af552f2903b9764e3bc0634a0037c39d1a837f4f 2022-08-16T21:33:45+05:30
In case the first time seen problem
mysqld: /data/Server/bb-10.6-MDEV-29250/storage/innobase/include/dict0mem.h:1348: void dict_index_t::init_change_cols(unsigned int): Assertion `n_fields > n_cols' failed.
is not caused by the modifications for MDEV-29250 I vote for pushing MDEV-29250.
People
Thirunarayanan Balathandayuthapani
Marko Mäkelä
Votes:
1Vote for this issue
Watchers:
6Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":1908.6000000238419,"ttfb":721.5,"pageVisibility":"visible","entityId":113492,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"c40eeb86-e16e-4404-bfff-6f64fe81f75e","navigationType":0,"readyForUser":1992.300000011921,"redirectCount":0,"resourceLoadedEnd":2210.100000023842,"resourceLoadedStart":728.3000000119209,"resourceTiming":[{"duration":683.4000000357628,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":728.3000000119209,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":728.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1411.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":683.5,"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":728.6000000238419,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":728.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1412.1000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":692.8000000119209,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":728.8000000119209,"connectEnd":728.8000000119209,"connectStart":728.8000000119209,"domainLookupEnd":728.8000000119209,"domainLookupStart":728.8000000119209,"fetchStart":728.8000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":728.8000000119209,"responseEnd":1421.6000000238419,"responseStart":1421.6000000238419,"secureConnectionStart":728.8000000119209},{"duration":758.3999999761581,"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":728.9000000357628,"connectEnd":728.9000000357628,"connectStart":728.9000000357628,"domainLookupEnd":728.9000000357628,"domainLookupStart":728.9000000357628,"fetchStart":728.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":728.9000000357628,"responseEnd":1487.300000011921,"responseStart":1487.300000011921,"secureConnectionStart":728.9000000357628},{"duration":762.3000000119209,"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":729.1000000238419,"connectEnd":729.1000000238419,"connectStart":729.1000000238419,"domainLookupEnd":729.1000000238419,"domainLookupStart":729.1000000238419,"fetchStart":729.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":729.1000000238419,"responseEnd":1491.4000000357628,"responseStart":1491.4000000357628,"secureConnectionStart":729.1000000238419},{"duration":762.5,"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":729.3000000119209,"connectEnd":729.3000000119209,"connectStart":729.3000000119209,"domainLookupEnd":729.3000000119209,"domainLookupStart":729.3000000119209,"fetchStart":729.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":729.3000000119209,"responseEnd":1491.800000011921,"responseStart":1491.800000011921,"secureConnectionStart":729.3000000119209},{"duration":762.6999999880791,"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":729.6000000238419,"connectEnd":729.6000000238419,"connectStart":729.6000000238419,"domainLookupEnd":729.6000000238419,"domainLookupStart":729.6000000238419,"fetchStart":729.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":729.6000000238419,"responseEnd":1492.300000011921,"responseStart":1492.300000011921,"secureConnectionStart":729.6000000238419},{"duration":849.7999999523163,"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":729.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":729.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1579.5,"responseStart":0,"secureConnectionStart":0},{"duration":763,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":729.9000000357628,"connectEnd":729.9000000357628,"connectStart":729.9000000357628,"domainLookupEnd":729.9000000357628,"domainLookupStart":729.9000000357628,"fetchStart":729.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":729.9000000357628,"responseEnd":1492.9000000357628,"responseStart":1492.9000000357628,"secureConnectionStart":729.9000000357628},{"duration":849.9000000357628,"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":730,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":730,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1579.9000000357628,"responseStart":0,"secureConnectionStart":0},{"duration":763.3999999761581,"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":730.1000000238419,"connectEnd":730.1000000238419,"connectStart":730.1000000238419,"domainLookupEnd":730.1000000238419,"domainLookupStart":730.1000000238419,"fetchStart":730.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":730.1000000238419,"responseEnd":1493.5,"responseStart":1493.5,"secureConnectionStart":730.1000000238419},{"duration":1443.3999999761581,"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":737.7000000476837,"connectEnd":737.7000000476837,"connectStart":737.7000000476837,"domainLookupEnd":737.7000000476837,"domainLookupStart":737.7000000476837,"fetchStart":737.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":737.7000000476837,"responseEnd":2181.100000023842,"responseStart":2181.100000023842,"secureConnectionStart":737.7000000476837},{"duration":1437.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":744,"connectEnd":744,"connectStart":744,"domainLookupEnd":744,"domainLookupStart":744,"fetchStart":744,"redirectEnd":0,"redirectStart":0,"requestStart":744,"responseEnd":2181.5,"responseStart":2181.5,"secureConnectionStart":744},{"duration":200.69999998807907,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1601.1000000238419,"connectEnd":1601.1000000238419,"connectStart":1601.1000000238419,"domainLookupEnd":1601.1000000238419,"domainLookupStart":1601.1000000238419,"fetchStart":1601.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":1601.1000000238419,"responseEnd":1801.800000011921,"responseStart":1801.800000011921,"secureConnectionStart":1601.1000000238419},{"duration":349.5,"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":1860.4000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1860.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2209.900000035763,"responseStart":0,"secureConnectionStart":0},{"duration":349.10000002384186,"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":1861,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1861,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2210.100000023842,"responseStart":0,"secureConnectionStart":0},{"duration":332.19999998807907,"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":1861.9000000357628,"connectEnd":1861.9000000357628,"connectStart":1861.9000000357628,"domainLookupEnd":1861.9000000357628,"domainLookupStart":1861.9000000357628,"fetchStart":1861.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":1861.9000000357628,"responseEnd":2194.100000023842,"responseStart":2194,"secureConnectionStart":1861.9000000357628},{"duration":343.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/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","startTime":1862.4000000357628,"connectEnd":1862.4000000357628,"connectStart":1862.4000000357628,"domainLookupEnd":1862.4000000357628,"domainLookupStart":1862.4000000357628,"fetchStart":1862.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":1862.4000000357628,"responseEnd":2205.600000023842,"responseStart":2205.600000023842,"secureConnectionStart":1862.4000000357628},{"duration":379.0999999642372,"initiatorType":"script","name":"https://jira.mariadb.org/s/86ee9bbc76cd1bcd8556fcdcf46241c9-CDN/lu2bu7/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/js/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.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":1862.7000000476837,"connectEnd":1862.7000000476837,"connectStart":1862.7000000476837,"domainLookupEnd":1862.7000000476837,"domainLookupStart":1862.7000000476837,"fetchStart":1862.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1862.7000000476837,"responseEnd":2241.800000011921,"responseStart":2241.800000011921,"secureConnectionStart":1862.7000000476837}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":538,"responseStart":722,"responseEnd":743,"domLoading":727,"domInteractive":2211,"domContentLoadedEventStart":2211,"domContentLoadedEventEnd":2272,"domComplete":2827,"loadEventStart":2827,"loadEventEnd":2828,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2186.600000023842},{"name":"bigPipe.sidebar-id.end","time":2187.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":2187.600000023842},{"name":"bigPipe.activity-panel-pipe-id.end","time":2191},{"name":"activityTabFullyLoaded","time":2299.800000011921}],"measures":[],"correlationId":"3d7984f3cfa880","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":118,"dbReadsTimeInMs":20,"dbConnsTimeInMs":29,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Critical
So far, I failed to reproduce the crash with the following test, which is based on the failing section of the main.alter_table test:
--source include/have_innodb.incI think that purge is running on the table because of the hidden metadata records for instant ADD COLUMN. I believe that the following test should be equivalent, but also it fails to fail for me:
--source include/have_innodb.inclet $N=10;while ($N) {}let $N=10;while ($N) {}