[jira] [Commented] (ROL-2037) Possible breakage in Planet feature

["Kohei Nozaki (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ROL-2037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15030864#comment-15030864 ] 

Kohei Nozaki commented on ROL-2037:
-----------------------------------

I think this can happen with a {{TIMESTAMP}} type column because it can't store any timestamp before 1970-01-01 00:00:01 UTC by spec. But Roller uses {{DATETIME}}, Which can store more wider range, In schema creation script so it shouldn't occur.

References:
http://dev.mysql.com/doc/refman/5.5/en/datetime.html
https://github.com/apache/roller/blob/a016635d334f2901b2fe9e1c0b6324dc81cf6bc6/app/src/main/java/org/apache/roller/weblogger/planet/tasks/SyncWebsitesTask.java#L178

A similar problem reported with {{TIMESTAMP}}:
http://forum.spring.io/forum/spring-projects/batch/111113-spring-batch-job-params-trying-to-insert-1969-12-31-16-00-00-for-column-date-val


> Possible breakage in Planet feature
> -----------------------------------
>
>                 Key: ROL-2037
>                 URL: https://issues.apache.org/jira/browse/ROL-2037
>             Project: Apache Roller
>          Issue Type: Bug
>          Components: Planet Aggregator
>    Affects Versions: 5.1
>            Reporter: David Johnson
>            Assignee: David Johnson
>
> I'm still investigating this and hope to fix for 5.1.
> [EL Warning]: 2014-07-08 17:38:00.199--UnitOfWork(1194666925)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1969-12-31 19:00:00' for column 'last_updated' at row 1
> Error Code: 1292
> Call: INSERT INTO rag_subscription (id, author, feed_url, inbound_blogs, inbound_links, last_updated, site_url, title) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
>         bind => [8 parameters bound]
> Query: InsertObjectQuery({weblogger:project, http://rollerweblogger.org/project/, Roller: free and open source Java blog software, Roller: free and open source Java blog software, Wed Dec 31 19:00:00 EST 1969})
> [EL Warning]: 2014-07-08 17:43:00.081--UnitOfWork(1313604468)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1969-12-31 19:00:00' for column 'last_updated' at row 1
> Error Code: 1292



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)