Hi James,
I am attaching the json profile
Please can you look into this
Waiting for your suggestion.
Thanks and regards
Jagadeesh maddi
On Sat, 8 Oct 2022 at 11:03 AM, James Turton <[email protected]
<mailto:[email protected]>> wrote:
Please send the JSON query profile.
On 2022/10/06 18:46, jagadeesh maddi wrote:
> Hi James,
>
> We are in production. We need your help
>
> Please provide your suggestion to solve this problem
>
> Thanks and regards
> Jagadeesh maddi
>
> On Thu, 6 Oct 2022 at 1:15 AM, jagadeesh maddi
<[email protected] <mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>> wrote:
>
> HI james,
>
> Error: error i am geting
>
> [30038]Query execution error. Details:[ SYSTEM ERROR:
> NullPointerException Fragment: 3:0 Please, refer to logs for more
> information. [Error Id: ba482a08-ffab-4069-a094-9fb82cbe0955 on
> blp14571311:31010]
> (com.fasterxml.jackson.databind.exc.ValueInstantiationException)
> Cannot construct instance of
> `org.apache.drill.exec.store.druid.DruidSubScan`, problem:
> `java.lang.NullPointerException` at [Source: (String)"{ "pop" :
> "hash-partition-sender", "@id" : 0, "receiver-major-fragment"
: 2,
> "child" : { "pop" : "druid-datasource-scan", "@id" : 1,
"columns" :
> [ "`__time`", "`COUNTER_GROUP_ID`", "C_1`", "`C_10`", "`C_11`",
> "`C_12`" ], "maxRecordsToRead" : -1, "initialAlloca...
> thanks and regards
> Jagadeesh Maddi
>
> On Wed, Oct 5, 2022 at 11:34 PM jagadeesh maddi
> <[email protected] <mailto:[email protected]>
<mailto:[email protected] <mailto:[email protected]>>>
wrote:
>
> thanks james,
>
> But in using as `__time` not 'time' it was type error..i am
> sorry for that
>
> i have checked no keywords used in the Query
>
> thanks and regards
> jagadeesh Maddi
>
> On Wed, Oct 5, 2022 at 7:55 PM James Turton
<[email protected] <mailto:[email protected]>
> <mailto:[email protected] <mailto:[email protected]>>> wrote:
>
> Hi Jagadeesh
>
> "time" is a keyword in Drill SQL. I'm not sure that
this is
> connected to
> the problem you're hitting but please try your query with
> `time` (and
> any other names that coincide with keywords) enclosed in
> backticks.
>
> Regards
> James
>
> On 2022/10/05 15:01, jagadeesh maddi wrote:
> > Hi Team,
> >
> > we are using Apache Drill to connect to Druid and pull
> the data
> > we are facing a issue when we did "order by"
> >
> > Query: select time,XXX,YYY from XXXXX order by
time desc
> >
> > Exception:
> > 2022-10-05 13:46:44,594
> [1cc2834a-c555-f719-ae42-4a6e85b69d80:frag:3:0]
> > INFO o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:3:0: State change
> requested
> > AWAITING_ALLOCATION --> FAILED
> > 2022-10-05 13:46:44,594
> [1cc2834a-c555-f719-ae42-4a6e85b69d80:frag:3:0]
> > INFO o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:3:0: State change
> requested FAILED
> > --> FINISHED
> > 2022-10-05 13:46:44,594
> [1cc2834a-c555-f719-ae42-4a6e85b69d80:frag:3:0]
> > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM
ERROR:
> > NullPointerException
> >
> > Fragment: 3:0
> >
> > Please, refer to logs for more information.
> >
> > [Error Id: 9a7171d4-8789-412d-84c4-87b46040fe1b on
> xxxxxxxxxx:31010]
> > org.apache.drill.common.exceptions.UserException:
SYSTEM
> ERROR:
> > NullPointerException
> >
> > Fragment: 3:0
> >
> > Please, refer to logs for more information.
> >
> > [Error Id: 9a7171d4-8789-412d-84c4-87b46040fe1b on
> xxxxxxxxxx:31010]
> > at
> >
>
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:657)
> > at
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:392)
> > at
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:244)
> > at
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentExecutor.run(FragmentExecutor.java:359)
> > at
> >
>
org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
> > at
> >
>
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> > at
> >
>
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> > at java.lang.Thread.run(Thread.java:748)
> > Caused by:
> >
>
com.fasterxml.jackson.databind.exc.ValueInstantiationException: Cannot
> > construct instance of
> `org.apache.drill.exec.store.druid.DruidSubScan`,
> > problem: `java.lang.NullPointerException`
> > at [Source: (String)"{
> > "pop" : "hash-partition-sender",
> > "@id" : 0,
> > "receiver-major-fragment" : 2,
> > "child" : {
> > "pop" : "druid-datasource-scan",
> > "@id" : 1,
> > "columns" : [ "`__time`", "`xxx_ID`",
"`xxx_C_1`",
> "`xxx_C_10`",
> > "`xxx_C_11`", "`xxx_C_12`", "`xxx_C_13`",
"`xxx_C_14`",
> "`xxx_C_15`",
> > "`xxx_C_16`", "`xxx_C_17`", "`xxx_C_18`",
"`xxx_C_19`",
> "`xxx_C_2`",
> > "`xxx_C_20`", "`xxx_C_21`", "`xxx_C_22`",
"`xxx_C_23`",
> "`xxx_C_24`",
> > "`xxx_C_25`", "`xxx_C_26`", "`xxx_C_27`",
"`xxx_C_28`",
> > "`xxx_C"[truncated 3449 chars]; line: 16, column: 3]
> (through reference
> > chain:
>
org.apache.drill.exec.physical.config.HashPartitionSender["child"])
> > at
> >
>
com.fasterxml.jackson.databind.exc.ValueInstantiationException.from(ValueInstantiationException.java:47)
> > at
> >
>
com.fasterxml.jackson.databind.DeserializationContext.instantiationException(DeserializationContext.java:2047)
> > at
> >
>
com.fasterxml.jackson.databind.deser.std.StdValueInstantiator.wrapAsJsonMappingException(StdValueInstantiator.java:587)
> > at
> >
>
com.fasterxml.jackson.databind.deser.std.StdValueInstantiator.rewrapCtorProblem(StdValueInstantiator.java:610)
> > at
> >
>
com.fasterxml.jackson.databind.deser.std.StdValueInstantiator.createFromObjectWith(StdValueInstantiator.java:293)
> > at
> >
>
com.fasterxml.jackson.databind.deser.ValueInstantiator.createFromObjectWith(ValueInstantiator.java:288)
> > at
> >
>
com.fasterxml.jackson.databind.deser.impl.PropertyBasedCreator.build(PropertyBasedCreator.java:202)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased(BeanDeserializer.java:518)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault(BeanDeserializerBase.java:1405)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject(BeanDeserializer.java:351)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId(BeanDeserializerBase.java:1371)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:217)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:186)
> > at
> >
>
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:144)
> > at
> >
>
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:110)
> > at
> >
>
com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType(AbstractDeserializer.java:263)
> > at
> >
>
com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize(SettableBeanProperty.java:539)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeWithErrorWrapping(BeanDeserializer.java:563)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased(BeanDeserializer.java:438)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault(BeanDeserializerBase.java:1405)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject(BeanDeserializer.java:351)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId(BeanDeserializerBase.java:1371)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:217)
> > at
> >
>
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:186)
> > at
> >
>
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:144)
> > at
> >
>
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:110)
> > at
> >
>
com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType(AbstractDeserializer.java:263)
> > at
> >
>
com.fasterxml.jackson.databind.deser.impl.TypeWrappedDeserializer.deserialize(TypeWrappedDeserializer.java:74)
> > at
> >
>
com.fasterxml.jackson.databind.deser.DefaultDeserializationContext.readRootValue(DefaultDeserializationContext.java:322)
> > at
> >
>
com.fasterxml.jackson.databind.ObjectReader._bindAndClose(ObjectReader.java:2051)
> > at
> >
>
com.fasterxml.jackson.databind.ObjectReader.readValue(ObjectReader.java:1492)
> > at
> >
>
org.apache.drill.exec.planner.PhysicalPlanReader.readFragmentRoot(PhysicalPlanReader.java:103)
> > at
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentExecutor.run(FragmentExecutor.java:288)
> > ... 4 common frames omitted
> > Caused by: java.lang.NullPointerException: null
> > at
> >
>
org.apache.drill.shaded.guava.com.google.common.base.Preconditions.checkNotNull(Preconditions.java:878)
> > at
> >
>
org.apache.drill.shaded.guava.com.google.common.cache.LocalCache.get(LocalCache.java:3950)
> > at
> >
>
org.apache.drill.shaded.guava.com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974)
> > at
> >
>
org.apache.drill.shaded.guava.com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4958)
> > at
> >
>
org.apache.drill.exec.store.StoragePluginRegistryImpl.getPluginByConfig(StoragePluginRegistryImpl.java:670)
> > at
> >
>
org.apache.drill.exec.store.StoragePluginRegistryImpl.resolve(StoragePluginRegistryImpl.java:918)
> > at
> >
>
org.apache.drill.exec.store.druid.DruidSubScan.<init>(DruidSubScan.java:64)
> > at
> >
>
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> > at
> >
>
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> > at
> >
>
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> > at
>
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> > at
> >
>
com.fasterxml.jackson.databind.introspect.AnnotatedConstructor.call(AnnotatedConstructor.java:128)
> > at
> >
>
com.fasterxml.jackson.databind.deser.std.StdValueInstantiator.createFromObjectWith(StdValueInstantiator.java:291)
> > ... 32 common frames omitted
> > 2022-10-05 13:46:44,595
> [1cc2834a-c555-f719-ae42-4a6e85b69d80:frag:3:0]
> > DEBUG o.a.d.e.w.f.FragmentStatusReporter - Closing
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentStatusReporter@55a64148
> > 2022-10-05 13:46:44,601 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:1:0: State change
> requested
> > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,601 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:1:0: State to
report:
> > CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,601 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:1:0: State change
> requested
> > CANCELLATION_REQUESTED --> FINISHED
> > 2022-10-05 13:46:44,601 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:1:0: State to
> report: CANCELLED
> > 2022-10-05 13:46:44,601 [BitServer-9] DEBUG
> > o.a.d.e.w.f.FragmentStatusReporter - Closing
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentStatusReporter@58bc8bec
> > 2022-10-05 13:46:44,601 [BitServer-9] DEBUG
> > o.a.d.exec.rpc.control.WorkEventBus - Cancel and
removed
> fragment
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:1:0 manager
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.NonRootFragmentManager@71ce5324
from
> > the work bus.
> > 2022-10-05 13:46:44,601 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:0: State change
> requested
> > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,601 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:0: State to
report:
> > CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,601 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:0: State change
> requested
> > CANCELLATION_REQUESTED --> FINISHED
> > 2022-10-05 13:46:44,602 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:0: State to
> report: CANCELLED
> > 2022-10-05 13:46:44,602 [BitServer-9] DEBUG
> > o.a.d.e.w.f.FragmentStatusReporter - Closing
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentStatusReporter@57871915
> > 2022-10-05 13:46:44,602 [BitServer-9] DEBUG
> > o.a.d.exec.rpc.control.WorkEventBus - Cancel and
removed
> fragment
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:0 manager
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.NonRootFragmentManager@33815de1
from
> > the work bus.
> > 2022-10-05 13:46:44,602 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:1: State change
> requested
> > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,602 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:1: State to
report:
> > CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,602 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:1: State change
> requested
> > CANCELLATION_REQUESTED --> FINISHED
> > 2022-10-05 13:46:44,602 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:1: State to
> report: CANCELLED
> > 2022-10-05 13:46:44,602 [BitServer-9] DEBUG
> > o.a.d.e.w.f.FragmentStatusReporter - Closing
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentStatusReporter@274e160d
> > 2022-10-05 13:46:44,602 [BitServer-9] DEBUG
> > o.a.d.exec.rpc.control.WorkEventBus - Cancel and
removed
> fragment
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:1 manager
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.NonRootFragmentManager@53aea3f7
from
> > the work bus.
> > 2022-10-05 13:46:44,602 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:2: State change
> requested
> > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,602 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:2: State to
report:
> > CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,602 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:2: State change
> requested
> > CANCELLATION_REQUESTED --> FINISHED
> > 2022-10-05 13:46:44,602 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:2: State to
> report: CANCELLED
> > 2022-10-05 13:46:44,603 [BitServer-9] DEBUG
> > o.a.d.e.w.f.FragmentStatusReporter - Closing
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentStatusReporter@494bd466
> > 2022-10-05 13:46:44,603 [BitServer-9] DEBUG
> > o.a.d.exec.rpc.control.WorkEventBus - Cancel and
removed
> fragment
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:2 manager
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.NonRootFragmentManager@67728ff4
from
> > the work bus.
> > 2022-10-05 13:46:44,603 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:3: State change
> requested
> > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,603 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:3: State to
report:
> > CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,603 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:3: State change
> requested
> > CANCELLATION_REQUESTED --> FINISHED
> > 2022-10-05 13:46:44,603 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:3: State to
> report: CANCELLED
> > 2022-10-05 13:46:44,603 [BitServer-9] DEBUG
> > o.a.d.e.w.f.FragmentStatusReporter - Closing
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentStatusReporter@7514c548
> > 2022-10-05 13:46:44,603 [BitServer-9] DEBUG
> > o.a.d.exec.rpc.control.WorkEventBus - Cancel and
removed
> fragment
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:3 manager
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.NonRootFragmentManager@45f6d750
from
> > the work bus.
> > 2022-10-05 13:46:44,603 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:4: State change
> requested
> > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,604 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:4: State to
report:
> > CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,604 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:4: State change
> requested
> > CANCELLATION_REQUESTED --> FINISHED
> > 2022-10-05 13:46:44,604 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:4: State to
> report: CANCELLED
> > 2022-10-05 13:46:44,604 [BitServer-9] DEBUG
> > o.a.d.e.w.f.FragmentStatusReporter - Closing
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentStatusReporter@1ab4354e
> > 2022-10-05 13:46:44,604 [BitServer-9] DEBUG
> > o.a.d.exec.rpc.control.WorkEventBus - Cancel and
removed
> fragment
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:4 manager
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.NonRootFragmentManager@45223df5
from
> > the work bus.
> > 2022-10-05 13:46:44,604 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:5: State change
> requested
> > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,604 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:5: State to
report:
> > CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,604 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:5: State change
> requested
> > CANCELLATION_REQUESTED --> FINISHED
> > 2022-10-05 13:46:44,604 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:5: State to
> report: CANCELLED
> > 2022-10-05 13:46:44,604 [BitServer-9] DEBUG
> > o.a.d.e.w.f.FragmentStatusReporter - Closing
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentStatusReporter@4d1da66b
> > 2022-10-05 13:46:44,604 [BitServer-9] DEBUG
> > o.a.d.exec.rpc.control.WorkEventBus - Cancel and
removed
> fragment
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:5 manager
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.NonRootFragmentManager@5e1a35c3
from
> > the work bus.
> > 2022-10-05 13:46:44,604 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:6: State change
> requested
> > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,604 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:6: State to
report:
> > CANCELLATION_REQUESTED
> > 2022-10-05 13:46:44,604 [BitServer-9] INFO
> > o.a.d.e.w.fragment.FragmentExecutor -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:6: State change
> requested
> > CANCELLATION_REQUESTED --> FINISHED
> > 2022-10-05 13:46:44,604 [BitServer-9] INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:6: State to
> report: CANCELLED
> > 2022-10-05 13:46:44,605 [BitServer-9] DEBUG
> > o.a.d.e.w.f.FragmentStatusReporter - Closing
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.FragmentStatusReporter@5a62b34a
> > 2022-10-05 13:46:44,605 [BitServer-9] DEBUG
> > o.a.d.exec.rpc.control.WorkEventBus - Cancel and
removed
> fragment
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:6 manager
> > org.apache.drill.exec.work
<http://org.apache.drill.exec.work>
> <http://org.apache.drill.exec.work
<http://org.apache.drill.exec.work>>.fragment.NonRootFragmentManager@5c4655af
from
> > the work bus.
> > 2022-10-05 13:46:44,605 [BitServer-9] WARN
> > o.a.d.exec.rpc.control.WorkEventBus - Fragment
> > 1cc2834a-c555-f719-ae42-4a6e85b69d80:3:0 manager
is not
> found in the
> > work bus.
> > 2022-10-05 13:46:44,605 [BitServer-9] WARN
> > o.a.d.e.w.b.ControlMessageHandler - Dropping
request to
> cancel
> > fragment. 1cc2834a-c555-f719-ae42-4a6e85b69d80:3:0
does
> not exist.
> >
> > i request to please help me with the issue
> >
> > Thanks and regards
> > Jagadeesh Maddi
>
