# Records are missing in the slave server while replication

**URL:** <https://forums.percona.com/t/records-are-missing-in-the-slave-server-while-replication/7096>\
**Category:** Other MySQL® Questions\
**Created:** [July 4, 2019, 7:24am UTC](https://forums.percona.com/t/records-are-missing-in-the-slave-server-while-replication/7096 "2019-07-04T07:24:23Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sujitkumarjha](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@sujitkumarjha](https://forums.percona.com/u/sujitkumarjha)\
**Post date:** [July 4, 2019, 7:24am UTC](https://forums.percona.com/t/records-are-missing-in-the-slave-server-while-replication/7096/1 "2019-07-04T07:24:23Z")

</div>

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