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";'

Has anyone encountered this issue before?

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

  • What version of DBI.pm? – Rick James Jan 6 '16 at 20:42
  • Hi, I've just updated the post. The DBI.pm version is 1.63. – Ana C. Jan 7 '16 at 12:58
  • What version of DBD::mysql – I Support The Boycott Jan 12 '17 at 18:20

I think the bug is in your copy of DBD::mysql which seems to have been fixed sometime before version 4.027. Make sure your copy of DBD::mysql is up to date. 4.041 was released in Nov of 2016.

cpan DBD::mysql

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.