Type:
Priority:
Resolution:
Fixed
Affects Version/s:
10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL) , 10.11
For the dataset in MDEV-30068
2022-11-21 8:59:32 0 [ERROR] [FATAL] InnoDB: Trying to write 65536 bytes at 2359296 outside the bounds of the file: ./test/t5.ibd
Before the failure, there was one call to fil_system_t::extend_to_recv_size() from recv_sys.apply_log(false) .
#5 0x00005640dd514e7d in fil_invalid_page_access_msg (name=<optimized out>,
offset=offset@entry=2359296, len=len@entry=65536, is_read=<optimized out>)
at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/fil/fil0fil.cc:2639
#6 0x00005640dd5287e6 in fil_space_t::io (this=this@entry=0x6120000034c0,
type=@0x7ffc0c342410: {bpage = 0x45cb7349a870, slot = 0x631000028820, node = 0x0, type = IORequest::WRITE_LRU}, offset=2359296, len=<optimized out>,
buf=buf@entry=0x6f6f7afb0000, bpage=bpage@entry=0x45cb7349a870)
at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/fil/fil0fil.cc:2715
#7 0x00005640dd41fdf2 in buf_page_t::flush (this=this@entry=0x45cb7349a870,
lru=lru@entry=true, space=space@entry=0x6120000034c0)
at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/buf/buf0flu.cc:900
#8 0x00005640dd4152a1 in buf_flush_LRU_list_batch (max=max@entry=32,
n=n@entry=0x7ffc0c342600)
at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/buf/buf0flu.cc:1299
#9 0x00005640dd416295 in buf_do_LRU_batch (max=max@entry=32)
at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/buf/buf0flu.cc:1337
#10 0x00005640dd416590 in buf_flush_LRU (max_n=32)
at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/buf/buf0flu.cc:1678
#11 0x00005640dd42f58d in buf_LRU_get_free_block (
have_mutex=have_mutex@entry=false)
at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/buf/buf0lru.cc:488
#12 0x00005640dcf678d0 in recv_sys_t::recover_low (
this=0x5640dec48760 <recv_sys>, page_id=<optimized out>)
at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/log/log0recv.cc:3155
#13 0x00005640dd3e4508 in recv_sys_t::recover (page_id=<optimized out>,
this=<optimized out>)
at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/include/log0recv.h:415
#14 buf_page_get_gen (page_id={m_id = 303}, zip_size=zip_size@entry=0,
rw_latch=rw_latch@entry=1, guess=guess@entry=0x45cb7349a870,
…
#25 0x00005640dd2cc19a in trx_resurrect (undo=undo@entry=0x611000043fc0, rseg=rseg@entry=0x5640decf2340 <trx_sys+30080>, start_time=start_time@entry=1669049972, start_time_micro=start_time_micro@entry=284020700207, rows_to_undo=rows_to_undo@entry=0x7ffc0c346840) at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/trx/trx0trx.cc:701
#26 0x00005640dd2cc843 in trx_lists_init_at_db_start () at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/trx/trx0trx.cc:752
#27 0x00005640dd23d5f0 in srv_start (create_new_db=<optimized out>) at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/srv/srv0start.cc:1485
#28 0x00005640dcdb1952 in innodb_init (p=<optimized out>) at /data/Server/bb-10.6-MDEV-29835extra/storage/innobase/handler/ha_innodb.cc:4293
#29 0x00005640dc30fd21 in ha_initialize_handlerton (plugin=0x62100002e010) at /data/Server/bb-10.6-MDEV-29835extra/sql/handler.cc:659
As far as I can tell, the problem should be fixed by extending the tablespace before invoking buf_LRU_get_free_block() , at least in recv_sys_t::recover_low() and possibly elsewhere (definitely when MDEV-14481
I was not able to reproduce the error for a copy of the data directory, so some additional testing will be needed.
{"report":{"fcp":1659.1999998092651,"ttfb":489.69999980926514,"pageVisibility":"visible","entityId":117093,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"cb2555a8-9623-4f3d-99f6-04d5741395be","navigationType":0,"readyForUser":1769.8000001907349,"redirectCount":0,"resourceLoadedEnd":1769.4000005722046,"resourceLoadedStart":500.6000003814697,"resourceTiming":[{"duration":395,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":500.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":500.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":895.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":398.1000003814697,"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":500.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":500.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":898.9000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":414,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":501,"connectEnd":501,"connectStart":501,"domainLookupEnd":501,"domainLookupStart":501,"fetchStart":501,"redirectEnd":0,"redirectStart":0,"requestStart":501,"responseEnd":915,"responseStart":915,"secureConnectionStart":501},{"duration":444.20000076293945,"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":501.19999980926514,"connectEnd":501.19999980926514,"connectStart":501.19999980926514,"domainLookupEnd":501.19999980926514,"domainLookupStart":501.19999980926514,"fetchStart":501.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":501.19999980926514,"responseEnd":945.4000005722046,"responseStart":945.4000005722046,"secureConnectionStart":501.19999980926514},{"duration":453,"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":501.5,"connectEnd":501.5,"connectStart":501.5,"domainLookupEnd":501.5,"domainLookupStart":501.5,"fetchStart":501.5,"redirectEnd":0,"redirectStart":0,"requestStart":501.5,"responseEnd":954.5,"responseStart":954.5,"secureConnectionStart":501.5},{"duration":454.1000003814697,"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":501.69999980926514,"connectEnd":501.69999980926514,"connectStart":501.69999980926514,"domainLookupEnd":501.69999980926514,"domainLookupStart":501.69999980926514,"fetchStart":501.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":501.69999980926514,"responseEnd":955.8000001907349,"responseStart":955.8000001907349,"secureConnectionStart":501.69999980926514},{"duration":455.19999980926514,"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":501.9000005722046,"connectEnd":501.9000005722046,"connectStart":501.9000005722046,"domainLookupEnd":501.9000005722046,"domainLookupStart":501.9000005722046,"fetchStart":501.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":501.9000005722046,"responseEnd":957.1000003814697,"responseStart":957.1000003814697,"secureConnectionStart":501.9000005722046},{"duration":457.8999996185303,"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":502.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":502.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":960,"responseStart":0,"secureConnectionStart":0},{"duration":456.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":502.30000019073486,"connectEnd":502.30000019073486,"connectStart":502.30000019073486,"domainLookupEnd":502.30000019073486,"domainLookupStart":502.30000019073486,"fetchStart":502.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":502.30000019073486,"responseEnd":958.6999998092651,"responseStart":958.6999998092651,"secureConnectionStart":502.30000019073486},{"duration":458.6000003814697,"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":502.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":502.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":961.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":457.3999996185303,"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":502.6000003814697,"connectEnd":502.6000003814697,"connectStart":502.6000003814697,"domainLookupEnd":502.6000003814697,"domainLookupStart":502.6000003814697,"fetchStart":502.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":502.6000003814697,"responseEnd":960,"responseStart":960,"secureConnectionStart":502.6000003814697},{"duration":797.9000005722046,"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":503.69999980926514,"connectEnd":503.69999980926514,"connectStart":503.69999980926514,"domainLookupEnd":503.69999980926514,"domainLookupStart":503.69999980926514,"fetchStart":503.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":503.69999980926514,"responseEnd":1301.6000003814697,"responseStart":1301.6000003814697,"secureConnectionStart":503.69999980926514},{"duration":1265.5,"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":503.9000005722046,"connectEnd":503.9000005722046,"connectStart":503.9000005722046,"domainLookupEnd":503.9000005722046,"domainLookupStart":503.9000005722046,"fetchStart":503.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":503.9000005722046,"responseEnd":1769.4000005722046,"responseStart":1769.4000005722046,"secureConnectionStart":503.9000005722046},{"duration":406,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1430.1999998092651,"connectEnd":1430.1999998092651,"connectStart":1430.1999998092651,"domainLookupEnd":1430.1999998092651,"domainLookupStart":1430.1999998092651,"fetchStart":1430.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1430.1999998092651,"responseEnd":1836.1999998092651,"responseStart":1836.1999998092651,"secureConnectionStart":1430.1999998092651},{"duration":309.5999994277954,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1650.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1650.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1960.1999998092651,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":294,"responseStart":490,"responseEnd":497,"domLoading":498,"domInteractive":1903,"domContentLoadedEventStart":1903,"domContentLoadedEventEnd":1960,"domComplete":3439,"loadEventStart":3439,"loadEventEnd":3441,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1884.5},{"name":"bigPipe.sidebar-id.end","time":1885.4000005722046},{"name":"bigPipe.activity-panel-pipe-id.start","time":1885.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.end","time":1889.5},{"name":"activityTabFullyLoaded","time":1971}],"measures":[],"correlationId":"696ec2c5b99aab","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":128,"dbReadsTimeInMs":21,"dbConnsTimeInMs":32,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Critical
MDEV-14481 Execute InnoDB crash recovery in the background