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

mysqlbinlog Don't know how to handle column type=0 meta=0 (0000)#

    Details

    • Sprint:
      5.5.44

      Description

      mysqlbinlog Ver 3.3 for Linux at x86_64 from MariaDB-client.x86_64 5.5.40-1.el6 @mariadb

      Following on from MDEV-7268

      mysqlbinlog --start-position 30748070  mysql-bin.046557 | more
       
      BEGIN
      /*!*/;
      # at 30748141
      # at 30748202
      # at 30748274
      #141204 10:12:43 server id 1  end_log_pos 30748202      Table_map: `weather`.`lightning` mapped to number 177647
      #141204 10:12:43 server id 1  end_log_pos 30748274      Table_map: `weather`.`_lightning_new` mapped to number 177646
      #141204 10:12:43 server id 1  end_log_pos 30748356      Delete_rows: table id 177647 flags: STMT_END_F
       
      BINLOG '
      65h/VBMBAAAAPQAAACou1QEAAO+1AgAAAAEAB3dlYXRoZXIACWxpZ2h0bmluZwAHAw8MAAAADwQK
      AAoAYA==
      65h/VBMBAAAASAAAAHIu1QEAAO61AgAAAAEAB3dlYXRoZXIADl9saWdodG5pbmdfbmV3AAcDDwz2
      9vYPCgoACgcKBwUBCgBg
      65h/VBkBAAAAUgAAAMQu1QEAAO+1AgAAAAEAB/+AG4GOBAVHUEFUU5OG1tNFEgAAIC0zMy42MzA3
      NDc5IDE1Mi44MzIwNjk3ICAtNDEuMgJHUw==
      '/*!*/;
      # at 30748356
      #141204 10:12:43 server id 1  end_log_pos 30748383      Xid = 12786901894
      COMMIT/*!*/;

      decoded version

      mysqlbinlog --start-position 30748070  --verbose --base64-output=decode-rows mysql-bin.046557 | more
       
      BEGIN
      /*!*/;
      # at 30748141
      # at 30748202
      # at 30748274
      #141204 10:12:43 server id 1  end_log_pos 30748202      Table_map: `weather`.`lightning` mapped to number 177647
      #141204 10:12:43 server id 1  end_log_pos 30748274      Table_map: `weather`.`_lightning_new` mapped to number 177646
      #141204 10:12:43 server id 1  end_log_pos 30748356      Delete_rows: table id 177647 flags: STMT_END_F
      ### DELETE FROM `weather`.`lightning`
      ### WHERE
      ###   @1=76448027
      ###   @2='GPATS'
      ###   @3=2009-11-16 09:51:23
      ###   @4=!! Don't know how to handle column type=0 meta=0 (0000)# at 30748356
      #141204 10:12:43 server id 1  end_log_pos 30748383      Xid = 12786901894
      COMMIT/*!*/;
       

      from upstream:

      mysqlbinlog did not properly decode DECIMAL ( http://dev.mysql.com/doc/refman/5.6/en/fixed-point-types.html ) values in a row-based binary log. This could cause invalid values to be printed out for DECIMAL columns. (Bug #17544169)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                danblack Daniel Black
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: