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
So do this in your my.cnf :-)
Forget workarounds to solve replication errors
and re-init you replication if you will be sure
it is really consistent
Am 16.02.2011 12:20, schrieb Carl:
> I am running master - master replication between two locations using MySQL version
> 5.1.41
> on Slackware Linux 13 (64bit).
>
> The problem from show slave status is:
>
> Last_Error: Relay log read failure: Could not parse relay log
> event entry. The possible reasons are: the master's binary log is corrupted (you can check
> this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you
> can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in
> the master's or slave's MySQL code. If you want to check the master's binary log or
> slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on
> this slave.
> Skip_Counter: 1
> Exec_Master_Log_Pos: 552321409
> Relay_Log_Space: 165412833
> Until_Condition: None
> Until_Log_File:
> Until_Log_Pos: 0
> Master_SSL_Allowed: No
> Master_SSL_CA_File:
> Master_SSL_CA_Path:
> Master_SSL_Cert:
> Master_SSL_Cipher:
> Master_SSL_Key:
> Seconds_Behind_Master: NULL
> Master_SSL_Verify_Server_Cert: No
> Last_IO_Errno: 1236
> 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'
> Last_SQL_Errno: 1594
> Last_SQL_Error: Relay log read failure: Could not parse relay log
> event entry. The possible reasons are: the master's binary log is corrupted (you can check
> this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you
> can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in
> the master's or slave's MySQL code. If you want to check the master's binary log or
> slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on
> this slave.
>
> I have tried telling it to skip that transaction (set global sql_slave_skip_counter =
> 1) to no avail.
>
> From what I have been able to determine from searching the Internet, it appears that
> the replication is failing replicating blobs ahich are basically jpg's of members. If I
> understand the problem, it is caused by blob containing a character which is the same
> character that is used to mark the end of a transaction in the bin log.
>
> My questions: 1) Is this a reasonable/correct analysis and 2) how do I work around
> the issue?
>
> Thanks,
>
> Carl
>
>
>
>
>
--
Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
