[MDEV-27754] Innodb assertion with innodb_flush_log_at_trx_commit=2 and innodb_flush_method=O_DSYNC Created: 2022-02-06 Updated: 2022-02-09 Resolved: 2022-02-08 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.5, 10.6, 10.7 |
| Fix Version/s: | 10.5.15, 10.6.7, 10.7.3, 10.8.2 |
| Type: | Bug | Priority: | Critical |
| Reporter: | Vladislav | Assignee: | Vladislav Vaintroub |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Windows Server 2019, IIS, php8 |
||
| Attachments: |
|
| Description |
|
Time by time (2-3 times per day) MariaDB server is crashed 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.6.5-MariaDB Thread pointer: 0x0 |
| Comments |
| Comment by Vladislav Vaintroub [ 2022-02-06 ] |
|
Zh, There should be mysqld.dmp file in C:\Program Files\MariaDB 10.6\data\ . Could you please attach it here, too ? |
| Comment by Vladislav [ 2022-02-06 ] |
| Comment by Vladislav Vaintroub [ 2022-02-06 ] |
|
Ok, thanks! I think I could guess what happened here, even without crash dump As a temporary workaround, I suggest to comment out innodb_flush_method = O_DSYNC . Alternatively, use innodb_flush_log_at_trx_commit=1 (this is not absolutely safe, but would make crash highly improbable). |
| Comment by Vladislav Vaintroub [ 2022-02-06 ] |
|
marko, please review https://github.com/MariaDB/server/commit/70e63796df78b6d34c65f9a9d957fd8bd46470bd |