This message was deleted.
# troubleshooting
s
This message was deleted.
a
Hey Thomas - which JDBC driver are you using? What are the versions of the driver, Druid and Tableau?
t
Druid 24.0.01 Tableau 2022.3 JDBC Trino 403
a
I'm not seeing any similar problems. Client / server side errors and logs would be great when you have them.
t
Are you using the same versions as I do ?
I’m working on it, will get back to you asap, I hope with interesting logs
Just caught
Terminating due to java.lang.OutOfMemoryError: Java heap space
on my broker when connecting to a Druid table 😞
Hey Adam, would you mind sharing your Broker specs please ?
I’m wondering which requests requires that much memory ..
a
Hey Thomas. It looks like you need to increase the broker heap – can you tell me a little about your Druid setup? Are you using the quickstart or docker or something else? Does the crash occur when you first connect through to Druid or when you run a specific query?
t
I’m running Druid in production for more than a year now, and my broker are fine. I’ve just found a request that Tableau issue:
Copy code
{"queryType":"groupBy","dataSource":{"type":"table","name":"some-datasource"},"intervals":{"type":"intervals","intervals":["-146136543-09-08T08:23:32.096Z/146140482-04-24T15:36:27.903Z"]},"granularity":{"type":"all"},"dimensions":[{"type":"default","dimension":"source","outputName":"d0","outputType":"STRING"}],"limitSpec":{"type":"NoopLimitSpec"},"context":{"queryId":"2e0c2347-cbb5-4792-a691-f79177a4fd7d","sqlQueryId":"70e15c9f-d776-4481-99c3-eea5a53904ec","sqlStringifyArrays":false}}	{"query/time":351106,"query/bytes":-1,"success":true,"identity":"allowAll"}
I think the intervals are the problems here. + I’m using a Redis to cache query results, and Tableau is trying to get data that don’t exist => redis exception in my broker logs.
a
Glad to hear you got to the bottom of it Thomas. I take it you can run this query directly on Druid without the intervening Tableau / JDBC/ Redis components?
t
Yup, I can run this query directly in Druid