There is no --recursion-method=none option
Bug #987694 reported by
Alexander P
This bug affects 1 person
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
Hi,
not sure if this is a bug or if I just cannot find the right command line option. I try to run the new 2.1.1. on Amazon RDS where I don't have access/privileges to access "SHOW SLAVE HOSTS". Therefore pt-online-
DBD::mysql::db selectall_arrayref failed: Access denied; you need (at least one of) the REPLICATION SLAVE privilege(s) for this operation [for Statement "SHOW SLAVE HOSTS"] at ./pt-online-
Is there a way to disable this query or to tell the tool not to check for this and just ignore any potential slaves?
Thanks a lot
Alex
Related branches
lp:~percona-toolkit-dev/percona-toolkit/recursion-method-none-bug-987694
- Daniel Nichter: Approve
-
Diff: 604 lines (+354/-6)13 files modifiedbin/pt-heartbeat (+10/-1)
bin/pt-online-schema-change (+9/-0)
bin/pt-slave-find (+10/-1)
bin/pt-slave-restart (+10/-1)
bin/pt-table-checksum (+13/-0)
bin/pt-table-sync (+10/-1)
lib/MasterSlave.pm (+10/-0)
t/lib/MasterSlave.t (+91/-1)
t/lib/samples/ro-checksum-user.sql (+3/-0)
t/pt-online-schema-change/privs.t (+86/-0)
t/pt-online-schema-change/samples/osc-user.sql (+3/-0)
t/pt-slave-restart/pt-slave-restart.t (+1/-1)
t/pt-table-checksum/privs.t (+98/-0)
tags: | added: pt-online-schema-change |
tags: | added: privs slave-recursion |
tags: | added: pt-table-checksum |
To post a comment you must log in.
There is currently no way to tell it to ignore that check entirely. However, you can create an empty DSN table and use --recursion- method= DSN=<DSN of your table> and it will then find no slaves to monitor.
We should probably add --recursion- method= none to all of the tools so that the checks can be disabled more easily.