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

Wrong binlog entry for BLOB on a blackhole intermediary master

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.7.23-25, 8.0.13-3, 5.6.43-84.3
    • Fix Version/s: 8.0.15-6, 5.6.44-85.0, 5.7.26-29
    • 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 */

        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

                  Smart Checklist