5.0.92 binlog issue

MySQL & MariaDB Other MySQL® Questions
1

Hi there,

I’m trying to set up master-slave replication in between 5.0.92 percona and regular 5.0.77 mysql. 5.0.77 - the slave reports about log corruption once it is established. When I do check binary logs with mysqlbinlog utulity on 5.0.92 - the master I’m getting like :

#121003 5:22:26 server id 1 end_log_pos 398528

Unknown event

at 398528

#960218 6:48:44 server id 1813111337 end_log_pos 1835008

Unknown event

ERROR: Error in Log_event::read_log_event(): ‘Event too big’, data_len: 1953066613, event_type: 8
DELIMITER ;

End of log file

However, I’m able to see quieries when I look at raw files and the same if I run mysqlbin -H. The output looks readable besides unknown event messages.
Most everything looks like this - https://answers.launchpad.net/percona-server/+question/12523 0.

OS - CentOS 6.3. percona was installed from percona’s repo.

Any help would be appreciated.

Thank you,

Pavel

2

An update. Checking hex dumps I’ve found out that logs looks similar on both servers besides the following:

Percona:

00000062 be f5 6b 50 02 01 00 00 00 82 00 00 00 e4 00 00 00 00 00

00000075 01 00 00 00 00 00 00 00 0c 00 00 17 00 00 00 40 |…|

00000085 00 00 01 00 00 00 00 00 00 00 00 06 03 04 08 00 |…|

00000095 08 00 08 00 61 6d 6d 75 6e 69 74 69 5f 6f 73 63 |…ammuniti.osc|

Regular mysql:

00000062 3c 50 6c 50 02 02 00 00 00 85 00 00 00 e7 00 00 00 00 00

00000075 08 00 00 00 00 00 00 00 0c 00 00 1a 00 00 00 40 |…|

00000085 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |…std|

00000095 04 08 00 08 00 08 00 61 6d 6d 75 6e 69 74 69 5f |…ammuniti.|

I.e. there is no “std” in percona’s log.

3

We are facing the same issue! Did you ever find a fix for this? Thanks