[MDEV-24108] Our server crashed and there was no possibility to restart it Created: 2020-11-03 Updated: 2021-04-25 Resolved: 2021-04-25 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.3.11 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Sergii | Assignee: | Marko Mäkelä |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | need_feedback | ||
| Environment: |
Operating System: CentOS Linux 7 (Core) |
||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
Suddenly we started receiving the next errors: After checking the log we found out that MariaDB is not able to restart after some fatal crash. Please investigate the log, I've attached the whole day trace, you may find a crash starting at about 12:55. |
| Comments |
| Comment by Marko Mäkelä [ 2020-11-03 ] | ||||||||||||
|
Could this report duplicate
I cannot say this for sure, and this is a bug tracker, not a customer support platform. | ||||||||||||
| Comment by Sergii [ 2020-11-04 ] | ||||||||||||
|
As I understood from logs the rootcause of this behavior was described by these statements: 2020-11-03 12:55:05 0 [Note] InnoDB: Uncompressed page, stored checksum in field1 3123149291, calculated checksums for field1: crc32 3123149291/2544593751, innodb 4231256809, page type 17855 == INDEX.none 3735928559, stored checksum in field2 3123149291, calculated checksums for field2: crc32 3123149291/2544593751, innodb 3996955962, none 3735928559, page LSN 1315 2769137356, low 4 bytes of LSN at page end 2769137356, page number (if stored to page already) 469, space id (if created with >= MySQL-4.1.1 and stored already) 403452 2020-11-03 12:55:05 0 [Note] InnoDB: Page may be an index page where index id is 541398 2020-11-03 12:55:05 0 [Note] InnoDB: Index 541398 is `PRIMARY` in table `pxbjyhhu_main1`.`oc_promo_mailing_queue` 2020-11-03 12:55:05 0 [ERROR] [FATAL] InnoDB: Apparent corruption of an index page [page id: space=403452, page number=469] to be written to data file. We intentionally crash the server to prevent corrupt data from ending up in data files. For me, it seems like server had an intention to update an index page, understood that some calculated result was invalid and tried to prevent the data corruption by crashing itself. | ||||||||||||
| Comment by Daniel Black [ 2021-03-28 ] | ||||||||||||
|
If you've restored from a backup and are running >10.3.17 we'd like to know if this happens again. |