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)

Commits related to this issue

Most upvoted comments

@shlomi-noach yes planning to test this today