cloud sql stops working after sometime

[ankur shah]

When i deploy the app engine project connected to cloud sql it works fine for sometime. But after sometime i try to access, it does not return any results. similar issue https://vaadin.com/old-forum/-/message_boards/view_message/2873573#_19_message_0

[cp]

If the app is not used I have noticed that the connection drops. Ping hasn't worked for me, so I refresh it every time I use it

[cp]

check this as well it might help you http://stackoverflow.com/questions/12574741/cron-job-on-google-app-engine-to-speed-up-pages

[ankur shah]

1. 2013-08-26 02:34:51.121 /api/buses/buslocation/1 200 271ms 0kb Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36
   173.230.64.120 - - [26/Aug/2013:02:34:51 -0700] "GET /api/buses/buslocation/1 HTTP/1.1" 200 430 - "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36" "transport-tracking.appspot.com" ms=272 cpu_ms=151 cpm_usd=0.000048 app_engine_release=1.8.3 instance=00c61b117c14ae15a695488c5e71a76159a0eb
   
   
   

Above is few hours back when it worked.

Below is when it does not work.

1. 2013-08-26 06:19:27.593 /api/buses/buslocation/1 200 9ms 0kb Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36

   173.230.64.120 - - [26/Aug/2013:06:19:27 -0700] "GET /api/buses/buslocation/1 HTTP/1.1" 200 76 - "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36" "transport-tracking.appspot.com" ms=9 cpu_ms=21 cpm_usd=0.000008 app_engine_release=1.8.3 instance=00c61b117c14ae15a695488c5e71a76159a0eb
   
   
   

[ankur shah]

So rest of the code logic works but only the part which access the sql is not working

[ankur shah]

So when you say connection you mean Database connection?. What if i add a check to my code to make sure that connection is refreshed every few hours will that help?
Also restarting the instance fixes everything again.

Thanks a lot for helping

[Razvan Musaloiu-E.]

What language you using? Are you using the native connections [1]? For Java one very important thing is to make sure the connections are closed at the end of a request.

[1] https://developers.google.com/cloud-sql/docs/native-mysql-gae

[2] https://developers.google.com/cloud-sql/docs/native-mysql-gae#java

-- Razvan ME

--
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-d...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/cef9ab0d-cb89-439d-8a07-f17dbe98d5d8%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.