Don't have ksql Queries status show in ksql-cluster dashboard about jmx-monitoring-stacks HOT 11 CLOSED

Hi there! Will need a bit more info. Are you using this JMX exporter config for ksql?

from jmx-monitoring-stacks.

Thank jeqo its solve by i remove confluent.ksql.yml ksql_metrics .* .+ to accepted blank ksql.cluster.id

from jmx-monitoring-stacks.

cannot make it work, can you give some more details @thititongumpun on what you did to make it work ?

from jmx-monitoring-stacks.

seems like it is not working when following the installation instructions in readme

from jmx-monitoring-stacks.

@mariusstaicu sure, If your connect-cluster have no cluster name like connect-cluster by default just do replace in confluent.ksql.yml for prometheus config in ksql_metrics .* to ksql_metrics .+

from jmx-monitoring-stacks.

@thititongumpun i am having this issue today. I try to read your answer many time, but i don't get it.
Can you share a bit of config so we can see how it looks like.

Otherwise @jeqo i am having the same issue. I am using the latest jmx config for ksql db. everything works expect for that queries status panel. Can you confirm that the current ksql jmx config in the repo actually work ?

from jmx-monitoring-stacks.

when i list my bean using jolokia is shows as such

status=_confluent-ksql-query_CST_ELSEVIER_CBE_RESNET_ORGANISM_93,type=ksql-queries

from jmx-monitoring-stacks.

so it is the reverse of the current pattern. I try to change it to

        - labels:
            $3: $4
            ksql_query: $1
          name: ksql_ksql_metrics_$2_$3
          pattern: 'io.confluent.ksql.metrics<status=_confluent-ksql-query_(.+), type=(.+)><>(.+): (.+)'
          value: "1"
          valueFactor: 1

but no sucsess

from jmx-monitoring-stacks.

Tried all the possible combinations, I cannot get ksql-queries from jmx to show up in the exporter.

The bean name is

io.confluent.ksql.metrics:type=ksql-queries,ksql_service_id=default_,status=_confluent-ksql-query_INSERTQUERY_285

from jmx-monitoring-stacks.

Hello can u try to remove ksql dashboard. Edit in json setting grafana remove the ksq_cluster_id in Queries Staus

from jmx-monitoring-stacks.

the problem is not in grafana. The jmx exporter does not have the query status metric at all.

from jmx-monitoring-stacks.