Bug#891218: mariadb-server-10.1: logrotate sometimes fails with "Lost connection to MySQL server"

[Ralf Jung]

Package: mariadb-server-10.1
Version: 10.1.26-0+deb9u1
Severity: normal

Dear Maintainer,

sometimes (but not every day), logrotate fails saying

/etc/cron.daily/logrotate:
mysqladmin: connect to server at 'localhost' failed
error: 'Lost connection to MySQL server at 'sending authentication information', system error: 32 "Broken pipe"'
error: error running shared postrotate script for '/var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/mariadb-slow.log /var/log/mysql/error.log '
run-parts: /etc/cron.daily/logrotate exited with return code 1

I can't see anything about this in other logfiles.

Kind regards,
Ralf

-- System Information:
Debian Release: buster/sid
APT prefers testing
APT policy: (990, 'testing'), (500, 'unstable-debug'), (500, 'testing-debug'), (100, 'unstable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.14.0-3-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

[Faustin Lammler]

Hi Ralf,
thank you for your report.

This seems to be a connexion problem and can be caused by the database
being under heavy load. Then the connexion times out and rotation of
logs can't be achieved. May that be possible?

Regards,

Faustin