Skip-check-slave-lag is not working for pt-online-schema-change

Polyglot Projects Percona Toolkit
,
1

Hi.
Guys, I am trying to use pt-online-schema-change for changing table structure to utf8mb4.
Faced with the issue when pt-online-schema-change showing the exception about “Cannot connect to h=10.3.15.0,p=…,u=” (slave host.)
Found that we can use --skip-check-slave-lag argument to skip connected slaves.
But unfortunately this option doesn’t work for me.
When we just specifying --skip-check-slave-lag without DSN it continue checking the slaves:

Found 1 slaves:
ip-10-3-2-60 -> slave_ip_address:socket
Will check slave lag on:
ip-10-3-2-60 -> slave_ip_address:socket

When we specifying the DSN like

--skip-check-slave-lag h=ip_addess,P=3306

It returns us that something could not be parsed exception:

Use of uninitialized value in string eq at /usr/bin/pt-online-schema-change line 8867.

The whole command that we are using is below:

pt-online-schema-change --alter 'CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci' --host={$host} D="{$DB}",t={$table},u="{$user}",p="{$password}" --no-drop-old-table --preserve-triggers --execute --no-check-replication-filters --skip-check-slave-lag h={$slave_ip_addr},P=3306 --alter-foreign-keys-method=rebuild_constraints --critical-load Threads_running=500

Please advise how we can properly use --skip-check-slave-lag.

2

Hi, you can try --recursion-method=none this should ignore any replicas

3

Hi Ivan. Thanks for so quick response.
I suppose this option works.

Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
  analyze_table, 10, 1
  copy_rows, 10, 0.25
  create_triggers, 10, 1
  drop_triggers, 10, 1
  swap_tables, 10, 1
  update_foreign_keys, 10, 1