Results 1 to 6 of 6

Thread: Incremental backup, parse-binlogs shows an error in binlogs

  1. #1

    Default Incremental backup, parse-binlogs shows an error in binlogs

    I've done a successful full logical backup of a database located in a remote MySQL Server. Then i've made some changes in that database and a successful incremental backup.

    The action: mysql-zrm --action parse-binlogs --backup-set backup1 --source-directory= /var/lib/mysql-zrm/backup1/20100611115056

    Returns:

    parse-binlogs:INFO: ZRM for MySQL Community Edition - version 2.1.1
    ------------------------------------------------------------
    Log filename | Log Position | Timestamp | Event Type | Event
    ------------------------------------------------------------
    ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 56, event_type: 19
    Could not read entry at offset 182:Error in log format or read error
    DELIMITER /*!*/;
    /var/lib/mysql-zrm/Pruebazrm2_backup/20100611115056/mysql-bin.000069 | 4 | 10-06-11 11:47:31 | Start: binlog v 4, server v 5.1.44-log created 100611 11:47:31 |
    /var/lib/mysql-zrm/Pruebazrm2_backup/20100611115056/mysql-bin.000069 | 106 | 10-06-11 11:47:37 | Query | /*!\C utf8 *//*!*/; BEGIN /*!*/; DELIMITER ;

    What's the problem???
    Last edited by gloria; June 16th, 2010 at 01:52 AM.

  2. #2
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    This means the mysqlbinlog command is not able to parse binary logs in the backup. The mysqlbinlog on the ZRM server must be compatible with MySQL server version.

  3. #3

    Default

    I'm using 5.1.44 MySQL version and 2.1.1 ZRM version. Aren't they compatible??

    Thanks for answering!!
    Last edited by gloria; June 16th, 2010 at 11:29 PM.

  4. #4

    Default

    Quote Originally Posted by paddy View Post
    This means the mysqlbinlog command is not able to parse binary logs in the backup. The mysqlbinlog on the ZRM server must be compatible with MySQL server version.

    If I change $MYSQLBINLOG="mysqlbinlog" -> $MYSQLBINLOG="mysqlbinlog -f"
    The parse-binlogs action works. Will it work too if I change it in mysql-zrm-recovery. Could I have any problem with recoverys?????

  5. #5
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    Yes you should use -f option in mysql-zrm-restore also. Otherwise incremental restores will not work.

  6. #6

    Default

    Quote Originally Posted by paddy View Post
    Yes you should use -f option in mysql-zrm-restore also. Otherwise incremental restores will not work.
    Adding this option, it doesn't show me the read error, but all the querys are void, it doesn't show me any transaction. The binlogs are Row logs and the code is UTF8.


    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8408045 | 10-06-16 14:07:59 | Query | COMMIT /*!*/;
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8408123 | 10-06-16 14:09:10 | Query | BEGIN /*!*/;
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8408200 | 10-06-16 14:09:10 | |
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8408278 | 10-06-16 14:09:10 | |
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8408501 | 10-06-16 14:09:10 | Query | COMMIT /*!*/;
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8408579 | 10-06-16 14:09:10 | Query | BEGIN /*!*/;
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8408656 | 10-06-16 14:09:10 | |
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8408722 | 10-06-16 14:09:10 | |
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8408855 | 10-06-16 14:09:10 | Query | COMMIT /*!*/;
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8408933 | 10-06-16 14:09:11 | Query | BEGIN /*!*/;
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8409010 | 10-06-16 14:09:11 | |
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8409076 | 10-06-16 14:09:11 | |
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8409164 | 10-06-16 14:09:11 | Query | COMMIT /*!*/;
    /var/lib/mysql-zrm/Pruebazrm3_backup/20100616142244/mysql-bin.000076 | 8409242 | 10-06-16 14:22:29 | Rotate to mysql-bin.000077 pos: 4 | DELIMITER ;

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •