InnoDB: Missing FILE_CREATE... before FILE_CHECKPOINT returns after a year

MariaDB 11.1.2-GA on Windows 11 Pro crashes every couple of days, sometimes couple of hours with "InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT". Having no other way (details below and in linked pages) I decided to throw it away and reinstall whole stack again. It works for another couple of days and then started to crash (actually: fails to start) with exactly the same error in the same conditions.

I am a total newbie an may be wrong, but from my perspective this is a regression of either: MDEV-28870, MDEV-31410 or MDEV-28976.

All the details, including all the attempts of self-resolve this issue are given in two connected questions at Server Fault and Database Administrators. There is also my own answer to the first one. It provides more details and brings some resolution attempts tried.

Here only some quick summary:

1. The whole story started with April 2023 edition (latest) of XAMPP 8.2.4 which claims to have MariaDB 10.4.28 on-board. It was a "never-ending story" of MariaDB running for couple of days and then being unable to start with:

mysqld.exe: Aria engine: checkpoint failed
mysqld.exe: Can't sync file 'C:\XAMPP\mysql\data\aria_log.00000001' to disk (Errcode: 9 "Bad file descriptor")
mysqld.exe: Error writing file 'C:\XAMPP\mysql\data\aria_log.00000001' (Errcode: 9 "Bad file descriptor")

2. Not being able to do anything (every clean reinstall of whole XAMPP or just MariaDB was always lasting for no more than five days) I have decided to upgrade to MariaDB 11.1.2-GA.

Here the "never-ending story" started back only this time the problem is with:

InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT

Thing that I have tried to resolve the above:

• Setting innodb_force_recovery on any value
• Deleting ib_logfile0
• Setting innodb_log_file_size = 48M
• Setting innodb_buffer_pool_size = 10M

The only thing that I have found working and able to resolve the above are hardcore solutions of:

• Deleting my corrupted files
• Reinstalling MariaDB
• Reinstalling whole XAMPP stack

However, I cannot repeat these tasks over and over again.