Strange. I don't have a 5.5.30 build handy but I tried this on my
trunk build of mariadb using the sql command and it works:
ebergen@santa:(~/store/mysql/standalone_mariadb) ls -li mysql/slow.log
52430026 -rw-rw----. 1 ebergen ebergen 244 May 23 11:56 mysql/slow.log
ebergen@santa:(~/store/mysql/standalone_mariadb) mv mysql/slow.log{,.old}
ebergen@santa:(~/store/mysql/standalone_mariadb) ls -li mysql/slow.log
ls: cannot access mysql/slow.log: No such file or directory
ebergen@santa:(~/store/mysql/standalone_mariadb) ./con
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 5.5.5-10.0.2-MariaDB-log Source distribution
Copyright (c) 2000, 2012, Oracle, Monty Program Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> flush slow logs;
Query OK, 0 rows affected (0.04 sec)
MariaDB [(none)]> Ctrl-C -- exit!
Aborted
ebergen@santa:(~/store/mysql/standalone_mariadb) ls -li mysql/slow.log*
52430011 -rw-rw----. 1 ebergen ebergen 244 May 23 11:59 mysql/slow.log
52430026 -rw-rw----. 1 ebergen ebergen 244 May 23 11:56 mysql/slow.log.old
Same with mysqladmin:
ebergen@santa:(~/store/mysql/standalone_mariadb) mv mysql/slow.log{,.old}
ebergen@santa:(~/store/mysql/standalone_mariadb) ls -li mysql/slow.log*
52430011 -rw-rw----. 1 ebergen ebergen 488 May 23 12:01 mysql/slow.log.old
ebergen@santa:(~/store/mysql/standalone_mariadb) mysqladmin -S
./mysql.sock flush-logs
ebergen@santa:(~/store/mysql/standalone_mariadb) ls -li mysql/slow.log*
52430026 -rw-rw----. 1 ebergen ebergen 244 May 23 12:02 mysql/slow.log
52430011 -rw-rw----. 1 ebergen ebergen 488 May 23 12:01 mysql/slow.log.old
Are you capturing errors from your crontab? Does running the command
by hand work?
> _______________________________________________
On Thu, May 23, 2013 at 1:11 AM, Rafa³ Radecki <radecki.rafal@gmail.com> wrote:
> Hi All.
>
> I use:
> MariaDB-server-5.5.30-1.x86_64
> on
> CentOS release 6.4 (Final)
> 2.6.32-358.el6.x86_64
>
>
> "flush logs" or "flush slow logs" does not recreate the file.
> In https://dev.mysql.com/doc/refman/5.5/en/flush.html there is "With no
> log_type option, FLUSH LOGS closes and reopens all log files." and "With a
> log_type option, only the specified log type is flushed." but neither
> command recreates the log file.
>
> I rotate slowlog through crontab:
> mv /var/log/mysqld-slow.log /var/log/mysqld-slow.log.old ; mysqladmin
> flush-logs
>
> Is it a bug or should it be so for some reason?
>
> Best regards,
> Rafal.
>
> 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
>
--
Eric Bergen
eric.bergen@gmail.com
http://www.ebergen.net