Package: mariadb-server-core-10.6 Version: 1:10.6.11-1 Severity: normal Dear Maintainer, I'm attempting to get the db installed and can't get it to start. I found a KB on the mariadb site that tells you to disable the apparmor profile by running 'sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/' and 'sudo apparmor_parser -R /etc/apparmor.d/usr.sbin.mysqld' and restart maria via 'dpkg- reconfigure mariadb-server' then 'sudo systemctl restart mariadb.service' Which gives this error: Job for mariadb.service failed because the control process exited with error code: See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.
I've attached the results of journal control to this as maria- errors.txt -- System Information: Debian Release: bookworm/sid APT prefers testing-debug APT policy: (500, 'testing-debug'), (500, 'testing') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 6.0.0-5-amd64 (SMP w/2 CPU threads; PREEMPT) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages mariadb-server-core-10.6 depends on: ii libc6 2.36-6 ii libcrypt1 1:4.4.33-1 ii liblz4-1 1.9.4-1 ii libnuma1 2.0.15-1 ii libpcre2-8-0 10.40-2 ii libpmem1 1.12.1-1 ii libsnappy1v5 1.1.9-2 ii libssl3 3.0.7-1 ii libstdc++6 12.2.0-9 ii libsystemd0 252.2-1 ii liburing2 2.3-2 ii mariadb-common 1:10.6.11-1 ii zlib1g 1:1.2.11.dfsg-4.1 mariadb-server-core-10.6 recommends no packages. mariadb-server-core-10.6 suggests no packages. -- no debconf information
Dec 05 19:52:48 DebianTim systemd[1]: Starting MariaDB 10.6.10 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 226. Dec 05 19:53:00 DebianTim mariadbd[1078]: 2022-12-05 19:53:00 0 [Note] /usr/sbin/mariadbd (server 10.6.10-MariaDB-1+b1) starting as process 1078 ... Dec 05 19:53:03 DebianTim mariadbd[1078]: 2022-12-05 19:53:03 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 Dec 05 19:53:04 DebianTim mariadbd[1078]: 2022-12-05 19:53:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Dec 05 19:53:04 DebianTim mariadbd[1078]: 2022-12-05 19:53:04 0 [Note] InnoDB: Number of pools: 1 Dec 05 19:53:04 DebianTim mariadbd[1078]: 2022-12-05 19:53:04 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Dec 05 19:53:04 DebianTim mariadbd[1078]: 2022-12-05 19:53:04 0 [Note] InnoDB: Using liburing Dec 05 19:53:04 DebianTim mariadbd[1078]: 2022-12-05 19:53:04 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Dec 05 19:53:04 DebianTim mariadbd[1078]: 2022-12-05 19:53:04 0 [Note] InnoDB: Completed initialization of buffer pool Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [Note] InnoDB: 128 rollback segments are active. Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [Note] InnoDB: 10.6.10 started; log sequence number 33688; transaction id 4 Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [Note] Plugin 'FEEDBACK' is disabled. Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [Note] InnoDB: Buffer pool(s) load completed at 221205 19:53:07 Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work. Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [Note] Server socket created on IP: '127.0.0.1'. Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist Dec 05 19:53:07 DebianTim mariadbd[1078]: 2022-12-05 19:53:07 0 [ERROR] Aborting Dec 05 19:53:08 DebianTim mariadbd[1078]: Warning: Memory not freed: 280 Dec 05 19:53:08 DebianTim 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. Dec 05 19:53:08 DebianTim 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'. Dec 05 19:53:08 DebianTim systemd[1]: Failed to start MariaDB 10.6.10 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 226 and the job result is failed. Dec 07 15:22:57 DebianTim systemd[1]: Starting MariaDB 10.6.11 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 106001. Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] /usr/sbin/mariadbd (server 10.6.11-MariaDB-1) starting as process 2449985 ... Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: Number of pools: 1 Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: Using liburing Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: Completed initialization of buffer pool Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: 128 rollback segments are active. Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: 10.6.11 started; log sequence number 33700; transaction id 4 Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] Plugin 'FEEDBACK' is disabled. Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] InnoDB: Buffer pool(s) load completed at 221207 15:22:57 Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work. Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [Note] Server socket created on IP: '127.0.0.1'. Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist Dec 07 15:22:57 DebianTim mariadbd[2449985]: 2022-12-07 15:22:57 0 [ERROR] Aborting Dec 07 15:22:57 DebianTim mariadbd[2449985]: Warning: Memory not freed: 280 Dec 07 15:22:57 DebianTim 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. Dec 07 15:22:57 DebianTim 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'. Dec 07 15:22:57 DebianTim systemd[1]: Failed to start MariaDB 10.6.11 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 106001 and the job result is failed. Dec 07 17:33:33 DebianTim systemd[1]: Starting MariaDB 10.6.11 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 110709. Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] /usr/sbin/mariadbd (server 10.6.11-MariaDB-1) starting as process 2470431 ... Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: Number of pools: 1 Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: Using liburing Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: Completed initialization of buffer pool Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: 128 rollback segments are active. Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: 10.6.11 started; log sequence number 33712; transaction id 4 Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] Plugin 'FEEDBACK' is disabled. Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] InnoDB: Buffer pool(s) load completed at 221207 17:33:33 Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work. Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [Note] Server socket created on IP: '127.0.0.1'. Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist Dec 07 17:33:33 DebianTim mariadbd[2470431]: 2022-12-07 17:33:33 0 [ERROR] Aborting Dec 07 17:33:34 DebianTim mariadbd[2470431]: Warning: Memory not freed: 280 Dec 07 17:33:34 DebianTim 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. Dec 07 17:33:34 DebianTim 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'. Dec 07 17:33:34 DebianTim systemd[1]: Failed to start MariaDB 10.6.11 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 110709 and the job result is failed.