[MDEV-13948] Can't find record in replication slaves Created: 2017-09-29  Updated: 2017-10-01  Resolved: 2017-10-01

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.2.9
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Michael Xu Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

CentOS 7.x x86_64


 Description   

I have 2 slave servers in my replication system. Here are the steps how I setup the system

step 1:
Setup master(m1) -> slave(s1) replication after server initialization, after that I run data import on m1 using mysql < data.sql. Everything is ok, no error message in mysqld.log

step 2:
backup data on m1 (there is no activity on m1)
mariabackup --backup --extra-lsndir=/data/backup_3306 --compress --host=127.0.0.1 --port=3306 --user=backup --password=changme --compress-threads=16 --parallel=16 --stream=xbstream --tmpdir=/tmp/backup_3306 --target-dir=/data/backup_3306 > /data/backup.xbs

copy data to s2
scp .....

decompress data
mbstream -x < /data/local-backup/backup.xbs -C /data/restore
mariabackup --decompress --parallel=16 --target-dir=/data/restore

copy-back
mariabackup --defaults-file=/etc/my.cnf --copy-back --target-dir=/data/restore

fix permission issues
...

start mysql service
setup replication
start replication

Make m1 as slave with log_slave_update to Mysql 5.6 server. After a while, I can see the following error messages on both s1 and s2.

2017-09-28 13:52:26 140519051532032 [ERROR] mysqld: Can't find record in 't1'
2017-09-28 13:52:26 140519051937536 [ERROR] mysqld: Can't find record in 't1'
2017-09-28 13:52:26 140519051667200 [ERROR] mysqld: Can't find record in 't1'
2017-09-28 13:52:26 140519051261696 [ERROR] mysqld: Can't find record in 't1'
2017-09-28 13:52:26 140519051667200 [ERROR] mysqld: Can't find record in 't1'
2017-09-28 13:52:29 140519051261696 [ERROR] mysqld: Can't find record in 't1'
2017-09-28 13:52:29 140519051261696 [ERROR] mysqld: Can't find record in 't1'
2017-09-28 13:52:29 140519051532032 [ERROR] mysqld: Can't find record in 't1'
2017-09-28 13:52:30 140519051396864 [ERROR] mysqld: Can't find record in 't1'
2017-09-28 13:52:30 140519051396864 [ERROR] mysqld: Can't find record in 't1'
2017-09-28 13:52:30 140519051532032 [ERROR] mysqld: Can't find record in 't1'
2017-09-28 13:52:30 140519051802368 [ERROR] mysqld: Can't find record in 't1'

So could you please investigate what the problem is? Thanks.

 Comments   
Comment by Elena Stepanova [ 2017-10-01 ]

Sorry, no, we cannot investigate your replication setup, there is nothing here so far that would suggest a possible bug. There are numerous reasons why this error could occur, valid from the software point of view, caused by misconfiguration.

If you need expert help with setting up, configuring and otherwise maintaining your database servers, please consider getting a MariaDB support contract.

Otherwise, you can seek advice from community forums and mailing lists.

Generated at Thu Feb 08 08:09:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.