pt-heartbeat handles timezones inconsistently
Bug #886059 reported by
Kristian Davies
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Medium
|
Brian Fraser |
Bug Description
I have a master in GMT and a slave in IST. CentOS 5, perl 5.8.8, pt-heartbeat v1.0.1.
When I set pt-heartbeat to monitor in other timezones it translates the time so I get 0.00s but it seems to ignore IST so I get 19800.00s.
Related branches
lp:~percona-toolkit-dev/percona-toolkit/fix-886059-pt-heartbeat-timezones
- Brian Fraser (community): Approve
- Daniel Nichter: Approve
-
Diff: 198 lines (+127/-10)2 files modifiedbin/pt-heartbeat (+14/-10)
t/pt-heartbeat/bugs.t (+113/-0)
tags: | added: pt-heartbeat |
tags: | added: tz |
Changed in percona-toolkit: | |
status: | New → Confirmed |
Changed in percona-toolkit: | |
assignee: | nobody → Brian Fraser (fraserbn) |
status: | Confirmed → Triaged |
summary: |
- pt-heartbeat timezone ignores IST + pt-heartbeat inconsistently handles timezones |
Changed in percona-toolkit: | |
milestone: | none → 2.2.1 |
summary: |
- pt-heartbeat inconsistently handles timezones + pt-heartbeat handles timezones inconsistently |
Changed in percona-toolkit: | |
status: | Triaged → In Progress |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Please include more information so we can understand and reproduce the
problem. What do you mean "set pt-heartbeat to monitor in other
timezones" ? What command-line arguments are you using? What is the
machine's local time? What is the output of this query?
SELECT NOW(), * FROM <timestamp table>