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]>
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]> 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
>> .fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:392)
>> > at
>> > org.apache.drill.exec.work
>> .fragment.FragmentExecutor.cleanup(FragmentExecutor.java:244)
>> > at
>> > 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
>> .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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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
>>
>
