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
_______________________________________________ Carbon-dev mailing list [email protected] https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev
