[MDEV-24543] corruption in the InnoDB tablespace Created: 2021-01-07  Updated: 2021-01-07  Resolved: 2021-01-07

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Update
Affects Version/s: 10.3.14
Fix Version/s: 10.3.17, 10.4.7

Type: Bug Priority: Major
Reporter: kangjia Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

prod
Server version: 10.3.14"


Attachments: Text File mysql-err.log    
Issue Links:
Duplicate
duplicates MDEV-19916 Corruption after instant ADD/DROP and... Closed

 Description   

2020-12-31 9:45:33 17 [ERROR] InnoDB: Page old data size 10435 new data size 10508, page old max ins size 5815 new max ins size 5742
2020-12-31 9:45:33 17 [ERROR] InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
2020-12-31 9:48:48 14 [ERROR] InnoDB: Page old data size 9785 new data size 9789, page old max ins size 6465 new max ins size 6461
2020-12-31 9:48:48 14 [ERROR] InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
2020-12-31 9:48:49 16 [ERROR] InnoDB: Page old data size 10901 new data size 10905, page old max ins size 5349 new max ins size 5345
2020-12-31 9:48:49 16 [ERROR] InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
2020-12-31 9:48:50 14 [ERROR] InnoDB: Page old data size 7235 new data size 7239, page old max ins size 9016 new max ins size 9012
2020-12-31 9:48:50 14 [ERROR] InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
2020-12-31 09:48:50 0x7f931f435700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/storage/innobase/btr/btr0cur.cc line 4467
InnoDB: Failing assertion: rec
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
InnoDB: about forcing recovery.
201231 9:48:50 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.



 Comments   
Comment by Marko Mäkelä [ 2021-01-07 ]

This looks like a duplicate of MDEV-19916, which was fixed in MariaDB 10.3.17. Unfortunately, the table will most likely be corrupted. Even if a logical dump succeeded, the data could be garbage.

Generated at Thu Feb 08 09:30:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.