I think you'll find that the mysql user don't have permissions to create a new file in /var/log/. As such logrotate renames the file which is still open by mysqld. As such it is now writing to mysqld.log.1.

On 28/03/17 00:13, Matthew Pash wrote:

Hi,

We've got some database servers running MariaDB 10.1.22, and are having issues with logrotate. Specifically, after it runs, it leaves a 0 byte file and continues writing log data to mysqld.log.1

Manually running logrotate in verbose mode shows this error from mysqladmin when it tries to run -flush_logs:

/usr/bin/mysqladmin: flush failed; error: 'Unknown error' error: error running non-shared postrotate script for /var/log/mysqld.log of '/var/log/mysqld.log ' set default create context

What does the logrotate script look like? It really should be a "shared" (in a logrotate way) script.

Has anyone seen this before? It doesn't look like a permissions error - the logs are created fine if you run systemctl restart mariadb.

Is the log actually writing to /var/log/mysqld.log using systemd? It normally writes to the journal because with systemd redirects stderr there.

Thanks, ~Matt

-- *Matthew* Senior Systems Administrator, IT Services University of Bristol

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp