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

MariaDB keeps restarting

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.5.15
    • Fix Version/s: N/A
    • Component/s: Platform Debian
    • Labels:
    • 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!

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            conta conta
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.