Comment 2 for bug 955057

Hi Elena,

  Based on the logs, it would seem that when the master receives a
binlog_checksum query (even though I turned those off), it throws an error
and replication breaks. According to the docs, replication is compatible
from earlier versions to newer versions of mysql/Mariadb. This makes me
think it's not so. I'm unable to provide the log file at this time. I'm
reverting back to MariaDB 5.2.10 for the meantime, as I need to migrate the
db.

-Alex

On Wed, Mar 14, 2012 at 6:05 PM, Elena Stepanova
<email address hidden>wrote:

> 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.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/955057
>
> Title:
> MariaDB 5.1.55 -> 5.3.5 replication fail
>
> Status in Maria:
> New
>
> 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_binlog_checksum= @@global.binlog_checksum failed with error:
> Unknown system variable 'binlog_checksum', Error_code: 1193
> 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://kb.askmonty.org/en/binlog-event-checksums
> Has no effect.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/maria/+bug/955057/+subscriptions
>