Gateway is not coming up

Products

• CA API Gateway

Issue/Introduction

Trying to restore mysqldump on gateway server :

# mysql -u root < ssgdump.Feb-15.sql

ERROR 3546 (HY000) at line 26: @@GLOBAL.GTID_PURGED cannot be changed: the added gtid set must not overlap with @@GLOBAL.GTID_EXECUTED

Environment

All supported versions of the CA API Gateway

Resolution

1. Run the following commands from Master and Slave nodes (both)

mysql> stop slave;
mysql> reset slave all;
mysql> reset master;
mysql> reset slave all;
mysql> reset master;

2. Try again the database restore :

mysql -u root < ssgdump.Feb-15.sql