ERROR org.postgresql.Driver - Connection error:

HLNA · February 9, 2018, 11:51pm

I noted that even when not in use the postgres driver (hearbeat?) throws connection error…

2018-02-09 15:48:24,897 [qtp906350712-274] ERROR org.postgresql.Driver - Connection error: 
org.postgresql.util.PSQLException: The connection attempt failed.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:275) ~[postgresql-42.1.1.jre7.jar:42.1.1.jre7]
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.1.1.jre7.jar:42.1.1.jre7]
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194) ~[postgresql-42.1.1.jre7.jar:42.1.1.jre7]
	at org.postgresql.Driver.makeConnection(Driver.java:450) ~[postgresql-42.1.1.jre7.jar:42.1.1.jre7]
	at org.postgresql.Driver.connect(Driver.java:252) ~[postgresql-42.1.1.jre7.jar:42.1.1.jre7]
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) [commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) [commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) [commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) [commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) [commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) [commons-dbcp-1.4.jar:1.4]
	at com.dremio.exec.store.jdbc.JdbcStoragePlugin.getState(JdbcStoragePlugin.java:195) [dremio-extra-plugin-jdbc-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
	at com.dremio.dac.service.source.SourceService.getSourceState(SourceService.java:587) [dremio-dac-backend-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
	at com.dremio.dac.service.source.SourceService.getStateForSource(SourceService.java:638) [dremio-dac-backend-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
	at com.dremio.dac.resource.SourcesResource.getSources(SourcesResource.java:68) [dremio-dac-backend-1.4.4-201801230630490666-6d69d32.jar:1.4.4-201801230630490666-6d69d32]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_102]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_102]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_102]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_102]
	at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) [jersey-server-2.25.1.jar:na]
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) [jersey-server-2.25.1.jar:na]
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) [jersey-server-2.25.1.jar:na]
	at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205) [jersey-server-2.25.1.jar:na]
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) [jersey-server-2.25.1.jar:na]
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) [jersey-server-2.25.1.jar:na]
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) [jersey-server-2.25.1.jar:na]
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) [jersey-server-2.25.1.jar:na]
	at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326) [jersey-server-2.25.1.jar:na]
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) [jersey-common-2.25.1.jar:na]
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) [jersey-common-2.25.1.jar:na]
	at org.glassfish.jersey.internal.Errors.process(Errors.java:315) [jersey-common-2.25.1.jar:na]
	at org.glassfish.jersey.internal.Errors.process(Errors.java:297) [jersey-common-2.25.1.jar:na]
	at org.glassfish.jersey.internal.Errors.process(Errors.java:267) [jersey-common-2.25.1.jar:na]
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) [jersey-common-2.25.1.jar:na]
	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305) [jersey-server-2.25.1.jar:na]
	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154) [jersey-server-2.25.1.jar:na]
	at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473) [jersey-container-servlet-core-2.25.1.jar:na]
	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427) [jersey-container-servlet-core-2.25.1.jar:na]
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388) [jersey-container-servlet-core-2.25.1.jar:na]
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341) [jersey-container-servlet-core-2.25.1.jar:na]
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228) [jersey-container-servlet-core-2.25.1.jar:na]
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812) [jetty-servlet-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) [jetty-servlet-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:83) [jetty-servlets-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:365) [jetty-servlets-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) [jetty-servlet-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) [jetty-servlet-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127) [jetty-server-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515) [jetty-servlet-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061) [jetty-server-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) [jetty-server-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [jetty-server-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.server.handler.RequestLogHandler.handle(RequestLogHandler.java:95) [jetty-server-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [jetty-server-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.server.Server.handle(Server.java:499) [jetty-server-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311) [jetty-server-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:258) [jetty-server-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544) [jetty-io-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) [jetty-util-9.2.22.v20170606.jar:9.2.22.v20170606]
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) [jetty-util-9.2.22.v20170606.jar:9.2.22.v20170606]
	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_102]
Caused by: java.net.UnknownHostException: hautelookdw.cguxjw7krgi8.us-west-2.redshift.amazonaws.com
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184) ~[na:1.8.0_102]
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:1.8.0_102]
	at java.net.Socket.connect(Socket.java:589) ~[na:1.8.0_102]
	at org.postgresql.core.PGStream.<init>(PGStream.java:68) ~[postgresql-42.1.1.jre7.jar:42.1.1.jre7]
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144) ~[postgresql-42.1.1.jre7.jar:42.1.1.jre7]
	... 60 common frames omitted

can · February 10, 2018, 1:36am

@HLNA are you using a Redshift source?

HLNA · February 11, 2018, 9:46pm

@can Thanks! Yes, and the error is not about " Call to cancel query on RDBMs source failed with error: Amazon Error setting/closing connection: Operation timed out."
Does the settings in https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-firewall-guidance.html takes care of this error as well?

jduong · February 13, 2018, 5:09pm

Hi @HLNA,

Want to clarify a few things here:
You should be using the Redshift JDBC driver rather than the PostgreSQL driver when working with redshift.

Use jdbc:redshift://… in the connection URL for the Redshift source.

Is the error: " Call to cancel query on RDBMs source failed with error: Amazon Error setting/closing connection: Operation timed out." happening using the Redshift driver or the PostgreSQL driver?

Can you describe how you run into this issue? Are you pressing the Cancel button from Dremio’s web app? Does this error happen after another error?

HLNA · July 25, 2018, 6:45am

Revisiting this datasource/dremio. I still face the same issue.

Dremio 2.0.5 on Cluster
Using jdbc:redshift://

In PREVIEW mode:
SOURCE_BAD_STATE ERROR: The source [redshift_src] is currently unavailable. Info: [[Message{level=ERROR, msg=Cannot create PoolableConnectionFactory (Amazon Error setting/closing connection: UnknownHostException.)}]]. ERROR Cannot create PoolableConnectionFactory (Amazon Error setting/closing connection: UnknownHostException.) Fragment 1:0 [Error Id: 69a377b6-c78c-49b6-86a7-363fa4a25850 on ip-11-22-33-142.aws.net:-1]

In RUN mode:
The source [redshift_src] is currently unavailable. Info: [[Message{level=ERROR, msg=Cannot create PoolableConnectionFactory (Amazon Error setting/closing connection: UnknownHostException.)}]].

jduong · September 4, 2018, 6:39pm

@HLNA

Have you been able to use this same JDBC URL to connect to your Redshift instance with other tools from the same computer? In Redshift, have you granted access to the external IP of the computer you’re using to test?

It seems like the host can’t be resolved, which can happen if the client machine has not been whitelisted.

HLNA · September 4, 2018, 8:10pm

@jduong
Hmm… that’s a while ago… I think I did not see it after that … I will update when I work on it again.

Topic		Replies	Views
Unable to preview data from a table in postgresql datasource	7	2032	March 15, 2019
Greenplum data source query exception(had resolved)	3	1399	September 28, 2018
Dremio3.0.0 connect postgresql8.2 query error	4	1165	November 6, 2018
Postgres query timing out after 10 seconds	4	1028	August 6, 2021
AWS Postgres:The JDBC storage plugin failed while trying setup the SQL query	3	359	July 31, 2023

ERROR org.postgresql.Driver - Connection error:

Related Topics