https://linen.dev logo
Join Slack
Powered by
This message was deleted.
# troubleshooting
s
This message was deleted.
p
what is the druid version that you are using?
s
0.19.0
@Pranav
p
It should be enabled by default on router console on 0.19.0
s
How do I access router console? I tried with router-ip:8888, it didn't work
Or how do I enable router console?
p
s
p
are you visiting console from coordinator host?
s
yes
j
you can find "clear forced mode" button from option wheel.
s
Seems like I do not have that option
@Sergio Ferragut do you have more ideas?
s
Let me try to replicate... you are running 0.19 locally or clustered (probably doesn't matter)?
s
on AWS opsworks. Its clustered.
s
I tried the default local nano quickstart and it comes up with the Query tab:
I'm not very familiar with 0.19... but let's dig through the 0.19 docs a bit...
Are you sure you are pointing to the router ip / port? If I use the coordinator process instead, I see something similar to you:
s
the above console is from master ip and port. When I run with router ip and port, it doesn't bring up router console.
s
Are the router and coordinator running on the same node? same ip? Can you check the router / coordinator runtime properties to see if they are colliding on port ? The router would fail to bind to the port if that is the case. Check the router log to verify this theory.
s
They are on different nodes and have different ports.
s
Can you share the router log?
s
maybe that's the issue
s
you are deploying docker containers? how did you start it?
s
This message contains interactive elements.
and the last logs were from 2021
cluster is on AWS opsworks, not sure how it was deployed đŸ˜„
s
hmmm.. does that router.log file have anything?
what do you see in the services tab in the druid console? is the router listed there?
s
since I can access only coordinator console, above is the screenshot of services.
s
I'm not sure if router would normally appear there. I'm not used to the coordinator console. Is that the full list?
s
yes thats the complete list
s
regarding the log rollover error, I wonder if the problem is the pattern config 
${sys:service}-service-2021-10-22.(\d+).log
it is weird that, that is not getting translated into the actual service name and also it should not have a static date.
can you log on to the node where the router is supposed to be running...either master or query node, typically and run a 
ps -ef | grep router
s
This message contains interactive elements.
is it safe to start router sevice and try it?
s
It is safe, yes.
The router does not affect the rest of the cluster, it provides the console and an entry point for REST API calls into the cluster.
s
oh i see
do you have the command handy?
s
Typically queries are executed through the router which routes queries among the brokers. But other load balancers can be placed in front of the brokers to provide this function. Not sure how yours is meant to be configured.
s
ok
off to a meeting for next 30 mins, will try restarting after that
c
Also make sure in router's runtime properties this is set:
Copy code
druid.router.managementProxy.enabled=true
s
This message contains interactive elements.
I got in touch with engineer who wants to use this feature. He is trying to query druid, currently from Looker. His query contains 
THETA_SKETCH_ESTIMATE
function which is failing. That's the reason he want to try from Druid Query option to validate. Is ``THETA_SKETCH_ESTIMATE` compatible with 0.18 and 0.19 version? Also what do I check if it is enabled? I checked the extension 
druid-datasketches
, it is there.
This is the error he is seeing
Copy code
Remote driver error: RuntimeException: java.util.concurrent.ExecutionException: <http://org.apache.druid.java.util.common.RE|org.apache.druid.java.util.common.RE>: function 'THETA_SKETCH_ESTIMATE' is not defined. -> ExecutionException: <http://org.apache.druid.java.util.common.RE|org.apache.druid.java.util.common.RE>: function 'THETA_SKETCH_ESTIMATE' is not defined. -> RE: function 'THETA_SKETCH_ESTIMATE' is not defined.
s
Can you share the SQL? Normally that function is used on a sketch column (ingested as a sketch or built at ingestion time) or it is used at query time wrapping a DS_THETA( column) aggregation as in ‘THETA_SKETCH_ESTIMATE( DS_THETA ( column ) )’
s
this is the query:
Copy code
with trait1 AS
( select cost as basis, membership_sketch, __time  from tableA
),
trait2 AS
( select cost as basis, membership_sketch ,  __time from tableB
)
select c.__time as control_time,
(sum(c.basis)/THETA_SKETCH_ESTIMATE(DS_THETA(c.membership_sketch))) as trait1_measure ,
(sum(e.basis)/THETA_SKETCH_ESTIMATE(DS_THETA(e.membership_sketch))) as trait2_measure
from trait1 c, trait2 e where c.__time=e.__time group by 1
s
Seems like it is being used correctly. Do you see an error in the broker log? Is the extension loaded on the brokers?
s
This message contains interactive elements.
broker-service.log:
s
At the time of the query?
s
no sorry
s
That might shed some light. Run the query and capture the output of that log.
Open in Slack
PreviousNext
Powered by