pt-table-checksum doesn't work with PXC
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Expired
|
Undecided
|
Unassigned |
Bug Description
When I try to run pt-table-checksum it fails. All verifications are OK.
This is the cammand I am using :
# pt-table-checksum h=localhost,
09-21T17:26:12 DBI connect(
# mysql --defaults-
+------
| dsn |
+------
| h=10.107.
+------
I created the table dsns inside the 'mysql' database and I got this :
# pt-table-checksum h=localhost,
DBD::mysql::db selectcol_arrayref failed: Table 'mysql.dsns' doesn't exist [for Statement "SELECT dsn FROM `mysql`.`dsns` ORDER BY id"] at /usr/bin/
# mysql --defaults-
+------
| dsn |
+------
| h=10.107.
| h=10.234.
+------
PXC version : 5.6
Percona toolkit version : 2.2
description: | updated |
description: | updated |
tags: | added: pt-table-checksum |
Thank you for the report.
I cannot repeat described behavior. Which version of pt-online- schema- change do you use? Please connect to mysql using credentials, provided in the dsn option and provide output of:
SELECT USER(), CURRENT_USER();
SHOW GRANTS;
SHOW DATABASES;
SELECT dsn FROM percona.dsns;
SELECT dsn FROM mysql.dsns;