gh-ost: Timezone issue with timestamp columns if server doesn't use UTC.
After running a gh-ost with -test-on-replica I found differences in two timestamp columns.
I found this by doing a
select
*
from
t1 a
inner join _t1_gho b on a.id=b.id
where
a.c1<>b.c1
or a.c2<>b.c2
...
Record 1
timestamp_notified: 2016-08-17 13:08:04
timestamp_notified: 2016-08-17 11:08:04
Record 2
timestamp_notified: 2016-08-17 13:08:19
timestamp_finalized: 2016-02-01 23:39:30
timestamp_notified: 2016-08-17 11:08:19
timestamp_finalized: 2016-02-01 22:39:30
From the definition:
`timestamp_notified` timestamp NULL DEFAULT NULL,
`timestamp_exported` timestamp NULL DEFAULT NULL,
`timestamp_finalized` timestamp NULL DEFAULT NULL,
About this issue
- Original URL
- State: closed
- Created 8 years ago
- Comments: 23 (23 by maintainers)
@shlomi-noach yes planning to test this today