dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Caused by: java.sql.SQLException: Lock wait timeout exceeded; try
restarting transaction

This problem has been reported many times, don't think this is specific
for the resource table function.

** Changed in: dhis2
    Milestone: 2.0.5 => None

-- 
Getting Error while generating OrgUnitStructure
https://bugs.launchpad.net/bugs/597600
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.

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