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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5.12
    • Fix Version/s: 10.5
    • Labels:
    • Environment:
      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

          Activity

            People

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

              Dates

              Created:
              Updated:

                Git Integration

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