Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.2.21
-
Component/s: Replication
-
Labels:None
Description
Using encrypted binlogs it was impossible to point a Slave to the Master getting error:
2019-09-09 5:55:23 139739348764416 [ERROR] Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the first event 'mysql-binlog.016054' at 763411303, the last event read from 'mysql-binlog.nnnnn' at xxxxxxx, the last byte read from 'mysql-binlog.nnnnn at yyyyyyy. (server_errno=1236)
The error message is misleading because it's just due to pointing to a wrong position.
Using the positions reported by SHOW BINLOG EVENTS worked.