Ошибка подключения к базе данных Athena из метабазы. ⇐ JAVA

[Anonymous]

Ранее я использовал два VPC. Один имел кластер MSK и коннектор msk-athena, а второй использовался для запуска Metabase на ECS. Мне удалось настроить базу данных Athena в Metabase, которая подключалась к Athena для запроса моей темы MSK Kafka. Однако, когда я изменил свои настройки и теперь использовал для всего один VPC, я получил эту ошибку при синхронизации базы данных Athena.
Oct 16 13:11:53.368 ERROR 44 com.simba.athena.exceptions.ExceptionConverter.toSQLException: [JDBC Driver]
java.sql.SQLException: [ J D B C D r i v e r ] < b r / > a t c o m . s i m b a . a t h e n a . a m a z o n a w s . i n t e r n a l . S d k F i l t e r I n p u t S t r e a m . a b o r t I f N e e d e d ( S d k F i l t e r I n p u t S t r e a m . j a v a : 6 1 ) < b r / > a t c o m . s i m b a . a t h e n a . a m a z o n a w s . i n t e r n a l . S d k F i l t e r I n p u t S t r e a m . r e a d ( S d k F i l t e r I n p u t S t r e a m . j a v a : 8 9 ) < b r / > a t c o m . s i m b a . a t h e n a . a m a z o n a w s . e v e n t . P r o g r e s s I n p u t S t r e a m . r e a d ( P r o g r e s s I n p u t S t r e a m . j a v a : 1 8 0 ) < b r / > a t c o m . s i m b a . a t h e n a . s h a d e d . f a s t e r x m l . j a c k s o n . c o r e . j s o n . B y t e S o u r c e J s o n B o o t s t r a p p e r . e n s u r e L o a d e d ( B y t e S o u r c e J s o n B o o t s t r a p p e r . j a v a : 5 3 9 ) < b r / > a t c o m . s i m b a . a t h e n a . s h a d e d . f a s t e r x m l . j a c k s o n . c o r e . j s o n . B y t e S o u r c e J s o n B o o t s t r a p p e r . d e t e c t E n c o d i n g ( B y t e S o u r c e J s o n B o o t s t r a p p e r . j a v a : 1 3 3 ) < b r / > a t c o m . s i m b a . a t h e n a . s h a d e d . f a s t e r x m l . j a c k s o n . c o r e . j s o n . B y t e S o u r c e J s o n B o o t s t r a p p e r . c o n s t r u c t P a r s e r ( B y t e S o u r c e J s o n B o o t s t r a p p e r . j a v a : 2 5 6 ) < b r / > a t c o m . s i m b a . a t h e n a . s h a d e d . f a s t e r x m l . j a c k s o n . c o r e . J s o n F a c t o r y . _ c r e a t e P a r s e r ( J s o n F a c t o r y . j a v a : 1 6 8 5 ) < b r / > a t c o m . s i m b a . a t h e n a . s h a d e d . f a s t e r x m l . j a c k s o n . c o r e . J s o n F a c t o r y . c r e a t e P a r s e r ( J s o n F a c t o r y . j a v a : 1 0 8 4 ) < b r / > a t c o m . s i m b a . a t h e n a . a m a z o n a w s . h t t p . J s o n R e s p o n s e H a n d l e r . h a n d l e ( J s o n R e s p o n s e H a n d l e r . j a v a : 1 0 9 ) < b r / > a t c o m . s i m b a . a t h e n a . a m a z o n a w s . h t t p . J s o n R e s p o n s e H a n d l e r . h a n d l e ( J s o n R e s p o n s e H a n d l e r . j a v a : 4 3 ) < b r / > a t c o m . s i m b a . a t h e n a . a m a z o n a w s . h t t p . r e s p o n s e . A w s R e s p o n s e H a n d l e r A d a p t e r . h a n d l e ( A w s R e s p o n s e H a n d l e r A d a p t e r . j a v a : 6 9 ) < b r / > a t c o m . s i m b a . a t h e n a . a m a z o n a w s . h t t p . A m a z o n H t t p C l i e n t $ R e q u e s t E x e c u t o r . h a n d l e R e s p o n s e ( A m a z o n H t t p C l i e n t . j a v a : 1 7 9 4 ) < b r / > a t c o m . s i m b a . a t h e n a . a m a z o n a w s . h t t p . A m a z o n H t t p C l i e n t $ R e q u e s t E x e c u t o r . h a n d l e S u c c e s s R e s p o n s e ( A m a z o n H t t p C l i e n t . j a v a : 1 4 7 7 ) < b r / > a t c o m . s i m b a . a t h e n a . a m a z o n a w s . h t t p . A m a z o n H t t p C l i e n t $ R e q u e s t E x e c u t o r . e x e c u t e O n e R e q u e s t ( A m a z o n H t t p C l i e n t . j a v a : 1 3 8 4 ) < b r / > a t c o m . s i m b a . a t h e n a . a m a z o n a w s . h t t p . A m a z o n H t t p C l i e n t $ R e q u e s t E x e c u t o r . e x e c u t e H e l p e r ( A m a z o n H t t p C l i e n t . j a v a : 1 1 5 7 ) < b r / > a t c o m . s i m b a . a t h e n a . a m a z o n a w s . h t t p . A m a z o n H t t p C l i e n t $ R e q u e s t E x e c u t o r . d o E x e c u t e ( A m a z o n H t t p C l i e n t . j a v a : 8 1 4 ) < b r / > a t com.simba.athena.amazonaws.http.AmazonHttpClient$RequestExecutor.executeWithTimer(AmazonHttpClient.java:781)
at com.simba.athena.amazonaws.http.AmazonHttpClient$RequestExecutor.execute(AmazonHttpClient.java:755)
at com.simba.athena.amazonaws.http.AmazonHttpClient$RequestExecutor.access$500(AmazonHttpClient.java:715)
at com.simba.athena.amazonaws.http.AmazonHttpClient$RequestExecutionBuilderImpl.execute(AmazonHttpClient.java:697)
at com.simba.athena.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:561)
at com.simba.athena.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:541)
at com.simba.athena.amazonaws.services.athena.AmazonAthenaClient.doInvoke(AmazonAthenaClient.java:2570)
at com.simba.athena.amazonaws.services.athena.AmazonAthenaClient.invoke(AmazonAthenaClient.java:2537)
at com.simba.athena.amazonaws.services.athena.AmazonAthenaClient.invoke(AmazonAthenaClient.java:2526)
at com.simba.athena.amazonaws.services.athena.AmazonAthenaClient.executeGetQueryExecution(AmazonAthenaClient.java:1150)
at com.simba.athena.amazonaws.services.athena.AmazonAthenaClient.getQueryExecution(AmazonAthenaClient.java:1119)
at com.simba.athena.athena.api.AJClient.executeQuery(Unknown Source)
at com.simba.athena.athena.dataengine.AJQueryExecutor.(Unknown Source)
at com.simba.athena.athena.dataengine.AJDataEngine.prepare(Unknown Source)
at com.simba.athena.athena.dataengine.AJDataEngine.prepare(Unknown Source)
at com.simba.athena.jdbc.common.SPreparedStatement.(Unknown Source)
at com.simba.athena.jdbc.jdbc41.S41PreparedStatement.(Unknown Source)
at com.simba.athena.jdbc.jdbc42.S42PreparedStatement.(Unknown Source)
at com.simba.athena.athena.jdbc42.AJ42PreparedStatement.(Unknown Source)
at com.simba.athena.athena.jdbc42.AJJDBC42ObjectFactory.createPreparedStatement(Unknown Source)
at com.simba.athena.jdbc.common.JDBCObjectFactory.newPreparedStatement(Unknown Source)
at com.simba.athena.jdbc.common.SConnection$5.create(Unknown Source)
at com.simba.athena.jdbc.common.SConnection$5.create(Unknown Source)
at com.simba.athena.jdbc.common.SConnection$StatementCreator.create(Unknown Source)
at com.simba.athena.jdbc.common.SConnection.prepareStatement(Unknown Source)
at com.simba.athena.jdbc.common.SConnection.prepareStatement(Unknown Source)
at com.simba.athena.jdbc.common.SConnection.prepareStatement(Unknown Source)
at clojure.java.jdbc$prepare_statement.invokeStatic(jdbc.clj:679)
at clojure.java.jdbc$prepare_statement.invoke(jdbc.clj:626)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1112)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1093)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invokeStatic(connection.clj:348)
at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invoke(connection.clj:345)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_$fn__82191.invoke(connection.clj:357)
at metabase.driver.sql_jdbc.connection$do_with_connection_spec_for_testing_connection$fn__82173.invoke(connection.clj:333)
at metabase.util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:165)
at metabase.util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:154)
at metabase.driver.sql_jdbc.connection$do_with_connection_spec_for_testing_connection.invokeStatic(connection.clj:328)
at metabase.driver.sql_jdbc.connection$do_with_connection_spec_for_testing_connection.invoke(connection.clj:324)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invokeStatic(connection.clj:356)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invoke(connection.clj:352)
at metabase.driver.sql_jdbc$fn__108323.invokeStatic(sql_jdbc.clj:49)
at metabase.driver.sql_jdbc$fn__108323.invoke(sql_jdbc.clj:47)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__56088.invoke(util.clj:167)
at clojure.core$binding_conveyor_fn$fn__5823.invoke(core.clj:2047)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: com.simba.athena.amazonaws.AbortedException:
... 71 more
2024-10-16 13:11:53,273 ERROR driver.util :: Failed to connect to Database
java.util.concurrent.TimeoutException: Timed out after 10.0 s



Подробнее здесь: https://stackoverflow.com/questions/790 ... m-metabase