Comment 0 for bug 912470

Revision history for this message
Paul Graydon (twirrim) wrote :

pt-table-checksum was reporting diffs between data on the master and data on the slave, despite numerous attempts to create and re-create the slave.

In the end it turned out to be that because the Master server was set to EST and the slave HST (Master should have been HST like the rest of the servers, something had messed up the tzdata), the returned data from timestamp fields was different. timestamp data is stored as UTC but converted to localtime during select.

You might want to either throw up an error if you can detect that the master & slave are on different timezones, or maybe force the timezone to UTC for your connection through the time_zone variable.