Note: Possibly it has already been fixed, but I don't see a clear indication of it.
http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/3970/steps/mtr_centos_mix/logs/stdio
bb-10.2-release 75dcb74da652d8ba504b6906b2aa2ae5 2020-05-06 16:30:28
|
innodb_zip.recover 'innodb' w1 [ fail ]
|
Test ended at 2020-05-06 14:52:03
|
|
CURRENT_TEST: innodb_zip.recover
|
mysqltest: In included file "./include/wait_until_connected_again.inc":
|
included from ./include/start_mysqld.inc at line 18:
|
included from ./include/restart_mysqld.inc at line 11:
|
included from /usr/share/mysql-test/suite/innodb_zip/t/recover.test at line 29:
|
At line 23: Server failed to restart
|
|
The result from queries just before the failure was:
|
#
|
# MDEV-12720 recovery fails with "Generic error"
|
# for ROW_FORMAT=compressed
|
#
|
CREATE TABLE a(i INT PRIMARY KEY AUTO_INCREMENT, s VARCHAR(255)) ENGINE=InnoDB
|
ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
|
BEGIN;
|
insert into a(i) select null;
|
insert into a select null, uuid() from a a, a b, a c;
|
insert into a select null, uuid() from a a, a b, a c;
|
insert into a select null, uuid() from a a, a b, a c;
|
SET GLOBAL innodb_flush_log_at_trx_commit=1;
|
COMMIT;
|
Last words in the log:
2020-05-07 9:42:08 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 17, since the redo log references ./test/t1.ibd with space ID 16.
|
2020-05-07 9:42:08 0 [Note] InnoDB: Starting a batch to recover 332 pages from redo log.
|
2020-05-07 9:42:09 0 [Warning] InnoDB: Difficult to find free blocks in the buffer pool (21 search iterations)! 21 failed attempts to flush a page! Consider increasing innodb_buffer_pool_size. Pending flushes (fsync) log: 0; buffer pool: 0. 381 OS file reads, 78 OS file writes, 78 OS fsyncs.
|
{"report":{"fcp":838.6999999880791,"ttfb":250.89999997615814,"pageVisibility":"visible","entityId":86712,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"28788ea5-efa0-4506-9309-2bec66784964","navigationType":0,"readyForUser":920.1999999880791,"redirectCount":0,"resourceLoadedEnd":581,"resourceLoadedStart":256.59999999403954,"resourceTiming":[{"duration":71.7999999821186,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":256.59999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":256.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":328.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":71.80000001192093,"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":256.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":256.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":328.69999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":202.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":257,"connectEnd":257,"connectStart":257,"domainLookupEnd":257,"domainLookupStart":257,"fetchStart":257,"redirectEnd":0,"redirectStart":0,"requestStart":334.69999998807907,"responseEnd":459.5,"responseStart":357.5,"secureConnectionStart":257},{"duration":323.80000001192093,"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":257.19999998807907,"connectEnd":257.19999998807907,"connectStart":257.19999998807907,"domainLookupEnd":257.19999998807907,"domainLookupStart":257.19999998807907,"fetchStart":257.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":335.39999997615814,"responseEnd":581,"responseStart":360.09999999403954,"secureConnectionStart":257.19999998807907},{"duration":105.80000001192093,"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":257.39999997615814,"connectEnd":257.39999997615814,"connectStart":257.39999997615814,"domainLookupEnd":257.39999997615814,"domainLookupStart":257.39999997615814,"fetchStart":257.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":335.5,"responseEnd":363.19999998807907,"responseStart":361.69999998807907,"secureConnectionStart":257.39999997615814},{"duration":105.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":257.5,"connectEnd":257.5,"connectStart":257.5,"domainLookupEnd":257.5,"domainLookupStart":257.5,"fetchStart":257.5,"redirectEnd":0,"redirectStart":0,"requestStart":335.69999998807907,"responseEnd":363,"responseStart":361.09999999403954,"secureConnectionStart":257.5},{"duration":107.59999999403954,"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":257.7999999821186,"connectEnd":257.7999999821186,"connectStart":257.7999999821186,"domainLookupEnd":257.7999999821186,"domainLookupStart":257.7999999821186,"fetchStart":257.7999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":336.59999999403954,"responseEnd":365.39999997615814,"responseStart":363.5,"secureConnectionStart":257.7999999821186},{"duration":75.80000001192093,"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":257.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":257.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":333.69999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":107.59999999403954,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":258.09999999403954,"connectEnd":258.09999999403954,"connectStart":258.09999999403954,"domainLookupEnd":258.09999999403954,"domainLookupStart":258.09999999403954,"fetchStart":258.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":336.7999999821186,"responseEnd":365.69999998807907,"responseStart":364.09999999403954,"secureConnectionStart":258.09999999403954},{"duration":77.90000000596046,"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":258.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":258.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":336.09999999403954,"responseStart":0,"secureConnectionStart":0},{"duration":108.7000000178814,"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":258.39999997615814,"connectEnd":258.39999997615814,"connectStart":258.39999997615814,"domainLookupEnd":258.39999997615814,"domainLookupStart":258.39999997615814,"fetchStart":258.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":338,"responseEnd":367.09999999403954,"responseStart":366,"secureConnectionStart":258.39999997615814},{"duration":298.09999999403954,"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":259.2999999821186,"connectEnd":259.2999999821186,"connectStart":259.2999999821186,"domainLookupEnd":259.2999999821186,"domainLookupStart":259.2999999821186,"fetchStart":259.2999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":449.09999999403954,"responseEnd":557.3999999761581,"responseStart":554.7999999821186,"secureConnectionStart":259.2999999821186},{"duration":303.80000001192093,"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":259.39999997615814,"connectEnd":259.39999997615814,"connectStart":259.39999997615814,"domainLookupEnd":259.39999997615814,"domainLookupStart":259.39999997615814,"fetchStart":259.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":539.8999999761581,"responseEnd":563.1999999880791,"responseStart":560.5,"secureConnectionStart":259.39999997615814},{"duration":193.39999997615814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":587,"connectEnd":587,"connectStart":587,"domainLookupEnd":587,"domainLookupStart":587,"fetchStart":587,"redirectEnd":0,"redirectStart":0,"requestStart":740.6999999880791,"responseEnd":780.3999999761581,"responseStart":779.6999999880791,"secureConnectionStart":587}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":52,"responseStart":250,"responseEnd":254,"domLoading":254,"domInteractive":996,"domContentLoadedEventStart":996,"domContentLoadedEventEnd":1044,"domComplete":1725,"loadEventStart":1725,"loadEventEnd":1725,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":976.7999999821186},{"name":"bigPipe.sidebar-id.end","time":977.5999999940395},{"name":"bigPipe.activity-panel-pipe-id.start","time":977.6999999880791},{"name":"bigPipe.activity-panel-pipe-id.end","time":978.7999999821186},{"name":"activityTabFullyLoaded","time":1061.7999999821186}],"measures":[],"correlationId":"8327a1b3086db8","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":124,"dbReadsTimeInMs":25,"dbConnsTimeInMs":36,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}