Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.11.11
-
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.