I dont have foriegn key in my table, but still getting the below warning and error message. Please let me know the changes to make it work? bhoopathi@it:~$ pt-online-schema-change --alter-foreign-keys-method=none --dry-run --print --alter “ADD column marketplace22 varchar(25)” D=testdb,t=tutorials…

I was on 3.1.0 and experienced the same issue. I updated to 3.6.0 and it seems to be fixed!

Pt-online-schema-change not working as expected

matthewb December 14, 2021, 5:35am 6

Run like this and see if you can figure out why PTOSC is giving this error:

$ PTDEBUG=1 pt-online-schema-change --dry-run ...

1 Like

Pt-online-schema-change --execute Hangs forever

Topic		Replies	Views
pt-online-schema-change - rename FK problem Percona Toolkit	0	1006	March 27, 2018
pt-online-schema-change drop the old and new table Percona Toolkit	2	2228	June 24, 2017
Pt-online-schema-change with --no-swap-tables and --alter-foreign-keys-method MySQL & MariaDB	1	473	January 12, 2021
pt-online-schema-change is not working right Percona Toolkit	2	1671	July 7, 2014
Pt-online-schema-change fails on add or drop (probably on everything) Percona Server for MySQL 8.0	10	2889	August 3, 2021