You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chris Westin (JIRA)" <ji...@apache.org> on 2015/03/26 23:07:53 UTC
[jira] [Closed] (DRILL-2585) Querying sys.threads and sys.memory
results in SQLException
[ https://issues.apache.org/jira/browse/DRILL-2585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Westin closed DRILL-2585.
-------------------------------
Resolution: Won't Fix
Assignee: Sudheesh Katkam (was: Steven Phillips)
We don't currently make any promises that things will work if you don't have the same version installed throughout your cluster.
> Querying sys.threads and sys.memory results in SQLException
> -----------------------------------------------------------
>
> Key: DRILL-2585
> URL: https://issues.apache.org/jira/browse/DRILL-2585
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata
> Affects Versions: 0.9.0
> Environment: {code}
> 0: jdbc:drill:> select * from sys.version;
> +------------+----------------+-------------+-------------+------------+
> | commit_id | commit_message | commit_time | build_email | build_time |
> +------------+----------------+-------------+-------------+------------+
> | 393a8affdab9b93093a7afcc81d016e720d7781f | MD-192: CONVERT_FROM in where clause | 25.03.2015 @ 17:57:28 EDT | Unknown | 26.03.2015 @ 17:00:19 EDT |
> +------------+----------------+-------------+-------------+------------+
> 1 row selected (0.131 seconds)
> {code}
> [root@centos-01 drill-0.9.0]# uname -a
> Linux centos-01.qa.lab 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
> Reporter: Khurram Faraaz
> Assignee: Sudheesh Katkam
> Priority: Minor
>
> Querying system tables (sys.threads and sys.memory) results in an Exception on drill-0.9.0
> {code}
> 0: jdbc:drill:> show tables;
> +--------------+------------+
> | TABLE_SCHEMA | TABLE_NAME |
> +--------------+------------+
> | sys | drillbits |
> | sys | threads |
> | sys | memory |
> | sys | version |
> | sys | options |
> +--------------+------------+
> 5 rows selected (0.711 seconds)
> 0: jdbc:drill:> select * from sys.version;
> +------------+----------------+-------------+-------------+------------+
> | commit_id | commit_message | commit_time | build_email | build_time |
> +------------+----------------+-------------+-------------+------------+
> | 393a8affdab9b93093a7afcc81d016e720d7781f | MD-192: CONVERT_FROM in where clause | 25.03.2015 @ 17:57:28 EDT | Unknown | 26.03.2015 @ 17:00:19 EDT |
> +------------+----------------+-------------+-------------+------------+
> 1 row selected (0.131 seconds)
> 0: jdbc:drill:> select * from sys.threads;
> +------------+------------+---------------+--------------+
> | hostname | user_port | total_threads | busy_threads |
> +------------+------------+---------------+--------------+
> | centos-01.qa.lab | 31010 | 113 | 113 |
> Query failed: RemoteRpcException: Failure while trying to start remote fragment, Can not construct instance of org.apache.drill.exec.store.sys.SystemTable from String value 'THREADS': value not one of declared Enum instance names: [OPTION, DRILLBITS, VERSION]
> at [Source: {
> "pop" : "single-sender",
> "@id" : 0,
> "receiver-major-fragment" : 0,
> "receiver-minor-fragment" : 0,
> "child" : {
> "pop" : "sys",
> "@id" : 1,
> "table" : "THREADS",
> "cost" : 20.0
> },
> "destination" : "ChBjZW50b3MtMDEucWEubGFiEKLyARij8gEgpPIB",
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 20.0
> }; line: 8, column: 14] [ 896e62e1-2740-46a3-99d1-e3f2d2f91201 on centos-04.qa.lab:31010 ]
> java.lang.RuntimeException: java.sql.SQLException: Failure while executing query.
> at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
> at sqlline.SqlLine.print(SqlLine.java:1809)
> at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
> at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
> at sqlline.SqlLine.dispatch(SqlLine.java:889)
> at sqlline.SqlLine.begin(SqlLine.java:763)
> at sqlline.SqlLine.start(SqlLine.java:498)
> at sqlline.SqlLine.main(SqlLine.java:460)
> {code}
> {code}
> 0: jdbc:drill:> select * from sys.memory;
> +------------+------------+--------------+------------+----------------+------------+
> | hostname | user_port | heap_current | heap_max | direct_current | direct_max |
> +------------+------------+--------------+------------+----------------+------------+
> | centos-01.qa.lab | 31010 | 76121712 | 4151836672 | 9048576 | 8589934592 |
> Query failed: RemoteRpcException: Failure while trying to start remote fragment, Can not construct instance of org.apache.drill.exec.store.sys.SystemTable from String value 'MEMORY': value not one of declared Enum instance names: [OPTION, DRILLBITS, VERSION]
> at [Source: {
> "pop" : "single-sender",
> "@id" : 0,
> "receiver-major-fragment" : 0,
> "receiver-minor-fragment" : 0,
> "child" : {
> "pop" : "sys",
> "@id" : 1,
> "table" : "MEMORY",
> "cost" : 20.0
> },
> "destination" : "ChBjZW50b3MtMDEucWEubGFiEKLyARij8gEgpPIB",
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 20.0
> }; line: 8, column: 14] [ d62bb322-2cc7-4faf-886f-d67a1a6a6e5e on centos-02.qa.lab:31010 ]
> java.lang.RuntimeException: java.sql.SQLException: Failure while executing query.
> at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
> at sqlline.SqlLine.print(SqlLine.java:1809)
> at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
> at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
> at sqlline.SqlLine.dispatch(SqlLine.java:889)
> at sqlline.SqlLine.begin(SqlLine.java:763)
> at sqlline.SqlLine.start(SqlLine.java:498)
> at sqlline.SqlLine.main(SqlLine.java:460)
> {code}
> {code}
> 0: jdbc:drill:> alter session set `exec.errors.verbose`=true;
> +------------+------------+
> | ok | summary |
> +------------+------------+
> | true | exec.errors.verbose updated. |
> +------------+------------+
> {code}
> {code}
> 0: jdbc:drill:> select * from sys.memory;
> +------------+------------+--------------+------------+----------------+------------+
> | hostname | user_port | heap_current | heap_max | direct_current | direct_max |
> +------------+------------+--------------+------------+----------------+------------+
> | centos-01.qa.lab | 31010 | 85261600 | 4151836672 | 12067822 | 8589934592 |
> Query failed: RemoteRpcException: Failure while trying to start remote fragment, Can not construct instance of org.apache.drill.exec.store.sys.SystemTable from String value 'MEMORY': value not one of declared Enum instance names: [OPTION, DRILLBITS, VERSION]
> at [Source: {
> "pop" : "single-sender",
> "@id" : 0,
> "receiver-major-fragment" : 0,
> "receiver-minor-fragment" : 0,
> "child" : {
> "pop" : "sys",
> "@id" : 1,
> "table" : "MEMORY",
> "cost" : 20.0
> },
> "destination" : "ChBjZW50b3MtMDEucWEubGFiEKLyARij8gEgpPIB",
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 20.0
> }; line: 8, column: 14] [ 7235e0cc-1ffe-4f52-a1ac-e0bd1b84be69 on centos-02.qa.lab:31010 ]
> java.lang.RuntimeException: java.sql.SQLException: Failure while executing query.
> at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
> at sqlline.SqlLine.print(SqlLine.java:1809)
> at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
> at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
> at sqlline.SqlLine.dispatch(SqlLine.java:889)
> at sqlline.SqlLine.begin(SqlLine.java:763)
> at sqlline.SqlLine.start(SqlLine.java:498)
> at sqlline.SqlLine.main(SqlLine.java:460)
> 0: jdbc:drill:> select * from sys.threads;
> +------------+------------+---------------+--------------+
> | hostname | user_port | total_threads | busy_threads |
> +------------+------------+---------------+--------------+
> | centos-01.qa.lab | 31010 | 120 | 120 |
> Query failed: RemoteRpcException: Failure while trying to start remote fragment, Can not construct instance of org.apache.drill.exec.store.sys.SystemTable from String value 'THREADS': value not one of declared Enum instance names: [OPTION, DRILLBITS, VERSION]
> at [Source: {
> "pop" : "single-sender",
> "@id" : 0,
> "receiver-major-fragment" : 0,
> "receiver-minor-fragment" : 0,
> "child" : {
> "pop" : "sys",
> "@id" : 1,
> "table" : "THREADS",
> "cost" : 20.0
> },
> "destination" : "ChBjZW50b3MtMDEucWEubGFiEKLyARij8gEgpPIB",
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 20.0
> }; line: 8, column: 14] [ e921f4a7-db96-4c39-8516-5547002d731b on centos-04.qa.lab:31010 ]
> java.lang.RuntimeException: java.sql.SQLException: Failure while executing query.
> at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
> at sqlline.SqlLine.print(SqlLine.java:1809)
> at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
> at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
> at sqlline.SqlLine.dispatch(SqlLine.java:889)
> at sqlline.SqlLine.begin(SqlLine.java:763)
> at sqlline.SqlLine.start(SqlLine.java:498)
> at sqlline.SqlLine.main(SqlLine.java:460)
> {code}
> {code}
> 0: jdbc:drill:> select * from sys.drillbits;
> +------------+------------+--------------+------------+------------+
> | hostname | user_port | control_port | data_port | current |
> +------------+------------+--------------+------------+------------+
> | centos-01.qa.lab | 31010 | 31011 | 31012 | true |
> | centos-03.qa.lab | 31010 | 31011 | 31012 | false |
> | centos-02.qa.lab | 31010 | 31011 | 31012 | false |
> | centos-04.qa.lab | 31010 | 31011 | 31012 | false |
> +------------+------------+--------------+------------+------------+
> 4 rows selected (0.106 seconds)
> {code}
> Stack trace from drillbit.log
> {code}
> org.apache.drill.exec.rpc.RemoteRpcException: Failure while trying to start remote fragment, Can not construct instance of org.apache.drill.exec.store.sys.SystemTable from String value 'THREADS': value not one of declared Enum instance names: [OPTION, DRILLBITS, VERSION]
> at [Source: {
> "pop" : "single-sender",
> "@id" : 0,
> "receiver-major-fragment" : 0,
> "receiver-minor-fragment" : 0,
> "child" : {
> "pop" : "sys",
> "@id" : 1,
> "table" : "THREADS",
> "cost" : 20.0
> },
> "destination" : "ChBjZW50b3MtMDEucWEubGFiEKLyARij8gEgpPIB",
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 20.0
> }; line: 8, column: 14] [ 8a33feab-30f0-4dfc-967d-5cfa41b94c11 on centos-02.qa.lab:31010 ]
> at org.apache.drill.exec.rpc.CoordinationQueue.updateFailedFuture(CoordinationQueue.java:153) [drill-java-exec-0.9.0-SNAPSHOT-rebuffed.jar:0.9.0-SNAPSHOT]
> at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:227) [drill-java-exec-0.9.0-SNAPSHOT-rebuffed.jar:0.9.0-SNAPSHOT]
> at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:173) [drill-java-exec-0.9.0-SNAPSHOT-rebuffed.jar:0.9.0-SNAPSHOT]
> at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) [netty-codec-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) [netty-codec-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:161) [netty-codec-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:787) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:130) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:116) [netty-common-4.0.24.Final.jar:4.0.24.Final]
> at java.lang.Thread.run(Thread.java:745) [na:1.7.0_75]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)