pt-table-sync 2.0.3 --recursion-method=dsn doesn't work

Bug #933252 reported by Jaime Sicam
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Invalid
Undecided
Unassigned

Bug Description

So, _find_slaves_by_dsn method does not exist but when you run pt-table-checksum with --recursion-method and --replicate, the script looks for the method, _find_slaves_by_dsn:

pt-table-sync --print --recursion-method=dsn=h=localhost,D=percona,t=dsns --replicate percona.checksums h=192.168.1.98,u=user,p=password

Can't locate object method "_find_slaves_by_dsn=h=localhost,D=percona,t=dsns" via package "MasterSlave" at ./pt-table-sync line 5977.
Issuing rollback() for database handle being DESTROY'd without explicit disconnect().
Issuing rollback() for database handle being DESTROY'd without explicit disconnect().

Revision history for this message
Baron Schwartz (baron-xaprb) wrote :

In which version did this happen? I've run the tool with these options a lot and didn't see this. If we can't find the problem code, we might need you to run it again with PTDEBUG=1.

Revision history for this message
Daniel Nichter (daniel-nichter) wrote : Re: pt-table-sync --recursion-method dsn doesn't work

This bug report was a little confused. The original title said "pt-table-checksum", like the first paragraph of the report, but the example in the report runs pt-table-sync. Jamie actually means pt-table-sync. In that case, this is not a bug because pt-table-sync 2.0.3 does not support --recursion-method dsn. It has the code to do that, but it doesn't call that code; it calls older code. This is why the documentation doesn't list dsn as a possible value for --recursion-method. pt-table-sync 2.0 can't simply call the new code because the new code requires other new code that is also not yet integrated into pt-table-sync 2.0. All this new code was written for pt-table-checksum 2.0, which was rewritten from the ground up, and the two tools share several modules.

summary: - pt-table-checksum looks for _find_slaves_by_dsn method when you only
- specify parameters --recursion-method and --replicate
+ pt-table-sync --recursion-method dsn doesn't work
Changed in percona-toolkit:
status: New → Invalid
summary: - pt-table-sync --recursion-method dsn doesn't work
+ pt-table-sync 2.0.3 --recursion-method dsn doesn't work
summary: - pt-table-sync 2.0.3 --recursion-method dsn doesn't work
+ pt-table-sync 2.0.3 --recursion-method=dsn doesn't work
Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

This bug will remained closed, but the same issue came up again in bug 934463, so the issue is accepted as a bug and tracked in that issue.

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-930

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.