Comment 8 for bug 420181

Does mysql_fix_privilege_tables fix the problem?

Sent from my iPhone

On Nov 30, 2010, at 3:08 PM, Andrew Kent <email address hidden> wrote:

> I've just been caught by the same problem.
>
> Restoring a backup from a master server running: Percona-Server-
> server-51-5.1.50-rel11.4.111.rhel5 onto a slave server running the same.
>
> The db restores correctly, but the /mysql/slow_log.CSV and
> /mysql/slow_log.CSM files did not come across as part of the restore.
>
> When I went to enable slow logging on the new slave, I received the
> following error:
>
> mysql> set global slow_query_log = 1;
> ERROR 13 (HY000): Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)
> mysql>
>
> However, my slow log configuration is (and always has been):
>
> | slow_query_log | OFF |
> | slow_query_log_file | /var/lib/mysql/sqls05-slow.log |
>
> I have never configured the server to use TABLES for the slow log, nor
> have I used a mysql or percona version that defaulted to TABLE output.
>
> For some reason mysql requires the slow_log.CSV table to be around even
> in order to enable slow logging to a file.
>
> Copying the slow_log.CSV and slow_log.CSM tables into place on the new
> server allowed me to enable slow logging.
>
> (The same issue may also impact the general_log table - it is also an
> automatically created CSV table. I don't use it so cannot confirm the
> impact).
>
> Andrew
>
> --
> innobackupex fails to backup CSV tables causing mysql_upgrade to fail
> https://bugs.launchpad.net/bugs/420181
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona-XtraBackup.