Skip to:

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

[PT 3.3.1] pt-osc --alter-foreign-keys-method=drop_swap doesn't work with MariaDB 10.x

Description

Still doesn't work for me on PT 3.3.1 and MariaDB 10.3.23. Worked on 3.0.6 on a different machine. Regression?
Regression of: PT-1634
PT-1971 should be removed - created as clone of PT-1634 by mistake

 

https://jira.percona.com/secure/AddComment!default.jspa?id=124412

Environment

None

Smart Checklist

Activity

Show:

Aaditya Dubey March 7, 2022 at 2:48 PM

Hi ,

Thank you for the report.

i've tried reproducing the issue with pt-online-schema-change 3.3.1 on MariaDB v10.3.28 and v10.7.3 but not able to repeat the issue however observing this Not dropping old table because --no-drop-old-table was specified. which looks bit weird because as per the document old table should be dropped, so sending it to engineering for further review.

Document for Reference: https://www.percona.com/doc/percona-toolkit/3.0/pt-online-schema-change.html#cmdoption-pt-online-schema-change-alter-foreign-keys-method

Thanks,
Aaditya Dubey

Nikolay Muntyanov September 10, 2021 at 4:00 PM

"jira-bot=reopen"

Nikolay Muntyanov September 10, 2021 at 3:59 PM

I'm using Mariadb RDS 10.3 in AWS cloud

jira-bot=reopen

Nikolay Muntyanov September 10, 2021 at 3:04 PM

Hello Guys! I had reproduced this issue on pt-online-schema-change 3.3.1 and mariadb v10.3.28

Jira Bot August 13, 2021 at 2:57 PM

Hello ,
It's been 52 days since this issue went into Incomplete and we haven't heard
from you on this.

At this point, our policy is to Close this issue, to keep things from getting
too cluttered. If you have more information about this issue and wish to
reopen it, please reply with a comment containing "jira-bot=reopen".

Details

Assignee

Reporter

Priority

Affects versions

Labels

Smart Checklist

Created June 20, 2021 at 1:24 PM
Updated February 29, 2024 at 8:52 PM