[MDEV-29790] MariaDB keeps restarting Created: 2022-10-14  Updated: 2022-10-18  Resolved: 2022-10-18

Status: Closed
Project: MariaDB Server
Component/s: Platform Debian
Affects Version/s: 10.5.15
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: conta Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: crash
Environment:

Raspberry Pi 4, Debian GNU/Linux 11 (bullseye) aarch64



 Description   

Hi,

I am using my Raspi and Yunohost (yunohost.org) for hosting apps on it, some of which use MariaDB. I noticed that those apps stopped to work and found that MariaDB keeps restarting.

Oct 11 06:59:40 noho.st systemd[1]: Starting MariaDB 10.5.15 database server...
Oct 11 06:59:40 noho.st mariadbd[2778341]: 2022-10-11  6:59:40 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.15-MariaDB-0+deb11u1) starting as process 2778341 ...
Oct 11 06:59:40 noho.st mariadbd[2778341]: 2022-10-11  6:59:40 0 [Note] InnoDB: Uses event mutexes
Oct 11 06:59:40 noho.st mariadbd[2778341]: 2022-10-11  6:59:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Oct 11 06:59:40 noho.st mariadbd[2778341]: 2022-10-11  6:59:40 0 [Note] InnoDB: Number of pools: 1
Oct 11 06:59:40 noho.st mariadbd[2778341]: 2022-10-11  6:59:40 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Oct 11 06:59:40 noho.st mariadbd[2778341]: 2022-10-11  6:59:40 0 [Note] InnoDB: Using Linux native AIO
Oct 11 06:59:40 noho.st mariadbd[2778341]: 2022-10-11  6:59:40 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Oct 11 06:59:40 noho.st mariadbd[2778341]: 2022-10-11  6:59:40 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 11 06:59:40 noho.st mariadbd[2778341]: 2022-10-11  6:59:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=22467617435,22467617435
Oct 11 06:59:41 noho.st mariadbd[2778341]: 2022-10-11  6:59:41 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 4 row operations to undo
Oct 11 06:59:41 noho.st mariadbd[2778341]: 2022-10-11  6:59:41 0 [Note] InnoDB: Trx id counter is 22340157
Oct 11 06:59:41 noho.st mariadbd[2778341]: 2022-10-11  6:59:41 0 [Note] InnoDB: Starting final batch to recover 254 pages from redo log.
Oct 11 06:59:41 noho.st mariadbd[2778341]: 2022-10-11  6:59:41 0 [Note] InnoDB: 128 rollback segments are active.
Oct 11 06:59:41 noho.st mariadbd[2778341]: 2022-10-11  6:59:41 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
Oct 11 06:59:41 noho.st mariadbd[2778341]: 2022-10-11  6:59:41 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Oct 11 06:59:41 noho.st mariadbd[2778341]: 2022-10-11  6:59:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Oct 11 06:59:41 noho.st mariadbd[2778341]: 2022-10-11  6:59:41 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Oct 11 06:59:41 noho.st mariadbd[2778341]: 2022-10-11  6:59:41 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Oct 11 06:59:41 noho.st mariadbd[2778341]: 2022-10-11 06:59:41 0x7f6affd100  InnoDB: Assertion failure in file ./storage/innobase/btr/btr0cur.cc line 336
Oct 11 06:59:41 noho.st mariadbd[2778341]: InnoDB: Failing assertion: btr_page_get_prev(get_block->frame) == block->page.id().page_no()
Oct 11 06:59:41 noho.st mariadbd[2778341]: InnoDB: We intentionally generate a memory trap.
Oct 11 06:59:41 noho.st mariadbd[2778341]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
Oct 11 06:59:41 noho.st mariadbd[2778341]: InnoDB: If you get repeated assertion failures or crashes, even
Oct 11 06:59:41 noho.st mariadbd[2778341]: InnoDB: immediately after the mysqld startup, there may be
Oct 11 06:59:41 noho.st mariadbd[2778341]: InnoDB: corruption in the InnoDB tablespace. Please refer to
Oct 11 06:59:41 noho.st mariadbd[2778341]: InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
Oct 11 06:59:41 noho.st mariadbd[2778341]: InnoDB: about forcing recovery.
Oct 11 06:59:41 noho.st mariadbd[2778341]: 221011  6:59:41 [ERROR] mysqld got signal 6 ;
Oct 11 06:59:41 noho.st mariadbd[2778341]: This could be because you hit a bug. It is also possible that this binary
Oct 11 06:59:41 noho.st mariadbd[2778341]: or one of the libraries it was linked against is corrupt, improperly built,
Oct 11 06:59:41 noho.st mariadbd[2778341]: or misconfigured. This error can also be caused by malfunctioning hardware.
Oct 11 06:59:41 noho.st mariadbd[2778341]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Oct 11 06:59:41 noho.st mariadbd[2778341]: We will try our best to scrape up some info that will hopefully help
Oct 11 06:59:41 noho.st mariadbd[2778341]: diagnose the problem, but since we have already crashed,
Oct 11 06:59:41 noho.st mariadbd[2778341]: something is definitely wrong and this may fail.
Oct 11 06:59:41 noho.st mariadbd[2778341]: Server version: 10.5.15-MariaDB-0+deb11u1
Oct 11 06:59:41 noho.st mariadbd[2778341]: key_buffer_size=134217728

Unfortunately I am not skilled enough to figure out how to proceed. Thanks!



 Comments   
Comment by conta [ 2022-10-17 ]

I was able to fix this in the end. Found the corrupted DB and was able to restore it.

Generated at Thu Feb 08 10:11:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.