# pt-table-sync fails "Turning off AutoCommit"

**URL:** <https://forums.percona.com/t/pt-table-sync-fails-turning-off-autocommit/4652>\
**Category:** Percona Toolkit\
**Created:** [January 6, 2016, 12:21pm UTC](https://forums.percona.com/t/pt-table-sync-fails-turning-off-autocommit/4652 "2016-01-06T12:21:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![alvarado-virag](https://avatars.discourse-cdn.com/v4/letter/a/e9a140/32.png) [@alvarado-virag](https://forums.percona.com/u/alvarado-virag)\
**Post date:** [January 6, 2016, 12:21pm UTC](https://forums.percona.com/t/pt-table-sync-fails-turning-off-autocommit/4652/1 "2016-01-06T12:21:33Z")

</div>

While trying to use pt-table-sync with the following options for a list of slaves:

pt-table-sync --print --replicate schema.checksum\_table --sync-to-master slave-001

I receive the following error message on some of the slaves:  
DBD::mysql::db STORE failed: Turning off AutoCommit failed at /usr/lib/perl5/DBI.pm line 723.

The MySQL version for the slave is 5.6.17 and for the master 5.6.15. Other slaves for which this does work also have MySQL 5.6.15 version.  
I am able to turn off session autocommit if I log in to the slave directly using MySQL client and the same user being used for pt-table-sync.  
The checksum table in use was created by previously running pt-table-checksum.

DBI.pm version:  
$ perl -MDBI -e ‘print “$DBI::VERSION\n”;’  
1.63

Has anyone encountered this issue before?

Please let me know if you need me to provide more information.

Thank you.