athena-jdbc icon indicating copy to clipboard operation
athena-jdbc copied to clipboard

SdkClientException when using profile credentials

Open DALDEI opened this issue 5 years ago • 1 comments

When I configure profile credentials, every query gets a SdkClientException logged

2020-03-23T20:29:54,271 DEBUG [qtp2144965699-63] software.amazon.awssdk.auth.credentials.AwsCredentialsProviderChain - Unable to load credentials from SystemPropertyCredentialsProvider(): Unable to load credentials from system settings. Access key must be specified either via environment variable (AWS_ACCESS_KEY_ID) or system property (aws.accessKeyId).
software.amazon.awssdk.core.exception.SdkClientException: Unable to load credentials from system settings. Access key must be specified either via environment variable (AWS_ACCESS_KEY_ID) or system property (aws.accessKeyId).

The code then continues on and works. I dont know if this is something you can control or not. Stack trace is like this:

2020-03-23T20:29:54,271 DEBUG [qtp2144965699-63] software.amazon.awssdk.auth.credentials.AwsCredentialsProviderChain - Unable to load credentials from SystemPropertyCredentialsProvider(): Unable to load credentials from system settings. Access key must be specified either via environment variable (AWS_ACCESS_KEY_ID) or system property (aws.accessKeyId). software.amazon.awssdk.core.exception.SdkClientException: Unable to load credentials from system settings. Access key must be specified either via environment variable (AWS_ACCESS_KEY_ID) or system property (aws.accessKeyId). at software.amazon.awssdk.core.exception.SdkClientException$BuilderImpl.build(SdkClientException.java:97) ~[sdk-core-2.5.37.jar:?] at software.amazon.awssdk.auth.credentials.internal.SystemSettingsCredentialsProvider.resolveCredentials(SystemSettingsCredentialsProvider.java:58) ~[auth-2.5.37.jar:?] at software.amazon.awssdk.auth.credentials.AwsCredentialsProviderChain.resolveCredentials(AwsCredentialsProviderChain.java:91) ~[auth-2.5.37.jar:?] at software.amazon.awssdk.auth.credentials.internal.LazyAwsCredentialsProvider.resolveCredentials(LazyAwsCredentialsProvider.java:52) ~[auth-2.5.37.jar:?] at software.amazon.awssdk.auth.credentials.DefaultCredentialsProvider.resolveCredentials(DefaultCredentialsProvider.java:98) ~[auth-2.5.37.jar:?] at software.amazon.awssdk.awscore.client.handler.AwsClientHandlerUtils.createExecutionContext(AwsClientHandlerUtils.java:70) ~[aws-core-2.5.37.jar:?] at software.amazon.awssdk.awscore.client.handler.AwsAsyncClientHandler.createExecutionContext(AwsAsyncClientHandler.java:64) ~[aws-core-2.5.37.jar:?] at software.amazon.awssdk.core.client.handler.BaseAsyncClientHandler.execute(BaseAsyncClientHandler.java:58) ~[sdk-core-2.5.37.jar:?] at software.amazon.awssdk.awscore.client.handler.AwsAsyncClientHandler.execute(AwsAsyncClientHandler.java:51) ~[aws-core-2.5.37.jar:?] at software.amazon.awssdk.services.athena.DefaultAthenaAsyncClient.startQueryExecution(DefaultAthenaAsyncClient.java:1228) ~[athena-2.5.37.jar:?] at software.amazon.awssdk.services.athena.AthenaAsyncClient.startQueryExecution(AthenaAsyncClient.java:2076) ~[athena-2.5.37.jar:?] at io.burt.athena.AthenaStatement.startQueryExecution(AthenaStatement.java:109) ~[athena-jdbc-0.2.0.jar:?] at io.burt.athena.AthenaStatement.execute(AthenaStatement.java:82) ~[athena-jdbc-0.2.0.jar:?] at io.burt.athena.AthenaStatement.executeQuery(AthenaStatement.java:70) ~[athena-jdbc-0.2.0.jar:?]

DALDEI avatar Mar 24 '20 00:03 DALDEI

This logging seems to be the default AWS behavior. We do not (currently) provide any mechanism for overriding the authentication settings, so you would either have to globally override the default credentials provider chain, or if that is not a possibility, I suppose you could configure your log framework to silence this message.

grddev avatar Apr 28 '20 10:04 grddev