Introspection hangs on "table columns in schema.table"
已回答
I am using DataGrip 2019.3 on Mac os Mojave verion 10.14.6. I recently upgraded to Datagrip 2019.3 from 2019.2. Since then my introspection has been very slow. In order to deal with that slowness, I turned off "auto-sync" in "Data Sources and Drivers" . Then in "Data Sources and Drivers" I turned "introspect using JBDC meta-data". Since then I have deleted some tables and a schema, and cancelled the request in the middle. Ever since that hard stop with the IDE , the introspection is extremely slow and hangs on the first schema's table columms.
请先登录再写评论。
The event log shows : failed to retrieve columns for role_usage_grants.
java.rmi.ConnectException: Connection refused to host: 127.0.0.1; nested exception is:
java.net.ConnectException: Connection refused (Connection refused)
java.net.ConnectException: Connection refused (Connection refused).
Connection refused to host: 127.0.0.1; nested exception is:
java.net.ConnectException: Connection refused (Connection refused)
and 66 duplicate reports
@Djamil ,
Could you email vasily.chernov@jetbrains.com me full IDE & SQL logs for investigation?
I faced the same problem - Can't update schemas (I can see table names, but without columns/indexes…) with error: failed to retrieve columns for TABLE_NAME. [08003] Соединение уже было закрыто. and 836 duplicate reports
DBeavier seemed to work fine with the same DB. Problem persist on different versions of datagrip (2022.2.5 and 2024.3.3)
Hi Vasya Kucherenko,
To help us investigate the issue, collect the following log files:
Once you've collected the logs, upload them to https://uploads.jetbrains.com/ and provide the uploadID so I can locate the files.