Aborted connection occur in Cloud SQL

[Muthukannan]

Hello All,

In Cloud SQL , we are getting below log in GCP. Root user connection is aborted.

[Note] [MY-010914] [Server] Aborted connection 1503128 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets).

But in our application we didn't use the root user for connections. Why it is occuring? Is there any setting change to solve this issue.

[comaro]

Can you tell me how you are trying to connect to the Cloud SQL database? For example, are you using Cloud Run, Cloud Build with Terraform or did this error appear when you tried to connect on the command line? I need this information because sometimes the problem originates where you are trying to connect to the database.

[Muthukannan]

@comaro 

Our Application uses GKE. From GKE Workload (Pod) , Cloud SQL database accessed through jdbc.
But as I mentioned earlier , We didn't use root user in application connection.

As We checked in Process List , it show some default root connections.
But we are not clear Why Aborted connection occurs.

[allentv]

Typically, connecting to Cloud SQL involves setting up the Cloud SQL proxy as a sidecar container a service account and then connecting to it using a preset database user. More details here: https://cloud.google.com/sql/docs/postgres/connect-kubernetes-engine

[Muthukannan]

@allentv 

Thanks for the reply. We understand Cloud SQL proxy is secure way to connect.

 But Currently we are connect cloud sql directly with private IP. (Cloud SQL proxy not used now)
root user not used when making connection from GKE pod.

Is Cloud SQL Auth proxy solve root connection abort Issue?

[comaro]

Your project would need to be inspected by support.

This can be done over a [support case](https://cloud.google.com/support-hub) under a valid business justification.