Permanently periodically unable to update "projections.notifications" state error in zitadel logs
Zitadel Helm chart: 8.11.2
Zitadel app version: v2.67.2
Self hosted Kubernetes with Postgresql 15.
We are getting permanent periodic errors on the notifications projections:
time="2025-06-18T11:05:32Z" level=info msg="process events failed" caller="/home/runner/work/zitadel/zitadel/internal/eventstore/handler/v2/handler.go:410" error="ID=V2-WF23g2 Message=unable to update state Parent=(sql: transaction has already been committed or rolled back)" projection=projections.notifications time="2025-06-18T11:05:38Z" level=warning msg="unable to update state" caller="/home/runner/work/zitadel/zitadel/internal/eventstore/handler/v2/state.go:96" error="sql: transaction has already been committed or rolled back" projection=projections.notificationsWhat could be the reason that causes this? All other projections are ok, the same thing happens on several testing environments.🤔
2 Replies
Bump
@FFO Would it be possible to look into this?
Heja, have not looked at this. Let me get an idea.
Hm this could be a problem we solved when moving to version 3 since we treat background processes different now.
What happens if you upgrade? (Do a backup first please ;-))