DataGrip 2019.2 RC Can't view External Tables in Redshift
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
Please sign in to leave a comment.
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.
Expect the fix in 2019.2.2
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
Ivan, we've fixed it. expect in the closest update.
I have the same problem in the current version: 2021.1.3 - macOS (dmg)
External schemas are under Database objects in tree:
I am on DataGrip version 2021.2.4. I am able to see the external schemas but not the tables within the external schemas. Is there a configuration I am missing that should enable viewing the list of tables within the external schemas? Even in the screenshot above the athena_test doesn't display any tables in the dropdown.
Shradhas,
Could you file an issue in DataGrip bug tracker and attach IDE, SQL and logs produced by Prepare Introspector Diagnostics action?
I can't reproduce the issue.