MySQL server gone away

1,189 views
Skip to first unread message

Jesse wu

unread,
Sep 9, 2014, 9:59:39 AM9/9/14
to google-a...@googlegroups.com
Hi,
I have developed the chat application using php(yii framework) and mysql. I have run the application in my local using cloud sdk, it response well and good, so after that I have deployed it in to google app engine server. It is working but it is not establishing connection with mysql. I am getting following error
CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2006] MySQL server has gone away

my url is http://yiichatsupport-697.appspot.com/user/login
 I have attached the some screen shot for reference, please help me and guide me at the right track

Thanks

gae_error.png
gae_sqlinstance.png
gae_sqlinstance_accessctrl.png
gae_sqlinstance1.png

Mars Lan

unread,
Sep 9, 2014, 4:01:56 PM9/9/14
to google-a...@googlegroups.com
What connection string did you use to connect to CloudSQL? Also is the app authorized to access the CloudSQL instance?

Vinny P

unread,
Sep 10, 2014, 1:02:29 AM9/10/14
to google-a...@googlegroups.com
On Tue, Sep 9, 2014 at 8:59 AM, Jesse wu <wu6507...@gmail.com> wrote:
it is not establishing connection with mysql. I am getting following error 
CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2006] MySQL server has gone away


 There's some example code of how to connect to a Cloud SQL instance here: https://developers.google.com/appengine/docs/php/cloud-sql/. If you upload that code, do you see a successful connection?

Also, try deauthorizing the app ID (click the little X next to the app ID on the Auth page) then reauthorizing it by copy & pasting the application ID into the prompt. Copying is the important part: don't type out the ID, but copy the ID text from the App Engine console.
 
 
-----------------
-Vinny P
Technology & Media Consultant
Chicago, IL

App Engine Code Samples: http://www.learntogoogleit.com

Jesse wu

unread,
Sep 10, 2014, 3:11:20 AM9/10/14
to google-a...@googlegroups.com
Hi All,

I have followed your instructions, my issue have been resolved, my app is working successfully. thanking you all

Venkat Yuvaraj

unread,
Aug 14, 2015, 10:50:07 AM8/14/15
to Google App Engine
Hello Vinny,
I got this error today Mysql Server has gone away. until last night it was working fine and intermittently it keeps coming..what should i do ? please help. 
-V

Ryan (Cloud Platform Support)

unread,
Aug 14, 2015, 12:25:43 PM8/14/15
to Google App Engine
Salutations Venkat,

We experienced intermittent connectivity issues with Google Cloud SQL beginning at Friday, 2015-08-14 03:28 US/Pacific. The issue should be resolved for all affected projects as of 08:35 US/Pacific. We will conduct an internal investigation of this issue and make appropriate improvements to our systems to prevent or minimize future recurrence. We will provide a more detailed analysis of this incident once we have completed our internal investigation.
Reply all
Reply to author
Forward
0 new messages