pt-table-checksum doesn't work with PXC

Bug #1626162 reported by Medali
6
This bug affects 1 person
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,P=3307,u=debian-sys-maint,p=********** --set-vars innodb_lock_wait_timeout=50 --no-check-binlog-format --recursion-method dsn=h=localhost,P=3307,D=percona,t=dsns
09-21T17:26:12 DBI connect('percona;host=localhost;port=3307;mysql_read_default_group=client','debian-sys-maint',...) failed: Unknown database 'percona' at /usr/bin/pt-table-checksum line 1576

# mysql --defaults-file=/etc/mysql/debian2.cnf -e "SELECT dsn FROM percona.dsns ORDER BY id;"
+-------------------------------------------------------+
| dsn |
+-------------------------------------------------------+
| h=10.107.12.148,u=debian-sys-maint,p=zDuVe9WuhRlz2HLL |
+-------------------------------------------------------+

I created the table dsns inside the 'mysql' database and I got this :

# pt-table-checksum h=localhost,P=3307,u=debian-sys-maint,p=zDuVe9WuhRlz2HLL --set-vars innodb_lock_wait_timeout=50 --no-check-binlog-format --recursion-method dsn=h=localhost,P=3307,D=mysql,t=dsns
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/pt-table-checksum line 5667.

# mysql --defaults-file=/etc/mysql/debian2.cnf -e "SELECT dsn FROM mysql.dsns ORDER BY id;"
+--------------------------------------------------------------+
| dsn |
+--------------------------------------------------------------+
| h=10.107.12.148,P=3307,u=debian-sys-maint,p=**************** |
| h=10.234.90.150,P=3307,u=debian-sys-maint,p=**************** |
+--------------------------------------------------------------+

PXC version : 5.6
Percona toolkit version : 2.2

Medali (medaliziedi)
description: updated
Medali (medaliziedi)
description: updated
tags: added: pt-table-checksum
Revision history for this message
Sveta Smirnova (svetasmirnova) wrote :

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;

Changed in percona-toolkit:
status: New → Incomplete
Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for Percona Toolkit because there has been no activity for 60 days.]

Changed in percona-toolkit:
status: Incomplete → Expired
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.