pt-osc : can not connect to slaves why ?

[yvonne]

Cannot connect to D=USER,P=3306,h=sjcprd3,p=...,u=root

why do I get this message seen above ?
I have 3 slaves connected to the master
the tool still continue to work
but I have a feeling it does not throttling or care about the max-lag=60 parameter since it says it can not connect
but one time one of the salves was going down for cold backup while pt-osc was running and it aborted pt-osc so somehow it was aware of the salve status ...
Mysql v5.1.64
hmmmm

# pt-online-schema-change h=127.0.0.1,D=USER,t=file_download_history -P3306 -uroot -pxxxxxxxx --alter "CHANGE COLUMN download_id download_id bigint(11) unsigned NOT NULL AUTO_INCREMENT" --progress time,300 --chunk-size 50000 --lock-wait-time=360 --max-lag=5000 --no-drop-old-table --max-load=Threads_running:25 --recursion-method=processlist --max-lag=60 --critical-load=Threads_running:2500 --execute
Cannot connect to D=USER,P=3306,h=sjcprd1,p=...,u=root
Cannot connect to D=USER,P=3306,h=sjcprd2,p=...,u=root
Cannot connect to D=USER,P=3306,h=sjcprd3,p=...,u=root
Altering `USER`.`file_download_history`...
Creating new table...
Created new table USER._file_download_history_new OK.
Altering new table...
Altered `USER`.`_file_download_history_new` OK.
Creating triggers...
Created triggers OK.
Copying approximately 394093669 rows...
Copying `USER`.`file_download_history`: 1% 04:06:00 remain
Copying `USER`.`file_download_history`: 4% 03:57:28 remain

[Daniel Nichter (daniel-nichter)]

Yvonne, I think this question is better addressed at http://www.percona.com/forums/ because it's probably not a bug; it's probably a matter of MySQL user credentials. You could use --recursion-method=DSN and specify each slave's DSN in the given DSN. You can also kind of test slave recursion with pt-slave-find.

If I'm mistaken and you have found a bug, let me know and we'll re-open this issue.

[Shahriyar Rzayev (rzayev-sehriyar)]

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