Combine 2 prom queries without Unique value

[Prajakta]

Hello Everyone,

 I am trying to combine 2 queries which do not have unique value among each. Can anybody please help me to find the solution.

Below are the 2 queries.

Query1 : sum by(statefulset)((kube_statefulset_replicas) == (kube_statefulset_status_replicas_ready))

Query2 : (kube_pod_status_phase{phase!="Succeeded"})  ==1)

I have combined 2 queries in past but those were having unique value like below.

sum by(namespace, pod, container) ((avg without(instance) (changes(kube_pod_container_status_restarts_total{namespace=~".*-prod"}[15m])))> 0) + on(pod, namespace) group_left(node) (sum by(pod, namespace, node) (kube_pod_info))

Thanks all in advance.

[Brian Candler]

On Wednesday, 14 October 2020 17:58:17 UTC+1, Prajakta wrote:

Below are the 2 queries.

Query1 : sum by(statefulset)((kube_statefulset_replicas) == (kube_statefulset_status_replicas_ready))

Query2 : (kube_pod_status_phase{phase!="Succeeded"})  ==1)

Can you show some examples of the outputs of those two queries separately?  And then how you'd like to combine those answers?

[Prajakta]

Query 1 Result:

I have changed query just to NOT EQUAL instead of EQUAL

Query 2

Here the condition is ,in the stateful set if desired and ready state is not same then only it should notify me that POD is not ready.

If the desired and ready count is same and one of the POD in that getting restarted or not available then I don't want to alert on.

Can you please help :)

Thanks in advance.

[Brian Candler]

You appear to have pasted two empty white boxes :-(

[Prajakta]

Hello ,

Sorry for that :). I have attached with query no. Please see if you can receive now,

And thank you so much for help in advance.

[Prajakta]

Hello All,

can anybody please help here. I am stuck on this issue.