drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2585) Querying sys.threads and sys.memory results in SQLException
Date Thu, 26 Mar 2015 21:39:52 GMT
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)

Mime
View raw message