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:

  1. Consider adding tracing to see whether we have any bot user using todos
  2. Prevent creation of new todos for those users
  3. Delete the todos created for those users
Edited by 🤖 GitLab Bot 🤖