Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
5.5(EOL) , 10.0(EOL) , 10.1(EOL) , 10.2(EOL) , 10.3(EOL) , 10.4(EOL)
I wanted to see if the MDEV-20934 test case covers the case where the change buffer contains entries that are beyond the end of the tablespace. It seems to be fine, but the test will crash on DROP TABLE because the .ibd file is corrupted:
diff --git a/mysql-test/suite/innodb/t/ibuf_not_empty.test b/mysql-test/suite/innodb/t/ibuf_not_empty.test
index 8b16d197e03..a5093892b35 100644
--- a/mysql-test/suite/innodb/t/ibuf_not_empty.test
+++ b/mysql-test/suite/innodb/t/ibuf_not_empty.test
@@ -73,8 +73,32 @@ EOF
--replace_regex /contains \d+ entries/contains #### entries/
check table t1;
+--source include/shutdown_mysqld.inc
+
+# Truncate the file to 5 pages, as if it were empty
+perl;
+do "$ENV{MTR_SUITE_DIR}/include/crc32.pl";
+my $file = "$ENV{MYSQLD_DATADIR}/test/t1.ibd";
+open(FILE, "+<$file") || die "Unable to open $file";
+binmode FILE;
+my $ps= $ENV{PAGE_SIZE};
+my $pages=5;
+my $page;
+die "Unable to read $file" unless sysread(FILE, $page, $ps) == $ps;
+substr($page,46,4)=pack("N", $pages);
+my $polynomial = 0x82f63b78; # CRC-32C
+my $ck= pack("N",mycrc32(substr($page, 4, 22), 0, $polynomial) ^
+ mycrc32(substr($page, 38, $ps - 38 - 8), 0, $polynomial));
+substr($page,0,4)=$ck;
+substr($page,$ps-8,4)=$ck;
+sysseek(FILE, 0, 0) || die "Unable to rewind $file\n";
+syswrite(FILE, $page, $ps)==$ps || die "Unable to write $file\n";
+truncate(FILE, $ps * $pages);
+close(FILE) || die "Unable to close $file";
+EOF
+
--let $restart_parameters=
---source include/restart_mysqld.inc
+--source include/start_mysqld.inc
SET GLOBAL innodb_fast_shutdown=0;
--source include/restart_mysqld.inc
10.2 bd2b05df6c5806e599698eb239b3e44b971eb031
CURRENT_TEST: innodb.ibuf_not_empty
mysqltest: At line 106: query 'DROP TABLE t1' failed: 2013: Lost connection to MySQL server during query
…
Version: '10.2.30-MariaDB-debug-log' socket: '/mariadb/10.2/build/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
mysqld: /mariadb/10.2/storage/innobase/fsp/fsp0fsp.cc:204: ulint xdes_mtr_get_bit(const xdes_t *, ulint, ulint, mtr_t *): Assertion `(mtr)->memo_contains_page_flagged((descr), (MTR_MEMO_PAGE_SX_FIX))' failed.
…
#7 0x0000562e4329d129 in fseg_free_page_low (seg_inode=<optimized out>, space=<optimized out>, offset=17, page_size=..., ahi=<optimized out>, mtr=0x7fec0564ca38) at /mariadb/10.2/storage/innobase/fsp/fsp0fsp.cc:3098
#8 0x0000562e4329e7d2 in fseg_free_step_func (header=0x7fec05e3804a "", ahi=true, mtr=0x7fec0564ca38) at /mariadb/10.2/storage/innobase/fsp/fsp0fsp.cc:3330
#9 0x0000562e43190c7b in btr_free_but_not_root (block=0x7fec0592be90, log_mode=MTR_LOG_ALL) at /mariadb/10.2/storage/innobase/btr/btr0btr.cc:1256
#10 0x0000562e4319090c in btr_free_if_exists (page_id=..., page_size=..., index_id=21, mtr=0x7fec0564d548) at /mariadb/10.2/storage/innobase/btr/btr0btr.cc:1305
#11 0x0000562e43228408 in dict_drop_index_tree (rec=<optimized out>, pcur=<optimized out>, mtr=0x7fec0564d548) at /mariadb/10.2/storage/innobase/dict/dict0crea.cc:1019
#12 0x0000562e43112b36 in row_upd_clust_step (node=0x7febb40417a8, thr=0x7febb4043608) at /mariadb/10.2/storage/innobase/row/row0upd.cc:3125
#13 row_upd (node=0x7febb40417a8, thr=<optimized out>) at /mariadb/10.2/storage/innobase/row/row0upd.cc:3291
#14 0x0000562e431123f3 in row_upd_step (thr=0x7febb4043608) at /mariadb/10.2/storage/innobase/row/row0upd.cc:3437
#15 0x0000562e4307c256 in que_thr_step (thr=<optimized out>) at /mariadb/10.2/storage/innobase/que/que0que.cc:1022
#16 que_run_threads_low (thr=0x7febb4043608) at /mariadb/10.2/storage/innobase/que/que0que.cc:1102
#17 que_run_threads (thr=0x7febb4043608) at /mariadb/10.2/storage/innobase/que/que0que.cc:1142
#18 0x0000562e4307cd13 in que_eval_sql (info=0x7febb4047a48, sql=0x562e435eadb7 "PROCEDURE DROP_TABLE_PROC () IS\ntid CHAR;\niid CHAR;\nDECLARE CURSOR cur_idx IS\nSELECT ID FROM SYS_INDEXES\nWHERE TABLE_ID = tid FOR UPDATE;\nBEGIN\nSELECT ID INTO tid FROM SYS_TABLES\nWHERE NAME = :name FO"..., reserve_dict_mutex=0, trx=0x7fec0623c268) at /mariadb/10.2/storage/innobase/que/que0que.cc:1219
#19 0x0000562e430c65bc in row_drop_table_for_mysql (name=<optimized out>, trx=0x7fec0623c268, sqlcom=SQLCOM_DROP_TABLE, create_failed=96, nonatomic=<optimized out>) at /mariadb/10.2/storage/innobase/row/row0mysql.cc:3632
#20 0x0000562e42fb9805 in ha_innobase::delete_table (this=<optimized out>, name=0x7fec0564fff0 "./test/t1", sqlcom=SQLCOM_DROP_TABLE) at /mariadb/10.2/storage/innobase/handler/ha_innodb.cc:13392
The call to btr_free_if_exists() seems totally unnecessary in this case, because we are going to delete the entire .ibd file.
{"report":{"fcp":1381.4000000953674,"ttfb":426.60000014305115,"pageVisibility":"visible","entityId":80497,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"e1350a5f-61d5-48fa-8d4d-bed9fc92f4f3","navigationType":0,"readyForUser":1481.6000001430511,"redirectCount":0,"resourceLoadedEnd":1942.7000000476837,"resourceLoadedStart":437,"resourceTiming":[{"duration":400.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":437,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":437,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":837.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":400.2999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":437.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":437.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":837.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":409.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":437.5,"connectEnd":437.5,"connectStart":437.5,"domainLookupEnd":437.5,"domainLookupStart":437.5,"fetchStart":437.5,"redirectEnd":0,"redirectStart":0,"requestStart":437.5,"responseEnd":846.7000000476837,"responseStart":846.7000000476837,"secureConnectionStart":437.5},{"duration":532,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":438.10000014305115,"connectEnd":438.10000014305115,"connectStart":438.10000014305115,"domainLookupEnd":438.10000014305115,"domainLookupStart":438.10000014305115,"fetchStart":438.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":438.10000014305115,"responseEnd":970.1000001430511,"responseStart":970.1000001430511,"secureConnectionStart":438.10000014305115},{"duration":535.5999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":438.40000009536743,"connectEnd":438.40000009536743,"connectStart":438.40000009536743,"domainLookupEnd":438.40000009536743,"domainLookupStart":438.40000009536743,"fetchStart":438.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":438.40000009536743,"responseEnd":974,"responseStart":974,"secureConnectionStart":438.40000009536743},{"duration":536,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":438.5,"connectEnd":438.5,"connectStart":438.5,"domainLookupEnd":438.5,"domainLookupStart":438.5,"fetchStart":438.5,"redirectEnd":0,"redirectStart":0,"requestStart":438.5,"responseEnd":974.5,"responseStart":974.5,"secureConnectionStart":438.5},{"duration":536.1000001430511,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":438.7000000476837,"connectEnd":438.7000000476837,"connectStart":438.7000000476837,"domainLookupEnd":438.7000000476837,"domainLookupStart":438.7000000476837,"fetchStart":438.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":438.7000000476837,"responseEnd":974.8000001907349,"responseStart":974.8000001907349,"secureConnectionStart":438.7000000476837},{"duration":570.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":438.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":438.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1009.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":536.3000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":439,"connectEnd":439,"connectStart":439,"domainLookupEnd":439,"domainLookupStart":439,"fetchStart":439,"redirectEnd":0,"redirectStart":0,"requestStart":439,"responseEnd":975.3000001907349,"responseStart":975.3000001907349,"secureConnectionStart":439},{"duration":570.2999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":439.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":439.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1009.5,"responseStart":0,"secureConnectionStart":0},{"duration":536.5999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":439.30000019073486,"connectEnd":439.30000019073486,"connectStart":439.30000019073486,"domainLookupEnd":439.30000019073486,"domainLookupStart":439.30000019073486,"fetchStart":439.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":439.30000019073486,"responseEnd":975.9000000953674,"responseStart":975.9000000953674,"secureConnectionStart":439.30000019073486},{"duration":759.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":451.40000009536743,"connectEnd":451.40000009536743,"connectStart":451.40000009536743,"domainLookupEnd":451.40000009536743,"domainLookupStart":451.40000009536743,"fetchStart":451.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":451.40000009536743,"responseEnd":1210.8000001907349,"responseStart":1210.8000001907349,"secureConnectionStart":451.40000009536743},{"duration":1476.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":451.5,"connectEnd":451.5,"connectStart":451.5,"domainLookupEnd":451.5,"domainLookupStart":451.5,"fetchStart":451.5,"redirectEnd":0,"redirectStart":0,"requestStart":451.5,"responseEnd":1928.3000001907349,"responseStart":1928.3000001907349,"secureConnectionStart":451.5},{"duration":187.70000004768372,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1023.5,"connectEnd":1023.5,"connectStart":1023.5,"domainLookupEnd":1023.5,"domainLookupStart":1023.5,"fetchStart":1023.5,"redirectEnd":0,"redirectStart":0,"requestStart":1023.5,"responseEnd":1211.2000000476837,"responseStart":1211.2000000476837,"secureConnectionStart":1023.5},{"duration":639.8999998569489,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/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&whisper-enabled=true","startTime":1302.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1302.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1942.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":680.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/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&whisper-enabled=true","startTime":1303.7000000476837,"connectEnd":1303.7000000476837,"connectStart":1303.7000000476837,"domainLookupEnd":1303.7000000476837,"domainLookupStart":1303.7000000476837,"fetchStart":1303.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1303.7000000476837,"responseEnd":1984.1000001430511,"responseStart":1984.1000001430511,"secureConnectionStart":1303.7000000476837},{"duration":686.5999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/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&whisper-enabled=true","startTime":1304.1000001430511,"connectEnd":1304.1000001430511,"connectStart":1304.1000001430511,"domainLookupEnd":1304.1000001430511,"domainLookupStart":1304.1000001430511,"fetchStart":1304.1000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":1304.1000001430511,"responseEnd":1990.7000000476837,"responseStart":1990.7000000476837,"secureConnectionStart":1304.1000001430511}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":260,"responseStart":426,"responseEnd":450,"domLoading":430,"domInteractive":1952,"domContentLoadedEventStart":1952,"domContentLoadedEventEnd":1996,"domComplete":4051,"loadEventStart":4051,"loadEventEnd":4053,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1930.1000001430511},{"name":"bigPipe.sidebar-id.end","time":1931.1000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":1931.3000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1933.7000000476837},{"name":"activityTabFullyLoaded","time":2005.9000000953674}],"measures":[],"correlationId":"c54a7e1380a68","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":95,"dbReadsTimeInMs":14,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}