[MDEV-12003] GTID different between nodes Created: 2017-02-06  Updated: 2017-05-25  Resolved: 2017-05-25

Status: Closed
Project: MariaDB Server
Component/s: Galera
Fix Version/s: N/A

Type: Task Priority: Blocker
Reporter: jongo Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: 10.1.17

Attachments: PNG File master_GalerCluster.png    

 Description   

Hi,

I've configure a Galera Cluster between two sites (Site 1 and 2)
First node of site 1 is a slave of the current production Master (Percona 5.5.14 with standard replication).

Behind each nodes of the second site I've 3 RO replica with GTID method.

My problem is that I have the same GTID between each nodes except the node 1 of site 1 - node who's replica of the Master production.
I can switch a RO replica between each nodes except with the first one on site 1 because when I switch to it I've an error like this:

Last_Error: Could not execute Write_rows_v1 event on table test.tes1; Duplicate entry '195001708' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.000002, end_log_pos 40652604

Need help to understand what happen.

On each config file I have:

log_bin=binlog
binlog_format=ROW
log_slave_updates=on
wsrep_gtid_mode=on

Regards



 Comments   
Comment by Sergei Golubchik [ 2017-05-25 ]

This is not a support forum. Please ask your questions on maria-developers@lists.launchpad.net or on the #maria channel on Freenode.

Generated at Thu Feb 08 07:54:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.