Блог

Всем привет, когда я пытаюсь подключиться к своей базе данных на Redshift из другого экземпляра, который я запустил на EC2.

Мне удалось подключиться из своего менеджера баз данных, но когда я попробовал это сделать из этого другого экземпляра, я получил следующую ошибку

 rdb-loader    | [ioapp-compute-0] WARN io.sentry.dsn.Dsn - *** Couldn't find a suitable DSN, Sentry operations will do nothing! See documentation: https://docs.sentry.io/clients/java/ ***
rdb-loader    | [ioapp-compute-0] WARN io.sentry.DefaultSentryClientFactory - No 'stacktrace.app.packages' was configured, this option is highly recommended as it affects stacktrace grouping and display on Sentry. See documentation: https://docs.sentry.io/clients/java/config/#in-application-stack-frames
rdb-loader    | [ioapp-compute-0] INFO com.snowplowanalytics.snowplow.rdbloader.dsl.Logging.$anon - Sentry has been initialised at
rdb-loader    | [ioapp-compute-0] INFO com.snowplowanalytics.snowplow.rdbloader.dsl.Logging.$anon - RDB Loader 1.1.0 [Redshift Loader] has started. Listening snowplow-rdb-loader-queue.fifo
rdb-loader    | [ioapp-compute-0] ERROR com.snowplowanalytics.snowplow.rdbloader.dsl.Logging.$anon - Loader shutting down
rdb-loader    | java.lang.NullPointerException
rdb-loader    |     at com.amazon.redshift.core.jdbc42.S42NotifiedConnection.setAutoCommit(Unknown Source)
rdb-loader    |     at doobie.free.KleisliInterpreter$ConnectionInterpreter.$anonfun$setAutoCommit$1(kleisliinterpreter.scala:800)
rdb-loader    |     at doobie.free.KleisliInterpreter$ConnectionInterpreter.$anonfun$setAutoCommit$1$adapted(kleisliinterpreter.scala:800)
rdb-loader    |     at doobie.free.KleisliInterpreter.$anonfun$primitive$2(kleisliinterpreter.scala:109)
rdb-loader    |     at blockOn$extension @ doobie.free.KleisliInterpreter.$anonfun$primitive$1(kleisliinterpreter.scala:112)
rdb-loader    |     at $anonfun$tailRecM$1 @ doobie.util.transactor$Transactor$anon$4.$anonfun$apply$4(transactor.scala:167)
rdb-loader    |     at tailRecM @ retry.package$RetryingOnSomeErrorsPartiallyApplied.apply(package.scala:96)
rdb-loader    |     at $anonfun$tailRecM$1 @ doobie.free.KleisliInterpreter$ConnectionInterpreter.$anonfun$bracketCase$28(kleisliinterpreter.scala:750)
rdb-loader    |     at tailRecM @ retry.package$RetryingOnSomeErrorsPartiallyApplied.apply(package.scala:96)
rdb-loader    |     at bracketCase @ doobie.free.KleisliInterpreter$ConnectionInterpreter.$anonfun$bracketCase$28(kleisliinterpreter.scala:750)
rdb-loader    |     at $anonfun$tailRecM$1 @ doobie.util.transactor$Transactor$anon$4.$anonfun$apply$4(transactor.scala:167)
rdb-loader    |     at tailRecM @ retry.package$RetryingOnSomeErrorsPartiallyApplied.apply(package.scala:96)
rdb-loader    |     at tailRecM @ retry.package$RetryingOnSomeErrorsPartiallyApplied.apply(package.scala:96)
rdb-loader    |     at bracketCase @ doobie.free.KleisliInterpreter$ConnectionInterpreter.$anonfun$bracketCase$28(kleisliinterpreter.scala:750)
rdb-loader    |     at $anonfun$tailRecM$1 @ doobie.util.transactor$Transactor$anon$4.$anonfun$apply$4(transactor.scala:167)
rdb-loader    |     at tailRecM @ retry.package$RetryingOnSomeErrorsPartiallyApplied.apply(package.scala:96)
rdb-loader    |     at use @ com.snowplowanalytics.snowplow.rdbloader.Main$.run(Main.scala:36)
rdb-loader    | [cats-effect-blocker-0] INFO org.http4s.client.PoolManager - Shutting down connection pool: curAllocated=1 idleQueues.size=1 waitQueue.size=0 maxWaitQueueLimit=256 closed=false
rdb-loader exited with code 1
 

Я уже дал разрешение другому IP-адресу экземпляра и моей локальной машине на подключение