Package: mariadb-server-10.0 Version: 10.0.38-0+deb8u1 Severity: normal Dear Maintainer,
I stopped the service as I'm not currently using the service but don't (yet) wish to uninstall it. root@yipyap:~# systemctl status mysql.service ○ mysql.service - LSB: Start and stop the mysql database server daemon Loaded: loaded (/etc/init.d/mysql; generated) Active: inactive (dead) Docs: man:systemd-sysv-generator(8) This has made logrotate slightly unhappy: root@yipyap:~# systemctl status logrotate.service × logrotate.service - Rotate log files Loaded: loaded (/lib/systemd/system/logrotate.service; static) Active: failed (Result: exit-code) since Tue 2023-07-11 00:00:58 AWST; 23h ago TriggeredBy: ● logrotate.timer Docs: man:logrotate(8) man:logrotate.conf(5) Main PID: 18227 (code=exited, status=1/FAILURE) CPU: 1.868s Jul 11 00:00:18 yipyap systemd[1]: Starting logrotate.service - Rotate log files... Jul 11 00:00:34 yipyap logrotate[19669]: [52B blob data] Jul 11 00:00:34 yipyap logrotate[19669]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")' Jul 11 00:00:34 yipyap logrotate[19669]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Jul 11 00:00:34 yipyap logrotate[18227]: error: error running shared postrotate script for '/var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/error.log ' Jul 11 00:00:58 yipyap systemd[1]: logrotate.service: Main process exited, code=exited, status=1/FAILURE Jul 11 00:00:58 yipyap systemd[1]: logrotate.service: Failed with result 'exit-code'. Jul 11 00:00:58 yipyap systemd[1]: Failed to start logrotate.service - Rotate log files. Jul 11 00:00:58 yipyap systemd[1]: logrotate.service: Consumed 1.868s CPU time. I'm not convinced that the (currently empty) logs are being rotated correctly: root@yipyap:~# ls -la /var/log/mysql/ total 112 drwxr-s--- 1 mysql adm 68 Jul 11 00:00 . drwxr-xr-x 1 root root 5932 Jul 11 06:25 .. -rw-r----- 1 mysql adm 0 Jul 11 00:00 error.log -rw-r----- 1 mysql adm 0 Jul 10 00:00 error.log.1 -rw-r----- 1 mysql adm 20 Jul 2 00:00 error.log.8.gz I suggest that /etc/logrotate.d/mysql-server should only attempt to run flush-logs if the server's actually running. -- System Information: Debian Release: 12.0 APT prefers stable-security APT policy: (500, 'stable-security'), (500, 'oldstable-updates'), (500, 'oldstable-security'), (500, 'oldoldstable-updates'), (500, 'oldoldstable-debug'), (500, 'oldoldstable'), (500, 'stable'), (500, 'oldstable'), (460, 'unstable') Architecture: i386 (i686) Kernel: Linux 6.1.0-9-686-pae (SMP w/1 CPU thread; PREEMPT) Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8), LANGUAGE not set Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) Versions of packages mariadb-server-10.0 depends on: ii adduser 3.134 ii debconf [debconf-2.0] 1.5.82 ii libaio1 0.3.113-4 ii libc6 2.36-9 ii libdbi-perl 1.643-4 ii libpam0g 1.5.2-6 ii libstdc++6 12.2.0-14 ii lsb-base 11.6 ii mariadb-client-10.0 10.0.38-0+deb8u1 ii mariadb-common 1:10.11.3-1 ii mariadb-server-core-10.0 10.0.38-0+deb8u1 ii passwd 1:4.13+dfsg1-1+b1 ii perl 5.36.0-7 ii psmisc 23.6-1 ii sysvinit-utils [lsb-base] 3.06-4 ii zlib1g 1:1.2.13.dfsg-1 Versions of packages mariadb-server-10.0 recommends: ii libhtml-template-perl 2.97-2 Versions of packages mariadb-server-10.0 suggests: pn mailx <none> pn mariadb-test <none> pn tinyca <none> -- Configuration Files: /etc/logcheck/ignore.d.paranoid/mariadb-server-10_0 [Errno 13] Permission denied: '/etc/logcheck/ignore.d.paranoid/mariadb-server-10_0' /etc/logcheck/ignore.d.server/mariadb-server-10_0 [Errno 13] Permission denied: '/etc/logcheck/ignore.d.server/mariadb-server-10_0' /etc/logcheck/ignore.d.workstation/mariadb-server-10_0 [Errno 13] Permission denied: '/etc/logcheck/ignore.d.workstation/mariadb-server-10_0' -- debconf information: mysql-server/password_mismatch: mariadb-server/oneway_migration: true mysql-server/error_setting_password: mysql-server-10.0/nis_warning: mysql-server-10.0/postrm_remove_databases: false mariadb-server-10.0/really_downgrade: false mysql-server/no_upgrade_when_using_ndb: