[MDEV-24626] Remove synchronous write of page0 and flushing file during file creation Created: 2021-01-19 Updated: 2023-12-04 Resolved: 2021-05-17 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.2, 10.3, 10.4, 10.5, 10.6 |
| Fix Version/s: | 10.6.1 |
| Type: | Bug | Priority: | Blocker |
| Reporter: | Thirunarayanan Balathandayuthapani | Assignee: | Marko Mäkelä |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Description |
|
InnoDB holds dict_sys mutex while doing file i/o operation during creation of table.
If we remove the page0 write and flushing the file then InnoDB should handle this scenario during recovery. Right now, InnoDB does the validation of page0 while parsing the FILE redo log records. InnoDB should defer these tablespace as uninitialized if it encounters zero-filled page 0 |
| Comments |
| Comment by Marko Mäkelä [ 2021-03-19 ] |
|
Some more changes are needed in mariabackup. |
| Comment by Marko Mäkelä [ 2021-04-07 ] |
|
As far as I understand, there still are some recovery or backup failures that are related to this change. |
| Comment by Thirunarayanan Balathandayuthapani [ 2021-04-20 ] |
|
Updated patch is in bb-10.6- |
| Comment by Marko Mäkelä [ 2021-05-11 ] |
|
The test innodb_fts,crash_recovery that was extended in |
| Comment by Marko Mäkelä [ 2021-07-21 ] |
|
Some unnecessary code was not removed until 10.6.4. |