search

kubecost / features-bugs

A public repository for filing of Kubecost feature requests and bugs. Please read the issue guidelines before filing an issue here.
0 stars 0 forks source link

[Bug] Agrregation by labels (team, department) error in v2.2.2 https://demo.kubecost.xyz/allocations?agg=team #66

Open katerynabay opened 5 months ago

katerynabay commented 5 months ago

Kubecost Helm Chart Version

2.2.2

Kubernetes Version

1.26

Kubernetes Platform

EKS

Description

Arggregation by any label failing with 500. image

URL: https://demo.kubecost.xyz/allocations?agg=team

{ "code": 500, "data": null, "message": "error querying DB: error querying via querysvc query Failure: Parser Error: syntax error at or near \"(\"\nLINE 1: ...T 25) UNION ALL (SELECT 'idle' AS (CASE \tWHEN \"container_1d_idleweighted...\n ^" }

Issue also exist in 2.2.1 Version 2.1.1 works as expected

Steps to reproduce

  1. Monitor -> allocations -> single aggregation (select team)

Expected behavior

Returned aggregation data

Impact

No response

Screenshots

No response

Logs

No response

Slack discussion

No response

Troubleshooting

teevans commented 5 months ago

@cliffcolvin can you triage? cc @AjayTripathy since you're on support as well

chipzoller commented 5 months ago

Not a Helm chart issue. Transferred to features-bugs.

cliffcolvin commented 5 months ago

@katerynabay the resolution for this should be in 2.2.3 coming early this week.

jiananyim commented 5 months ago

Hello, we are using kubecost 2.2.3 will our mirror images which still have this issue. Could you let us know which image the fix is in?

my mirror image based versions - kubecostFrontend: frontend:prod-2.2.3 kubecostAggregator: cost-model:prod-2.2.3 kubecostModel: cost-model:prod-2.2.3 forecasting: kubecost-modeling:prod-v0.1.3 prometheus prod-v0.71.2

@cliffcolvin

cliffcolvin commented 4 months ago

@jiananyim cost-model should have the fix. Are you saying you are still getting the error? If so can you give me the url to the api that you're using that gets the error so I can look at the label?

jiananyim commented 4 months ago

I am calling - http://my_elb_endpoint:9090/model/allocation?window=2024-05-10T00:00:00Z,2024-05-20T00:00:00Z&aggregate=service&shareIdle=false&shareNamespaces=kube-system&sharedSplit=weighted&etl=true

jiananyim commented 4 months ago

I fixed the issue by upgrading to cost-model:prod-2.2.5. prod-2.2.3 doesn't work for me (platform linux/amd64)