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