{"action":"created","issue":{"url":"https://api.github.com/repos/github/gh-ost/issues/161","repository_url":"https://api.github.com/repos/github/gh-ost","labels_url":"https://api.github.com/repos/github/gh-ost/issues/161/labels{/name}","comments_url":"https://api.github.com/repos/github/gh-ost/issues/161/comments","events_url":"https://api.github.com/repos/github/gh-ost/issues/161/events","html_url":"https://github.com/github/gh-ost/issues/161","id":171659531,"number":161,"title":"Possible timezone issue with timestamp columns","user":{"login":"dveeden","id":1272980,"avatar_url":"https://avatars.githubusercontent.com/u/1272980?v=3","gravatar_id":"","url":"https://api.github.com/users/dveeden","html_url":"https://github.com/dveeden","followers_url":"https://api.github.com/users/dveeden/followers","following_url":"https://api.github.com/users/dveeden/following{/other_user}","gists_url":"https://api.github.com/users/dveeden/gists{/gist_id}","starred_url":"https://api.github.com/users/dveeden/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dveeden/subscriptions","organizations_url":"https://api.github.com/users/dveeden/orgs","repos_url":"https://api.github.com/users/dveeden/repos","events_url":"https://api.github.com/users/dveeden/events{/privacy}","received_events_url":"https://api.github.com/users/dveeden/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-08-17T13:38:41Z","updated_at":"2016-08-17T13:42:42Z","closed_at":null,"body":"After running a gh-ost with -test-on-replica I found differences in two timestamp columns.\r\n\r\nI found this by doing a \r\n```\r\nselect \r\n  * \r\nfrom \r\n  t1 a \r\n  inner join _t1_gho b on a.id=b.id \r\nwhere \r\n  a.c1<>b.c1 \r\n  or a.c2<>b.c2\r\n  ...\r\n```\r\n\r\nRecord 1\r\n```\r\n   timestamp_notified: 2016-08-17 13:08:04\r\n   timestamp_notified: 2016-08-17 11:08:04\r\n```\r\n\r\nRecord 2\r\n```\r\n   timestamp_notified: 2016-08-17 13:08:19\r\n  timestamp_finalized: 2016-02-01 23:39:30\r\n   timestamp_notified: 2016-08-17 11:08:19\r\n  timestamp_finalized: 2016-02-01 22:39:30\r\n```\r\n\r\nFrom the definition:\r\n```\r\n  `timestamp_notified` timestamp NULL DEFAULT NULL,\r\n  `timestamp_exported` timestamp NULL DEFAULT NULL,\r\n  `timestamp_finalized` timestamp NULL DEFAULT NULL,\r\n```"},"comment":{"url":"https://api.github.com/repos/github/gh-ost/issues/comments/240414650","html_url":"https://github.com/github/gh-ost/issues/161#issuecomment-240414650","issue_url":"https://api.github.com/repos/github/gh-ost/issues/161","id":240414650,"user":{"login":"dveeden","id":1272980,"avatar_url":"https://avatars.githubusercontent.com/u/1272980?v=3","gravatar_id":"","url":"https://api.github.com/users/dveeden","html_url":"https://github.com/dveeden","followers_url":"https://api.github.com/users/dveeden/followers","following_url":"https://api.github.com/users/dveeden/following{/other_user}","gists_url":"https://api.github.com/users/dveeden/gists{/gist_id}","starred_url":"https://api.github.com/users/dveeden/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dveeden/subscriptions","organizations_url":"https://api.github.com/users/dveeden/orgs","repos_url":"https://api.github.com/users/dveeden/repos","events_url":"https://api.github.com/users/dveeden/events{/privacy}","received_events_url":"https://api.github.com/users/dveeden/received_events","type":"User","site_admin":false},"created_at":"2016-08-17T13:42:42Z","updated_at":"2016-08-17T13:42:42Z","body":"Environment: CentOS 6, MySQL 5.6.27\r\n/etc/localtime is a link to /usr/share/zoneinfo/Europe/Amsterdam\r\n\r\n@@global.time_zone is set to SYSTEM."}}
{"actor":{"display_login":"dveeden"}}