You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "xwinie (JIRA)" <ji...@apache.org> on 2016/07/20 02:42:20 UTC
[jira] [Created] (DRILL-4790) DATA_READ ERROR: Failure while
attempting to read from database.
xwinie created DRILL-4790:
-----------------------------
Summary: 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.3.4#6332)