* Describe the bug
In one specific case, a deleted collection (unternehmen_branchen_kategorien) still appears in the Action permissions tab of a role (Users & Permissions → Roles → Configure permissions), even though it no longer exists in the Data source manager.
This is not the normal behavior — I have created and deleted many collections over time, and in all other cases the deleted collections correctly disappeared from role permissions as well. This appears to be a rare, edge case where something went wrong during deletion, leaving behind an orphaned permission entry.
“Sync from database” does not resolve the issue.
* Environment
- NocoBase version: 2.0.53
- Database type and version: PostgreSQL 16
- OS: MacOS Catalina 10.15.8
- Deployment Methods: Docker container
- Docker image version: 2.0.53
- NodeJS version: N/A
* How To Reproduce
Unknown. I cannot reliably reproduce this issue. Standard collection deletion works correctly in all other observed cases. The specific conditions that caused the orphaned entry to remain are unclear.
Possible contributing factors (speculation):
- A timing or async issue during deletion
- An incomplete transaction at time of deletion
- A specific permission state that prevented cascade deletion
Expected behavior
When a collection is deleted, its entries should be removed from all role-based Action Permissions as well. This is the normal behavior — this case is the exception.
Screenshots
Screenshot 1 — Users & Permissions (Action permissions): Same filter — shows the same collections PLUS the deleted
unternehmen_branchen_kategorien (marked with red underline), which should not be there.
Screenshot 2 — Data source manager (Collections tab): Filtered by “Unternehmen” — shows only existing collections.
unternehmen_branchen_kategorien is NOT listed.
I made a database full-test search for “unternehmen_branchen_kategorien” and this was found. Hopefully it helps. If you need more details let me know.
Logs
N/A — no API errors observed.