Thursday, July 6, 2017

[google-cloud-sql-discuss] Re: Aborted connection 29 to db: 'unconnected' user: 'root' host: 'cloudsqlproxy~xxx.xxx.xx.xx' (Got an error reading communication packets)

We are having exactly the same issue, from Compute Engine.

George, this does not seem to be a networking/connectivity issue since this is GCP internal. Any other idea why these things occur? They occur like 20+ times a day - not rare at all.

Thanks!

On Friday, May 26, 2017 at 8:53:23 AM UTC-7, George (Cloud Platform Support) wrote:
Hello Peter, 

This type of errors is usually caused by networking and connectivity issues, such as badly configured TCP/IP, faulty Ethernets, hubs, switches, cables. For diagnosing purposes it may be worthwhile trying to connect from a different network and check for any differences in eventual error messages. 

If connectivity is not an issue, your can try raising the max_allowed_packet to a  larger number, upwards from the default value of 1M. 

For more detail, have a look at the "B.5.2.11 Communication Errors and Aborted Connections" online document

If you have any more information facilitating our reproduction of the issue, you are encouraged to add it to your reply. 

--
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/5b9f6b85-54ea-4e6d-a0a8-77da125c4ca8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment