Permanently periodically unable to update "projections.notifications" state error in zitadel logs

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.notifications