Datagrip -- Unable to Connect using Cloud SQL Proxy

[0xBraunGuy]

Sometimes I'm able to connect, usually by restarting (after a force-quit) Datagrip. Currently, however I'm not able to connect at all, seems the issue has become persistent.

Expected Behavior

Connect via Cloud SQL Proxy
Connecting to any existing database sources should work (refreshing, querying, Test Connection)
The Cloud SQL console should log "connection created" and "connection closed" everytime DataGrip pings through the proxy

Actual Behavior

Connecting hangs, the console messages never show up.
Datagrip needs to be closed and force quit, as the application hangs as well while cancelling / closing the connections

Additional Information

• IDE type (e.g. IntelliJ, Pycharm): Datagrip
• IDE version:

DataGrip 2023.2.3
Build #DB-232.10203.8, built on October 24, 2023

• Cloud Code version (Settings > Plugins > Cloud Code):

23.10.2-api-version-222

• Cloud SDK (Settings > Cloud Code > Cloud SDK)

• Are you allowing the plugin to manage the Cloud SDK:
  No, it's installed separately

• Version of the Cloud SDK:

Google Cloud SDK 455.0.0
beta 2023.11.10
bq 2.0.98
core 2023.11.10
gcloud-crc32c 1.0.0
gsutil 5.27

• Skaffold version (If you are using Kubernetes features; Settings > Cloud Code > Kubernetes):

N/A

• Operating System:

  macOS 12.5
  GC: G1 Young Generation, G1 Old Generation
  Memory: 2048M
  Cores: 8

[ivanporty]

Thanks for the report @0xBraunGuy, we were not able to reproduce so far. To help us debugging, please answer these questions:

1. Are DB instances showing properly in your Google Cloud Databases window?
2. When you connect an instance, terminal opens and proxy starts? Is IDE functional and non-frozen at this point?
3. What happens next - you try to open a data source related to your database and connect to it, and then it hangs?

[DiegoVillalobos-SB24]

Hi @ivanporty I opened the other ticket #3168 and to answer your questions:

1. Yes the instances are shown properly in the Databases window
2. Yes the terminal opens, the proxy starts, the IDE is fully functional and I can connect to the databases using 3rd party clients (pgAdmin)
3. As soon as I type anything on any file, the IDE freezes, while the IDE is frozen the proxy is still active and working without any issues

[villesau]

Looks like the same problem as in the ticket I created. This seemed to help in my case: #3176 (comment)

Also the freezing problem is discussed there (no resolution tho).