MariaDB 5.1.55 -> 5.3.5 replication fail
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Incomplete
|
Undecided
|
Unassigned |
Bug Description
Have a master+slave MariaDB 5.1.55 replicating using statement binlog format, all fine.
Added MariaDB 5.3.5 slave, get this error:
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master'
This is unrelated to max packet. max_allowed_packet is 16M on mariadb 5.1.55. It was the same on 5.3.55. Attempted to increase it to 32M to no avail.
From the error log:
120314 8:51:18 [Warning] Slave I/O: Notifying master by SET @master_
120314 8:51:18 [ERROR] Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master ( server_errno=1236)
120314 8:51:18 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master', Error_code: 1236
attempting to turn off checksums using info from here: http://
Has no effect.
Changed in maria: | |
status: | New → Incomplete |
Hi Alexey,
The warning about binlog_checksum seems reasonable, it just means that master does not know about binlog_checksum functionality, which is true since your master server is 5.1.55.
In regard to the real issue (log event entry exceeded max_allowed_ packet) , could you please provide your master binlog on which the replication breaks, full contents of slave error log file, and cnf files from master and slave? You can FTP them to ftp://ftp. askmonty. org.
Thank you.