Hi could you provide the "caused by" part of the stacktrace? On Sat, Mar 12, 2011 at 8:28 PM, jason.p.pickering < [email protected]> wrote:
> Experiencing this when attempting to insert a rather large number of > orgunits using the Amazon RDS backend (MySQL). Any update on this? > > -- > You received this bug notification because you are a bug assignee. > https://bugs.launchpad.net/bugs/597600 > > Title: > Getting Error while generating OrgUnitStructure > > Status in DHIS 2 - District Health Information Software: > New > > Bug description: > While generating OrganisationUnitSturcture (Maintenance -> DataAdmin > -> Resource Table) getting following exception: (TRIED with empty > database as well, using MYSQL) > > ERROR 14:28:39,218 Error while executing action > (ExceptionInterceptor.java [31283773@qtp-3223780 > -0]) > ava.lang.RuntimeException: Failed to flush BatchHandler > at > org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:2 > 2) > at > org.hisp.dhis.resourcetable.DefaultResourceTableService.generateOrganisationUnitStructu > es(DefaultResourceTableService.java:196) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:3 > 9) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(Reflective > ethodInvocation.java:183) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodIn > ocation.java:150) > at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionIn > erceptor.java:110) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodIn > ocation.java:172) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202 > > at $Proxy38.generateOrganisationUnitStructures(Unknown Source) > at > org.hisp.dhis.dataadmin.action.resourcetable.GenerateResourceTableAction.execute(Genera > eResourceTableAction.java:114) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.ja > a:441) > at > com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocatio > .java:280) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243 > > at > org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUse > Interceptor.java:82) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalM > duleInterceptor.java:85) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMen > Interceptor.java:91) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalP > ramsInterceptor.java:117) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:89) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.j > va:103) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > org.hisp.dhis.interceptor.DataDictionaryModeInterceptor.intercept(DataDictionaryModeInt > rceptor.java:109) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyIntercept > r.java:90) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > > > org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:124) > > at > > > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterc > ptor.java:98) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:141) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.j > va:126) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterce > tor.java:195) > at > com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInter > eptor.java:87) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParamet > rsInterceptor.java:179) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:89) > at > com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 > > at > org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) > at > org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488) > at > org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha > nProxy.java:343) > at > org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:129 > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha > nProxy.java:355) > at > org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java > 112) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha > nProxy.java:355) > at > org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilt > r.java:105) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha > nProxy.java:355) > at > org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter. > oFilter(AbstractAuthenticationProcessingFilter.java:188) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha > nProxy.java:355) > at > org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(Secu > ityContextPersistenceFilter.java:79) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha > nProxy.java:355) > at > org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149) > at > org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterPro > y.java:237) > at > org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.jav > :167) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) > > at > org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(Ope > SessionInViewFilter.java:198) > at > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java: > 6) > 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.ContextHandlerCollection.handle(ContextHandlerCollection.java > 230) > at > org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) > 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.content(HttpConnection.java:943) > at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) > at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) > at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) > at > org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) > at > org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) > aused by: java.sql.SQLException: Lock wait timeout exceeded; try > restarting transaction > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) > at > com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564) > at > com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485) > at > org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:2 > 6) > ... 89 more > -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/597600 Title: Getting Error while generating OrgUnitStructure Status in DHIS 2 - District Health Information Software: New Bug description: While generating OrganisationUnitSturcture (Maintenance -> DataAdmin -> Resource Table) getting following exception: (TRIED with empty database as well, using MYSQL) ERROR 14:28:39,218 Error while executing action (ExceptionInterceptor.java [31283773@qtp-3223780 -0]) ava.lang.RuntimeException: Failed to flush BatchHandler at org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:2 2) at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateOrganisationUnitStructu es(DefaultResourceTableService.java:196) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:3 9) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(Reflective ethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodIn ocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionIn erceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodIn ocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202 at $Proxy38.generateOrganisationUnitStructures(Unknown Source) at org.hisp.dhis.dataadmin.action.resourcetable.GenerateResourceTableAction.execute(Genera eResourceTableAction.java:114) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.ja a:441) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocatio .java:280) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243 at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUse Interceptor.java:82) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalM duleInterceptor.java:85) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMen Interceptor.java:91) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalP ramsInterceptor.java:117) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:89) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.j va:103) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at org.hisp.dhis.interceptor.DataDictionaryModeInterceptor.intercept(DataDictionaryModeInt rceptor.java:109) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyIntercept r.java:90) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:124) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterc ptor.java:98) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:141) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.j va:126) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterce tor.java:195) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInter eptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParamet rsInterceptor.java:179) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:89) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237 at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488) at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha nProxy.java:343) at org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:129 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha nProxy.java:355) at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java 112) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha nProxy.java:355) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilt r.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha nProxy.java:355) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter. oFilter(AbstractAuthenticationProcessingFilter.java:188) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha nProxy.java:355) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(Secu ityContextPersistenceFilter.java:79) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha nProxy.java:355) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterPro y.java:237) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.jav :167) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(Ope SessionInViewFilter.java:198) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java: 6) 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.ContextHandlerCollection.handle(ContextHandlerCollection.java 230) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) 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.content(HttpConnection.java:943) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) aused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485) at org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:2 6) ... 89 more _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
