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

          Richard Richard Stracke added a comment - - edited

          Is 10.2 not affected ?
          commit

          https://github.com/MariaDB/server/commit/ef4fe2366fc631853f07e14601c3603774f2049b
          show this change:

          -   !my_strnncoll(charset_info, (uchar*) name, DELIMITER_NAME_LEN
          +  !my_strnncoll(&my_charset_latin1, (uchar*) name, DELIMITER_NAME_LEN, 
          

          Code 10.2.10

                    !my_strnncoll(charset_info, (uchar*) name, DELIMITER_NAME_LEN,
                                  (uchar *) DELIMITER_NAME, DELIMITER_NAME_LEN));
          
          

          Richard

          Richard Richard Stracke added a comment - - edited Is 10.2 not affected ? commit https://github.com/MariaDB/server/commit/ef4fe2366fc631853f07e14601c3603774f2049b show this change: - !my_strnncoll(charset_info, (uchar*) name, DELIMITER_NAME_LEN + !my_strnncoll(&my_charset_latin1, (uchar*) name, DELIMITER_NAME_LEN, Code 10.2.10 !my_strnncoll(charset_info, (uchar*) name, DELIMITER_NAME_LEN, (uchar *) DELIMITER_NAME, DELIMITER_NAME_LEN)); Richard
          pentve Vesa Pentti (Inactive) added a comment - - edited

          For now it's in 10.1, not yet in 10.2. I assume 10.1 fixes will be later merged to 10.2 and 10.3.

          pentve Vesa Pentti (Inactive) added a comment - - edited For now it's in 10.1, not yet in 10.2. I assume 10.1 fixes will be later merged to 10.2 and 10.3.

          Yes, they absolutely will be.

          serg Sergei Golubchik added a comment - Yes, they absolutely will be.

          So it will be probably merged with 10.2.11 ?

          Richard Richard Stracke added a comment - So it will be probably merged with 10.2.11 ?

          Yes. It is currently in 10.0-galera branch.
          First 10.0-galera will be merged into 10.1 in MDEV-14135, then 10.1 will be merged into 10.2 in MDEV-14289.

          serg Sergei Golubchik added a comment - Yes. It is currently in 10.0-galera branch. First 10.0-galera will be merged into 10.1 in MDEV-14135 , then 10.1 will be merged into 10.2 in MDEV-14289 .

          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.