A Lightweight SQL Database for Cloud Infrastructure and Web Applications

slave doesn't work with filtered_replicator because the latter writes invalid replication events

Reported by Daniel Nichter on 2012-04-29
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
High
Unassigned

Bug Description

The slave plugin doesn't work with the filtered_replicator plugin in 7.1 because the replicator writes invalid replication events:

drizzle> select * from data_dictionary.innodb_replication_log\G
*************************** 1. row ***************************
            TRANSACTION_ID: 800
    TRANSACTION_SEGMENT_ID: 0
                 COMMIT_ID: 0
             END_TIMESTAMP: 1335659685463387
   ORIGINATING_SERVER_UUID: 8666E171-1415-4792-B36C-52B2EFEE1AF9
     ORIGINATING_COMMIT_ID: 0
TRANSACTION_MESSAGE_STRING: transaction_context {
  server_id: 1
  transaction_id: 800
  start_timestamp: 1335659685463363
  end_timestamp: 1335659685463387
}
statement {
  type: CREATE_SCHEMA

The zeros values for segment ID, commit ID, etc. are invalid. Consequently, the slave plugin never sees any new commit IDs to read.

description: updated
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers