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)