[kube-prometheus-stack] failed to delete orphaned service accounts: Error 1064 MariaDB

[noe-max]

Describe the bug a clear and concise description of what the bug is.

This bug is related to following issue. grafana/grafana#95904
It seem to be fixed in grafana but the fix didn't made it kube-prom-stack yet.
Any ETA ?

What's your helm version?

v3.12.3

What's your kubectl version?

v1.30.1

Which chart?

kube-prom-stack

What's the chart version?

65.8.1

What happened?

Grafana DB migration failed:
id="delete orphaned service account permissions" │
│ logger=migrator t=2024-11-20T10:13:17.934155634Z level=error msg="Executing migration failed" id="delete orphaned service account permissions" error="failed to delete orphaned service accounts: Error 1064 (42000): You have an error in │
│ logger=migrator t=2024-11-20T10:13:17.934184985Z level=error msg="Exec failed" error="failed to delete orphaned service accounts: Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your Maria │
│ logger=migrator t=2024-11-20T10:13:17.935264019Z level=info msg="Unlocking database" │
│ Error: ✗ migration failed (id = delete orphaned service account permissions): failed to delete orphaned service accounts: Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB serve │

What you expected to happen?

Should run through even with MariaDB 10.x (default on most debian based systems)

How to reproduce it?

No response

Enter the changed values of values.yaml?

No response

Enter the command that you execute and failing/misfunctioning.

helm upgrade kube-prom-stack prometheus-community/kube-prometheus-stack --version -namespace monitoring
-f "prom-stack-values-v${HELM_CHART_VERSION}.yaml"

Anything else we need to know?

Not sure if this is the right approach to address this, as somewhat it's an upstream issue. let me know. Thanks