You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "david_hudavy (JIRA)" <ji...@apache.org> on 2016/01/22 13:24:39 UTC
[jira] [Commented] (DRILL-4302) when running select count(*) from
table;alert:Error: DATA_READ ERROR: The JDBC storage plugin failed while
trying setup the SQL query
[ 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)