Remove soft removals related code

Closes #37447

See merge request gitlab-org/gitlab-ce!15789

(cherry picked from commit 7acabf7c)

d0b8f536 Remove soft removals related code
e5c49b57 Added tests for removing soft removed objects