[debian-mysql] Bug#1025784: mariadb-server-core-10.6: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (111)

Tim McConnell tmcconnell168 at gmail.com
Fri Dec 9 01:25:52 GMT 2022 

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
-------------- next part --------------
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.

More information about the pkg-mysql-maint mailing list