Pt-online-schema-change selectrow_arrayref failed. 'wsrep_on' not found

MySQL & MariaDB
1

Hi All

I’m in the process to test pt-online-schema-change to see if it will resolve the schema change challenges we face.
Running it with a test schema change on my local MySQL v5.7 is working fine. When I try to run it on an Aurora MySQL db running on AWS, I get the following error:

DBD::mysql::db selectrow_arrayref failed: fetch() without execute() [for Statement "SHOW VARIABLES LIKE 'wsrep_on'"] at /opt/homebrew/Cellar/percona-toolkit/3.5.1/libexec/bin/pt-online-schema-change line 8209.

I’ve checked on my local db and that variable doesn’t exist there as well but for some reason it’s looking for that variable when running it against the AWS instance.

Any help would be appreciated.

2

Hi Pieter, this looks like a bug. May I ask you to report it on jira.percona.com?

Thanks

3

Sure. I’ve logged a bug.

1 Like
5

Thank you for your attention,

I have the same problem,

I have tried adjusting various parameters,

Finally, it is inferred that the operation error was caused by network interruption.