[ https://issues.apache.org/jira/browse/DRILL-2585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14382776#comment-14382776 ]
Khurram Faraaz commented on DRILL-2585: --------------------------------------- The cluster had 4 nodes, and only one of them had the latest version drill-0.9.0 installed, and the other three nodes were still on version drill-0.8.0. After, I installed version drill-0.9.0 on the other three nodes, the queries return expected results and no exceptions were returned. {code} 0: jdbc:drill:> select * from sys.drillbits; +------------+------------+--------------+------------+------------+ | hostname | user_port | control_port | data_port | current | +------------+------------+--------------+------------+------------+ | centos-04.qa.lab | 31010 | 31011 | 31012 | false | | centos-02.qa.lab | 31010 | 31011 | 31012 | true | | centos-01.qa.lab | 31010 | 31011 | 31012 | false | | centos-03.qa.lab | 31010 | 31011 | 31012 | false | +------------+------------+--------------+------------+------------+ 4 rows selected (0.595 seconds) 0: jdbc:drill:> select * from sys.memory; +------------+------------+--------------+------------+----------------+------------+ | hostname | user_port | heap_current | heap_max | direct_current | direct_max | +------------+------------+--------------+------------+----------------+------------+ | centos-01.qa.lab | 31010 | 141233192 | 4151836672 | 17000000 | 8589934592 | | centos-02.qa.lab | 31010 | 73520824 | 4151836672 | 6048576 | 8589934592 | | centos-04.qa.lab | 31010 | 107456512 | 4151836672 | 2000000 | 8589934592 | | centos-03.qa.lab | 31010 | 112883632 | 4151836672 | 2000000 | 8589934592 | +------------+------------+--------------+------------+----------------+------------+ 4 rows selected (0.637 seconds) 0: jdbc:drill:> select * from sys.threads; +------------+------------+---------------+--------------+ | hostname | user_port | total_threads | busy_threads | +------------+------------+---------------+--------------+ | centos-02.qa.lab | 31010 | 120 | 119 | | centos-01.qa.lab | 31010 | 123 | 123 | | centos-03.qa.lab | 31010 | 110 | 110 | | centos-04.qa.lab | 31010 | 111 | 111 | +------------+------------+---------------+--------------+ 4 rows selected (0.131 seconds) {code} > 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)