# pt-online-schema-change issue with multi master setup **URL:** \ **Category:** Percona Toolkit\ **Created:** [September 5, 2018, 6:01am UTC](https://forums.percona.com/t/pt-online-schema-change-issue-with-multi-master-setup/6560 "2018-09-05T06:01:00Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Mahesh\_P](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mahesh_p/32/1039_2.png) [@Mahesh\_P](https://forums.percona.com/u/Mahesh_P)\ **Post date:** [September 5, 2018, 6:01am UTC](https://forums.percona.com/t/pt-online-schema-change-issue-with-multi-master-setup/6560/1 "2018-09-05T06:01:00Z")
We are using pt-online-schema-change 3.0.10. We tried adding a column like below: pt-online-schema-change --execute user=dba --ask-pass --alter “ADD COLUMN IF NOT EXISTS RedemptionTransactionL INT DEFAULT 1 AFTER RedemptionLimitPerTransaction” D=nextgen\_offer,t=Offer We have setup like M5 \<–\> M1 \<–\> S1 . We have executed on M1 and changes were reflected on all replicas (multi-master setup). But replication failed from M5 → M1 with error Last\_SQL\_Errno: 1677 Last\_SQL\_Error: Column 78 of table ‘nextgen\_offer.Offer’ cannot be converted from type ‘bigint’ to type ‘int(11)’ Why this error affecting, although we executed it only on M1. Note: Mariadb v10.1.31 ---
**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\ **Post date:** [September 5, 2018, 8:08am UTC](https://forums.percona.com/t/pt-online-schema-change-issue-with-multi-master-setup/6560/2 "2018-09-05T08:08:13Z")
Hi there - could you do a SHOW CREATE TABLE on each of the servers please? ---
**Author:** ![smith18](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@smith18](https://forums.percona.com/u/smith18)\ **Post date:** [November 15, 2018, 1:19pm UTC](https://forums.percona.com/t/pt-online-schema-change-issue-with-multi-master-setup/6560/3 "2018-11-15T13:19:35Z")
Sorry I have a quick question on pt-online-schema-change, when does the table swapping actually happen ? we have an application which runs 24/7\*365 days and we trying to alter one table column datatype from int to bigint – if process is running continuously and new rows will be added to the table my question is if new rows are added continuously then when does percona make a decision to swap the table tables without losing incoming rows – we don’t want to lose any data because we cannot getback the data? any help would be appreciated ---
**Author:** ![smith18](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@smith18](https://forums.percona.com/u/smith18)\ **Post date:** [November 19, 2018, 9:34am UTC](https://forums.percona.com/t/pt-online-schema-change-issue-with-multi-master-setup/6560/4 "2018-11-19T09:34:30Z")
i am not able to see my messages when i click on view it says sign in as different user or contact admin ? and i am also not able to view my post ---
**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\ **Post date:** [November 19, 2018, 10:21am UTC](https://forums.percona.com/t/pt-online-schema-change-issue-with-multi-master-setup/6560/5 "2018-11-19T10:21:35Z")
Hi [smith18](https://www.percona.com/forums/member/42471-smith18) due to unwelcome spam, new users are moderated for the first few posts they make. It varies, but… I noticed a post from you earlier today… OK found it, and there’s also an answer … [url][https://www.percona.com/forums/questions-discussions/percona-toolkit/52880-pt-online-schema-swapping-tables[/url]](https://www.percona.com/forums/questions-discussions/percona-toolkit/52880-pt-online-schema-swapping-tables%5B/url%5D)