search cancel

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

book

Article ID: 229281

calendar_today

Updated On:

Products

CA Mobile API Gateway

Issue/Introduction

Replication on gateway 10.x keeps breaking ... 

Got 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

first repair replication : https://knowledge.broadcom.com/external/article?articleId=44402

than to prevent this issue ...

keep using the manage_binlogs script.

https://knowledge.broadcom.com/external/article?articleId=9846

and please review below from your my.cnf.(In the dct).

# 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=864000

 

set that above expire_logs_seconds to 0 that would make it not to expire and bin logs,  script would take care of it