[google-cloud-sql-discuss] Aborted connection 47625 to db | Read Replica

For my CloudSQL DB, Read-Replica of PROD, i am getting frequent aborted connections error. We use Read-Replica for reporting purpose, We use SQL proxy to connect from MS-SQL server ( hosted in Azure) along with C-data in between for fetching data from CloudSQL to MS-SQL server. 

SQL quires executes for 30-180 mins and are running for last 1 year. In last 4-5 days , our reporting SQL's start hanging after running for 20-30 mins and did not respond. 

Read-Replica logs show are is a increase in aborted connect error.

Logs:

====

{

 insertId: "xxxxxxxx"  

 logName: "projects/xxx-xxx-db/logs/cloudsql.googleapis.com%2Fmysql.err"  

 receiveTimestamp: "2020-03-30T13:07:53.626203743Z"  

 resource: {…}  

 severity: "INFO"  

 textPayload: "2020-03-30T13:07:52.901100Z 47625 [Note] Aborted connection 47625 to db: 'XXXXDB' user: 'readonlyusr' host: 'cloudsqlproxy~xx.xx.xx.xxx' (Got an error writing communication packets)"  

 timestamp: "2020-03-30T13:07:52.901563Z"  

}

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/d1884ab8-a710-4bb3-9702-05eae89ee532%40googlegroups.com.