Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.5.12
-
Debian Bullseye on Kobol Helios4
SoC: Marvell Armada 380/385
MariaDB 1:10.5.12-0+deb11u1 armhf
Description
This morning mysql crashed with error below.
Feb 25 01:49:56 ains mysqld: 2022-02-25 1:49:56 0 [ERROR] InnoDB: Unable to find a record to delete-mark
Feb 25 01:49:56 ains mysqld: InnoDB: tuple DATA TUPLE: 3 fields;
Feb 25 01:49:56 ains mysqld: 0: len 8; hex 8000000000000003; asc ;;
Feb 25 01:49:56 ains mysqld: 1: len 32; hex 3636643739393733366632656563343732393865323738393734366661393930; asc 66d799736f2eec47298e2789746fa990;;
Feb 25 01:49:56 ains mysqld: 2: len 8; hex 8000000000052c42; asc ,B;;
{{Feb 25 01:49:56 ains mysqld: }}
Feb 25 01:49:56 ains mysqld: InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
Feb 25 01:49:56 ains mysqld: 0: len 8; hex 8000000000000003; asc ;;
Feb 25 01:49:56 ains mysqld: 1: len 30; hex 363664373939373336663265656334373239386532373839373436666139; asc 66d799736f2eec47298e2789746fa9; (total 32 bytes);
Feb 25 01:49:56 ains mysqld: 2: len 8; hex 8000000000052c01; asc , ;;
Feb 25 01:49:56 ains mysqld: 2022-02-25 1:49:56 0 [ERROR] InnoDB: page [page id: space=242, page number=447] (161 records, index id 954).
Feb 25 01:49:56 ains mysqld: 2022-02-25 1:49:56 0 [ERROR] InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
any attempt to interact with this specific database table after that failed.
restarting only made things worse, as the process crashes with signal 11. part of restart log below.
Feb 25 08:32:10 ains mysqld: 2022-02-25 8:32:10 0 [ERROR] InnoDB: Unable to decompress ./nextcloud/oc_filecache.ibd[page id: space=242, page number=447]
Feb 25 08:32:10 ains mysqld: 220225 8:32:10 [ERROR] mysqld got signal 11 ;
What is needed to resolve this issue and have mariadb (and as a result nextcloud) online again?
Attachments
Issue Links
- duplicates
-
MDEV-27765 MariaDB stopped to work randomly - misery started at "Unable to find a record to delete-mark"
- Closed
- relates to
-
MDEV-26917 InnoDB: Clustered record for sec rec not found index
- Closed