[MXS-2047] BLR must store full path of events Created: 2018-09-13  Updated: 2020-07-03  Resolved: 2020-07-03

Status: Closed
Project: MariaDB MaxScale
Component/s: binlogrouter
Affects Version/s: 2.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Johan Wikman Assignee: Johan Wikman
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Blocks
blocks MXS-2011 Binlog Router and Binlog-Avro Router ... Closed

 Description   

If BLR is replicating from one node in a Galera cluster (e.g. GTID = 0-1-X), and updates are made also via other nodes than that node (i.e. the GTIDs will be different, e.g. GTID = 0-2-X), all events will end up in the same file (as they should) until a rotation.

In the case above, the full path of the file will e.g. be .../0/1/galera000-bin.000001 and it may contain events like 0-1-0, 0-1-1, 0-1-2, 0-2-3, 0-2-4 etc.

However, now when a slave looks for event 0-2-4, the BLR will assume to find it in file 0/2/galera000-bin.000001, which does not exist and the operation will thus fail.

BLR should, one way or another, store the full path information in its internal database.



 Comments   
Comment by Johan Wikman [ 2018-10-05 ]

By requiring that

  • that all Galera nodes have the same server_id and
  • that all Galera nodes have the same binlog basename (specified with log_bin=basename)
    this bug need not be fixed for MXS-1980.
Generated at Thu Feb 08 04:11:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.