[MDEV-28174] InnoDB: Assertion failure Created: 2022-03-25  Updated: 2022-05-01  Resolved: 2022-05-01

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.3.32, 10.3.33, 10.3.34
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Muhamed Osmani Assignee: Marko Mäkelä
Resolution: Cannot Reproduce Votes: 0
Labels: crash, galera, innodb
Environment:

Product version: Plesk Obsidian 18.0.42.1
OS version: CloudLinux 7.9 x86_64
Build date: 2022/03/14 17:00

Issue Links:
Relates
relates to MDEV-13542 Crashing on a corrupted page is unhel... Closed

 Description   

Version 10.3.32
2022-02-12 21:27:54 0x7ff3d8956700 InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.3.32/storage/innobase/btr/btr0cur.cc line 7699

Version 10.3.33
2022-03-18 00:04:16 0x7fca28acc700 InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.3.33/storage/innobase/btr/btr0cur.cc line 7699

Version 10.3.34 (Error still there):
2022-03-24 17:08:49 0x7fed3c4ae700 InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.3.34/storage/innobase/btr/btr0cur.cc line 7699

 Comments   
Comment by Marko Mäkelä [ 2022-03-25 ]

The failing assertion is a consistency check in btr_check_blob_fil_page_type():

        ut_a(space_id == page_get_space_id(page));

It suggests that a BLOB pointer in a clustered index record is pointing to an invalid page. There are various possible reasons for that, such as, an attempt to "fix" crash recovery failures by removing ib_logfile*, or an attempt to copy data files while the server is running, without using a tool like mariabackup.

I am not aware of any currently open BLOB bugs.

Comment by Marko Mäkelä [ 2022-03-25 ]

Can you reproduce this bug after initializing a new database from an SQL dump?

Comment by Muhamed Osmani [ 2022-03-28 ]

After initiaziling and recover from a dump the error dissappeared...

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