Comment 4 for bug 1367156

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

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 ~]#