DB connector (Athena) connection error

#1

DB connector (Athena JDBC) not able to connect with aws platform. Returns the following error.

ERROR DB Connector 2:560 Execute failed: [Simba]AthenaJDBC An error has been thrown from the AWS Athena client. Unknown.

Connection credentials to the platform are correct. The connector sporadically works and then gives the same error again. Does not seem to be an issue with the aws platform.

0 Likes

#2

Hi there @emadsyed,

welcome to KNIME Community!

So you are saying that sometimes it works and sometimes throws error? What KNIME version are you running? Did you try Amazon Athena Connector?

Br,
Ivan

0 Likes

#3

Thank you for your response Ivan, I am using KNIME 4.0.1. About the connector, previously it sometimes used to throw this error and then would work again after sometime. However today it is consistently throwing this error. We have not tried amazon athena connector. The DB connector was working fine until now.

0 Likes

#4

Hi @emadsyed,

sounds like a network issue but just a guess. Is there any other information in log file?

Above mentioned dedicated Athena Connector is available from 4.1.0.

Br,
Ivan

0 Likes

#5

Yes it is a network issue it seems, It started working again several hours later. I will be sure to checkout the the athena dedicated connector. Thank you.

1 Like

#6

This is the error that is logged into the knime log file. Any help to resolve this would be appreciated.

2020-01-15 10:00:48,266 : WARN : KNIME-Worker-1 : : TipsAndNewsInjector : : : Could not modify intro page: Connection reset
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:210)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)
at sun.security.ssl.InputRecord.read(InputRecord.java:503)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:975)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1367)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1395)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1379)
at sun.net.www.protocol.https.HttpsClient.afterConnect(HttpsClient.java:559)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:185)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.connect(HttpsURLConnectionImpl.java:162)
at org.knime.product.rcp.intro.TipsAndNewsInjector.prepareData(TipsAndNewsInjector.java:220)
at org.knime.product.rcp.intro.AbstractInjector.run(AbstractInjector.java:145)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:123)
at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:246)
2020-01-15 10:00:49,370 : WARN : main : : KNIMECorePlugin : : : Can’t set C:\Users\g2384\AppData\Local\Temp\Knime as temp dir
2020-01-15 10:01:18,066 : WARN : ModalContext : : Node : Database Reader (legacy) : 0:406:563 : No query configured.
2020-01-15 10:01:33,023 : ERROR : KNIME-Worker-1 : : Node : DB Connector : 0:561 : Execute failed: [Simba]AthenaJDBC An error has been thrown from the AWS Athena client. Unknown

0 Likes

#7

Do you see any more information in the log file after this entry? Ideally there is a stacktrace like the one above the line which indicates a problem with fetching the tips&tricks information that are shown on the KNIME welcome page.
Tobias

0 Likes

#8

