Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27949

[crash] Unable to find a record to delete-mark

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.5.12
    • N/A
    • 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

          Activity

            People

              marko Marko Mäkelä
              robje RobJE
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.