[Chore][Log] Delete error loggings right before returned errors

[MortalHappiness]

Why are these changes needed?

Based on the What not to Log section in the logging guidelines, we should not log errors inside functions that return errors. Therefore, in this PR all error loggings right before the returned errors are deleted.

Related issue number

N/A

Checks

• [x] I've made sure the tests are passing.
• Testing Strategy
  • [x] Unit tests
  • [ ] Manual tests
  • [ ] This PR is not tested :(