Not the answer you need?
Register and ask your own question!

pt-online-schema-change issue with multi master setup

Mahesh PMahesh P EntrantCurrent User Role Beginner
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

Comments

  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    Hi there - could you do a SHOW CREATE TABLE on each of the servers please?
  • smith18smith18 Entrant Current User Role Beginner
    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
  • smith18smith18 Entrant Current User Role Beginner
    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
  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    Hi 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 .. https://www.percona.com/forums/questions-discussions/percona-toolkit/52880-pt-online-schema-swapping-tables
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.