pt-table-checksum privilege check fails on MySQL 5.5
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Medium
|
Daniel Nichter | ||
2.0 |
Won't Fix
|
Undecided
|
Unassigned | ||
2.1 |
Fix Released
|
Medium
|
Daniel Nichter |
Bug Description
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`
Here's the PTDEBUG output:
# pt_table_
# pt_table_
# pt_table_
# pt_table_
# TableParser:1952 6643 Checking `percona`
# TableParser:1956 6643 SHOW TABLES FROM `percona` LIKE 'checksums'
# TableParser:1970 6643 Table exists; no privs to check
# pt_table_
# TableParser:1952 6643 Checking `percona`
# 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`
# TableParser:1989 6643 DELETE FROM `percona`
# TableParser:1995 6643 User privs on `percona`
# TableParser:2000 6643 User does not have all privs
01-13T12:21:20 User does not have all privileges on --replicate table `percona`
# Cxn:1514 6643 Disconnecting dbh DBI::db=
# Cxn:1514 6643 Disconnecting dbh DBI::db=
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.
grant all on percona.* to 'u'@'10.
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
Related branches
- Daniel Nichter: Approve
-
Diff: 93 lines (+49/-11)3 files modifiedbin/pt-table-checksum (+2/-9)
t/pt-table-checksum/privs.t (+26/-2)
t/pt-table-checksum/samples/privs-bug-916168.sql (+21/-0)
tags: | added: privs pt-table-checksum |
Changed in percona-toolkit: | |
status: | New → Confirmed |
Changed in percona-toolkit: | |
milestone: | none → 2.1.3 |
Changed in percona-toolkit: | |
importance: | Undecided → Medium |
Changed in percona-toolkit: | |
status: | Confirmed → In Progress |
assignee: | nobody → Daniel Nichter (daniel-nichter) |
summary: |
- bug in pt-table-checksum privileges check + pt-table-checksum privileges check fail on MySQL 5.5 |
summary: |
- pt-table-checksum privileges check fail on MySQL 5.5 + pt-table-checksum privilege check fails on MySQL 5.5 |
Bug 1003939 is a duplicate of this one. There is some useful discussion in the comments thread on that bug.