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

MariaDB Crashes during auto updates Ubuntu 24.04

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.11.11
    • N/A
    • None
    • Server version: 10.11.11-MariaDB-0ubuntu0.24.04.2 Ubuntu 24.04

    Description

      At random intervals (one day to four weeks), the MariaDB server will shut down normally during auto updates, and then crash upon startup.
      This does NOT occur on Ubuntu 22 or earlier versions.

      Syslog snippet:

      2025-04-05T06:06:23.082304+00:00 systemd[1]: Stopping mariadb.service - MariaDB 10.11.11 database server...
      2025-04-05T06:06:23.083691+00:00 mariadbd[48432]: 2025-04-05 6:06:23 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
      2025-04-05T06:06:23.092968+00:00 mariadbd[48432]: 2025-04-05 6:06:23 0 [Note] InnoDB: FTS optimize thread exiting.
      2025-04-05T06:06:23.151897+00:00 mariadbd[48432]: 2025-04-05 6:06:23 0 [Note] InnoDB: Starting shutdown...
      2025-04-05T06:06:23.159819+00:00 mariadbd[48432]: 2025-04-05 6:06:23 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
      2025-04-05T06:06:23.160500+00:00 mariadbd[48432]: 2025-04-05 6:06:23 0 [Note] InnoDB: Restricted to 2016 pages due to innodb_buf_pool_dump_pct=25
      2025-04-05T06:06:23.162000+00:00 mariadbd[48432]: 2025-04-05 6:06:23 0 [Note] InnoDB: Buffer pool(s) dump completed at 250405 6:06:23
      2025-04-05T06:06:23.642228+00:00 mariadbd[48432]: 2025-04-05 6:06:23 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
      2025-04-05T06:06:23.642335+00:00 mariadbd[48432]: 2025-04-05 6:06:23 0 [Note] InnoDB: Shutdown completed; log sequence number 41037891025; transaction id 23091490
      2025-04-05T06:06:23.678742+00:00 mariadbd[48432]: 2025-04-05 6:06:23 0 [Note] /usr/sbin/mariadbd: Shutdown complete
      2025-04-05T06:06:23.742015+00:00 systemd[1]: mariadb.service: Deactivated successfully.
      2025-04-05T06:06:23.742357+00:00 systemd[1]: Stopped mariadb.service - MariaDB 10.11.11 database server.
      2025-04-05T06:06:23.742486+00:00 systemd[1]: mariadb.service: Consumed 45min 2.757s CPU time, 380.0M memory peak, 0B memory swap peak.
      2025-04-05T06:06:23.760217+00:00 systemd[1]: Starting mariadb.service - MariaDB 10.11.11 database server...
      2025-04-05T06:06:24.053383+00:00 (mariadbd)[121586]: mariadb.service: Referenced but unset environment variable evaluates to an empty string: MYSQLD_OPTS, _WSREP_NEW_CLUSTER
      2025-04-05T06:06:24.133902+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [Note] Starting MariaDB 10.11.11-MariaDB-0ubuntu0.24.04.2 source revision e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4 server_uid DN5nFlgOENgRVFku5no/U+EYDDw= as process 121586
      2025-04-05T06:06:24.183605+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [Note] InnoDB: Compressed tables use zlib 1.3
      2025-04-05T06:06:24.188046+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [Note] InnoDB: Number of transaction pools: 1
      2025-04-05T06:06:24.188423+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2025-04-05T06:06:24.189854+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [Note] InnoDB: Using liburing
      2025-04-05T06:06:24.189931+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
      2025-04-05T06:06:24.192866+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [Note] InnoDB: Initialized memory pressure event listener
      2025-04-05T06:06:24.192940+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [Note] InnoDB: Completed initialization of buffer pool
      2025-04-05T06:06:24.193695+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
      2025-04-05T06:06:24.242742+00:00 kernel: I/O error, dev vda, sector 8844530 op 0x0:(READ) flags 0x0 phys_seg 4 prio class 0
      2025-04-05T06:06:24.242771+00:00 kernel: I/O error, dev vda, sector 8844562 op 0x0:(READ) flags 0x4000 phys_seg 126 prio class 0
      2025-04-05T06:06:24.242781+00:00 kernel: I/O error, dev vda, sector 8845570 op 0x0:(READ) flags 0x4000 phys_seg 126 prio class 0
      2025-04-05T06:06:24.245581+00:00 kernel: I/O error, dev vda, sector 8846578 op 0x0:(READ) flags 0x0 phys_seg 4 prio class 0
      2025-04-05T06:06:24.246929+00:00 kernel: I/O error, dev vda, sector 8846610 op 0x0:(READ) flags 0x4000 phys_seg 126 prio class 0
      2025-04-05T06:06:24.248317+00:00 kernel: I/O error, dev vda, sector 8847618 op 0x0:(READ) flags 0x4000 phys_seg 126 prio class 0
      2025-04-05T06:06:24.249586+00:00 kernel: I/O error, dev vda, sector 8848626 op 0x0:(READ) flags 0x0 phys_seg 4 prio class 0
      2025-04-05T06:06:24.250685+00:00 kernel: I/O error, dev vda, sector 8848658 op 0x0:(READ) flags 0x4000 phys_seg 126 prio class 0
      2025-04-05T06:06:24.250704+00:00 kernel: I/O error, dev vda, sector 8849674 op 0x0:(READ) flags 0x4000 phys_seg 126 prio class 0
      2025-04-05T06:06:24.252958+00:00 kernel: I/O error, dev vda, sector 8850682 op 0x0:(READ) flags 0x0 phys_seg 4 prio class 0
      2025-04-05T06:06:24.255922+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [ERROR] InnoDB: pread("ib_logfile0") returned -1, operating system error 5
      2025-04-05T06:06:24.256046+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [ERROR] InnoDB: Failed to read log at 72930304: I/O error
      2025-04-05T06:06:24.256109+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
      2025-04-05T06:06:24.256145+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [Note] InnoDB: Starting shutdown...
      2025-04-05T06:06:24.473459+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
      2025-04-05T06:06:24.473616+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [Note] Plugin 'FEEDBACK' is disabled.
      2025-04-05T06:06:24.478905+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [ERROR] Unknown/unsupported storage engine: InnoDB
      2025-04-05T06:06:24.479934+00:00 mariadbd[121586]: 2025-04-05 6:06:24 0 [ERROR] Aborting
      2025-04-05T06:06:24.501335+00:00 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
      2025-04-05T06:06:24.501803+00:00 systemd[1]: mariadb.service: Failed with result 'exit-code'.
      2025-04-05T06:06:24.504044+00:00 systemd[1]: Failed to start mariadb.service - MariaDB 10.11.11 database server.

      Attachments

        Activity

          People

            danblack Daniel Black
            LLTechTeam Lounge Lizard Tech Team
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.