[MDEV-22209] InnoDB repeatedly crashes upon startup with crash recovery Created: 2020-04-10 Updated: 2020-09-21 Resolved: 2020-09-21 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.3.16 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Alexander Keremidarski | Assignee: | Alexander Keremidarski |
| Resolution: | Incomplete | Votes: | 1 |
| Labels: | need_feedback | ||
| Description |
|
Customer reports server crashing repeatedly during crash recovery. The cause of the initial crash is still unkown, but during subsequent restarts it crashes with: 2020-04-09 21:36:15 0 [Note] InnoDB: Starting final batch to recover 11194 pages from redo log. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help Server version: 10.3.16-MariaDB-log Thread pointer: 0x0 |
| Comments |
| Comment by Marko Mäkelä [ 2020-05-06 ] | ||||
|
salle, can you try to get the following from the core dump (or by starting up the recovery in gdb on the corrupted data directory):
Then, armed with this, start recovery with a debug build of mysqld, and invoke
and then filter the output for the page number. If it is a clustered index page (this we could find out by checking if PAGE_INDEX_ID on the page corresponds to the SYS_INDEXES.ID of the clustered index), then this corruption most likely was caused by | ||||
| Comment by Marko Mäkelä [ 2020-07-24 ] | ||||
|
I would strongly suspect that this problem was fixed by |