pt-online-schema-change requests password twice

[markus_albe]

~/sandboxes/msb_5_5_32$ ./pt-online-schema-change --user root --ask-pass --alter="MODIFY COLUMN i VARCHAR(255)" D=test,t=x --dry-run
Enter MySQL password:
Enter MySQL password:
Operation, tries, wait:
  copy_rows, 10, 0.25
  create_triggers, 10, 1
  drop_triggers, 10, 1
  swap_tables, 10, 1

~/sandboxes/msb_5_5_32$ ./pt-online-schema-change --version
pt-online-schema-change 2.2.7

Near line 7937 we can see (thanks Ernie Souhrada)
my $cxn = $make_cxn->(dsn => $dsn);
my $aux_cxn = $make_cxn->(dsn => $dsn, prev_dsn => $dsn);

Guess it should ask for pass only once? We fixed with globals, but I presume that won't be accepted as patch.

[Jericho Rivera (jericho-rivera)]

Confirmed on pt-osc version since 2.2.1 to 2.2.7, not seen on pt-osc versions 2.1.x or 2.0.x
root@ubuntu:/home/percona# pt-online-schema-change --user root --ask-pass --alter="MODIFY COLUMN i VARCHAR(255)" D=test,t=tbl_test --dry-run
Enter MySQL password:
Enter MySQL password:
Operation, tries, wait:
  copy_rows, 10, 0.25
  create_triggers, 10, 1
  drop_triggers, 10, 1
  swap_tables, 10, 1
  update_foreign_keys, 10, 1

[Frank Cizmich (frank-cizmich)]

Here's a patch for version 2.2.7

[Shahriyar Rzayev (rzayev-sehriyar)]

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