improve error logging for aws sdk err

[xxchan]

Display of SdkError is very simple, and not helpful at all for diagnosing problem:

ERROR: ExecuteError: internal error: connector error: failed to construct request

{:?} is more informative, but less readable.

The recommended way is:

https://docs.rs/aws-smithy-http/latest/aws_smithy_http/result/enum.SdkError.html

When logging an error from the SDK, it is recommended that you either wrap the error in DisplayErrorContext, use another error reporter library that visits the error’s cause/source chain, or call Error::source for more details about the underlying cause.

[xxchan]

Note: We have much nicer error message in v0.19, e.g.,

The regression in v1.0 is because we upgraded aws sdk.

[xxchan]

smithy-lang/smithy-rs#1345

[xxchan]

smithy-lang/smithy-rs#1950 upgrade guidance

https://web.archive.org/web/20230518023205/https://awslabs.github.io/smithy-rs/design/rfcs/rfc0022_error_context_and_compatibility.html Their error handling RFC

[xxchan]

https://risingwave-community.slack.com/archives/C03BW71523T/p1690455709545769 Another trouble due to error message.

[xxchan]

s3 source error improved in #11120

[xxchan]

#11198 also related

[xxchan]

most important parts fixed. fix more in future on demand