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

2 comments
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

Please sign in to leave a comment.