Problems connecting Dremio v 4.2.1 with PostgreSQL running on AWS

Hello, guys!

I recently installed version 4.2.1 of Dremio on AWS using the existing version of the AWS Marketplace. When trying to connect to a PostgreSQL database I run into the error.

[source-management2] ERROR c.d.e.store.jdbc.JdbcStoragePlugin - Connection is not valid.
java.lang.NullPointerException: null
at com.dremio.exec.store.jdbc.JdbcStoragePlugin.getState(JdbcStoragePlugin.java:360)
at com.dremio.exec.catalog.ManagedStoragePlugin.lambda$refreshState$6(ManagedStoragePlugin.java:822)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1604)
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)

From what I saw there are already other people with the same problem(link below) and so I would like to know if this has already been solved and what is the way to try to solve it in my installation too!

server.log.zip (7,2,KB)

1 Like