DataGrip 2019.2 RC Can't view External Tables in Redshift

Answered

Hi,

 

Since upgrading to 2019.2 I can't seem to view any Redshift external tables. I can only see them in the schema selector accessed by using the inline text on the Database Explorer (not in the connection properties schema selector), and when I select them in the aforementioned schema selector nothing happens and they are unselected when I next open it.

I've also just tried selecting all schemas and they still do not appear.

 

Selected them manually:

Next time I open it, they are unselected:

 

With "All Schemas" selected, they are just unchecked:

 

And the schema selector in Connection Properties, they aren't shown at all:

 

 

I can't see anything suspect in the logs, apart from the following error on initial connection (fyi I'm connecting to a external server not localhost) - i'm guessing its not related but just incase:

2019-08-08 10:25:22,071 [175288279] INFO - ution.rmi.RemoteProcessSupport - version: PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.9003
2019-08-08 10:25:22,072 [175288280] INFO - ution.rmi.RemoteProcessSupport - Detected: REDSHIFT 1.0.9003
2019-08-08 10:25:24,186 [175290394] INFO - ution.rmi.RemoteProcessSupport - Terminating: 18855/RemoteDriverImple5cf33a6
2019-08-08 10:25:24,186 [175290394] INFO - ution.rmi.RemoteProcessSupport - Terminating: 18855/RemoteDriverImple5cf33a6
2019-08-08 10:25:24,247 [175290455] INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code -1
2019-08-08 10:25:29,550 [175295758] INFO - nSession$CountedThreadExecutor - DbSrcWriter stopped
2019-08-08 10:25:30,244 [175296452] WARN - lij.database.util.ErrorHandler - Connection refused to host: 127.0.0.1; nested exception is:
java.net.ConnectException: Connection refused: connect
java.rmi.ConnectException: Connection refused to host: 127.0.0.1; nested exception is:
java.net.ConnectException: Connection refused: connect
at java.rmi/sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:619)
at java.rmi/sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:209)
at java.rmi/sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:196)
at java.rmi/sun.rmi.server.UnicastRef.invoke(UnicastRef.java:129)
at java.rmi/java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:209)
at java.rmi/java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:161)
at com.sun.proxy.$Proxy138.disconnect(Unknown Source)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.intellij.execution.rmi.RemoteUtil.invokeRemote(RemoteUtil.java:175)
at com.intellij.execution.rmi.RemoteUtil.access$200(RemoteUtil.java:38)
at com.intellij.execution.rmi.RemoteUtil$RemoteInvocationHandler.invoke(RemoteUtil.java:271)
at com.sun.proxy.$Proxy139.disconnect(Unknown Source)
at com.intellij.database.dialects.base.introspector.AuditFacade.disconnect(AuditFacade.kt:52)
at org.jetbrains.dekaf.intermediate.AdaptIntermediateFacade.disconnect(AdaptIntermediateFacade.java:41)
at org.jetbrains.dekaf.core.BaseFacade.disconnect(BaseFacade.java:49)
at com.intellij.database.dialects.base.introspector.BaseIntrospector.detachFromDB(BaseIntrospector.kt:147)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.lambda$null$2(DatabaseModelLoader.java:382)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.withFacade(DatabaseModelLoader.java:639)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.lambda$introspect$3(DatabaseModelLoader.java:366)
at com.intellij.database.dataSource.DataSourceSyncManager.lambda$null$0(DataSourceSyncManager.java:48)
at com.intellij.database.console.session.SessionsUtil$function$1.invoke(SessionsUtil.kt:16)
at com.intellij.database.console.session.DatabaseSessionManager$Facade.compute(DatabaseSessionManager.kt:331)
at com.intellij.database.console.session.DatabaseSessionManager$Facade.runSync(DatabaseSessionManager.kt:266)
at com.intellij.database.dataSource.DataSourceSyncManager.lambda$static$1(DataSourceSyncManager.java:46)
at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor$1.perform(DataSourceSyncManager.java:303)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.introspect(DatabaseModelLoader.java:366)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.lambda$run$1(DatabaseModelLoader.java:277)
at com.intellij.database.dataSource.LocalDataSource.performBatch(LocalDataSource.java:1296)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.run(DatabaseModelLoader.java:275)
at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor.performSync(DataSourceSyncManager.java:305)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
at com.intellij.openapi.progress.impl.CoreProgressManager.registerIndicatorAndRun(CoreProgressManager.java:591)
at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:537)
at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:59)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:167)
at com.intellij.database.dataSource.AsyncUtil.lambda$null$2(AsyncUtil.java:64)
at com.intellij.openapi.application.impl.ApplicationImpl$1.run(ApplicationImpl.java:294)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.net.ConnectException: Connection refused: connect
at java.base/java.net.PlainSocketImpl.connect0(Native Method)
at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:101)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
at java.base/java.net.Socket.connect(Socket.java:591)
at java.base/java.net.Socket.connect(Socket.java:540)
at java.base/java.net.Socket.<init>(Socket.java:436)
at java.base/java.net.Socket.<init>(Socket.java:213)
at java.rmi/sun.rmi.transport.tcp.TCPDirectSocketFactory.createSocket(TCPDirectSocketFactory.java:40)
at java.rmi/sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:613)
... 44 more
2019-08-08 10:25:46,259 [175312467] INFO - .diagnostic.PerformanceWatcher - Pushing properties took 1ms; general responsiveness: ok; EDT responsiveness: ok

4 comments
Comment actions Permalink

Ivan, we've fixed it. expect in the closest update.

1
Comment actions Permalink

Exactly the same here. I am not able to show the Redshift external tables with 2019.2 version. I just acquired the license to work on Redshift environments and just now I find this issue. Any help will be appreciated.

0
Comment actions Permalink

Expect the fix in 2019.2.2

0
Comment actions Permalink


I have a similar issue in 2019.2.5.

If "all schemas" are selected for the connection then new external schemas are added to the database and the connection was refreshed, those new schemas are not visible in the explorer. They are however visible under "Schemas" in the connection properties.
Only way to make them visible in the explorer is to manually select them. "All schemas" does not seem to work

0

Please sign in to leave a comment.