Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

Description

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.

Environment

None

Activity

Show:

Aaditya Dubey June 27, 2023 at 12:57 PM

Hi ,

We still haven't heard any news from you. So I assume issue is not persists anymore. If you disagree just reply and create a follow-up report.

Aaditya Dubey March 30, 2023 at 8:56 AM

Hi ,

Thank you for the report.
Unfortunately i'm unable to repeat the issue in 5.7.mysql_aurora.2.11.1, Please check my test case below:

Please share exact command for pt-online-schema-change to further debug the issue, Also if there is full reproducible steps available then please share it.

Cannot Reproduce

Details

Assignee

Reporter

Priority

Components

Affects versions

Needs QA

Yes

Smart Checklist

Created March 22, 2023 at 12:59 PM
Updated June 27, 2023 at 12:57 PM
Resolved June 27, 2023 at 12:57 PM