Found duplicate series for match group

  • What Grafana version and what operating system are you using?
  • What are you trying to achieve?
    Join query on windows metrics to view processes by the service display_name
  • How are you trying to achieve it?
    using a join query
  • What happened?
    Found duplicate series for match group
  • What did you expect to happen?
    unique - only one pid can exist on instance
  • Can you copy/paste the configuration(s) that you are having problems with?

sum((rate(windows_process_cpu_time_total{mode!=“idle”}[$__rate_interval])) * on(instance, process_id) group_left(display_name) windows_service_info{display_name=~“$process”}) without (mode,process_id)

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

“found duplicate series for the match group {instance="host1", process_id="0"} on the right hand-side of the operation: [{name="windows_service_info", display_name="", env="prod", host="host1", instance="host1", job="", name="", process_id="0"}, {name="windows_service_info", display_name="process1", env="prod", host="host1", instance="host1", job="job1", name="ame_46", process_id="0", region="us"}];many-to-many matching not allowed: matching labels must be unique on one side”

  • Did you follow any online instructions? If so, what is the URL?