--recursion-method cluster does NOT work with PXC

[Nilnandan Joshi]

[root@percona-pxc55-1 mysql]# pt-table-checksum --recursion-method=cluster --user=root --password=root
Diffs cannot be detected because no cluster nodes were found. Please read the --recursion-method documentation for information.
percona-pxc55-1 is a cluster node but no other nodes or regular replicas were found. Use --recursion-method=dsn to specify the other nodes in the cluster.

Even though there are two nodes.

| wsrep_local_state_comment | Synced |
| wsrep_cert_index_size | 2 |
| wsrep_causal_reads | 0 |
| wsrep_incoming_addresses | 192.168.43.60:3306,192.168.43.61:3306 |
| wsrep_cluster_conf_id | 2 |
| wsrep_cluster_size | 2 |
| wsrep_cluster_state_uuid | eb3828f9-2125-11e4-b71b-3ff545ea7ce6 |
| wsrep_cluster_status | Primary |
| wsrep_connected | ON |
| wsrep_local_bf_aborts | 0 |
| wsrep_local_index | 0 |
| wsrep_provider_name | Galera |
| wsrep_provider_vendor | Codership Oy <email address hidden> |
| wsrep_provider_version | 2.11(r318911d) |

[Nilnandan Joshi (nilnandan-joshi)]

Checked with latest pt-table-checksum.

[root@percona-pxc55-1 mysql]# pt-table-checksum --version
pt-table-checksum 2.2.10
[root@percona-pxc55-1 mysql]#

[Nilnandan Joshi (nilnandan-joshi)]

This was noted while working on https://bugs.launchpad.net/percona-toolkit/+bug/1220579

[Frank Cizmich (frank-cizmich)]

Hi Joshi,

Please check server_id of the nodes. If they are all the same the tool thinks they are the same and discards them.

See:
https://bugs.launchpad.net/percona-toolkit/+bug/1217466

[Nilnandan Joshi (nilnandan-joshi)]

Hi Frank,

That's true. My both nodes have the same server-id, when I change it in another node, it worked.

[root@percona-pxc55-1 ~]# pt-table-checksum --recursion-method=cluster --user=root --password=root
Not checking replica lag on percona-pxc55-2 because it is a cluster node.
            TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
09-09T23:44:45 0 0 0 1 0 0.367 mysql.columns_priv
09-09T23:44:45 0 0 2 1 0 0.129 mysql.db
09-09T23:44:45 0 0 0 1 0 0.096 mysql.event
09-09T23:44:45 0 0 0 1 0 0.092 mysql.func
09-09T23:44:45 0 0 40 4 0 0.431 mysql.help_category
09-09T23:44:46 0 0 467 4 0 0.405 mysql.help_keyword
09-09T23:44:46 0 0 1048 1 0 0.110 mysql.help_relation
09-09T23:44:46 0 0 510 1 0 0.106 mysql.help_topic
09-09T23:44:46 0 0 0 1 0 0.086 mysql.host
09-09T23:44:46 0 0 0 1 0 0.131 mysql.ndb_binlog_index
09-09T23:44:46 0 0 0 1 0 0.100 mysql.plugin
09-09T23:44:47 0 0 0 1 0 0.126 mysql.proc
09-09T23:44:47 0 0 0 1 0 0.104 mysql.procs_priv
09-09T23:44:47 0 0 2 1 0 0.105 mysql.proxies_priv
09-09T23:44:47 0 0 0 1 0 0.095 mysql.servers
09-09T23:44:47 0 0 0 1 0 0.107 mysql.tables_priv
09-09T23:44:47 0 0 0 1 0 0.107 mysql.time_zone
09-09T23:44:47 0 0 0 1 0 0.092 mysql.time_zone_leap_second
09-09T23:44:47 0 0 0 1 0 0.100 mysql.time_zone_name
09-09T23:44:47 0 0 0 1 0 0.088 mysql.time_zone_transition
09-09T23:44:47 0 0 0 1 0 0.087 mysql.time_zone_transition_type
09-09T23:44:48 0 1 9 1 0 0.107 mysql.user
09-09T23:44:49 0 0 100000 6 0 1.325 sbtest.sbtest
09-09T23:44:49 0 0 110064 1 0 0.443 sbtest.sbtest1
09-09T23:44:50 0 0 0 1 0 0.104 test.black
09-09T23:44:50 0 0 1 1 0 0.102 test.inno
09-09T23:44:50 0 0 0 1 0 0.110 test.mem
09-09T23:44:50 0 0 0 1 0 0.118 test.nil
09-09T23:44:54 0 0 2097152 9 0 3.633 test.t1
09-09T23:44:54 0 0 2 1 0 0.101 test.tb1
09-09T23:44:54 0 0 3 1 0 0.104 test2.t2
[root@percona-pxc55-1 ~]#

[Przemek (pmalkowski)]

Marking as invalid as related issues were already fixed in https://bugs.launchpad.net/percona-toolkit/+bug/1217466 and https://bugs.launchpad.net/percona-toolkit/+bug/1399789