[MDEV-25809] Cant start replication. MIssing rows Created: 2021-05-28 Updated: 2021-06-04 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | mariabackup |
| Affects Version/s: | 10.5.6, 10.5.10 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Dutchak Vitalij | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Ubuntu 18.04 LTS |
||
| Description |
|
I have tried to setup one-way replication from wsrep cluster to another wsrep cluster. I was choose one server from first cluster as replica master and put in config:
Then i was made full backup and preapre it:
Then copy to another server which i choose as replication slave.
Got from file xtrabackup_binlog_info filename and pos (backup-bin.000017 and 47155747) Then I was bootstrap new wsrep cluster with only 1 node and trying to start replication between this node and master.
And got error Node was dropped from the cluster. I was check error.log and got error:
So i was checked what happend in binlog at this pos and find 1 record update. I was check this record on master and slave, it's present on master but not at slave. So I was checked does this record present in binlog and find insert query at position 47071167 As I understand problem in the backup operation or prepare operation. so I have not full data after backup or wrong position after prepare operation. I was try to repeat it couple times but got same results. What I can check in configs or maybe I was missing something? |
| Comments |
| Comment by Dutchak Vitalij [ 2021-06-04 ] | ||
|
Find out problem. Sorry for distracting.
and NVME drives.
fix the problem |