pt-online-schema-change slave-user and slave-password ignored when recursion-method is dsn

Bug #1733283 reported by Iwo
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
New
Undecided
Unassigned

Bug Description

Options --slave-user and --slave-password of pt-online-schema-change are ignored when --recursion-method is set to dsn.

Step to reproduce:

$ PTDEBUG=1 pt-online-schema-change --recursion-method dsn=t=percona.dsns --execute D=test,t=test,h=127.0.0.1,P=20594 --slave-user dupa123 --slave-pass test321 --user=root --password=msandbox --alter "ENGINE=InnoDB"

[...]

# MasterSlave:4845 7838 SELECT dsn FROM `percona`.`dsns` ORDER BY id
# MasterSlave:4850 7838 DSN from DSN table: h=127.0.0.1,P=20595
# DSNParser:2241 7838 DSN string made from options: u=root,p=msandbox

The workaround is to define slave user and slave password directly in dsns.

Tested against pt-online-schema-change 3.0.4.

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

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.