# Dremio Error to connect redshift

**URL:** <https://community.dremio.com/t/dremio-error-to-connect-redshift/8864>\
**Category:** Site Feedback\
**Created:** [March 10, 2022, 7:21pm UTC](https://community.dremio.com/t/dremio-error-to-connect-redshift/8864 "2022-03-10T19:21:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jlcornejo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/jlcornejo/32/3499_2.png) [@jlcornejo](https://community.dremio.com/u/jlcornejo)\
**Post date:** [March 10, 2022, 7:21pm UTC](https://community.dremio.com/t/dremio-error-to-connect-redshift/8864/1 "2022-03-10T19:21:51Z")

</div>

I don’t know what’s going on, I tried the credentials in dbeaver for example and it works.  
Could it be that the jdbc url is different, or the Dremio v18.1.0 driver is not compatible?

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/7/7017da4c4e5c3466b636a3916b6c26a932a3c94f.png)

```auto
2022-03-10 19:10:10,239 [qtp1667729405-4982] ERROR c.d.exec.catalog.CatalogServiceImpl - Exception encountered: Could not connect to redshift_paris_jda, check your JDBC connection information and credentials
com.dremio.common.exceptions.UserException: Could not connect to redshift_paris_jda, check your JDBC connection information and credentials
	at com.dremio.common.exceptions.UserException$Builder.build(UserException.java:830)
	at com.dremio.exec.catalog.ManagedStoragePlugin.createOrUpdateSource(ManagedStoragePlugin.java:410)
	at com.dremio.exec.catalog.ManagedStoragePlugin.createSource(ManagedStoragePlugin.java:317)
	at com.dremio.exec.catalog.PluginsManager.create(PluginsManager.java:172)
	at com.dremio.exec.catalog.CatalogServiceImpl.createSource(CatalogServiceImpl.java:387)
	at com.dremio.exec.catalog.CatalogServiceImpl.access$400(CatalogServiceImpl.java:104)
	at com.dremio.exec.catalog.CatalogServiceImpl$SourceModifier.createSource(CatalogServiceImpl.java:720)
	at com.dremio.exec.catalog.CatalogImpl.createSource(CatalogImpl.java:1026)
	at com.dremio.exec.catalog.SourceAccessChecker.createSource(SourceAccessChecker.java:297)
	at com.dremio.exec.catalog.DelegatingCatalog.createSource(DelegatingCatalog.java:264)
	at com.dremio.dac.service.source.SourceService.registerSourceWithRuntime(SourceService.java:161)
	at com.dremio.dac.service.source.SourceService.registerSourceWithRuntime(SourceService.java:152)
	at com.dremio.dac.service.source.SourceService.registerSourceWithRuntime(SourceService.java:148)
	at com.dremio.dac.resource.PutSourceResource.putSource(PutSourceResource.java:80)
	at sun.reflect.GeneratedMethodAccessor499.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167)
	at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:469)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:391)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:80)
	at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:253)
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:232)
	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680)
	at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)
	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:755)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1617)
	at com.dremio.dac.server.GenericResponseHeadersFilter.doFilter(GenericResponseHeadersFilter.java:46)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
	at com.dremio.dac.server.SecurityHeadersFilter.doFilter(SecurityHeadersFilter.java:57)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
	at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:717)
	at org.eclipse.jetty.server.handler.RequestLogHandler.handle(RequestLogHandler.java:54)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
	at org.eclipse.jetty.server.Server.handle(Server.java:500)
	at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)
	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
	at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.util.concurrent.ExecutionException: java.lang.Exception: Unavailable: 
	at java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:357)
	at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1928)
	at com.dremio.exec.catalog.ManagedStoragePlugin.replacePlugin(ManagedStoragePlugin.java:969)
	at com.dremio.exec.catalog.ManagedStoragePlugin.createOrUpdateSource(ManagedStoragePlugin.java:352)
	... 70 common frames omitted
Caused by: java.lang.Exception: Unavailable: 
	at com.dremio.exec.catalog.ManagedStoragePlugin.lambda$newStartSupplier$1(ManagedStoragePlugin.java:551)
	at com.dremio.exec.catalog.ManagedStoragePlugin.lambda$nameSupplier$3(ManagedStoragePlugin.java:613)
	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)
	... 1 common frames omitted

```

---

<div class="post-metadata">

**Author:** ![jlcornejo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/jlcornejo/32/3499_2.png) [@jlcornejo](https://community.dremio.com/u/jlcornejo)\
**Post date:** [March 10, 2022, 7:26pm UTC](https://community.dremio.com/t/dremio-error-to-connect-redshift/8864/2 "2022-03-10T19:26:21Z")

</div>

I use this driver on dbeaver

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/2/28c363ae52c176141a482a20170dcdedda75094f.jpeg)

😶

```auto
2022-03-10 19:31:44,242 [start-redshift_paris_jda] WARN c.d.e.catalog.ManagedStoragePlugin - Error starting new source: redshift_paris_jda
java.lang.Exception: Unavailable: 
	at com.dremio.exec.catalog.ManagedStoragePlugin.lambda$newStartSupplier$1(ManagedStoragePlugin.java:551)
	at com.dremio.exec.catalog.ManagedStoragePlugin.lambda$nameSupplier$3(ManagedStoragePlugin.java:613)
	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)
2022-03-10 19:31:44,243 [start-redshift_paris_jda] INFO c.d.s.s.LocalSchedulerService - Cancelling task metadata-refresh-wakeup-redshift_paris_jda
2022-03-10 19:31:44,270 [qtp1667729405-6110] ERROR c.d.e.store.jdbc.JdbcStoragePlugin - JDBC source redshift_paris_jda has not been started.
2022-03-10 19:31:44,274 [qtp1667729405-6110] ERROR c.dremio.exec.catalog.PluginsManager - Exception while creating source.

```

---

<div class="post-metadata">

**Author:** ![jlcornejo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/jlcornejo/32/3499_2.png) [@jlcornejo](https://community.dremio.com/u/jlcornejo)\
**Post date:** [March 10, 2022, 9:04pm UTC](https://community.dremio.com/t/dremio-error-to-connect-redshift/8864/3 "2022-03-10T21:04:56Z")

</div>

network problems, everything is ok.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [March 25, 2022, 2:38pm UTC](https://community.dremio.com/t/dremio-error-to-connect-redshift/8864/4 "2022-03-25T14:38:11Z")

</div>

Thanks for the update @jlcornejo, apologies for missing this post