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 !

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 !

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

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

Continue the conversation

ZITADEL

Continue the conversation

ZITADEL

Similar Threads