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

Mariadb-binlog cant filter partial_log_events

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 12.3
    • 12.3.1
    • Replication
    • None
    • Not for Release Notes
    • Q1/2026 Server Maintenance

    Description

      MDEV-32570 : Fragment ROW replication events larger than slave_max_allowed_packet

      | binlog.000001 | 173097 | Gtid              |         1 |      173139 | BEGIN GTID 0-1-44                                                                       |
      | binlog.000001 | 173139 | Annotate_rows     |         1 |           0 | INSERT INTO t1 VALUES (NULL, '1')                                                       |
      | binlog.000001 | 173195 | Table_map         |         1 |           0 | table_id: 25 (DB1.t1)                                                                   |
      | binlog.000001 | 173241 | Write_rows_v1     |         1 |           0 | table_id: 25 flags: STMT_END_F                                                          |
      | binlog.000001 | 173284 | Xid               |         1 |      173315 | COMMIT /* xid=85 */                                                                     |
      | binlog.000001 | 173315 | Gtid              |         1 |      173357 | BEGIN GTID 0-1-45                                                                       |
      | binlog.000001 | 173357 | Annotate_rows     |         1 |           0 | INSERT INTO t1 VALUES (NULL, @blob)                                                     |
      | binlog.000001 | 173415 | Table_map         |         1 |           0 | table_id: 25 (DB1.t1)                                                                   |
      | binlog.000001 | 173461 | Partial_rows      |         1 |        1128 | Fragment 1 of 2                                                                         |
      | binlog.000001 | 174485 | Partial_rows      |         1 |        1238 | Fragment 2 of 2                                                                         |
      | binlog.000001 | 174595 | Xid               |         1 |      174626 | COMMIT /* xid=87 */                                                                     |
      +---------------+--------+-------------------+-----------+-------------+-----------------------------------------------------------------------------------------+
      353 rows in set (0.001 sec)
      

      ./bin/mariadb-binlog ./data/binlog.000001 --database=db10
      

      # at 173097
      #260122  1:07:31 server id 1  end_log_pos 173139 CRC32 0x9b3aef5a 	GTID 0-1-44 trans thread_id=7
      /*M!100001 SET @@session.gtid_seq_no=44*//*!*/;
      START TRANSACTION
      /*!*/;
      # at 173139
      # at 173195
      # at 173241
      # at 173284
      #260122  1:07:31 server id 1  end_log_pos 173315 CRC32 0x4a4ec7e1 	Xid = 85
      COMMIT/*!*/;
      # at 173315
      #260122  1:08:08 server id 1  end_log_pos 173357 CRC32 0x006a5624 	GTID 0-1-45 trans thread_id=7
      /*M!100001 SET @@session.gtid_seq_no=45*//*!*/;
      START TRANSACTION
      /*!*/;
      # at 173357
      # at 173415
      # at 173461
      #260122  1:08:08 server id 1  end_log_pos 1128 CRC32 0x160fcf1b 	Partial_rows (1 / 2):
       
      BINLOG '
      ICtxaawBAAAAAAQAAGgEAAAAAAIAAAABAAAAASYEAAAAAAAAICtxaRcBAAAAKgQAAAAAAAAAABkA
      AAAAAAEAAgP8DQAAAAAEAABBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBG88PFg==
      '/*!*/;
      # at 174485
      #260122  1:08:08 server id 1  end_log_pos 1238 CRC32 0xc5662228 	Partial_rows (2 / 2):
       
      BINLOG '
      ICtxaawBAAAAbgAAANYEAAAAAAIAAAACAAAAAEFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFB
      QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQSgiZsU=
      '/*!*/;
      # at 174595
      #260122  1:08:08 server id 1  end_log_pos 174626 CRC32 0x8b9a81f2 	Xid = 87
      COMMIT/*!*/;
      DELIMITER ;
      # End of log file
      ROLLBACK /* added by mysqlbinlog */;
      /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
      /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
      
      

      Partial_log_events are not filtered correctly

      Attachments

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              Deepthi ES Deepthi Eranti Sreenivas
              Brandon Nesterenko Brandon Nesterenko
              Deepthi Eranti Sreenivas Deepthi Eranti Sreenivas
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.