There is no --recursion-method=none option

[Alexander P]

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-schema-change gives me the error:

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-schema-change line 3019.

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

[Baron Schwartz (baron-xaprb)]

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.

[Daniel Nichter (daniel-nichter)]

WontFix in 2.0 because that series is for bug fixes only, and this more of a feature than a bug. Will fix in 2.1 tools.

[Daniel Nichter (daniel-nichter)]

I can reproduce this:

CREATE USER 'ro_checksum_user'@'%' IDENTIFIED BY 'msandbox';
GRANT SELECT ON sakila.* TO 'ro_checksum_user'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON percona.checksums TO 'ro_checksum_user'@'%';

$ pt-table-checksum u=ro_checksum_user,p=msandbox,h=127.1,P=12345

DBD::mysql::db selectall_arrayref failed: Access denied; you need the REPLICATION SLAVE privilege for this operation [for Statement "SHOW SLAVE HOSTS"] at ./pt-table-checksum line 2603.

[Daniel Nichter (daniel-nichter)]

Tools that now have --recursion-method=none (to be released in 2.1.2):

  bin/pt-heartbeat
  bin/pt-online-schema-change
  bin/pt-slave-find
  bin/pt-slave-restart
  bin/pt-table-checksum
  bin/pt-table-sync

Not that --recursion-method=none makes sense for pt-slave-find or pt-slave-restart, but nonetheless.

[Shahriyar Rzayev (rzayev-sehriyar)]

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