~maria-captains/maria/5.2

Viewing all changes in revision 2502.1191.1.

  • Committer: Manish Kumar
  • Date: 2012-05-21 07:27:39 UTC
  • mto: (2502.1137.203 mysql-5.1)
  • mto: This revision was merged to the branch mainline in revision 3164.
  • Revision ID: manish.4.kumar@oracle.com-20120521072739-qusdes0ei1nlwq7t
BUG#12400221 - 60926: BINARY LOG EVENTS LARGER THAN MAX_ALLOWED_PACKET

Problem
========
            
SQL statements close to the size of max_allowed_packet produce binary
log events larger than max_allowed_packet.
              
The reason why this failure is occuring is because the event length is
more than the total size of the max_allowed_packet + max_event_header
length. Now since the event length exceeds this size master Dump
thread is unable to send the packet on to the slave.
                      
That can happen e.g with row-based replication in Update_rows event.
            
Fix
====
          
The problem was fixed by increasing the max_allowed_packet for the
slave's threads (IO/SQL) by increasing it to 1GB.
This is done using the new server option included which is used to
regulate the max_allowed_packet of the slave thread (IO/SQL).
This causes the large packets to be received by the slave and apply
it successfully.

expand all expand all

Show diffs side-by-side

added added

removed removed

Lines of Context: