Type:
Bug
Priority:
Critical
Resolution:
Unresolved
Affects Version/s:
10.5 , 10.6 , 10.11 , 11.1(EOL) , 11.2(EOL) , 11.3(EOL)
Sprint:
Q2/2025 Development
# Requires standard m/s replication. Use RBR or MBR.
SET binlog_row_image= 'NOBLOB' ;
CREATE TABLE t (c INT PRIMARY KEY , d INT , i BLOB GENERATED ALWAYS AS (c), KEY k(i)) ENGINE=InnoDB;
CREATE TEMPORARY TABLE t2 (c INT ) ENGINE=InnoDB;
INSERT INTO t (c) VALUES (1);
SELECT * FROM performance_schema.global_status;
UPDATE t SET d=0;
Leads to:
10.6.18 33af5575a976c86163752cce77dddb640ffeef00 (Optimized, Slave)
2024-04-23 10:31:44 6 [ERROR] InnoDB: Record in index `k` of table `test`.`t` was not found on update: TUPLE (info_bits=0, 2 fields): {NULL,[4] (0x80000001)} at: COMPACT RECORD(info_bits=0, 1 fields): {[8]infimum (0x696E66696D756D00)}
2024-04-23 10:31:44 6 [ERROR] InnoDB: We detected index corruption in an InnoDB type table. You have to dump + drop + reimport the table or, in a case of widespread corruption, dump all InnoDB tables and recreate the whole tablespace. If the mariadbd server crashes after the startup or when you dump the tables. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2024-04-23 10:31:44 6 [Warning] InnoDB: Record in index `k` of table `test`.`t` was not found on rollback, trying to insert: TUPLE (info_bits=0, 2 fields): {NULL,[4] (0x80000001)} at: COMPACT RECORD(info_bits=0, 1 fields): {[8]infimum (0x696E66696D756D00)}
2024-04-23 10:31:44 6 [ERROR] mariadbd: Index for table 't' is corrupt; try to repair it
2024-04-23 10:31:44 6 [ERROR] Slave SQL: Could not execute Update_rows_v1 event on table test.t; Index for table 't' is corrupt; try to repair it, Error_code: 1034; handler error HA_ERR_CRASHED; the event's master log binlog.000001, end_log_pos 1595, Gtid 0-1-7, Internal MariaDB error code: 1034
2024-04-23 10:31:44 6 [Warning] Slave: Index for table 't' is corrupt; try to repair it Error_code: 1034
2024-04-23 10:31:44 6 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'binlog.000001' position 1416; GTID position '0-1-6'
May seem lightly sporadic, but is more likely timing-based (i.e. SLEEP's etc. may help to reduce any light sporadicity).
Both dbg+opt affected. PS required. The specific PS table queried does not seem to matter.
The issue has been reproduced in the versions listed above, but not in 11.4, 11.5.
{"report":{"fcp":813.4000000953674,"ttfb":222.30000019073486,"pageVisibility":"visible","entityId":128843,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"2796b93e-de1c-4835-abbb-90dbbe63ab50","navigationType":0,"readyForUser":896.1000001430511,"redirectCount":0,"resourceLoadedEnd":908.4000000953674,"resourceLoadedStart":227.40000009536743,"resourceTiming":[{"duration":62,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":227.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":227.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":289.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":62.200000047683716,"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":227.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":227.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":289.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":127.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":227.80000019073486,"connectEnd":227.80000019073486,"connectStart":227.80000019073486,"domainLookupEnd":227.80000019073486,"domainLookupStart":227.80000019073486,"fetchStart":227.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":227.80000019073486,"responseEnd":355.10000014305115,"responseStart":355.10000014305115,"secureConnectionStart":227.80000019073486},{"duration":213.29999995231628,"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":227.90000009536743,"connectEnd":227.90000009536743,"connectStart":227.90000009536743,"domainLookupEnd":227.90000009536743,"domainLookupStart":227.90000009536743,"fetchStart":227.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":227.90000009536743,"responseEnd":441.2000000476837,"responseStart":441.2000000476837,"secureConnectionStart":227.90000009536743},{"duration":217,"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":228.10000014305115,"connectEnd":228.10000014305115,"connectStart":228.10000014305115,"domainLookupEnd":228.10000014305115,"domainLookupStart":228.10000014305115,"fetchStart":228.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":228.10000014305115,"responseEnd":445.10000014305115,"responseStart":445.10000014305115,"secureConnectionStart":228.10000014305115},{"duration":217.39999985694885,"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":228.10000014305115,"connectEnd":228.10000014305115,"connectStart":228.10000014305115,"domainLookupEnd":228.10000014305115,"domainLookupStart":228.10000014305115,"fetchStart":228.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":228.10000014305115,"responseEnd":445.5,"responseStart":445.5,"secureConnectionStart":228.10000014305115},{"duration":217.79999995231628,"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":228.20000004768372,"connectEnd":228.20000004768372,"connectStart":228.20000004768372,"domainLookupEnd":228.20000004768372,"domainLookupStart":228.20000004768372,"fetchStart":228.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":228.20000004768372,"responseEnd":446,"responseStart":446,"secureConnectionStart":228.20000004768372},{"duration":218,"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":228.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":228.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":446.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":217.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":228.5,"connectEnd":228.5,"connectStart":228.5,"domainLookupEnd":228.5,"domainLookupStart":228.5,"fetchStart":228.5,"redirectEnd":0,"redirectStart":0,"requestStart":228.5,"responseEnd":446.30000019073486,"responseStart":446.30000019073486,"secureConnectionStart":228.5},{"duration":218.20000004768372,"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":228.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":228.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":446.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":218.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":228.60000014305115,"connectEnd":228.60000014305115,"connectStart":228.60000014305115,"domainLookupEnd":228.60000014305115,"domainLookupStart":228.60000014305115,"fetchStart":228.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":228.60000014305115,"responseEnd":446.90000009536743,"responseStart":446.90000009536743,"secureConnectionStart":228.60000014305115},{"duration":464.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":234.40000009536743,"connectEnd":234.40000009536743,"connectStart":234.40000009536743,"domainLookupEnd":234.40000009536743,"domainLookupStart":234.40000009536743,"fetchStart":234.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":234.40000009536743,"responseEnd":699.2000000476837,"responseStart":699.2000000476837,"secureConnectionStart":234.40000009536743},{"duration":528.5999999046326,"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":234.80000019073486,"connectEnd":234.80000019073486,"connectStart":234.80000019073486,"domainLookupEnd":234.80000019073486,"domainLookupStart":234.80000019073486,"fetchStart":234.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":234.80000019073486,"responseEnd":763.4000000953674,"responseStart":763.4000000953674,"secureConnectionStart":234.80000019073486},{"duration":187.69999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":511.80000019073486,"connectEnd":511.80000019073486,"connectStart":511.80000019073486,"domainLookupEnd":511.80000019073486,"domainLookupStart":511.80000019073486,"fetchStart":511.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":511.80000019073486,"responseEnd":699.5,"responseStart":699.5,"secureConnectionStart":511.80000019073486},{"duration":92.70000004768372,"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":715.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":715.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":808.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":93.60000014305115,"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":716.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":716.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":809.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":182.20000004768372,"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":716.9000000953674,"connectEnd":716.9000000953674,"connectStart":716.9000000953674,"domainLookupEnd":716.9000000953674,"domainLookupStart":716.9000000953674,"fetchStart":716.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":716.9000000953674,"responseEnd":899.1000001430511,"responseStart":899.1000001430511,"secureConnectionStart":716.9000000953674},{"duration":189.69999980926514,"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":717.3000001907349,"connectEnd":717.3000001907349,"connectStart":717.3000001907349,"domainLookupEnd":717.3000001907349,"domainLookupStart":717.3000001907349,"fetchStart":717.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":717.3000001907349,"responseEnd":907,"responseStart":907,"secureConnectionStart":717.3000001907349},{"duration":190.70000004768372,"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":717.7000000476837,"connectEnd":717.7000000476837,"connectStart":717.7000000476837,"domainLookupEnd":717.7000000476837,"domainLookupStart":717.7000000476837,"fetchStart":717.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":717.7000000476837,"responseEnd":908.4000000953674,"responseStart":908.4000000953674,"secureConnectionStart":717.7000000476837},{"duration":102.80000019073486,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":806.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":806.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":909.3000001907349,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":100,"responseStart":223,"responseEnd":234,"domLoading":226,"domInteractive":969,"domContentLoadedEventStart":969,"domContentLoadedEventEnd":1020,"domComplete":1705,"loadEventStart":1705,"loadEventEnd":1707,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":936.8000001907349},{"name":"bigPipe.sidebar-id.end","time":937.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":937.6000001430511},{"name":"bigPipe.activity-panel-pipe-id.end","time":940},{"name":"activityTabFullyLoaded","time":1032.4000000953674}],"measures":[],"correlationId":"c45b13b5d165cc","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":71,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}