[mythtv-users] Unable to start mariadb after Debian system upgrade

[Peter Carlsson]

Hello!

Yesterday I updated from Debian Buster to Bullseye and I did not see any
errors during the update. But after a reboot I am no longer able to
start MariaDB.

Any help would be appreciated to fix this problem.

Best regards,
Peter Carlsson

server:/etc# systemctl start mariadb
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

server:/etc# systemctl status mariadb.service
● mariadb.service - MariaDB 10.5.18 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Sun 2023-01-22 10:20:31 CET; 49s ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 23847 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 23848 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 23850 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
    Process: 23901 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
   Main PID: 23901 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"
        CPU: 107ms

jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] InnoDB: Starting shutdown...
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] Plugin 'InnoDB' init function returned error.
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] Plugin 'FEEDBACK' is disabled.
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] Unknown/unsupported storage engine: InnoDB
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] Aborting
jan 22 10:20:31 server systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
jan 22 10:20:31 server systemd[1]: mariadb.service: Failed with result 'exit-code'.
jan 22 10:20:31 server systemd[1]: Failed to start MariaDB 10.5.18 database server.

jan 22 10:20:31 server systemd[1]: Starting MariaDB 10.5.18 database server...
░░ Subject: A start job for unit mariadb.service has begun execution
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░ 
░░ A start job for unit mariadb.service has begun execution.
░░ 
░░ The job identifier is 19499.
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.18-MariaDB-0+deb11u1) starting as process 23901 ...
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] InnoDB: Uses event mutexes
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] InnoDB: Number of pools: 1
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] InnoDB: Using Linux native AIO
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] InnoDB: Completed initialization of buffer pool
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] InnoDB: Space id and page no stored in the page, read in are [page id: space=0, page number=32824], should be [page id: space=0, page number=1081400]
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] InnoDB: invalid undo header offset 65535
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] InnoDB: Retry with innodb_force_recovery=5
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] InnoDB: Starting shutdown...
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] Plugin 'InnoDB' init function returned error.
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [Note] Plugin 'FEEDBACK' is disabled.
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] Unknown/unsupported storage engine: InnoDB
jan 22 10:20:31 server mariadbd[23901]: 2023-01-22 10:20:31 0 [ERROR] Aborting
jan 22 10:20:31 server systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░ 
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░ 
░░ The process' exit code is 'exited' and its exit status is 1.
jan 22 10:20:31 server audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 subj=unconfined msg='unit=mariadb comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=failed'
jan 22 10:20:31 server systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░ 
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
jan 22 10:20:31 server systemd[1]: Failed to start MariaDB 10.5.18 database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░ 
░░ A start job for unit mariadb.service has finished with a failure.
░░ 
░░ The job identifier is 19499 and the job result is failed.