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

mysqlbinlog can't be input to mysql client

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5(EOL), 10.0(EOL), 10.1(EOL)
    • 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

          Transition Time In Source Status Execution Times
          Elena Stepanova made transition -
          Open Confirmed
          5d 43m 1
          Vesa Pentti (Inactive) made transition -
          Confirmed In Progress
          420d 20h 58m 1
          Vesa Pentti (Inactive) made transition -
          In Progress In Review
          1d 2h 21m 1
          Vesa Pentti (Inactive) made transition -
          Stalled In Review
          1d 6h 7m 1
          Alexander Barkov made transition -
          In Review Stalled
          3h 7m 2
          Vesa Pentti (Inactive) made transition -
          Stalled Closed
          1d 18h 47m 1

          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.