You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2015/03/26 22:39:52 UTC
[jira] [Created] (DRILL-2585) Querying sys.threads and sys.memory
results in SQLException
Khurram Faraaz created DRILL-2585:
-------------------------------------
Summary: 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: Steven Phillips
Priority: Critical
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)