fatal error 1236 - Cannot replicate because the master purged required binary logs

Products

• CA Mobile API Gateway

Issue/Introduction

Replication on gateway 10.x broke with the following error:

fatal error 1236 from master when reading data from binary log: 'Cannot replicate because the master purged required binary logs. 

Environment

Release : 10.X

Component : API Gateway 

Resolution

1. First fix the replication by following the instructions from this KB: https://knowledge.broadcom.com/external/article?articleId=44402
2. Use this KB to manage binary log (binlog) and prevent any further error related to missing binlog files: https://knowledge.broadcom.com/external/article?articleId=9846
3. Make sure my.cnf file has the following settings:
   • # flush binary logs on commits. 
   • innodb_flush_log_at_trx_commit=1
   • binlog_format=MIXED
   • max_binlog_size=500M
   • # wait for 10 days(864000 sec) before binlog expires
   • binlog_expire_logs_seconds=0
4. Set the expire_logs_seconds to 0 which would make it not expire (the manage binlog script from step 2 will take care of deleting/purging this log file)