The following test, based on a test in a MySQL 8.0 fix BUG #26818787: ASSERTION: DATA0DATA.IC:430:TUPLE causes a crash in InnoDB:
diff --git a/mysql-test/suite/gcol/t/innodb_virtual_debug_purge.test b/mysql-test/suite/gcol/t/innodb_virtual_debug_purge.test
|
index 1862de268af..5e2cf3fd59b 100644
|
--- a/mysql-test/suite/gcol/t/innodb_virtual_debug_purge.test
|
+++ b/mysql-test/suite/gcol/t/innodb_virtual_debug_purge.test
|
@@ -184,7 +184,8 @@ connection default;
|
update t set a = repeat('m', 16000) where a like "aaa%";
|
connect(lock_table, localhost, root);
|
lock table t write;
|
-disconnect prevent_purge;
|
+connection prevent_purge;
|
+commit;
|
connection default;
|
--source ../../innodb/include/wait_all_purged.inc
|
disconnect lock_table;
|
@@ -194,6 +195,28 @@ commit;
|
set global debug_dbug=@old_dbug;
|
drop table t;
|
|
+CREATE TABLE t1(
|
+ u INT PRIMARY KEY, b BLOB, ug INT GENERATED ALWAYS AS (u) VIRTUAL,
|
+ INDEX bug(b(100),ug)
|
+) ENGINE=InnoDB;
|
+INSERT INTO t1 (u,b) VALUES(1,REPEAT('a',16384));
|
+connection prevent_purge;
|
+start transaction with consistent snapshot;
|
+connection default;
|
+DELETE FROM t1;
|
+SET DEBUG_SYNC='blob_write_middle SIGNAL halfway WAIT_FOR purged';
|
+send INSERT INTO t1 (u,b) VALUES(1,REPEAT('a',16384));
|
+connection prevent_purge;
|
+SET DEBUG_SYNC='now WAIT_FOR halfway';
|
+COMMIT;
|
+--source ../../innodb/include/wait_all_purged.inc
|
+SET DEBUG_SYNC='now SIGNAL purged';
|
+disconnect prevent_purge;
|
+
|
+connection default;
|
+reap;
|
+DROP TABLE t1;
|
+
|
--source include/wait_until_count_sessions.inc
|
set debug_sync=reset;
|
SET GLOBAL innodb_purge_rseg_truncate_frequency = @saved_frequency;
|
error log
|
Version: '10.2.13-MariaDB-debug-log' socket: '/mariadb/10.2-ext/build/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
|
mysqld: /mariadb/10.2-ext/storage/innobase/include/data0data.ic:429: dfield_t* dtuple_get_nth_field(const dtuple_t*, ulint): Assertion `tuple' failed.
|
…
|
mysys/stacktrace.c:267(my_print_stacktrace)[0x55a6a0877ec9]
|
include/data0data.ic:430(dtuple_get_nth_field(dtuple_t const*, unsigned long))[0x55a6a08784e3]
|
row/row0purge.cc:584(0purge.cc:477)[0x55a6a0878b49]
|
que/que0que.cc:1055(que_thr_step(que_thr_t*))[0x55a6a0758888]
|
que/que0que.cc:1117(que_run_threads_low(que_thr_t*))[0x55a6a0758c35]
|
que/que0que.cc:1159(que_run_threads(que_thr_t*))[0x55a6a0758fde]
|
srv/srv0srv.cc:2561(srv_task_execute())[0x55a6a094083e]
|
srv/srv0srv.cc:2606(srv_worker_thread)[0x55a6a09409c4]
|
{"report":{"fcp":732.8999998569489,"ttfb":172.19999980926514,"pageVisibility":"visible","entityId":65661,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"dac8308f-db23-4c53-acc1-14f48a53c6be","navigationType":0,"readyForUser":801.0999999046326,"redirectCount":0,"resourceLoadedEnd":788,"resourceLoadedStart":177.69999980926514,"resourceTiming":[{"duration":135.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":177.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":177.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":313.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":135.59999990463257,"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":178,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":178,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":313.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":145.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":178.09999990463257,"connectEnd":178.09999990463257,"connectStart":178.09999990463257,"domainLookupEnd":178.09999990463257,"domainLookupStart":178.09999990463257,"fetchStart":178.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":178.09999990463257,"responseEnd":324,"responseStart":324,"secureConnectionStart":178.09999990463257},{"duration":211.79999995231628,"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":178.09999990463257,"connectEnd":178.09999990463257,"connectStart":178.09999990463257,"domainLookupEnd":178.09999990463257,"domainLookupStart":178.09999990463257,"fetchStart":178.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":178.09999990463257,"responseEnd":389.89999985694885,"responseStart":389.89999985694885,"secureConnectionStart":178.09999990463257},{"duration":215.20000004768372,"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":178.29999995231628,"connectEnd":178.29999995231628,"connectStart":178.29999995231628,"domainLookupEnd":178.29999995231628,"domainLookupStart":178.29999995231628,"fetchStart":178.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":178.29999995231628,"responseEnd":393.5,"responseStart":393.5,"secureConnectionStart":178.29999995231628},{"duration":215.40000009536743,"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":178.39999985694885,"connectEnd":178.39999985694885,"connectStart":178.39999985694885,"domainLookupEnd":178.39999985694885,"domainLookupStart":178.39999985694885,"fetchStart":178.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":178.39999985694885,"responseEnd":393.7999999523163,"responseStart":393.7999999523163,"secureConnectionStart":178.39999985694885},{"duration":216.09999990463257,"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":178.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":178.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":394.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":215.69999980926514,"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":178.5,"connectEnd":178.5,"connectStart":178.5,"domainLookupEnd":178.5,"domainLookupStart":178.5,"fetchStart":178.5,"redirectEnd":0,"redirectStart":0,"requestStart":178.5,"responseEnd":394.19999980926514,"responseStart":394.19999980926514,"secureConnectionStart":178.5},{"duration":215.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":178.69999980926514,"connectEnd":178.69999980926514,"connectStart":178.69999980926514,"domainLookupEnd":178.69999980926514,"domainLookupStart":178.69999980926514,"fetchStart":178.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":178.69999980926514,"responseEnd":394.59999990463257,"responseStart":394.59999990463257,"secureConnectionStart":178.69999980926514},{"duration":216.29999995231628,"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":178.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":178.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":395.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":216.29999995231628,"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":178.89999985694885,"connectEnd":178.89999985694885,"connectStart":178.89999985694885,"domainLookupEnd":178.89999985694885,"domainLookupStart":178.89999985694885,"fetchStart":178.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":178.89999985694885,"responseEnd":395.19999980926514,"responseStart":395.19999980926514,"secureConnectionStart":178.89999985694885},{"duration":600,"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":179.69999980926514,"connectEnd":179.69999980926514,"connectStart":179.69999980926514,"domainLookupEnd":179.69999980926514,"domainLookupStart":179.69999980926514,"fetchStart":179.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":179.69999980926514,"responseEnd":779.6999998092651,"responseStart":779.5999999046326,"secureConnectionStart":179.69999980926514},{"duration":608.3000001907349,"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":179.69999980926514,"connectEnd":179.69999980926514,"connectStart":179.69999980926514,"domainLookupEnd":179.69999980926514,"domainLookupStart":179.69999980926514,"fetchStart":179.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":179.69999980926514,"responseEnd":788,"responseStart":788,"secureConnectionStart":179.69999980926514},{"duration":243.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":537.5999999046326,"connectEnd":537.5999999046326,"connectStart":537.5999999046326,"domainLookupEnd":537.5999999046326,"domainLookupStart":537.5999999046326,"fetchStart":537.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":537.5999999046326,"responseEnd":781.1999998092651,"responseStart":781.1999998092651,"secureConnectionStart":537.5999999046326},{"duration":84.20000004768372,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":712.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":712.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":796.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":31,"responseStart":172,"responseEnd":176,"domLoading":175,"domInteractive":919,"domContentLoadedEventStart":919,"domContentLoadedEventEnd":961,"domComplete":1642,"loadEventStart":1642,"loadEventEnd":1643,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":900.5},{"name":"bigPipe.sidebar-id.end","time":901.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":901.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":903.6999998092651},{"name":"activityTabFullyLoaded","time":972}],"measures":[],"correlationId":"9f43a4b78ec07d","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":72,"dbReadsTimeInMs":10,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}