You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@druid.apache.org by Phalguni Mukherjee <ph...@gmail.com> on 2020/01/06 06:13:55 UTC
Druid query getting timeout at historical node
Hi Team,
Getting timeout after enabling cache in druid.
"*io.druid.query.QueryInterruptedException: Timeout waiting for task.*
* at
io.druid.query.groupby.epinephelinae.GroupByMergingQueryRunnerV2.waitForFutureCompletion(GroupByMergingQueryRunnerV2.java:372)
~[druid-processing-0.12.0.jar:0.12.0]*
* at
io.druid.query.groupby.epinephelinae.GroupByMergingQueryRunnerV2.access$900(GroupByMergingQueryRunnerV2.java:76)
~[druid-processing-0.12.0.jar:0.12.0]*
* at
io.druid.query.groupby.epinephelinae.GroupByMergingQueryRunnerV2$2.make(GroupByMergingQueryRunnerV2.java:300)
~[druid-processing-0.12.0.jar:0.12.0]*"
We have enabled cache in both historical and broker node.My configuration
is as follows:
*Broker configuration:*
druid.broker.cache.useCache=true
druid.broker.cache.populateCache=true
druid.broker.cache.unCacheable=["select"]
druid.cache.type=local
druid.cache.sizeInBytes=5000000000
druid.cache.initialSize=100000000
*Historical Configuration:*
druid.historical.cache.useCache=true
druid.historical.cache.populateCache=true
druid.historical.cache.unCacheable=["select"]
druid.cache.type=local
druid.cache.sizeInBytes=2000000000
--
*Thanks & Regards*
*Phalguni Mukherjee*
Re: Druid query getting timeout at historical node
Posted by Gaurav Bhatnagar <ga...@gmail.com>.
query can timeout for various reasons. Have you tried useCache = false in
the context and tested if query works?
On Mon, Jan 6, 2020 at 12:40 AM Phalguni Mukherjee <
phalgunimukherjee1007@gmail.com> wrote:
> Hi Team,
>
>
> Getting timeout after enabling cache in druid.
>
>
> "*io.druid.query.QueryInterruptedException: Timeout waiting for task.*
>
> * at
>
> io.druid.query.groupby.epinephelinae.GroupByMergingQueryRunnerV2.waitForFutureCompletion(GroupByMergingQueryRunnerV2.java:372)
> ~[druid-processing-0.12.0.jar:0.12.0]*
>
> * at
>
> io.druid.query.groupby.epinephelinae.GroupByMergingQueryRunnerV2.access$900(GroupByMergingQueryRunnerV2.java:76)
> ~[druid-processing-0.12.0.jar:0.12.0]*
>
> * at
>
> io.druid.query.groupby.epinephelinae.GroupByMergingQueryRunnerV2$2.make(GroupByMergingQueryRunnerV2.java:300)
> ~[druid-processing-0.12.0.jar:0.12.0]*"
>
>
> We have enabled cache in both historical and broker node.My configuration
> is as follows:
>
>
> *Broker configuration:*
>
>
> druid.broker.cache.useCache=true
>
> druid.broker.cache.populateCache=true
>
> druid.broker.cache.unCacheable=["select"]
>
> druid.cache.type=local
>
> druid.cache.sizeInBytes=5000000000
>
> druid.cache.initialSize=100000000
>
>
> *Historical Configuration:*
>
>
> druid.historical.cache.useCache=true
>
> druid.historical.cache.populateCache=true
>
> druid.historical.cache.unCacheable=["select"]
>
> druid.cache.type=local
>
> druid.cache.sizeInBytes=2000000000
>
>
>
>
> --
> *Thanks & Regards*
> *Phalguni Mukherjee*
>