Bug: Deleted Helm Charts are marked as active in database and also some charts were throwing ERROR:22001while charts were synced

[SATYAsasini]

📜 Description

The deleted charts were marked as active : true resulting failing in chart sync Also some of the charts were throwing an ERROR :22001 which is Postgress native error for long values for a particular column resulting in blocking of chart sync for further charts in a particular repo

Affected areas

Other CRITICAL functionality

Additional affected areas

None

Prod/Non-prod environments?

Prod

Is User unblocked?

No

How was the user un-blocked?

None

Impact on Enterprise

1. app-sync-cron and mannual-sync-cron were failing sometimes
2. all the charts of specific repo were not able to sync after anyone gets an error during sync

👟 Steps to replicate the Issue

1. Add any chart and then delete it, this should replicate the first issue

👍 Expected behavior

The sync should only take place if the chart is not deleted and is marked as active : true

👎 Actual Behavior

Keeps on trying to sync the chart resulting in failing after timed out is reached

☸ Kubernetes version

NA

Cloud provider

NA

🌍 Browser

Chrome

✅ Proposed Solution

No response

👀 Have you spent some time to check if this issue has been raised before?

• [X] I checked and didn't find any similar issue

🏢 Have you read the Code of Conduct?

• [X] I have read the Code of Conduct