ZITADELZZITADEL
Powered by
WolfbergenW
ZITADEL•9mo ago•
11 replies
Wolfbergen

permission denied for function seq_nextval (SQLSTATE 42501)" projection=projections.notifications

Hi,
My instance can't send notifications on password reset or on email verification. I have this error :
level=error msg="statement execution failed" caller="/home/runner/work/zitadel/zitadel/internal/eventstore/handler/v2/handler.go:673" error="ERROR: permission denied for function seq_nextval (SQLSTATE 42501)" projection=projections.notifications
level=info msg="process events failed" caller="/home/runner/work/zitadel/zitadel/internal/eventstore/handler/v2/handler.go:436" error="statement failed: ERROR: permission denied for function seq_nextval (SQLSTATE 42501)" projection=projections.notifications
level=error msg="statement execution failed" caller="/home/runner/work/zitadel/zitadel/internal/eventstore/handler/v2/handler.go:673" error="ERROR: permission denied for function seq_nextval (SQLSTATE 42501)" projection=projections.notifications
level=info msg="process events failed" caller="/home/runner/work/zitadel/zitadel/internal/eventstore/handler/v2/handler.go:436" error="statement failed: ERROR: permission denied for function seq_nextval (SQLSTATE 42501)" projection=projections.notifications

I have grant all on sequences to my zitadel user (he's also the owner of the sequences).
After some research, I saw an error in postgresql logs before the permission denied :
ERROR: could not obtain lock on row in relation "current_states"
CONTEXT:  unnamed portal with parameters: $1 = '217***', $2 = 'projections.notifications'
ERROR: could not obtain lock on row in relation "current_states"
CONTEXT:  unnamed portal with parameters: $1 = '217***', $2 = 'projections.notifications'

My instance is self-hosted on the latest version 3.2.2.
I'll appreciate if someone have an idea on how to fix this. Thanks !
ZITADEL banner
ZITADELJoin
ZITADEL - Identity infrastructure, simplified for you.
4,374Members
Resources
Recent Announcements

Similar Threads

Was this page helpful?

Similar Threads

Migration failed. Permission denied
R7FXRR7FX / questions-help-bugs
7mo ago
ERROR: relation "projections.instance_domains" does not exist (SQLSTATE 42P01))
EquinoxeEEquinoxe / questions-help-bugs
2y ago
permission error grpc access denied
boblack_zockerBboblack_zocker / questions-help-bugs
2y ago