The following exception is observed in the DSS 3.2.2 in a clustered setup.
What can be the root cause of this issue? Could anyone please shed some
light on this issue
TID: [0] [DSS] [2014-11-17 10:30:54,662] ERROR
{org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO} - Failed to delete
the resource with id 41. Lock wait timeout exceeded; try restarting
transaction {org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO}
java.sql.SQLException: Lock wait timeout exceeded; try restarting
transaction
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)
at
org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.deleteResource(JDBCResourceDAO.java:1545)
at
org.wso2.carbon.registry.core.jdbc.Repository.removeResource(Repository.java:615)
at
org.wso2.carbon.registry.core.jdbc.Repository.deleteNode(Repository.java:580)
at
org.wso2.carbon.registry.core.jdbc.Repository.deleteSubTree(Repository.java:542)
at
org.wso2.carbon.registry.core.jdbc.RecursionRepository.deleteSubTree(RecursionRepository.java:139)
at
org.wso2.carbon.registry.core.jdbc.Repository.deleteSubTree(Repository.java:537)
at org.wso2.carbon.registry.core.jdbc.Repository.delete(Repository.java:455)
at
org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.delete(EmbeddedRegistry.java:847)
at
org.wso2.carbon.registry.core.caching.CacheBackedRegistry.delete(CacheBackedRegistry.java:512)
at
org.wso2.carbon.registry.core.session.UserRegistry.deleteInternal(UserRegistry.java:870)
at
org.wso2.carbon.registry.core.session.UserRegistry.access$1100(UserRegistry.java:60)
at
org.wso2.carbon.registry.core.session.UserRegistry$12.run(UserRegistry.java:845)
at
org.wso2.carbon.registry.core.session.UserRegistry$12.run(UserRegistry.java:842)
at java.security.AccessController.doPrivileged(Native Method)
at
org.wso2.carbon.registry.core.session.UserRegistry.delete(UserRegistry.java:842)
at
org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent.setupMounts(RegistryCoreServiceComponent.java:343)
at
org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent.initializeTenant(RegistryCoreServiceComponent.java:275)
at
org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent.access$200(RegistryCoreServiceComponent.java:83)
at
org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent$TenantDeploymentListenerImpl.loadTenantRegistry(RegistryCoreServiceComponent.java:873)
at
org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.createTenantConfigurationContext(TenantAxisUtils.java:294)
at
org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getTenantConfigurationContext(TenantAxisUtils.java:135)
at
org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getTenantAxisConfiguration(TenantAxisUtils.java:104)
at
org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getAxisService(TenantAxisUtils.java:195)
at
org.wso2.carbon.wsdl2form.WSDL2FormGenerator.getAxisService(WSDL2FormGenerator.java:701)
at
org.wso2.carbon.wsdl2form.WSDL2FormGenerator.getJSStub(WSDL2FormGenerator.java:502)
at
org.wso2.carbon.wsdl2form.StubRequestProcessor.process(StubRequestProcessor.java:51)
at
org.wso2.carbon.core.transports.CarbonServlet.processWithGetProcessor(CarbonServlet.java:182)
at
org.wso2.carbon.core.transports.CarbonServlet.doGet(CarbonServlet.java:145)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at
org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at
org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.wso2.carbon.tomcat.ext.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:61)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at
org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:178)
at
org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:49)
at
org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:141)
at
org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:156)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at
org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:52)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
TID: [0] [DSS] [2014-11-17 10:30:54,665] ERROR
{org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent} -
Unable to create fixed remote mounts.
{org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent}
org.wso2.carbon.registry.core.exceptions.RegistryException: Failed to
delete the resource with id 41. Lock wait timeout exceeded; try restarting
transaction
This issue is reported at https://wso2.org/jira/browse/DS-995
--
Best Regards..
Chanika Geeganage
Software Engineer
Mobile : +94773522586
WSO2, Inc.; http://wso2.com
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
