-
Type:
Bug
-
Status: Done
-
Priority:
High
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Launchpad URL:
**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:
- pt_table_checksum:6995 6643 Checking --replicate table `percona`.`checksums`
- pt_table_checksum:7000 6643 SHOW DATABASES LIKE 'percona'
- pt_table_checksum:7098 6643 use_repl_db
- pt_table_checksum:7119 6643 USE `percona`
- TableParser:1952 6643 Checking `percona`.`checksums`
- TableParser:1956 6643 SHOW TABLES FROM `percona` LIKE 'checksums'
- TableParser:1970 6643 Table exists; no privs to check
- pt_table_checksum:7033 6643 --replicate table `percona`.`checksums` already exists
- TableParser:1952 6643 Checking `percona`.`checksums`
- TableParser:1956 6643 SHOW TABLES FROM `percona` LIKE 'checksums'
- TableParser:1970 6643 Table exists; no privs to check
- TableParser:1974 6643 SHOW FULL COLUMNS FROM `percona`.`checksums`
- TableParser:1989 6643 DELETE FROM `percona`.`checksums` LIMIT 0
- TableParser:1995 6643 User privs on `percona`.`checksums` : select delete
- TableParser:2000 6643 User does not have all privs
01-13T12:21:20 User does not have all privileges on --replicate table `percona`.`checksums`. - Cxn:1514 6643 Disconnecting dbh DBI::db=HASH(0xffdb2c0) undef
- 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