Hi, since March 7, we've experienced lots of timeouts and reset connections when calling the Sheets API.
After drilling down a bit, we realized that on the affected hosts, DNS queries for sheets.googleapis.com (which is a CNAME for googleapis.l.google.com) would always only return a single record, 74.125.193.95 to be specific. All of these hosts are Amazon EC2 instances in the eu-west-1 region. Normally, if we resolve *.googleapis.com from any other host (including EC2 instances in other regions), we always get a list of records back, which seems to indicate a form of round-robin load balancing. While the DNS peculiarity doesn't necessarily has to be related to the connection issues we've been seeing, it's at least an odd coincidence. Note that the symptoms are not exclusive to the sheets API—any of Google's APIs that has endpoints on googleapis.com and which we use has shown the timeouts and reset connections mentioned above. I have created an entry on Google's issue tracker, but I'd be interested if there's anyone else that has also noticed similar symptoms. Thanks for any feedback and best regards, Dorian -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-spreadsheets-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
