[
https://issues.apache.org/jira/browse/DRILL-4302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15112363#comment-15112363
]
david_hudavy commented on DRILL-4302:
-------------------------------------
2016-01-22 19:18:45,747 [295defe9-eb85-6313-25b3-c63032ad3ac6:foreman] INFO
o.a.drill.exec.work.foreman.Foreman - Query text for query id
295defe9-eb85-6313-25b3-c63032ad3ac6: select count(*) from
mysql256.upg_datamart.mscIdentities
2016-01-22 19:18:47,999 [295defe9-eb85-6313-25b3-c63032ad3ac6:frag:0:0] INFO
o.a.d.e.store.jdbc.JdbcRecordReader - User Error Occurred
org.apache.drill.common.exceptions.UserException: DATA_READ ERROR: The JDBC
storage plugin failed while trying setup the SQL query.
sql SELECT COUNT(*) AS `EXPR$0`
FROM (SELECT 0 AS `$f0`
FROM `datamart`.`tab2`) AS `t`
plugin mysql256
[Error Id: 484826c9-2c99-48ee-84db-d48029e8565a ]
at
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534)
~[drill-common-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.store.jdbc.JdbcRecordReader.setup(JdbcRecordReader.java:221)
[drill-jdbc-storage-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.physical.impl.ScanBatch.<init>(ScanBatch.java:108)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.physical.impl.ScanBatch.<init>(ScanBatch.java:136)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.store.jdbc.JdbcBatchCreator.getBatch(JdbcBatchCreator.java:40)
[drill-jdbc-storage-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.store.jdbc.JdbcBatchCreator.getBatch(JdbcBatchCreator.java:33)
[drill-jdbc-storage-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch(ImplCreator.java:147)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:170)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.physical.impl.ImplCreator.getRootExec(ImplCreator.java:101)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.physical.impl.ImplCreator.getExec(ImplCreator.java:79)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:230)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
[drill-common-1.4.0.jar:1.4.0]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_80]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_80]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]
Caused by: java.sql.SQLException: Incorrect key file for table
'/tmp/#sql_1531_0.MYI'; try to repair it
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2082)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1956)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3298)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:463)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at
com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3032)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2280)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2546)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2504)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1370)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
~[commons-dbcp-1.4.jar:1.4]
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
~[commons-dbcp-1.4.jar:1.4]
at
org.apache.drill.exec.store.jdbc.JdbcRecordReader.setup(JdbcRecordReader.java:177)
[drill-jdbc-storage-1.4.0.jar:1.4.0]
... 13 common frames omitted
2016-01-22 19:18:47,999 [295defe9-eb85-6313-25b3-c63032ad3ac6:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 295defe9-eb85-6313-25b3-c63032ad3ac6:0:0:
State change requested AWAITING_ALLOCATION --> FAILED
2016-01-22 19:18:47,999 [295defe9-eb85-6313-25b3-c63032ad3ac6:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 295defe9-eb85-6313-25b3-c63032ad3ac6:0:0:
State change requested FAILED --> FINISHED
2016-01-22 19:18:48,010 [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-01-22 19:18:48,011 [CONTROL-rpc-event-queue] WARN
o.a.d.e.w.b.ControlMessageHandler - Dropping request to cancel fragment.
295defe9-eb85-6313-25b3-c63032ad3ac6:0:0 does not exist.
2016-01-22 20:12:46,006 [295de340-e2e5-ce72-4b90-8846dd692343:foreman] INFO
o.a.drill.exec.work.foreman.Foreman - Query text for query id
295de340-e2e5-ce72-4b90-8846dd692343: select count(*) from
mysql256.upg_datamart.mscIdentities
2016-01-22 20:12:48,250 [295de340-e2e5-ce72-4b90-8846dd692343:frag:0:0] INFO
o.a.d.e.store.jdbc.JdbcRecordReader - User Error Occurred
org.apache.drill.common.exceptions.UserException: DATA_READ ERROR: The JDBC
storage plugin failed while trying setup the SQL query.
sql SELECT COUNT(*) AS `EXPR$0`
FROM (SELECT 0 AS `$f0`
FROM `datamart`.`tab2` ) AS `t`
plugin mysql256
[Error Id: 4c4d8818-3641-4cf8-a85e-ee0d0ed9284b ]
at
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534)
~[drill-common-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.store.jdbc.JdbcRecordReader.setup(JdbcRecordReader.java:221)
[drill-jdbc-storage-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.physical.impl.ScanBatch.<init>(ScanBatch.java:108)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.physical.impl.ScanBatch.<init>(ScanBatch.java:136)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.store.jdbc.JdbcBatchCreator.getBatch(JdbcBatchCreator.java:40)
[drill-jdbc-storage-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.store.jdbc.JdbcBatchCreator.getBatch(JdbcBatchCreator.java:33)
[drill-jdbc-storage-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch(ImplCreator.java:147)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:170)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.physical.impl.ImplCreator.getRootExec(ImplCreator.java:101)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.physical.impl.ImplCreator.getExec(ImplCreator.java:79)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:230)
[drill-java-exec-1.4.0.jar:1.4.0]
at
org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
[drill-common-1.4.0.jar:1.4.0]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_80]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_80]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]
Caused by: java.sql.SQLException: Incorrect key file for table
'/tmp/#sql_1531_0.MYI'; try to repair it
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2082)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1956)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3298)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:463)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at
com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3032)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2280)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2546)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2504)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1370)
~[mysql-connector-java-5.1.37-bin.jar:5.1.37]
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
~[commons-dbcp-1.4.jar:1.4]
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
~[commons-dbcp-1.4.jar:1.4]
at
org.apache.drill.exec.store.jdbc.JdbcRecordReader.setup(JdbcRecordReader.java:177)
[drill-jdbc-storage-1.4.0.jar:1.4.0]
... 13 common frames omitted
2016-01-22 20:12:48,250 [295de340-e2e5-ce72-4b90-8846dd692343:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 295de340-e2e5-ce72-4b90-8846dd692343:0:0:
State change requested AWAITING_ALLOCATION --> FAILED
2016-01-22 20:12:48,250 [295de340-e2e5-ce72-4b90-8846dd692343:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 295de340-e2e5-ce72-4b90-8846dd692343:0:0:
State change requested FAILED --> FINISHED
2016-01-22 20:12:48,262 [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-01-22 20:12:48,262 [CONTROL-rpc-event-queue] WARN
o.a.d.e.w.b.ControlMessageHandler - Dropping request to cancel fragment.
295de340-e2e5-ce72-4b90-8846dd692343:0:0 does not exist.
> when running select count(*) from table;alert:Error: DATA_READ ERROR: The
> JDBC storage plugin failed while trying setup the SQL query
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DRILL-4302
> URL: https://issues.apache.org/jira/browse/DRILL-4302
> Project: Apache Drill
> Issue Type: Improvement
> Components: Client - JDBC
> Affects Versions: Future
> Reporter: david_hudavy
>
> 0: jdbc:drill:zk=SC-1:6181,SC-2:6181,PL-3:618> select count(1) from
> mysql256.datamart.tab1;
> +----------+
> | EXPR$0 |
> +----------+
> | 1225578 |
> +----------+
> 1 row selected (1.819 seconds)
> 0: jdbc:drill:zk=SC-1:6181,SC-2:6181,PL-3:618> select count(1) from
> mysql256.datamart.tab2;
> Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the
> SQL query.
> sql SELECT COUNT(*) AS `EXPR$0`
> FROM (SELECT 1 AS `$f0`
> FROM `datamart`.`tab2`) AS `t`
> plugin mysql256
> Fragment 0:0
> [Error Id: 9e919a48-bae5-4835-a9cd-64066bf560b0 on SC-2:31010] (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
