Adds some extra description to socket errors in order to distinguish similar errors

[scottopell]

What does this PR do?

Currently there are two branches in this exception handler that print the exact same text. This PR adds some way to distinguish them if they appear in error logs.

Description of the Change

This PR fixes one small typo in a comment and then adds some additional context to one of the error types in order to distinguish them.

Docs for herror and gaierror

Alternate Designs

Possible Drawbacks

Verification Process

Additional Notes

Release Notes

Review checklist (to be filled by reviewers)

• [ ] Feature or bug fix MUST have appropriate tests (unit, integration, etc...)
• [ ] PR title must be written as a CHANGELOG entry (see why)
• [ ] Files changes must correspond to the primary purpose of the PR as described in the title (small unrelated changes should have their own PR)
• [ ] PR must have one changelog/ label attached. If applicable it should have the backward-incompatible label attached.
• [ ] PR should not have do-not-merge/ label attached.
• [ ] If Applicable, issue must have kind/ and severity/ labels attached at least.

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. Note that the issue will not be automatically closed, but this notification will remind us to investigate why there's been inactivity.