Deepak,
Thank you for responding. Last night I did send a reply
back to your question but the mail system bounced it back due to some of
the text in the error. I’m going to try this again.
I have been using the following software and Drivers
- JMeter 5.6.2
- Java openjdk 17.0.7 2023-04-18 LTS.
- AWS Athena JDBC driver AthenaJDBC42-2.0.34.1000.jar which I downloaded
from here Connecting to Amazon Athena with JDBC - Amazon Athena
<https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html>
Using 5.6.2 with driver AthenaJDBC42-2.0.34.1000.jar JMeter will not start
in GUI mode. I tried to start it via the CLI and I got the following error.
.
AsyncWaitStrategyFactoryConfig"'s signer information does not match signer
information of other classes in the same package
I am also running DBeaver which uses driver version
AthenaJDBC42-2.0.34.1000.jar and DBeaver is able to connect to Athena
without issue. So, I tried that driver jar with JMeter as well and I get
the same error as above.
I then started testing older versions of JMeter and I found when I got back
to JMeter 5.5 the error above didn’t happen and JMeter would start up.
However, when I tried to connect it would stop right away and I got another
Java error like.
at
com.simba.athena.amazonaws.auth.profile.internal.BasicProfileConfigFileLoader.getProfilesConfigFile(BasicProfileConfigFileLoader.java:71)
~[AthenaJDBC42-2.1.1.1001.jar:?]
I then tested JMeter 5.4.3. The UI would also launch and this time when I
started my test it didn’t die right away. But the JMeter log showed this
error.
Invalid type definition for type
com.simba.athena.amazonaws.services.athena.model.AmazonAthenaException:
Failed to call setAccess() on Method 'setCause' (of class
java.lang.Throwable`) due to java.lang.reflect.InaccessibleObjectException,
problem: Unable to make final void
java.lang.Throwable.setCause(java.lang.Throwable) accessible: module
java.base does not "opens java.lang" to unnamed module @747ddf94
Here is an example of my connection string. The user, password and bucket
below is not my actual user, password or bucket.
jdbc:awsathena://
athena.us-east-2.amazonaws.com:443/iceberg_tpcds_sf1000_01?user=KCABLAHBLAHBLAHBLAHW&password=WKBLAHBLAHBLAHBLAH4lXKtDkbjWblahBLAHblahLblah&s3_staging_dir=s3://athena-results-bucket-name-us-west-2/
--
*Kyle Payne*
Technical Director, Enablement
920.475.7014
[email protected]
<https://www.starburst.io/>
*From:* Deepak Goel <[email protected]>
*Sent:* Friday, November 17, 2023 12:17 AM
*To:* JMeter Users List <[email protected]>
*Subject:* Re: Using JMeter to connect to AWS Athena
What's the error? Can you please paste it here?
Deepak
"The greatness of a nation can be judged by the way its animals are treated
- Mahatma Gandhi"
+91 73500 12833
[email protected]
Facebook: https://www.facebook.com/deicool
LinkedIn: www.linkedin.com/in/deicool
"Plant a Tree, Go Green"
Make In India : http://www.makeinindia.com/home
On Fri, Nov 17, 2023 at 8:06 AM Kyle Payne <[email protected]>
wrote:
I’ve been using JMeter to connect to multiple data sources like Databricks,
Trino and Starburst and I’ve never had an issue. Tonight, I tried to
connect to AWS Athena. I’m getting an error from the JDBC driver from AWS
and I did open a support call with AWS. I’m reaching out to this list
server only to see if there are any other users who have connected JMeter
to Athena.
--
*Kyle Payne*
Technical Director, Enablement
920.475.7014
[email protected]
<https://www.starburst.io/>
