drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abou Haydar Elias (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4790) DATA_READ ERROR: Failure while attempting to read from database.
Date Wed, 02 Aug 2017 08:16:00 GMT

    [ 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)

Mime
View raw message