When trying to upgrade to gateway 11.1, on DB upgrade, it fails with error,
liquibase.exception.MigrationFailedException: Migration failed for change set ssg-base.xml:add_pk_ID_AUTHOR_FILENAME::gateway: Reason: liquibase.exception.DatabaseException: Multiple primary key defined [Failed SQL: (1068) ALTER TABLE ***_testUpgrade.DATABASECHANGELOG ADD PRIMARY KEY (ID, AUTHOR, FILENAME)]
Trouble shooting:
Verify the primary key data as per KB DB Upgrade failing during 11.1 upgrade, the data is good.
Run follow SQL on ssg database,
mysql> show create table DATABASECHANGELOG\G
It shows the primary key on (ID, AUTHOR, FILENAME) already defined. (The primary keys were manually added to resolve the group replication restriction).
Stop group replication, drop the existing primary keys, perform DB upgrade, re-build the group replication.