[
https://issues.apache.org/jira/browse/DRILL-4790?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16110505#comment-16110505
]
Abou Haydar Elias commented on DRILL-4790:
------------------------------------------
The following issue :
{code:java}
Caused by: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be
represented as java.sql.Timestamp
{code}
Is actually related to the jdbc connector, and like suggested by [~xwinie]
adding *?zeroDateTimeBehavior=convertToNull* to the plugin storage url should
solve this issue.
Thus there is no actually issue here.
> DATA_READ ERROR: Failure while attempting to read from database.
> ----------------------------------------------------------------
>
> Key: DRILL-4790
> URL: https://issues.apache.org/jira/browse/DRILL-4790
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
> Affects Versions: 1.6.0
> Environment: centos mysql56
> Reporter: xwinie
> Fix For: Future
>
>
> 2016-07-20 10:08:51,318 [287122cc-54de-ad19-8235-a2ee1bc5cbc0:frag:0:0] INFO
> o.a.d.e.w.fragment.FragmentExecutor -
> 287122cc-54de-ad19-8235-a2ee1bc5cbc0:0:0: State change requested
> AWAITING_ALLOCATION --> RUNNING
> 2016-07-20 10:08:51,319 [287122cc-54de-ad19-8235-a2ee1bc5cbc0:frag:0:0] INFO
> o.a.d.e.w.f.FragmentStatusReporter -
> 287122cc-54de-ad19-8235-a2ee1bc5cbc0:0:0: State to report: RUNNING
> 2016-07-20 10:09:00,118 [287122cc-54de-ad19-8235-a2ee1bc5cbc0:frag:0:0] INFO
> o.a.d.e.w.fragment.FragmentExecutor -
> 287122cc-54de-ad19-8235-a2ee1bc5cbc0:0:0: State change requested RUNNING -->
> FINISHED
> 2016-07-20 10:09:00,119 [287122cc-54de-ad19-8235-a2ee1bc5cbc0:frag:0:0] INFO
> o.a.d.e.w.f.FragmentStatusReporter -
> 287122cc-54de-ad19-8235-a2ee1bc5cbc0:0:0: State to report: FINISHED
> 2016-07-20 10:09:20,058 [287122ae-8f8c-b370-08fa-d9e6aa6566dd:foreman] INFO
> o.a.drill.exec.work.foreman.Foreman - Query text for query id
> 287122ae-8f8c-b370-08fa-d9e6aa6566dd: select * from mysqlplugin.mfm.sys_dict
> 2016-07-20 10:09:20,130 [287122ae-8f8c-b370-08fa-d9e6aa6566dd:frag:0:0] INFO
> o.a.d.e.w.fragment.FragmentExecutor -
> 287122ae-8f8c-b370-08fa-d9e6aa6566dd:0:0: State change requested
> AWAITING_ALLOCATION --> RUNNING
> 2016-07-20 10:09:20,131 [287122ae-8f8c-b370-08fa-d9e6aa6566dd:frag:0:0] INFO
> o.a.d.e.w.f.FragmentStatusReporter -
> 287122ae-8f8c-b370-08fa-d9e6aa6566dd:0:0: State to report: RUNNING
> 2016-07-20 10:09:20,141 [287122ae-8f8c-b370-08fa-d9e6aa6566dd:frag:0:0] INFO
> o.a.d.e.store.jdbc.JdbcRecordReader - User Error Occurred
> org.apache.drill.common.exceptions.UserException: DATA_READ ERROR: Failure
> while attempting to read from database.
> sql SELECT *
> FROM `mfm`.`sys_dict`
> plugin mysqlplugin
> [Error Id: cf1ef1a8-2e88-4ce3-8e51-129f6e3b7f83 ]
> at
> org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:543)
> ~[drill-common-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.store.jdbc.JdbcRecordReader.next(JdbcRecordReader.java:247)
> [drill-jdbc-storage-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.physical.impl.ScanBatch.next(ScanBatch.java:178)
> [drill-java-exec-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
> [drill-java-exec-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:109)
> [drill-java-exec-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:51)
> [drill-java-exec-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:135)
> [drill-java-exec-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:162)
> [drill-java-exec-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:104)
> [drill-java-exec-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:81)
> [drill-java-exec-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:94)
> [drill-java-exec-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:257)
> [drill-java-exec-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:251)
> [drill-java-exec-1.7.0.jar:1.7.0]
> at java.security.AccessController.doPrivileged(Native Method)
> [na:1.7.0_101]
> at javax.security.auth.Subject.doAs(Subject.java:415) [na:1.7.0_101]
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
> [hadoop-common-2.7.1.jar:na]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:251)
> [drill-java-exec-1.7.0.jar:1.7.0]
> at
> org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
> [drill-common-1.7.0.jar:1.7.0]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> [na:1.7.0_101]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> [na:1.7.0_101]
> at java.lang.Thread.run(Thread.java:745) [na:1.7.0_101]
> Caused by: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be
> represented as java.sql.Timestamp
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
> ~[mysql-connector-java-5.1.25.jar:na]
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
> ~[mysql-connector-java-5.1.25.jar:na]
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
> ~[mysql-connector-java-5.1.25.jar:na]
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
> ~[mysql-connector-java-5.1.25.jar:na]
> at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1102)
> ~[mysql-connector-java-5.1.25.jar:na]
> at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:127)
> ~[mysql-connector-java-5.1.25.jar:na]
> at
> com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6592)
> ~[mysql-connector-java-5.1.25.jar:na]
> at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6214)
> ~[mysql-connector-java-5.1.25.jar:na]
> at
> org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:586)
> ~[commons-dbcp-1.4.jar:1.4]
> at
> org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:586)
> ~[commons-dbcp-1.4.jar:1.4]
> at
> org.apache.drill.exec.store.jdbc.JdbcRecordReader$TimeStampCopier.copy(JdbcRecordReader.java:442)
> ~[drill-jdbc-storage-1.7.0.jar:1.7.0]
> at
> org.apache.drill.exec.store.jdbc.JdbcRecordReader.next(JdbcRecordReader.java:242)
> [drill-jdbc-storage-1.7.0.jar:1.7.0]
> ... 19 common frames omitted
> 2016-07-20 10:09:20,142 [287122ae-8f8c-b370-08fa-d9e6aa6566dd:frag:0:0] INFO
> o.a.d.e.w.fragment.FragmentExecutor -
> 287122ae-8f8c-b370-08fa-d9e6aa6566dd:0:0: State change requested RUNNING -->
> FAILED
> 2016-07-20 10:09:20,142 [287122ae-8f8c-b370-08fa-d9e6aa6566dd:frag:0:0] INFO
> o.a.d.e.w.fragment.FragmentExecutor -
> 287122ae-8f8c-b370-08fa-d9e6aa6566dd:0:0: State change requested FAILED -->
> FINISHED
> 2016-07-20 10:09:20,159 [CONTROL-rpc-event-queue] WARN
> o.a.drill.exec.work.foreman.Foreman - Dropping request to move to COMPLETED
> state as query is already at FAILED state (which is terminal).
> 2016-07-20 10:09:20,160 [CONTROL-rpc-event-queue] WARN
> o.a.d.e.w.b.ControlMessageHandler - Dropping request to cancel fragment.
> 287122ae-8f8c-b370-08fa-d9e6aa6566dd:0:0 does not exist.
> 2016-07-20 10:09:42,310 [28712298-e350-3c1e-dd7d-e02f87e709f0:foreman] INFO
> o.a.drill.exec.work.foreman.Foreman - Query text for query id
> 28712298-e350-3c1e-dd7d-e02f87e709f0: select * from mysqlplugin.api.sys_dict
> 2016-07-20 10:09:42,353 [28712298-e350-3c1e-dd7d-e02f87e709f0:frag:0:0] INFO
> o.a.d.e.w.fragment.FragmentExecutor -
> 28712298-e350-3c1e-dd7d-e02f87e709f0:0:0: State change requested
> AWAITING_ALLOCATION --> RUNNING
> 2016-07-20 10:09:42,353 [28712298-e350-3c1e-dd7d-e02f87e709f0:frag:0:0] INFO
> o.a.d.e.w.f.FragmentStatusReporter -
> 28712298-e350-3c1e-dd7d-e02f87e709f0:0:0: State to report: RUNNING
> 2016-07-20 10:09:42,356 [28712298-e350-3c1e-dd7d-e02f87e709f0:frag:0:0] INFO
> o.a.d.e.store.jdbc.JdbcRecordReader - User Error Occurred
> org.apache.drill.common.exceptions.UserException: DATA_READ ERROR: Failure
> while attempting to read from database.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
