[MDEV-16989] InnoDB hang on crash recovery: Waited for 10 seconds for 256 pending reads Created: 2018-08-15 Updated: 2022-01-14 Resolved: 2022-01-14 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Backup, Storage Engine - InnoDB, Storage Engine - XtraDB |
| Affects Version/s: | 5.5, 10.0, 10.1, 10.2, 10.3 |
| Fix Version/s: | 10.5.0 |
| Type: | Bug | Priority: | Major |
| Reporter: | Marko Mäkelä | Assignee: | Marko Mäkelä |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | hang, not-10.5, recovery | ||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
wlad made me aware of a PBX-1467 fix for Percona Xtrabackup. I believe that the described hang scenario is possible in InnoDB and XtraDB crash recovery. Quoting sergei-gl’s commit message:
This hang should only be possible if there were buffered changes to secondary index leaf pages, to pages which were read during the redo log processing, possibly by read-ahead. |
| Comments |
| Comment by YURII KANTONISTOV [ 2020-03-27 ] |
|
Reproducible in stress tests with prepare of incremental backup - see attached log of mariabackup. localtranprepare18604.zip |
| Comment by Marko Mäkelä [ 2020-10-19 ] |
|
|
| Comment by Marko Mäkelä [ 2021-05-11 ] |
|
ykantoni, is this reproducible with MariaDB 10.5.10? The crash recovery was heavily refactored in 10.5 (among other things, in |
| Comment by Marko Mäkelä [ 2021-05-11 ] |
|
Restoring an incremental backup should never invoke ibuf_merge_or_delete_for_page(), and in 10.5 that is not invoked at all during log-based recovery, thanks to |
| Comment by Marko Mäkelä [ 2022-01-14 ] |
|
|