Not the answer you need?
Register and ask your own question!

Records are missing in the slave server while replication

sujitkumarjhasujitkumarjha EntrantCurrent User Role Novice
We have two server setup :
Master : 10.64.11.142
Slave: 10.64.11.56

We have created a table on Master:

CREATE TABLE `billing_details`.`app_records` (
`msisdn` VARCHAR(45) NOT NULL,
`sc` VARCHAR(45) NULL,
`date_time` VARCHAR(45) NULL,
PRIMARY KEY (`msisdn`));

After that replication has stopped on slave and got below logs :

2019-07-01 13:06:24 10636 exist[ERROR] Slave SQL: Error executing row event: 'Table 'billing_details.app_records' doesn't exist', Error_code: 1146
2019-07-01 13:06:24 10636 [Warning] Slave: Table 'billing_details.app_records' doesn't exist Error_code: 1146
2019-07-01 13:06:24 10636 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at lexistog 'mysql-bin.000263' position 506655964

Also some times we found records are missing in the slave server while replication.
Please help.

Best regards,
Sujit
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.