Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL) , 10.11 , 11.0(EOL) , 11.1(EOL)
axel reproduced one more hang related to innodb_undo_log_truncate=ON , similar to MDEV-30180 . Here is a description of a hang that was reproduced with innodb_use_native_aio=0 :
trx_purge_truncate_history() writes the message InnoDB: Truncating and is about to truncate an undo log tablespace.
trx_purge_truncate_history() is busy-looping in a scan of buf_pool.flush_list because one of the pages belonging to the undo tablespace is write-fixed.
During the time trx_purge_truncate_history() releases and re-acquires buf_pool.flush_list_mutex , other threads that are waiting for it cannot grab it, in this version of GNU libc . This is similar to MDEV-30180 , which could only be reproduced in the same particular environment.
buf_dblwr_t::flush_buffered_writes_completed() was waiting for log_sys.mutex in log_write_up_to() , while trying to write the block that trx_purge_truncate_history() is trying to lock.
log_sys.mutex was be held by buf_flush_page_cleaner() , which is waiting for buf_pool.flush_list_mutex .
A possible fix would be that trx_purge_truncate_history() buffer-fixes the block, releases buf_pool.flush_list_mutex , waits for an exclusive latch on the block and finally reacquire buf_pool.flush_list_mutex . In that way, the blocking of other threads is minimized. The buffer-fix will prevent the eviction or relocation of the block in the buffer pool while no mutex is held by trx_purge_truncate_history() .
Marko Mäkelä
made changes -
2023-05-25 12:50
Status
Open
[ 1
]
In Progress
[ 3
]
Marko Mäkelä
made changes -
2023-05-25 12:50
Status
In Progress
[ 3
]
In Testing
[ 10301
]
Marko Mäkelä
made changes -
2023-05-25 12:50
Assignee
Marko Mäkelä
[ marko
]
Axel Schwenke
[ axel
]
Axel Schwenke
made changes -
2023-05-26 10:20
Attachment
timeseries_tpcc_64.png
[ 70286
]
Axel Schwenke
made changes -
2023-05-26 10:25
Attachment
timeseries_tpcc_64.png
[ 70286
]
Axel Schwenke
made changes -
2023-05-26 10:33
Assignee
Axel Schwenke
[ axel
]
Matthias Leich
[ mleich
]
Marko Mäkelä
made changes -
2023-05-26 14:00
issue.field.resolutiondate
2023-05-26 14:00:06.0
2023-05-26 14:00:06.429
Marko Mäkelä
made changes -
2023-05-26 14:00
Fix Version/s
10.6.14
[ 28914
]
Fix Version/s
10.9.7
[ 28916
]
Fix Version/s
10.10.5
[ 28917
]
Fix Version/s
10.11.4
[ 28918
]
Fix Version/s
11.0.3
[ 28920
]
Fix Version/s
11.1.2
[ 28921
]
Fix Version/s
10.6
[ 24028
]
Fix Version/s
10.9
[ 26905
]
Fix Version/s
10.10
[ 27530
]
Fix Version/s
10.11
[ 27614
]
Fix Version/s
11.0
[ 28320
]
Fix Version/s
11.1
[ 28549
]
Resolution
Fixed
[ 1
]
Status
In Testing
[ 10301
]
Closed
[ 6
]
Daniel Bartholomew
made changes -
2023-06-07 13:32
Fix Version/s
10.6.15
[ 29013
]
Fix Version/s
10.9.8
[ 29015
]
Fix Version/s
10.10.6
[ 29017
]
Fix Version/s
10.11.5
[ 29019
]
Fix Version/s
10.6.14
[ 28914
]
Fix Version/s
10.9.7
[ 28916
]
Fix Version/s
10.10.5
[ 28917
]
Fix Version/s
10.11.4
[ 28918
]
Daniel Bartholomew
made changes -
2023-06-07 14:05
Fix Version/s
10.6.14
[ 28914
]
Fix Version/s
10.9.7
[ 28916
]
Fix Version/s
10.10.5
[ 28917
]
Fix Version/s
10.11.4
[ 28918
]
Fix Version/s
11.0.2
[ 28706
]
Fix Version/s
11.1.1
[ 28704
]
Fix Version/s
11.0.3
[ 28920
]
Fix Version/s
11.1.2
[ 28921
]
Fix Version/s
10.6.15
[ 29013
]
Fix Version/s
10.9.8
[ 29015
]
Fix Version/s
10.10.6
[ 29017
]
Fix Version/s
10.11.5
[ 29019
]
{"report":{"fcp":1112.8000001907349,"ttfb":407.0999994277954,"pageVisibility":"visible","entityId":122260,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"3593b413-acde-4f82-8180-7acba1cc5cca","navigationType":0,"readyForUser":1192.1999998092651,"redirectCount":0,"resourceLoadedEnd":754.8000001907349,"resourceLoadedStart":413.0999994277954,"resourceTiming":[{"duration":123.60000038146973,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":413.0999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":413.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":536.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":123.79999923706055,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":413.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":413.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":537.0999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":250.0999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":413.5,"connectEnd":413.5,"connectStart":413.5,"domainLookupEnd":413.5,"domainLookupStart":413.5,"fetchStart":413.5,"redirectEnd":0,"redirectStart":0,"requestStart":542.8999996185303,"responseEnd":663.5999994277954,"responseStart":562.5,"secureConnectionStart":413.5},{"duration":313,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":413.69999980926514,"connectEnd":413.69999980926514,"connectStart":413.69999980926514,"domainLookupEnd":413.69999980926514,"domainLookupStart":413.69999980926514,"fetchStart":413.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":542.5999994277954,"responseEnd":726.6999998092651,"responseStart":561.5,"secureConnectionStart":413.69999980926514},{"duration":150.9000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":413.8999996185303,"connectEnd":413.8999996185303,"connectStart":413.8999996185303,"domainLookupEnd":413.8999996185303,"domainLookupStart":413.8999996185303,"fetchStart":413.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":543.8000001907349,"responseEnd":564.8000001907349,"responseStart":563.0999994277954,"secureConnectionStart":413.8999996185303},{"duration":153.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":414.0999994277954,"connectEnd":414.0999994277954,"connectStart":414.0999994277954,"domainLookupEnd":414.0999994277954,"domainLookupStart":414.0999994277954,"fetchStart":414.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":546.8000001907349,"responseEnd":567.8999996185303,"responseStart":566.5999994277954,"secureConnectionStart":414.0999994277954},{"duration":156.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":414.30000019073486,"connectEnd":414.30000019073486,"connectStart":414.30000019073486,"domainLookupEnd":414.30000019073486,"domainLookupStart":414.30000019073486,"fetchStart":414.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":548,"responseEnd":571,"responseStart":569.0999994277954,"secureConnectionStart":414.30000019073486},{"duration":131.20000076293945,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":414.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":414.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":545.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":158.60000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":414.69999980926514,"connectEnd":414.69999980926514,"connectStart":414.69999980926514,"domainLookupEnd":414.69999980926514,"domainLookupStart":414.69999980926514,"fetchStart":414.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":552.1999998092651,"responseEnd":573.3000001907349,"responseStart":571.3000001907349,"secureConnectionStart":414.69999980926514},{"duration":133,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":414.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":414.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":547.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":159.0999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":415,"connectEnd":415,"connectStart":415,"domainLookupEnd":415,"domainLookupStart":415,"fetchStart":415,"redirectEnd":0,"redirectStart":0,"requestStart":552.5,"responseEnd":574.0999994277954,"responseStart":572,"secureConnectionStart":415},{"duration":312.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":421.19999980926514,"connectEnd":421.19999980926514,"connectStart":421.19999980926514,"domainLookupEnd":421.19999980926514,"domainLookupStart":421.19999980926514,"fetchStart":421.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":642.6999998092651,"responseEnd":733.5999994277954,"responseStart":729.6999998092651,"secureConnectionStart":421.19999980926514},{"duration":320.9000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":433.8999996185303,"connectEnd":433.8999996185303,"connectStart":433.8999996185303,"domainLookupEnd":433.8999996185303,"domainLookupStart":433.8999996185303,"fetchStart":433.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":744.0999994277954,"responseEnd":754.8000001907349,"responseStart":753.8000001907349,"secureConnectionStart":433.8999996185303},{"duration":227.80000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":861.3999996185303,"connectEnd":861.3999996185303,"connectStart":861.3999996185303,"domainLookupEnd":861.3999996185303,"domainLookupStart":861.3999996185303,"fetchStart":861.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":1041.8000001907349,"responseEnd":1089.1999998092651,"responseStart":1088.3000001907349,"secureConnectionStart":861.3999996185303}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":155,"responseStart":407,"responseEnd":434,"domLoading":411,"domInteractive":1267,"domContentLoadedEventStart":1267,"domContentLoadedEventEnd":1314,"domComplete":2511,"loadEventStart":2511,"loadEventEnd":2512,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1232.1999998092651},{"name":"bigPipe.sidebar-id.end","time":1233},{"name":"bigPipe.activity-panel-pipe-id.start","time":1233.0999994277954},{"name":"bigPipe.activity-panel-pipe-id.end","time":1238.6999998092651},{"name":"activityTabFullyLoaded","time":1338.0999994277954}],"measures":[],"correlationId":"176312c1aa1b67","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":179,"dbReadsTimeInMs":31,"dbConnsTimeInMs":42,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}