Hi to all, thank you for the replies.
On Monday, June 24, 2013 12:05:01 PM UTC+2, Luca Zanconato wrote:
Our application is already on High Replication Datastore (not migrated but created in HRD) and also we are already using the native connection (driver "com.mysql.jdbc.GoogleDriver") to Cloud SQL.
On Monday, June 24, 2013 12:05:01 PM UTC+2, Luca Zanconato wrote:
Hello,since friday 21st the Cloud SQL instance has become really slow when bulk inserting records: we tried to remove indexes, to restart the instance and also to drop and recreate the database without success.Before friday we were able to bulk insert 800 records per time on a single table, and now when trying to insert 400 the instance takes more than 60 seconds to respond and so AppEngine reaches the request timeout limit.
- instance name: workforcegso-pre:workforcegso-
pre-db - application name: workforcegso
- stacktrace:
2013-06-24 10:53:34.500
it.gocloud.wgso.srv.biz.wfm.AnnotatedActionsWorkflowManage r handleWorkflow: null java.lang.reflect. InvocationTargetException at com.google.appengine.runtime. Request.process- 017071684c02af59(Request.java) at sun.reflect. NativeMethodAccessorImpl. invoke0(Native Method) at sun.reflect. NativeMethodAccessorImpl. invoke( NativeMethodAccessorImpl.java: 57) at sun.reflect. DelegatingMethodAccessorImpl. invoke( DelegatingMethodAccessorImpl. java:43) at java.lang.reflect.Method. invoke(Method.java:45) at it.gocloud.wgso.srv.biz.wfm. AnnotatedActionsWorkflowManage r.handleWorkflow( AnnotatedActionsWorkflowManage r.java:86) at it.gocloud.wgso.srv.res. BulkInterventions.putCsv( BulkInterventions.java:94) at sun.reflect. NativeMethodAccessorImpl. invoke0(Native Method) at sun.reflect. NativeMethodAccessorImpl. invoke( NativeMethodAccessorImpl.java: 57) at sun.reflect. DelegatingMethodAccessorImpl. invoke( DelegatingMethodAccessorImpl. java:43) at java.lang.reflect.Method. invoke(Method.java:45) at com.sun.jersey.server.impl. model.method.dispatch. AbstractResourceMethodDispatch Provider$ResponseOutInvoker._ dispatch( AbstractResourceMethodDispatch Provider.java:186) at com.sun.jersey.server.impl. model.method.dispatch. ResourceJavaMethodDispatcher. dispatch( ResourceJavaMethodDispatcher. java:70) at com.sun.jersey.server.impl. uri.rules.HttpMethodRule. accept(HttpMethodRule.java: 279) at com.sun.jersey.server.impl. uri.rules.ResourceClassRule. accept(ResourceClassRule.java: 86) at com.sun.jersey.server.impl. uri.rules.RightHandPathRule. accept(RightHandPathRule.java: 136) at com.sun.jersey.server.impl. uri.rules. RootResourceClassesRule. accept( RootResourceClassesRule.java: 74) at com.sun.jersey.server.impl. application. WebApplicationImpl._ handleRequest( WebApplicationImpl.java:1347) at com.sun.jersey.server.impl. application. WebApplicationImpl._ handleRequest( WebApplicationImpl.java:1279) at com.sun.jersey.server.impl. application. WebApplicationImpl. handleRequest( WebApplicationImpl.java:1229) at com.sun.jersey.server.impl. application. WebApplicationImpl. handleRequest( WebApplicationImpl.java:1219) at com.sun.jersey.spi.container. servlet.WebComponent.service( WebComponent.java:419) at com.sun.jersey.spi.container. servlet.ServletContainer. service(ServletContainer.java: 537) at com.sun.jersey.spi.container. servlet.ServletContainer. service(ServletContainer.java: 699) at javax.servlet.http. HttpServlet.service( HttpServlet.java:717) at com.google.inject.servlet. ServletDefinition.doService( ServletDefinition.java:263) at com.google.inject.servlet. ServletDefinition.service( ServletDefinition.java:178) at com.google.inject.servlet. ManagedServletPipeline. service( ManagedServletPipeline.java: 91) at com.google.inject.servlet. FilterChainInvocation. doFilter( FilterChainInvocation.java:62) at org.apache.shiro.guice.web. SimpleFilterChain.doFilter( SimpleFilterChain.java:44) at org.apache.shiro.web.servlet. AdviceFilter.executeChain( AdviceFilter.java:108) at org.apache.shiro.web.servlet. AdviceFilter.doFilterInternal( AdviceFilter.java:137) at org.apache.shiro.web.servlet. OncePerRequestFilter.doFilter( OncePerRequestFilter.java:125) at org.apache.shiro.guice.web. SimpleFilterChain.doFilter( SimpleFilterChain.java:41) at org.apache.shiro.web.servlet. AdviceFilter.executeChain( AdviceFilter.java:108) at org.apache.shiro.web.servlet. AdviceFilter.doFilterInternal( AdviceFilter.java:137) at org.apache.shiro.web.servlet. OncePerRequestFilter.doFilter( OncePerRequestFilter.java:125) at org.apache.shiro.guice.web. SimpleFilterChain.doFilter( SimpleFilterChain.java:41) at org.apache.shiro.web.servlet. AdviceFilter.executeChain( AdviceFilter.java:108) at org.apache.shiro.web.servlet. AdviceFilter.doFilterInternal( AdviceFilter.java:137) at org.apache.shiro.web.servlet. OncePerRequestFilter.doFilter( OncePerRequestFilter.java:125) at org.apache.shiro.guice.web. SimpleFilterChain.doFilter( SimpleFilterChain.java:41) at org.apache.shiro.web.servlet. AdviceFilter.executeChain( AdviceFilter.java:108) at org.apache.shiro.web.servlet. AdviceFilter.doFilterInternal( AdviceFilter.java:137) at org.apache.shiro.web.servlet. OncePerRequestFilter.doFilter( OncePerRequestFilter.java:125) at org.apache.shiro.guice.web. SimpleFilterChain.doFilter( SimpleFilterChain.java:41) at org.apache.shiro.web.servlet. AbstractShiroFilter. executeChain( AbstractShiroFilter.java:449) at org.apache.shiro.web.servlet. AbstractShiroFilter$1.call( AbstractShiroFilter.java:365) at org.apache.shiro.subject. support.SubjectCallable. doCall(SubjectCallable.java: 90) at org.apache.shiro.subject. support.SubjectCallable.call( SubjectCallable.java:83) at org.apache.shiro.subject. support.DelegatingSubject. execute(DelegatingSubject. java:380) at org.apache.shiro.web.servlet. AbstractShiroFilter. doFilterInternal( AbstractShiroFilter.java:362) at org.apache.shiro.web.servlet. OncePerRequestFilter.doFilter( OncePerRequestFilter.java:125) at com.google.inject.servlet. FilterDefinition.doFilter( FilterDefinition.java:163) at com.google.inject.servlet. FilterChainInvocation. doFilter( FilterChainInvocation.java:58) at com.google.inject.servlet. ManagedFilterPipeline. dispatch( ManagedFilterPipeline.java: 118) at com.google.inject.servlet. GuiceFilter.doFilter( GuiceFilter.java:113) at org.mortbay.jetty.servlet. ServletHandler$CachedChain. doFilter(ServletHandler.java: 1157) at org.mortbay.jetty.servlet. ServletHandler$CachedChain. doFilter(ServletHandler.java: 1157) at org.mortbay.jetty.servlet. ServletHandler$CachedChain. doFilter(ServletHandler.java: 1157) at org.mortbay.jetty.servlet. ServletHandler$CachedChain. doFilter(ServletHandler.java: 1157) at org.mortbay.jetty.servlet. ServletHandler$CachedChain. doFilter(ServletHandler.java: 1157) at org.mortbay.jetty.servlet. ServletHandler.handle( ServletHandler.java:388) at org.mortbay.jetty.security. SecurityHandler.handle( SecurityHandler.java:216) at org.mortbay.jetty.servlet. SessionHandler.handle( SessionHandler.java:182) at org.mortbay.jetty.handler. ContextHandler.handle( ContextHandler.java:765) at org.mortbay.jetty.webapp. WebAppContext.handle( WebAppContext.java:418) at org.mortbay.jetty.handler. HandlerWrapper.handle( HandlerWrapper.java:152) at org.mortbay.jetty.Server. handle(Server.java:326) at org.mortbay.jetty. HttpConnection.handleRequest( HttpConnection.java:542) at org.mortbay.jetty. HttpConnection$RequestHandler. headerComplete(HttpConnection. java:923) at org.mortbay.jetty. HttpConnection.handle( HttpConnection.java:404) at com.google.tracing. TraceContext$ TraceContextRunnable. runInContext(TraceContext. java:483) at com.google.tracing. TraceContext$ TraceContextRunnable$1.run( TraceContext.java:490) at com.google.tracing. TraceContext.runInContext( TraceContext.java:777) at com.google.tracing. TraceContext$DoInTraceContext. runInContext(TraceContext. java:754) at com.google.tracing. TraceContext$ AbstractTraceContextCallback. runInInheritedContextNoUnref( TraceContext.java:345) at com.google.tracing. TraceContext$ AbstractTraceContextCallback. runInInheritedContext( TraceContext.java:337) at com.google.tracing. TraceContext$ TraceContextRunnable.run( TraceContext.java:487) at java.lang.Thread.run(Thread. java:722) Caused by: com.google.apphosting.api. DeadlineExceededException: This request (017071684c02af59) started at 2013/06/24 08:52:35.074 UTC and was still executing at 2013/06/24 08:53:34.497 UTC. at java.util.regex.Pattern$Curly. match0(Pattern.java:4170) at java.util.regex.Pattern$Curly. match(Pattern.java:4132) at java.util.regex.Pattern$ GroupHead.match(Pattern.java: 4556) at java.util.regex.Pattern$Start. match(Pattern.java:3408) at java.util.regex.Matcher. search(Matcher.java:1318) at java.util.regex.Matcher.find( Matcher.java:593) at it.gocloud.wgso.srv.data. BaseJpaDao.addDomainFilter( BaseJpaDao.java:102) at it.gocloud.wgso.srv.data. BaseJpaDao.query(BaseJpaDao. java:152) at it.gocloud.wgso.srv.data. BaseJpaDao.find(BaseJpaDao. java:245) at it.gocloud.wgso.srv.data.