DROP command denied to userfor table '__maatkit_char_chunking_map'

[monty solomon]

When running the pt-table-sync command it sometimes fails with an error message similar to

DROP command denied to user 'SUSR_Checksum' for table '__maatkit_char_chunking_map' [for Statement "DROP TABLE IF EXISTS `Pipeline`.`__maatkit_char_chunking_map`"] at line 4022 while doing Pipeline.jobs on green-queen

pt-table-sync should CREATE and DROP the temporary table in the same database as the checksum table so that suitable privileges can be provided to the pt-table-sync user and not need to provide DROP and CREATE TEMPORARY TABLES privileges on *.* or on other databases.

I was running the command

pt-table-sync --print --replicate percona.checksums --nobin-log --recursion-method hosts

after running the command

pt-table-checksum --no-check-binlog-format --function murmur_hash -recursion-method hosts

pt-table-sync 2.2.16

mysql Ver 14.14 Distrib 5.6.25-73.1, for Linux (x86_64) using 6.0
Server version: 5.6.25-73.1-log Percona Server (GPL), Release 73.1, Revision 07b797f

P.S. Consider updating the name of the `__maatkit_char_chunking_map` table.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1325