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 prometheus-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/prometheus-users/ba97a288-4344-4b4e-b901-807e697440c9n%40googlegroups.com.
