pt-table-checksum pxc same_node function incorrectly uses wsrep_sst_receive_address

[Jay Janssen]

pt-table-checksum has a 'same_node' function which seems to try to identify if one connection is actually the same node as another:

sub same_node {
   my ($self, $cxn1, $cxn2) = @_;

   my $sql = "SHOW VARIABLES LIKE 'wsrep\_sst\_receive\_address'";
   PTDEBUG && _d($cxn1->name, $sql);
   my (undef, $val1) = $cxn1->dbh->selectrow_array($sql);
   PTDEBUG && _d($cxn2->name, $sql);
   my (undef, $val2) = $cxn2->dbh->selectrow_array($sql);

   return ($val1 || '') eq ($val2 || '');
}

Unfortunately in PXC, it is perfectly legal to leave wsrep_sst_receive_address as the default, which is AUTO and thus the same on all the nodes.

I'd suggest checking either (or both):
wsrep_node_name
wsrep_node_address (maybe)

[Daniel Nichter (daniel-nichter)]

Thanks Jay. We'll look into this.

[Shahriyar Rzayev (rzayev-sehriyar)]

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