pt-table-checksum fails to find pxc nodes when wsrep_node_incoming_address is set to AUTO
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
High
|
Frank Cizmich |
Bug Description
Per this fix https:/
However, our cluster sets this value to AUTO, so all the nodes are being seen as non-unique causing no nodes to be found. If I downgrade to version 2.2.11, the error goes away because server-id is being used again.
A possible fix could be to check the server-id first, and if thats not unique then check wsrep_node_
percona-toolkit version: 2.2.12
Server version: 5.6.20-68.0-56-log Percona XtraDB Cluster (GPL), Release 25.7, wsrep_25.7.r4126
Reproduce:
root@CCCCCCCCC:~# pt-table-checksum --version
pt-table-checksum 2.2.12
root@CCCCCCCCCC:~# pt-table-checksum --recursion-
Diffs cannot be detected because no cluster nodes were found. Please read the --recursion-method documentation for information.
CCCCCCCCCCCCCCC is a cluster node but no other nodes or regular replicas were found. Use --recursion-
root@CCCCCCCCCCC:~# mysql -e "show variables like 'wsrep_
+------
| Variable_name | Value |
+------
| wsrep_node_
+------
Downgraded:
root@AAAAAAAA:/tmp# pt-table-checksum --recursion-
Not checking replica lag on BBBBBBBBBBBBBBB
Not checking replica lag on AAAAAAAAAAAAAAA
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
12-05T20:37:54 0 0 0 1 0 0.047 mysql.columns_priv
12-05T20:37:54 0 0 2 1 0 0.067 mysql.db
12-05T20:37:54 0 0 0 1 0 0.086 mysql.event
12-05T20:37:54 0 0 0 1 0 0.043 mysql.func
12-05T20:37:55 0 0 40 1 0 0.076 mysql.help_category
12-05T20:37:55 0 0 485 1 0 0.099 mysql.help_keyword
12-05T20:37:55 0 0 1090 1 0 0.045 mysql.help_relation
12-05T20:37:55 0 0 533 1 0 0.044 mysql.help_topic
12-05T20:37:55 0 0 0 1 0 0.036 mysql.ndb_
12-05T20:37:55 0 0 0 1 0 0.047 mysql.plugin
12-05T20:37:55 0 0 0 1 0 0.042 mysql.proc
12-05T20:37:55 0 0 0 1 0 0.046 mysql.procs_priv
12-05T20:37:55 0 0 2 1 0 0.041 mysql.proxies_priv
12-05T20:37:55 0 0 0 1 0 0.051 mysql.servers
12-05T20:37:55 0 0 0 1 0 0.039 mysql.tables_priv
12-05T20:37:55 0 0 0 1 0 0.047 mysql.time_zone
12-05T20:37:55 0 0 0 1 0 0.051 mysql.time_
12-05T20:37:56 0 0 0 1 0 0.893 mysql.time_
12-05T20:37:56 0 0 0 1 0 0.050 mysql.time_
12-05T20:37:56 0 0 0 1 0 0.037 mysql.time_
12-05T20:37:56 0 0 7 1 0 0.044 mysql.user
root@AAAAAAAAAA
+------
| Variable_name | Value |
+------
| wsrep_node_
+------
Related branches
- Daniel Nichter: Needs Information
-
Diff: 605 lines (+302/-56)11 files modifiedbin/pt-config-diff (+29/-4)
bin/pt-deadlock-logger (+29/-4)
bin/pt-fk-error-logger (+29/-4)
bin/pt-kill (+29/-4)
bin/pt-online-schema-change (+30/-8)
bin/pt-table-checksum (+32/-12)
bin/pt-upgrade (+29/-4)
lib/Cxn.pm (+32/-7)
lib/Percona/XtraDB/Cluster.pm (+1/-7)
sandbox/servers/pxc/5.6/my.sandbox.cnf (+42/-0)
t/pt-table-checksum/pxc.t (+20/-2)
Changed in percona-toolkit: | |
status: | New → In Progress |
milestone: | none → 2.2.13 |
importance: | Undecided → High |
assignee: | nobody → Frank Cizmich (frank-cizmich) |
tags: | added: pt-table-checksum pxc |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
Attached is a version that uses a combination of variables to obtain a unique id.