Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10728

mysqlbinlog can't be input to mysql client

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5, 10.0, 10.1
    • 10.1.29
    • Character Sets
    • None
    • 10.1.29

    Description

      I can't replay any of my binlog files even the file have no user events.
      Like this:

      [lzk@redhat64-26 binlog]$ mysqlbinlog mysql-bin.000018|mysql
      ERROR 1064 (42000) at line 8: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ';
       
       
       
       
       
       
       
      DELIMITER ;
       
      ROLLBACK  ;
      /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_T' at line 1
      

      [lzk@redhat64-26 binlog]$ mysqlbinlog mysql-bin.000018
      /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
      /*!40019 SET @@session.max_insert_delayed_threads=0*/;
      /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
      DELIMITER /*!*/;
      # at 4
      #160902 16:25:40 server id 12324  end_log_pos 248       Start: binlog v 4, server v 10.0.12-MariaDB-debug-log created 160902 16:25:40
      # Warning: this binlog is either in use or was not closed properly.
      BINLOG '
      hDfJVw8kMAAA9AAAAPgAAAABAAQAMTAuMC4xMi1NYXJpYURCLWRlYnVnLWxvZwAAAAAAAAAAAAAA
      AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAA3AAEGggAAAAICAgCAAAACgoKAAAAAAAA
      AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
      AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
      AAAAAAAAAAAEEwQACr8VJg==
      '/*!*/;
      # at 248
      #160902 16:25:40 server id 12324  end_log_pos 303       Gtid list [0-3282660265-4,
      # 0-12324-354244]
      # at 303
      #160902 16:25:40 server id 12324  end_log_pos 342       Binlog checkpoint mysql-bin.000017
      # at 342
      #700101  8:00:00 server id 12324  end_log_pos 381       Binlog checkpoint mysql-bin.000018
      DELIMITER ;
      # End of log file
      ROLLBACK /* added by mysqlbinlog */;
      /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
      /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
      

      Attachments

        1. my.cnf
          2 kB
        2. mysql-bin.000018
          1 kB
        3. mysql-bin.000019
          0.4 kB
        4. mysql-bin.000020
          0.4 kB

        Activity

          People

            pentve Vesa Pentti (Inactive)
            linzhoukai Zhoukai Lin
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.