Not the answer you need?
Register and ask your own question!

5.0.92 binlog issue

vpaulvpaul EntrantCurrent User Role Participant
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

Comments

  • vpaulvpaul Entrant Current User Role Participant
    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.
  • oldmavenoldmaven Entrant Legacy User Role Participant
    We are facing the same issue! Did you ever find a fix for this? Thanks
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.