[ https://issues.apache.org/jira/browse/DRILL-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15948133#comment-15948133 ]
Rahul Challapalli commented on DRILL-5400: ------------------------------------------ Dataset used in the query : {code} { "type": "FeatureCollection", "maps" : [ {"m1":"val1", "m2":"val2"}, {"m3": {"m4":"val4"}} ], "metadata": { "generated": 1406245017000, "url": "http://comcat.cr.usgs.gov/fdsnws/event/1/query?format=geojson&starttime=2000-07-24%2000%3A00%3A00&minmagnitude=6&endtime=2014-07-24%2023%3A59%3A59&orderby=time", "title": "USGS Earthquakes", "status": 200, "api": "1.0.13", "count": 2184 }, "features": [ { "type": "Feature", "properties": { "mag": 6.9, "time": 1405954481000, "updated": 1405983436259 }, "geometry": { "type": "Point", "coordinates": "100,90" }, "id": "usb000ruzk", "location": { "zip": "95134", "street": "zanker", "bldgs": { "bldg1" : "HQ1", "bldg2" : "HQ2" } } } ] } {code} > Random IndexOutOfBoundsException when running a kvgen query on top of nested > json data > -------------------------------------------------------------------------------------- > > Key: DRILL-5400 > URL: https://issues.apache.org/jira/browse/DRILL-5400 > Project: Apache Drill > Issue Type: Bug > Components: Storage - JSON > Affects Versions: 1.10.0 > Reporter: Rahul Challapalli > > git.commit.id.abbrev=38ef562 > The below query did not fail when I ran it in isolation. However when I ran > the test suite at [1], which also contains the below query, by using 50 > threads submitting queries concurrently, I hit the below error. > {code} > select geo.features[0].location.bldgs, kvgen(geo.features[0].location.bldgs) > from `json_kvgenflatten/nested.json` geo > Failed with exception > java.sql.SQLException: SYSTEM ERROR: IndexOutOfBoundsException: index: 0, > length: 4 (expected: range(0, 0)) > Fragment 0:0 > [Error Id: 9bf434d1-2199-498d-b0a5-b487bbc7690b on qa-node182.qa.lab:31010] > (java.lang.IndexOutOfBoundsException) index: 0, length: 4 (expected: > range(0, 0)) > io.netty.buffer.DrillBuf.checkIndexD():123 > io.netty.buffer.DrillBuf.chk():147 > io.netty.buffer.DrillBuf.getInt():520 > org.apache.drill.exec.vector.UInt4Vector$Accessor.get():358 > org.apache.drill.exec.vector.VarCharVector$Mutator.setSafe():534 > > org.apache.drill.exec.vector.NullableVarCharVector$Mutator.fillEmpties():480 > > org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setValueCount():591 > org.apache.drill.exec.vector.complex.MapVector$Mutator.setValueCount():346 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.setValueCount():273 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.doWork():206 > org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():93 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():135 > org.apache.drill.exec.record.AbstractRecordBatch.next():162 > > org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next():215 > org.apache.drill.exec.physical.impl.BaseRootExec.next():104 > > org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():81 > org.apache.drill.exec.physical.impl.BaseRootExec.next():94 > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():232 > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():226 > java.security.AccessController.doPrivileged():-2 > javax.security.auth.Subject.doAs():422 > org.apache.hadoop.security.UserGroupInformation.doAs():1595 > org.apache.drill.exec.work.fragment.FragmentExecutor.run():226 > org.apache.drill.common.SelfCleaningRunnable.run():38 > java.util.concurrent.ThreadPoolExecutor.runWorker():1142 > java.util.concurrent.ThreadPoolExecutor$Worker.run():617 > java.lang.Thread.run():745 > at > org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:489) > at > org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:561) > at > org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1895) > at > org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:61) > at > oadd.org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:473) > at > org.apache.drill.jdbc.impl.DrillMetaImpl.prepareAndExecute(DrillMetaImpl.java:1100) > at > oadd.org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477) > at > org.apache.drill.jdbc.impl.DrillConnectionImpl.prepareAndExecuteInternal(DrillConnectionImpl.java:180) > at > oadd.org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109) > at > oadd.org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:130) > at > org.apache.drill.jdbc.impl.DrillStatementImpl.executeQuery(DrillStatementImpl.java:112) > at > org.apache.drill.test.framework.DrillTestJdbc.executeQuery(DrillTestJdbc.java:177) > at > org.apache.drill.test.framework.DrillTestJdbc.run(DrillTestJdbc.java:101) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: oadd.org.apache.drill.common.exceptions.UserRemoteException: > SYSTEM ERROR: IndexOutOfBoundsException: index: 0, length: 4 (expected: > range(0, 0)) > Fragment 0:0 > [Error Id: 9bf434d1-2199-498d-b0a5-b487bbc7690b on qa-node182.qa.lab:31010] > (java.lang.IndexOutOfBoundsException) index: 0, length: 4 (expected: > range(0, 0)) > io.netty.buffer.DrillBuf.checkIndexD():123 > io.netty.buffer.DrillBuf.chk():147 > io.netty.buffer.DrillBuf.getInt():520 > org.apache.drill.exec.vector.UInt4Vector$Accessor.get():358 > org.apache.drill.exec.vector.VarCharVector$Mutator.setSafe():534 > > org.apache.drill.exec.vector.NullableVarCharVector$Mutator.fillEmpties():480 > > org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setValueCount():591 > org.apache.drill.exec.vector.complex.MapVector$Mutator.setValueCount():346 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.setValueCount():273 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.doWork():206 > org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():93 > > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():135 > org.apache.drill.exec.record.AbstractRecordBatch.next():162 > > org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next():215 > org.apache.drill.exec.physical.impl.BaseRootExec.next():104 > > org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():81 > org.apache.drill.exec.physical.impl.BaseRootExec.next():94 > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():232 > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():226 > java.security.AccessController.doPrivileged():-2 > javax.security.auth.Subject.doAs():422 > org.apache.hadoop.security.UserGroupInformation.doAs():1595 > org.apache.drill.exec.work.fragment.FragmentExecutor.run():226 > org.apache.drill.common.SelfCleaningRunnable.run():38 > java.util.concurrent.ThreadPoolExecutor.runWorker():1142 > java.util.concurrent.ThreadPoolExecutor$Worker.run():617 > java.lang.Thread.run():745 > at > oadd.org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123) > at > oadd.org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:343) > at > oadd.org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:88) > at > oadd.org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:274) > at > oadd.org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:244) > at > oadd.io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > at > oadd.io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:254) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > at > oadd.io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > at > oadd.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > at > oadd.io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > at > oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > at > oadd.io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847) > at > oadd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) > at > oadd.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511) > at > oadd.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468) > at > oadd.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382) > at oadd.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354) > at > oadd.io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) > {code} > [1] > https://github.com/mapr/drill-test-framework/tree/master/framework/resources/Functional/json/json_kvgenflatten -- This message was sent by Atlassian JIRA (v6.3.15#6346)