# pt\_table\_sync cannot resolve conflict

**URL:** <https://forums.percona.com/t/pt-table-sync-cannot-resolve-conflict/5670>\
**Category:** Percona Toolkit\
**Created:** [June 10, 2017, 2:38pm UTC](https://forums.percona.com/t/pt-table-sync-cannot-resolve-conflict/5670 "2017-06-10T14:38:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mismail](https://avatars.discourse-cdn.com/v4/letter/m/35a633/32.png) [@mismail](https://forums.percona.com/u/mismail)\
**Post date:** [June 10, 2017, 2:38pm UTC](https://forums.percona.com/t/pt-table-sync-cannot-resolve-conflict/5670/1 "2017-06-10T14:38:12Z")

</div>

Hi,  
OS: Windows  
Framework Used: Strawberry Perl  
Interface: Command Line  
Statement: (perl pt-table-sync --print --bidirectional --columns=Posted --conflict-column=TStamp --conflict-comparison=newest --verbose --charset utf8 --d=ptktest --t=test --where=warehouse=3 h=server1,u=root,p=pass1,P=3306 h=server2,u=root,p=pass2,P=3306)  
where posted is a tinyint(1) column, TStamp a timestamp with default (CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP) and warehouse an int11.

Keep giving: Cannot resolve conflict WHERE `id`=‘1’: `TStamp` values are the same  
While TStamp in server1 = “2017-06-10 20:36:14” and posted = 1  
TStamp in server2 = “2017-06-10 14:04:36” and posted = 0  
Which is a diff. of about 6Hrs.

Can you please tell me where is my error?

---

<div class="post-metadata">

**Author:** ![carlos.salguero](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/carlos.salguero/32/20_2.png) [@carlos.salguero](https://forums.percona.com/u/carlos.salguero)\
**Post date:** [June 12, 2017, 7:43am UTC](https://forums.percona.com/t/pt-table-sync-cannot-resolve-conflict/5670/2 "2017-06-12T07:43:14Z")

</div>

Hi,

Column names are converted to lowercase internally. Try using

```auto
--conflict-column=tstamp

```

and also you can specify the threshold using something like

```auto
--conflict-threshold=5m

```

Regards