App Engine closed local connection on Cloud sql

Mike Hardy

unread,

Oct 30, 2017, 5:07:07 PM10/30/17

to Google App Engine

Hi, we have an app on app engine + cloud sql. To sync up our production and staging environments, we dumped our production database and restored our staging database with this dump. Both databases have the same permissions and table owners but now our app is unable to access this database and we're consistently getting this error from the app engine logs. What could be causing this?

3:55:11.0002017/10/30 20:55:11 Client closed local connection on /cloudsql/<CONNECTION STRING>/.s.PGSQL.5432
Expand all | Collapse all
{ insertId: "1iy1i8ig25r7zmm"  
 labels: {  appengine.googleapis.com/instance_name: "aef-default-dev--34a56a4-57vh"   
  compute.googleapis.com/resource_id: "2868526200192389103"   
  compute.googleapis.com/resource_name: "266b95872058"   
  compute.googleapis.com/zone: "us-central1-b"   
 }
 logName: "projects/localinsights-staging/logs/appengine.googleapis.com%2Fstderr"  
 receiveTimestamp: "2017-10-30T20:55:16.522269142Z"  
 resource: {  labels: {   module_id: "default"    
   project_id: "<PROJECT ID>"    
   version_id: "dev-34a56a4"    
  }
  type: "gae_app"   
 }
 textPayload: "2017/10/30 20:55:11 Client closed local connection on /cloudsql/<CONNECTION STRING>.s.PGSQL.5432
"  
 timestamp: "2017-10-30T20:55:11Z"  
}

Jordan (Cloud Platform Support)

unread,

Oct 31, 2017, 3:05:05 PM10/31/17

to Google App Engine

As described in the blue 'Note' in the documentation, your instance type is PostgreSQL and connections from App Engine to PostgreSQL are not currently supported in the App Engine Standard environment.

Our engineering team is aware of this and are currently working on supporting this. You may actually have luck if you are making connections from the new Java 8 App Engine standard runtime.

- Since Google Groups is meant for general product discussions and not for technical support or for reporting issues or feature requests, it is recommended in the future to report Google-end issues and feature requests to the Public Issue Tracker and to seek technical support on Stack Overflow using the supported Cloud tags.

Mike Hardy

unread,

Nov 1, 2017, 7:31:05 PM11/1/17

to Google App Engine

Hi Jordan, we're actually on GAE Flexible but we solved this problem by adding more resources to both postgres and GAE.

George (Cloud Platform Support)

unread,

Nov 3, 2017, 2:44:00 PM11/3/17

to Google App Engine

Hello Mike,

How was this issue solved exactly? A more detailed description might benefit Group members in future, and increase the value of your posting.

Mike Hardy

unread,

Nov 3, 2017, 3:46:27 PM11/3/17

to Google App Engine

Hi George, we removed our scaling restrictions that limited our dev machine to 1 instance and increased our cloud sql instance to 2 cores + 7.5GB. Hope that helps.

Sajal Garg

unread,

Dec 18, 2018, 10:08:36 PM12/18/18

to Google App Engine

Hi Mike

I am suffering from the same issue. I am running MySQL 2nd Gen instance. I have upgraded to 2 cores + 7.5 GB with 1 failover replica but futile. Can you please explain what do you mean by " we removed our scaling restrictions that limited our dev machine to 1 instance ". Thanks in advance.

Reply all

Reply to author

Forward