list all active namespaces

[msvinaykumar]

Describe the bug

sum by (namespace) ( avg_over_time(kube_namespace_status_phase{namespace!="" }[15d]

autotune/src/main/java/com/autotune/common/data/dataSourceQueries/DataSourceQueries.java

Line 10 in 268063a

NAMESPACE_QUERY("sum by (namespace) ( avg_over_time(kube_namespace_status_phase{namespace!=\"\" ADDITIONAL_LABEL}[15d]))"),

We are not generating recommendations using the above query; instead, we are requesting a list of all active namespaces. And 15d should not be considered

we gather container details based on the namespaces retrieved from the query. However, for a scenario where a user generates recommendations for a 15-day-old job via the UI, it makes sense to account for namespaces that might no longer be active.
In such cases, the query should ensure it fetches data from historical metrics as well, so that namespaces tied to past jobs are considered, even if they aren't currently active.
but as of bulk considers only active containers and namespaces recommendations only .

How to reproduce it
Create a namespace older than 15 days and call /bulk api and it fails

Expected behavior
Create a namespace older than 15 days and call /bulk api and it should gerneates recommendations

Relevant logs

kubectl exec -it po/kruize-58447bddff-58dbn -n openshift-tuning -- curl "http://thanos-query-frontend.thanos-bench.svc.cluster.local:9090/api/v1/query?query=sum+by+%28namespace%29+%28+avg_over_time%28kube_namespace_status_phase%7Bnamespace%21%3D%22%22+%7D%5B15d%5D%29%29"
Defaulted container "kruize" out of: kruize, wait-for-kruize-db (init)
{"status":"success","data":{"resultType":"vector","result":[]}}

[vinakuma@vinakuma-thinkpadp1gen3 kruize-demos]$ kubectl exec -it po/kruize-58447bddff-58dbn -n openshift-tuning -- curl "http://thanos-query-frontend.thanos-bench.svc.cluster.local:9090/api/v1/query?query=sum+by+%28namespace%29+%28+avg_over_time%28kube_namespace_status_phase%7Bnamespace%21%3D%22%22+%7D%5B25d%5D%29%29"
Defaulted container "kruize" out of: kruize, wait-for-kruize-db (init)
{"status":"success","data":{"resultType":"vector","result":[{"metric":{"namespace":"msc-0"},"value":[1732703222.824,"7"]}]}}E1127 15:57:02.978593 2243313 v3.go:79] EOF
[vinakuma@vinakuma-thinkpadp1gen3 kruize-demos]$ 

Environment:

• Kubernetes Cluster [, openshift] http://kruize-openshift-tuning.apps.kruize-scalelab.h0b5.p1.openshiftapps.com
• Version
• OS

Additional context
slack conversation log