It's the User Manager. Is this problem solved now? Seeing this frequently? /sumedha
On Tue, Nov 9, 2010 at 1:46 PM, Supun Kamburugamuva <[email protected]> wrote: > 2010-11-09 08:09:39,593 [-] [Thread-124] ERROR DatabaseUtil Error! Deadlock > found when trying to get lock; try restarting transaction > com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock > found when trying to get lock; try restarting transaction > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) > at com.mysql.jdbc.Util.getInstance(Util.java:384) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1066) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) > at > org.wso2.carbon.user.core.util.DatabaseUtil.updateDatabase(DatabaseUtil.java:242) > at > org.wso2.carbon.user.core.authorization.JDBCAuthorizationManager.clearResourceAuthorizations(JDBCAuthorizationManager.java:279) > at > org.wso2.carbon.registry.core.jdbc.realm.RegistryAuthorizationManager.clearResourceAuthorizations(RegistryAuthorizationManager.java:149) > at > org.wso2.carbon.registry.core.utils.AuthorizationUtils.clearAuthorizations(AuthorizationUtils.java:128) > at > org.wso2.carbon.registry.core.jdbc.Repository.deleteNode(Repository.java:589) > at > org.wso2.carbon.registry.core.jdbc.Repository.deleteSubTree(Repository.java:531) > at > org.wso2.carbon.registry.core.jdbc.RecursionRepository.deleteSubTree(RecursionRepository.java:138) > at > org.wso2.carbon.registry.core.jdbc.Repository.deleteSubTree(Repository.java:526) > at > org.wso2.carbon.registry.core.jdbc.Repository.delete(Repository.java:444) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.delete(EmbeddedRegistry.java:744) > at > org.wso2.carbon.registry.core.session.UserRegistry.delete(UserRegistry.java:652) > at > org.wso2.carbon.registry.core.jdbc.handlers.builtin.MountHandler.delete(MountHandler.java:440) > at > org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.delete(HandlerManager.java:2483) > at > org.wso2.carbon.registry.core.jdbc.handlers.UserDefinedHandlerManager.delete(UserDefinedHandlerManager.java:215) > at > org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.delete(HandlerLifecycleManager.java:378) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.delete(EmbeddedRegistry.java:740) > at > org.wso2.carbon.registry.core.session.UserRegistry.delete(UserRegistry.java:652) > at > org.wso2.carbon.mediation.initializer.RegistryBasedSynapseConfigSerializer.clearSynapseConfigRegistrySpace(RegistryBasedSynapseConfigSerializer.java:235) > at > org.wso2.carbon.mediation.initializer.RegistryBasedSynapseConfigSerializer.serializeConfiguration(RegistryBasedSynapseConfigSerializer.java:102) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager.saveFullConfiguration(MediationPersistenceManager.java:487) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager.persistElement(MediationPersistenceManager.java:424) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager.access$1400(MediationPersistenceManager.java:51) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager$MediationPersistenceWorker.run(MediationPersistenceManager.java:403) > 2010-11-09 08:09:39,597 [-] [Thread-124] ERROR DatabaseUtil Using sql : > DELETE FROM UM_ROLE_PERMISSION WHERE UM_PERMISSION_ID IN (SELECT UM_ID FROM > UM_PERMISSION WHERE UM_RESOURCE_ID=?) AND UM_TENANT_ID=? > 2010-11-09 08:09:39,601 [-] [Thread-124] ERROR AuthorizationUtils Could not > clear authorizations. Error! Deadlock found when trying to get lock; try > restarting transaction > org.wso2.carbon.user.core.UserStoreException: Error! Deadlock found when > trying to get lock; try restarting transaction > at > org.wso2.carbon.user.core.util.DatabaseUtil.updateDatabase(DatabaseUtil.java:250) > at > org.wso2.carbon.user.core.authorization.JDBCAuthorizationManager.clearResourceAuthorizations(JDBCAuthorizationManager.java:279) > at > org.wso2.carbon.registry.core.jdbc.realm.RegistryAuthorizationManager.clearResourceAuthorizations(RegistryAuthorizationManager.java:149) > at > org.wso2.carbon.registry.core.utils.AuthorizationUtils.clearAuthorizations(AuthorizationUtils.java:128) > at > org.wso2.carbon.registry.core.jdbc.Repository.deleteNode(Repository.java:589) > at > org.wso2.carbon.registry.core.jdbc.Repository.deleteSubTree(Repository.java:531) > at > org.wso2.carbon.registry.core.jdbc.RecursionRepository.deleteSubTree(RecursionRepository.java:138) > at > org.wso2.carbon.registry.core.jdbc.Repository.deleteSubTree(Repository.java:526) > at > org.wso2.carbon.registry.core.jdbc.Repository.delete(Repository.java:444) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.delete(EmbeddedRegistry.java:744) > at > org.wso2.carbon.registry.core.session.UserRegistry.delete(UserRegistry.java:652) > at > org.wso2.carbon.registry.core.jdbc.handlers.builtin.MountHandler.delete(MountHandler.java:440) > at > org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.delete(HandlerManager.java:2483) > at > org.wso2.carbon.registry.core.jdbc.handlers.UserDefinedHandlerManager.delete(UserDefinedHandlerManager.java:215) > at > org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.delete(HandlerLifecycleManager.java:378) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.delete(EmbeddedRegistry.java:740) > at > org.wso2.carbon.registry.core.session.UserRegistry.delete(UserRegistry.java:652) > at > org.wso2.carbon.mediation.initializer.RegistryBasedSynapseConfigSerializer.clearSynapseConfigRegistrySpace(RegistryBasedSynapseConfigSerializer.java:235) > at > org.wso2.carbon.mediation.initializer.RegistryBasedSynapseConfigSerializer.serializeConfiguration(RegistryBasedSynapseConfigSerializer.java:102) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager.saveFullConfiguration(MediationPersistenceManager.java:487) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager.persistElement(MediationPersistenceManager.java:424) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager.access$1400(MediationPersistenceManager.java:51) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager$MediationPersistenceWorker.run(MediationPersistenceManager.java:403) > Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock > found when trying to get lock; try restarting transaction > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) > at com.mysql.jdbc.Util.getInstance(Util.java:384) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1066) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) > at > org.wso2.carbon.user.core.util.DatabaseUtil.updateDatabase(DatabaseUtil.java:242) > ... 22 more > > > -- > Supun Kamburugamuva > Technical Lead > WSO2 Inc.; http://wso2.org > E-mail: [email protected]; Mobile: +94 77 431 3585 > Blog: http://supunk.blogspot.com > > _______________________________________________ > Stratos-dev mailing list > [email protected] > https://wso2.org/cgi-bin/mailman/listinfo/stratos-dev > >
_______________________________________________ Carbon-dev mailing list [email protected] https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev
