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?

Hi @nicholastripp

I believe that you are using the Transformations “Join” in your case.

Here is the link to the documentation that explains how join works

Please check it as will be helpful to understand