Comment 3 for bug 1480719

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

Hi Thomas,

Couldn't able to reproduce this.

nilnandan@desktop:~$ pt-table-checksum --user=root --ask-pass --databases=test --tables=nil
Enter MySQL password:
Diffs cannot be detected because no slaves were found. Please read the --recursion-method documentation for information.
            TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
08-11T14:11:50 0 0 5 1 0 0.005 test.nil
nilnandan@desktop:~$

Are you facing this issue with this specific table? or all tables on that server?
Can you provide the structure of that table with original name of columns and data types?

Also can you create the table with same structure but different name and then try to run pt-table-checksum on that? I'm sure there is only one table with that name in the database. (yes, it should not happen but sometimes, its possible due to some bug)

mysql> create table aa_database.ee like aa_database.dd_stats_access;