java.sql.SQLException: [Simba]AthenaJDBC An error has been thrown from the AWS Athena client. Unknown
at com.simba.athena.athena.api.AJClient.checkAndThrowException(Unknown Source)
at com.simba.athena.athena.api.AJClient.executeQuery(Unknown Source)
at com.simba.athena.athena.api.AJClient.checkAthenaConnection(Unknown Source)
at com.simba.athena.athena.api.AJClient.(Unknown Source)
at com.simba.athena.athena.core.AJConnection.connect(Unknown Source)
at com.simba.athena.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
at com.simba.athena.jdbc.common.AbstractDriver.connect(Unknown Source)
at org.knime.database.connection.UrlDBConnectionController$ControlledDriver.connect(UrlDBConnectionController.java:95)
at org.knime.database.connection.UrlDBConnectionController.createConnection(UrlDBConnectionController.java:306)
at org.knime.database.connection.UserDBConnectionController.createConnection(UserDBConnectionController.java:249)
at org.knime.database.connection.AbstractConnectionProvider.createConnection(AbstractConnectionProvider.java:89)
at org.knime.database.connection.impl.DBConnectionManager.lambda$2(DBConnectionManager.java:370)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
Caused by: com.simba.athena.support.exceptions.GeneralException: [Simba]AthenaJDBC An error has been thrown from the AWS Athena client. Unknown
… 15 more
Caused by: com.simba.athena.amazonaws.services.athena.model.AmazonAthenaException: null (Service: AmazonAthena; Status Code: 403; Error Code: null; Request ID: null)
at com.simba.athena.amazonaws.http.AmazonHttpClient$RequestExecutor.handleErrorResponse(AmazonHttpClient.java:1712)
at com.simba.athena.amazonaws.http.AmazonHttpClient$RequestExecutor.executeOneRequest(AmazonHttpClient.java:1367)
at com.simba.athena.amazonaws.http.AmazonHttpClient$RequestExecutor.executeHelper(AmazonHttpClient.java:1113)
at com.simba.athena.amazonaws.http.AmazonHttpClient$RequestExecutor.doExecute(AmazonHttpClient.java:770)
at com.simba.athena.amazonaws.http.AmazonHttpClient$RequestExecutor.executeWithTimer(AmazonHttpClient.java:744)
at com.simba.athena.amazonaws.http.AmazonHttpClient$RequestExecutor.execute(AmazonHttpClient.java:726)
at com.simba.athena.amazonaws.http.AmazonHttpClient$RequestExecutor.access$500(AmazonHttpClient.java:686)
at com.simba.athena.amazonaws.http.AmazonHttpClient$RequestExecutionBuilderImpl.execute(AmazonHttpClient.java:668)
at com.simba.athena.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:532)
at com.simba.athena.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:512)
at com.simba.athena.amazonaws.services.athena.AmazonAthenaClient.doInvoke(AmazonAthenaClient.java:1388)
at com.simba.athena.amazonaws.services.athena.AmazonAthenaClient.invoke(AmazonAthenaClient.java:1355)
at com.simba.athena.amazonaws.services.athena.AmazonAthenaClient.invoke(AmazonAthenaClient.java:1344)
at com.simba.athena.amazonaws.services.athena.AmazonAthenaClient.executeStartQueryExecution(AmazonAthenaClient.java:1060)
at com.simba.athena.amazonaws.services.athena.AmazonAthenaClient.startQueryExecution(AmazonAthenaClient.java:1031)
at com.simba.athena.athena.api.AJClient.executeQuery(Unknown Source)
at com.simba.athena.athena.api.AJClient.checkAthenaConnection(Unknown Source)
at com.simba.athena.athena.api.AJClient.(Unknown Source)
at com.simba.athena.athena.core.AJConnection.connect(Unknown Source)
at com.simba.athena.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
at com.simba.athena.jdbc.common.AbstractDriver.connect(Unknown Source)
at org.knime.database.connection.UrlDBConnectionController$ControlledDriver.connect(UrlDBConnectionController.java:95)
at org.knime.database.connection.UrlDBConnectionController.createConnection(UrlDBConnectionController.java:306)
at org.knime.database.connection.UserDBConnectionController.createConnection(UserDBConnectionController.java:249)
at org.knime.database.connection.AbstractConnectionProvider.createConnection(AbstractConnectionProvider.java:89)
at org.knime.database.connection.impl.DBConnectionManager.lambda$2(DBConnectionManager.java:370)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

0 Likes

#9

@tobias.koetter i think this is what you requested in the previous response. Also we changed the athena jdbc drivers to the latest ones. The important thing to note here is that it works sporadically. It works for a couple of hours and then malfunctions and starts shooting the errors mentioned above. Sometime later ranging from 30 mins to a couple of hours, it starts to work again.

0 Likes

#10

Hi,
it seems that you get an error 403 when the Athena driver checks that the connection to Athena is valid when KNIME tries to create a new connection. Error 403 is a standard HTTP status code that indicates that the access to the requested URL is forbidden for some reason. Unfortunately the reason is unknown which doesn’t help us. What makes it even more problematic is that it works once in a while :frowning:

Can you please contact the Amazon support and send them the stacktrace that you have posted in your previous reply or point them to this forum entry.
Bye
Tobias

1 Like