A user noticed that when he tries to use innochecksum with some of his 4 GB or larger tablespace files on Windows, the tool reports that the file doesn't exist:
X:\MySQL\Data>"c:\Program Files\MariaDB 10.1\bin\innochecksum.exe" .\ibdata1
|
InnoDB offline file checksum utility.
|
Error; .\ibdata1 cannot be found
|
The error seems to be getting raised here: https://github.com/MariaDB/server/blob/ec5bd0d3855aa49afc3e356aa18b7edea3b7a18b/extra/innochecksum.cc#L709
The user thinks that this check is probably failing on Windows for files larger than 4 GB, because MariaDB is probably using one of the Windows stat functions that uses 32-bit file sizes:
Variations of these functions support 32- or 64-bit time types, and 32- or 64-bit file lengths. The first numerical suffix (32 or 64) indicates the size of the time type used; the second suffix is either i32 or i64, indicating whether the file size is represented as a 32-bit or 64-bit integer.
_stat is equivalent to _stat64i32, and struct _stat contains a 64-bit time. This is true unless _USE_32BIT_TIME_T is defined, in which case the old behavior is in effect; _stat uses a 32-bit time, and struct _stat contains a 32-bit time. The same is true for _stati64.
https://msdn.microsoft.com/en-us/library/14h5k7ff.aspx
wlad's analysis:
struct stat has st_size member defined as _off_t , and _off_t is typedef to a long (not even unsigned), and long is 4 bytes on all Windows. So large file sizes would not fit. I never saw stat() failing in recent memory,
but we're not using stat() elsewhere either. My guess, it is the culprit.
Transition |
Time In Source Status |
Execution Times |
Open |
|
Closed |
|
15h 18m
|
1
|
{"report":{"fcp":690.6999999880791,"ttfb":168.30000001192093,"pageVisibility":"visible","entityId":58666,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"ac0541bb-39b4-4b0f-8a6f-2ddf6e4de5cc","navigationType":0,"readyForUser":749.3000000119209,"redirectCount":0,"resourceLoadedEnd":1154.6000000238419,"resourceLoadedStart":173.69999998807907,"resourceTiming":[{"duration":11.100000023841858,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":173.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":173.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":184.80000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":11.300000011920929,"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":173.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":173.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":185.19999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":69.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":174.10000002384186,"connectEnd":174.10000002384186,"connectStart":174.10000002384186,"domainLookupEnd":174.10000002384186,"domainLookupStart":174.10000002384186,"fetchStart":174.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":174.10000002384186,"responseEnd":243.80000001192093,"responseStart":243.80000001192093,"secureConnectionStart":174.10000002384186},{"duration":212,"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":174.19999998807907,"connectEnd":174.19999998807907,"connectStart":174.19999998807907,"domainLookupEnd":174.19999998807907,"domainLookupStart":174.19999998807907,"fetchStart":174.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":174.19999998807907,"responseEnd":386.19999998807907,"responseStart":386.19999998807907,"secureConnectionStart":174.19999998807907},{"duration":216.10000002384186,"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":174.39999997615814,"connectEnd":174.39999997615814,"connectStart":174.39999997615814,"domainLookupEnd":174.39999997615814,"domainLookupStart":174.39999997615814,"fetchStart":174.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":174.39999997615814,"responseEnd":390.5,"responseStart":390.5,"secureConnectionStart":174.39999997615814},{"duration":217.39999997615814,"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":174.60000002384186,"connectEnd":174.60000002384186,"connectStart":174.60000002384186,"domainLookupEnd":174.60000002384186,"domainLookupStart":174.60000002384186,"fetchStart":174.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":174.60000002384186,"responseEnd":392,"responseStart":392,"secureConnectionStart":174.60000002384186},{"duration":218.5,"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":174.80000001192093,"connectEnd":174.80000001192093,"connectStart":174.80000001192093,"domainLookupEnd":174.80000001192093,"domainLookupStart":174.80000001192093,"fetchStart":174.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":174.80000001192093,"responseEnd":393.30000001192093,"responseStart":393.30000001192093,"secureConnectionStart":174.80000001192093},{"duration":219.39999997615814,"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":175,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":175,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":394.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":219.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":175.10000002384186,"connectEnd":175.10000002384186,"connectStart":175.10000002384186,"domainLookupEnd":175.10000002384186,"domainLookupStart":175.10000002384186,"fetchStart":175.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":175.10000002384186,"responseEnd":394.5,"responseStart":394.5,"secureConnectionStart":175.10000002384186},{"duration":221.39999997615814,"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":175.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":175.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":396.69999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":220.60000002384186,"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":175.39999997615814,"connectEnd":175.39999997615814,"connectStart":175.39999997615814,"domainLookupEnd":175.39999997615814,"domainLookupStart":175.39999997615814,"fetchStart":175.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":175.39999997615814,"responseEnd":396,"responseStart":396,"secureConnectionStart":175.39999997615814},{"duration":971.1000000238419,"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":176.19999998807907,"connectEnd":176.19999998807907,"connectStart":176.19999998807907,"domainLookupEnd":176.19999998807907,"domainLookupStart":176.19999998807907,"fetchStart":176.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":176.19999998807907,"responseEnd":1147.300000011921,"responseStart":1147.300000011921,"secureConnectionStart":176.19999998807907},{"duration":972.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":176.30000001192093,"connectEnd":176.30000001192093,"connectStart":176.30000001192093,"domainLookupEnd":176.30000001192093,"domainLookupStart":176.30000001192093,"fetchStart":176.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":176.30000001192093,"responseEnd":1148.800000011921,"responseStart":1148.800000011921,"secureConnectionStart":176.30000001192093},{"duration":696.6000000238419,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":389,"connectEnd":389,"connectStart":389,"domainLookupEnd":389,"domainLookupStart":389,"fetchStart":389,"redirectEnd":0,"redirectStart":0,"requestStart":389,"responseEnd":1085.6000000238419,"responseStart":1085.6000000238419,"secureConnectionStart":389},{"duration":470.89999997615814,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":681.3000000119209,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":681.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1152.199999988079,"responseStart":0,"secureConnectionStart":0},{"duration":63.10000002384186,"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":1088.8999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1088.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1152,"responseStart":0,"secureConnectionStart":0},{"duration":62.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":1089.800000011921,"connectEnd":1089.800000011921,"connectStart":1089.800000011921,"domainLookupEnd":1089.800000011921,"domainLookupStart":1089.800000011921,"fetchStart":1089.800000011921,"redirectEnd":0,"redirectStart":0,"requestStart":1089.800000011921,"responseEnd":1152,"responseStart":1151.8999999761581,"secureConnectionStart":1089.800000011921},{"duration":64.30000001192093,"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":1090.300000011921,"connectEnd":1090.300000011921,"connectStart":1090.300000011921,"domainLookupEnd":1090.300000011921,"domainLookupStart":1090.300000011921,"fetchStart":1090.300000011921,"redirectEnd":0,"redirectStart":0,"requestStart":1090.300000011921,"responseEnd":1154.6000000238419,"responseStart":1154.6000000238419,"secureConnectionStart":1090.300000011921}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":12,"responseStart":168,"responseEnd":172,"domLoading":171,"domInteractive":1221,"domContentLoadedEventStart":1221,"domContentLoadedEventEnd":1257,"domComplete":1425,"loadEventStart":1425,"loadEventEnd":1425,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1206},{"name":"bigPipe.sidebar-id.end","time":1206.8999999761581},{"name":"bigPipe.activity-panel-pipe-id.start","time":1207},{"name":"bigPipe.activity-panel-pipe-id.end","time":1207.800000011921},{"name":"activityTabFullyLoaded","time":1270}],"measures":[],"correlationId":"3c46f88d93827c","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":98,"dbReadsTimeInMs":10,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}