Jay Sen created GOBBLIN-1182:
--------------------------------
Summary: Incorrect datetime value error on mysql 5.7
Key: GOBBLIN-1182
URL: https://issues.apache.org/jira/browse/GOBBLIN-1182
Project: Apache Gobblin
Issue Type: Improvement
Components: gobblin-core
Affects Versions: 0.15.0
Reporter: Jay Sen
Assignee: Abhishek Tiwari
Fix For: 0.15.0
jobExecution record insertion with default value of epoch timestamp throws
error on MySql 5.7+
the reason is MySQL 5.7+ will convert timestamp to local for internal storage
and by default errors out anything less than epoch time unless server sets the
zero or negative time allowed explicitly.
as a quick fix, Gobblin can use 1970-01-02 00:00:00 which ensures all world's
localtime is covered. alternate solution can be not to set the end_Date at all
and allow null to indicate "not set".
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
