LP #916168: pt-table-checksum privilege check fails on MySQL 5.5

**Reported in Launchpad by Aurimas Mikalauskas last update 10-08-2012 18:13:32

If percona.checksum table exists, privileges check fails with the following error:

01-13T12:21:20 User does not have all privileges on --replicate table `percona`.`checksums`.

Here's the PTDEBUG output:

1. pt_table_checksum:6995 6643 Checking --replicate table `percona`.`checksums`
2. pt_table_checksum:7000 6643 SHOW DATABASES LIKE 'percona'
3. pt_table_checksum:7098 6643 use_repl_db
4. pt_table_checksum:7119 6643 USE `percona`
5. TableParser:1952 6643 Checking `percona`.`checksums`
6. TableParser:1956 6643 SHOW TABLES FROM `percona` LIKE 'checksums'
7. TableParser:1970 6643 Table exists; no privs to check
8. pt_table_checksum:7033 6643 --replicate table `percona`.`checksums` already exists
9. TableParser:1952 6643 Checking `percona`.`checksums`
10. TableParser:1956 6643 SHOW TABLES FROM `percona` LIKE 'checksums'
11. TableParser:1970 6643 Table exists; no privs to check
12. TableParser:1974 6643 SHOW FULL COLUMNS FROM `percona`.`checksums`
13. TableParser:1989 6643 DELETE FROM `percona`.`checksums` LIMIT 0
14. TableParser:1995 6643 User privs on `percona`.`checksums` : select delete
15. TableParser:2000 6643 User does not have all privs
    01-13T12:21:20 User does not have all privileges on --replicate table `percona`.`checksums`.
16. Cxn:1514 6643 Disconnecting dbh DBI::db=HASH(0xffdb2c0) undef
17. Cxn:1514 6643 Disconnecting dbh DBI::db=HASH(0x1038c830) undef

When I drop the table, everything starts up just fine. I have created the following privileges:

grant select, replication slave, replication client, super, process on . to 'u'@'10.0.0.0/255.255.255.0' identified by 'p';
grant all on percona.* to 'u'@'10.0.0.0/255.255.255.0';
create database percona;

And I run check as:

perl pt-table-checksum h=10.0.0.1,u=u,p=p

On 5.5.14-55-log Percona Server (GPL), Release rel20.5, Revision 149

Aurimas