I don't understand how does --recursion-method=none and --check-slave-lag work together in pt-osc

Polyglot Projects Percona Toolkit
1

Hi there!
I have following situation, I have a master, a slave, and two maxscale servers.
When I try to perform the following:

perl /bin/pt-online-schema-change \
--check-slave-lag=h=slave.host,P=3306 \
--recursion-method=none \
--slave-user=user_for_percona \
--slave-password=PWD \
--check-interval=1 --max-lag=2s --progress=time,2 \
--recurse 0 \
--critical-load='Threads_running=200' \
--max-load='Threads_running=50' \
D=databasetoalter,t=t1 \
--user user_for_percona --p PWD \
--alter="MODIFY COLUMN t1 MEDIUMTEXT" \
--execute

I got the following err:
Replica maxscale_address_here_from_processlist is stopped. Waiting

I don’t understand, why it ignores --recursion-method=none clause.

Any help is appreciated.

2

Hi @cookie,
There might be a bug when using --check-slave-lag and --recursion-method together. Please test out --recursion-method=DSN and add only the one host to this table. If that works as you intend, then we’d appreciate it if you can open a JIRA at https://jira.percona.com/ and give the above use-case as a bug.