2

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.

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

1 Answer 1

1

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 and acknowledge you have read our privacy policy.

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