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:
