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)
