Activity log for bug #912470

Date Who What changed Old value New value Message
2012-01-05 20:17:12 Paul Graydon bug added bug
2012-01-05 20:18:12 Paul Graydon description 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. 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. pt-table-checksum version 2.0.1, mysql 5.1.58 on master, 5.1.59 on slave.
2012-01-05 20:26:26 Baron Schwartz percona-toolkit: status New Invalid