# Replication issue

**URL:** <https://forums.percona.com/t/replication-issue/2274>\
**Category:** Percona XtraBackup\
**Created:** [August 1, 2012, 10:05am UTC](https://forums.percona.com/t/replication-issue/2274 "2012-08-01T10:05:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sanket](https://avatars.discourse-cdn.com/v4/letter/s/57b2e6/32.png) [@sanket](https://forums.percona.com/u/sanket)\
**Post date:** [August 1, 2012, 10:05am UTC](https://forums.percona.com/t/replication-issue/2274/1 "2012-08-01T10:05:58Z")

</div>

One master Server  
3 slaves

Master Server version: 5.5.24-55-log

1st slave Server version: 5.5.24-55

2nd Slave Server version: 5.5.24-55

3rd slave Server version: 5.5.25a-27.1

On the first two slaves,the following type of statements get replicated properly  
insert into table1 (select \* from table 2)  
insert into db2.table1(select \* from table2)

On slave 3 (with newer version of percona db), the statements seem to fail

all of the slaves have same my.cnf file with only server\_id different.

could this be a bug in the new version of the software.

I have tried uninstalling the slave and then resyncing it using latest data from the master.

Any clues?

---

<div class="post-metadata">

**Author:** ![sanket](https://avatars.discourse-cdn.com/v4/letter/s/57b2e6/32.png) [@sanket](https://forums.percona.com/u/sanket)\
**Post date:** [August 1, 2012, 2:32pm UTC](https://forums.percona.com/t/replication-issue/2274/2 "2012-08-01T14:32:08Z")

</div>

Found the Issue

1. The timezone on the slave was different to all other machines
2. this differnce in time ,caused some of the queries to not work properly as the queries were using the mysql NOW function
