dhis2-devs team mailing list archive

["jason.p.pickering" <597600@xxxxxxxxxxxxxxxxxx>]

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 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