I no longer have it handy but I seem to recall it looked very similar to the original report by Bharath.
2011/4/1 Lars Helge Øverland <[email protected]>: > 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 > India 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 > -- Jason P. Pickering email: [email protected] tel:+260974901293 -- 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
