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
This bug report is a duplicate of:
Bug #1388870: pt-table-checksum has some errors with different time zones.
Edit
Remove
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned | ||
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.
Revision history for this message
| Matthew B (utdrmac) wrote | #1 |
Revision history for this message
| Frank Cizmich (frank-cizmich) wrote | #2 |
Revision history for this message
| Nilnandan Joshi (nilnandan-joshi) wrote | #3 |
To post a comment you must log in.
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.