Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5353

Wrong binlog entry for BLOB on a blackhole intermediary master

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.13-3, 5.7.23-25, 5.6.43-84.3
    • Fix Version/s: 5.6.44-85.0, 5.7.26-29, 8.0.15-6
    • Component/s: None
    • Labels:

      Description

      Originally reported at https://bugs.mysql.com/bug.php?id=93917
       
      Description:
       
      Bug #56007
      seems to be silently fixed. However, the same issue exists for a BLOB column.
      How to repeat:
      Run the attached test case, then check binary logs on the slave.

      Test column changes recorded correctly.

      Original update:

      UPDATE BLACK SET TEXTCOL='teststring_update' where ID=1;

      Binlog entry:

          1. UPDATE `test`.`BLACK`
          2. WHERE
          3. @1=1 /* LONGINT meta=0 nullable=1 is_null=0 */
          4. @2='teststring' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
          5. @3='TESTBLOB' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
          6. SET
          7. @1=1 /* LONGINT meta=0 nullable=1 is_null=0 */
          8. @2='teststring_update' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
          9. @3='TESTBLOB' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */

      Update for a BLOB column not.

      Original update:

      UPDATE BLACK SET BLOBCOL='testblob_update' where ID=2;

      Binlog entry:

          1. UPDATE `test`.`BLACK`
          2. WHERE
          3. @1=2 /* LONGINT meta=0 nullable=1 is_null=0 */
          4. @2='TESTSTRING_2' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
          5. @3='testblob_u' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
          6. SET
          7. @1=2 /* LONGINT meta=0 nullable=1 is_null=0 */
          8. @2='TESTSTRING_2' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
          9. @3='testblob_update' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                yura.sorokin Yura Sorokin
                Reporter:
                sveta.smirnova Sveta Smirnova
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 week, 4 days, 3 hours
                  1w 4d 3h