Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

pt-table-checksum "this server" is ambiguous

Description

pt-table-checksum outputs an ambiguous/false statement regarding replica discovery. Consider the following replication architecture:

+ db0 +-> db1 +-> db2 +-> db3 <-> db4

Above, db0 is source, and db1/2/3 are direct replicas. db4 is a replica of db3 in source/source configuration.

Running [user@db0 ~$] pt-table-checksum h=localhost against db0 produces this error:

This server returned more than one row for SHOW SLAVE STATUS but "channel" was not specified on the command line at /usr/bin/pt-table-checksum line 5570.

This error is ambiguous. “This server” means what? Which server? db0? No, because it is not a replica. This error is referring to db3, because db3 has 2 channels: db0->db3 and db4->db3

pt-table-checksum should output the actual server hostname causing the error to better assist users in determining where the problem actually exists.

Environment

None

Activity

Show:

Details

Assignee

Reporter

Priority

Needs QA

Yes

Smart Checklist

Created last month
Updated last month

Flag notifications