Comment 8 for bug 1136834
Revision history for this message
| Daniel Nichter (daniel-nichter) wrote | #8 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
Yvonne,
I don't think this is a bug in any tool, but some local MySQL issue. It works on stock MySQL 5.5 for me:
$ bin/pt-slave-find -h 127.1 -u msandbox -p msandbox -P 12345
127.1:12345
Version 5.5.29-log
Server ID 12345
Uptime 00:34 (started 2013-03-
Replication Is not a slave, has 1 slaves connected, is not read_only
...
We regularly test all the tools on MySQL 5.0 - 5.6 and this has never happened. So the evidence points to a local MySQL issue. I thought maybe a privileges problem, but http://
"""
SHOW GRANTS requires the SELECT privilege for the mysql database, except to see the privileges for the current user.
"""
So "SHOW GRANTS FOR CURRENT_USER()" should always work.
It's a very odd problem: by all accounts it shouldn't happen, but it is. Since I feel confident that it's not a bug in the tools and I can't reproduce it, I'm going to mark this bug as Incomplete for now. Please try to debug locally and either isolate the cause or provide a way for me to re-create this error.