Delete todos OWNED by bot users
Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.
In GitLab we have different user types: https://gitlab.com/gitlab-org/gitlab/-/blob/63dce8b8e15ece052e81a5666301187c2bf8ef41/app/models/concerns/has_user_type.rb#L6-43
It seems like about ~6% of todos are OWNED by bot users:
SELECT "todos".id FROM "todos" LEFT JOIN users ON todos.user_id= users.id WHERE "users"."user_type" > 0
While it makes sense that a bot user can create todos, owning not as much.
We probably should:
- Consider adding tracing to see whether we have any bot user using todos
- Prevent creation of new todos for those users
- Delete the todos created for those users
Edited by 🤖 GitLab Bot 🤖