pt-table-checksum should check for timezone settings on slave vs master and report when not set the same

Bug #1395930 reported by Michael Coburn on 2014-11-24
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to

Bug Description

We should check the master and slave timezone settings and confirm they are set to the same value, otherwise throw an alert that there may be differences on date/time fields.

Matthew B (utdrmac) wrote :

Not just check timezone, but also run NOW() on master/slave and make sure they are the same. If master OS is in PDT and mysql starts, mysql will continue to operate in PDT even if the OS timezone is changed. This makes it "appear" as if both are the same zone but in fact are not.

Frank Cizmich (frank-cizmich) wrote :

This might be a duplicate of:

There is a fix targeted for 2.2.13 for that issue.

As per the details, its indeed duplicate of

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers