ZITADELZZITADEL
Powered by
wlinnaW
ZITADEL•2y ago•
8 replies
wlinna

Can't remove an organization as an IAM owner (internal error V3-C8l3V)

I'm trying to delete an organization with all its users but all I'm getting is an
An internal error occurred (V3-C8l3V)
An internal error occurred (V3-C8l3V)
.
My user is an IAM Owner, but not the creator of the organization. The organization has 219 users. Many of them are broken because I removed the IDP they used to login. (It's okay — not in production yet)

Here's the relevant part of the log. It seems to suggest that it has got to do with lack of memory, but there's plenty of RAM available. However, for the query the budget is set to
0
0
for some reason.

07:27:37 03be66e673a8[783]: time="7:27:37Z" level=info msg="query failed" caller="/eventstore/repository/sql/query.go:129" error="timeout: context deadline exceeded"
07:27:37 03be66e673a8[783]: time="7:27:37Z" level=info msg="process events failed" caller="/eventstore/handler/v2/handler.go:413" error="ID=SQL-KyeAx Message=unable to filter events Parent=(timeout: context deadline exceeded)" projection=projections.idps3
07:27:37 03be66e673a8[783]: time="7:27:37Z" level=warning msg="delete unique constraint failed" caller="/eventstore/v3/unique_constraints.go:63" error="ERROR: sql: memory budget exceeded: 3348480 bytes requested, 997627327 currently allocated, 0 bytes in budget (SQLSTATE 53200)"
07:27:37 03be66e673a8[783]: time="7:27:37Z" level=info msg="query failed" caller="/eventstore/repository/sql/query.go:129" error="timeout: context deadline exceeded"
07:27:37 03be66e673a8[783]: time="7:27:37Z" level=info msg="process events failed" caller="/eventstore/handler/v2/handler.go:413" error="ID=SQL-KyeAx Message=unable to filter events Parent=(timeout: context deadline exceeded)" projection=projections.idps3
07:27:37 03be66e673a8[783]: time="7:27:37Z" level=warning msg="delete unique constraint failed" caller="/eventstore/v3/unique_constraints.go:63" error="ERROR: sql: memory budget exceeded: 3348480 bytes requested, 997627327 currently allocated, 0 bytes in budget (SQLSTATE 53200)"


The next message contains the query from CockroachDB. It is over 3000 lines long and is mostly just repetition (but probably with different parameters). Makes me wonder if a query that long could cause problems

I'm using Zitadel 2.59.1 (but it also happened with 2.58.1) with CockroachDB v24.1.3
ZITADEL banner
ZITADELJoin
ZITADEL - Identity infrastructure, simplified for you.
4,374Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

Assigning User IAM_OWNER Role
GroguGGrogu / questions-help-bugs
4w ago
Actions v2 on v3.1.0 returning [internal] An internal error occurred (QUERY-y2u7vctrha)
ShardoolSShardool / questions-help-bugs
9mo ago
Zitadel login as admin returns An internal error occurred
Matej MijoskiMMatej Mijoski / questions-help-bugs
11mo ago