Query timeout not working

TROUBLESHOOTING ANALYTICS
#1

Hi,

Not able to aggregate 1 day data in Druid. Able to fetch all data without aggregate function , but if i use aggregate function getting Request failed with status code 504 . Tried increasing timeout in query context but no use.

image
image1503×772 49.5 KB

Same query if i use groupBy getting timeout

image
image1203×474 27.2 KB

timeout query context parameter also not working

image
image991×797 27.5 KB

all queries got terminated after 30seconds

someone help how to set query timeout value

#2

The property that comes to mind is druid.server.http.defaultQueryTimeout. Have you checked the Broker logs for any errors?

#3

no logs in broker. also we set druid.server.http.defaultQueryTimeout druid_server_http_defaultQueryTimeout: 1500000

#4

Hi,

please note that:

  • if it is only the groupBy queries that are timing out, you may need to investigate merge buffers and make sure that you are following the tuning recommendations noted here: Basic cluster tuning · Apache Druid

  • timeouts are set at both the historicals as well as the broker. Please check both: Configuration reference · Apache Druid

  • You may also have to look at broker backpressure as well as spill-to-disk settings

One of these should solve your issue. Please reach out if you need further help.