In Grafana i create query A and Query B and then an Expression C with
"Math" and then I can compare Like $A > 0 && B > 0.
Maybe there is "Transform Data" and then a calcukation Option.
Puneet Singh schrieb am Donnerstag, 22. Februar 2024 um 21:58:08 UTC+1:
> okay, So I think should this be the correct way to perform the and
> operation ? -
> (sum without (USER, HOSTNAME ,instance ) (
> *go_service_status{HOSTNAME="server1",SERVER_CATEGORY="db1",SERVICETYPE="grade1"}*)
>
> < 1) and (sum without ( USER, HOSTNAME ,instance ) (
> *go_service_status{HOSTNAME="server2",SERVER_CATEGORY="db1",SERVICETYPE="grade1"}*)
>
> < 1)
>
> Regards
> P
>
>
> On Friday 23 February 2024 at 00:58:52 UTC+5:30 Puneet Singh wrote:
>
>> Hi All,
>> I have a metric called go_service_status where i use the "sum without"
>> operator to determine whether a service is up or down on a server. Now
>> there can be a situation where service can be down simultaneously on 2
>> master servers and I am unable to figure out a PromQL query to detect that
>> situation. Example -
>>
>>
>> *go_service_status{SERVICETYPE="grade1",SERVER_CATEGORY="db1",instance=~"server1:7878"}*
>> and it can have 2 possible series -
>> go_service_status{HOSTNAME="server1", SERVER_CATEGORY="db1",
>> SERVICETYPE="grade1", USER="admin", instance="server1:7878",
>> job="customprocessexporter01"} 0
>> go_service_status{HOSTNAME="server1", SERVER_CATEGORY="db1",
>> SERVICETYPE="grade1", USER="root", instance="server1:7878",
>> job="customprocessexporter01"} 1
>>
>> and in the same way
>>
>> *go_service_status{SERVICETYPE="grade1",SERVER_CATEGORY="db1",instance=~"server2:7878"}*
>> and it can have 2 possible series -
>> go_service_status{HOSTNAME="server2", SERVER_CATEGORY="db1",
>> SERVICETYPE="grade1", USER="admin", instance="server2:7878",
>> job="customprocessexporter01"} 0
>> go_service_status{HOSTNAME="server2", SERVER_CATEGORY="db1",
>> SERVICETYPE="grade1", USER="root", instance="server2:7878",
>> job="customprocessexporter01"} 0
>>
>>
>> Here;s the query using which i figure out status of the service on
>> server1. Example -
>>
>> (sum without (USER) (
>> *go_service_status{HOSTNAME="server1",SERVER_CATEGORY="db1",SERVICETYPE="grade1"}*)
>>
>> < 1)[image: Untitled.png]
>>
>> so the server1's service is momentarily 0
>>
>>
>> and server2's service is always down , example -
>> (sum without (USER) (
>> *go_lsf_service_status{HOSTNAME="server2",SERVER_CATEGORY="db1",SERVICETYPE="grade1"}*)
>>
>> < 1)[image: Untitled.png]
>>
>>
>> Now i tried to find the time duration where both these service were
>> simultaneously down / 0 on both server1 and server2 :
>> (sum without (USER) (
>> *go_service_status{HOSTNAME="server1",SERVER_CATEGORY="db1",SERVICETYPE="grade1"}*)
>>
>> < 1) and (sum without (USER) (
>> *go_service_status{HOSTNAME="server2",SERVER_CATEGORY="db1",SERVICETYPE="grade1"}*)
>>
>> < 1)
>>
>>
>> I was expecting a graph similar to the once for server2 , but i got :
>> [image: Untitled.png]
>>
>> I think i need to ignore the HOSTNAME label , but unable to figure out
>> the way to ignore the HOSTNAME label in combination with sum without
>> clause.
>>
>> Any help/hint to improve this query will be very useful for me to
>> understand the and condition in context of sum without clause.
>>
>> Thanks,
>> Puneet
>
>
--
You received this message because you are subscribed to the Google Groups
"Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/prometheus-users/91684962-e2f3-4ba2-ae74-9fd9bebce60en%40googlegroups.com.
