[Stratos-dev] Registry deadlocked in ESB private cloud
Ruwan Linton
ruwan at wso2.com
Tue Nov 9 02:10:58 PST 2010
On 11/9/10 3:10 PM, Sumedha Rubasinghe wrote:
> It's the User Manager. Is this problem solved now? Seeing this frequently?
Yes we see this very frequently on the private cloud, if 2 or 3 users
started to work on private cloud you get it.
Thanks,
Ruwan
>
> /sumedha
>
> On Tue, Nov 9, 2010 at 1:46 PM, Supun Kamburugamuva <supun at wso2.com
> <mailto:supun at wso2.com>> 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: supun at wso2.com <mailto:supun at wso2.com>; Mobile: +94 77
> 431 3585
> Blog: http://supunk.blogspot.com
>
> _______________________________________________
> Stratos-dev mailing list
> Stratos-dev at wso2.org <mailto:Stratos-dev at wso2.org>
> https://wso2.org/cgi-bin/mailman/listinfo/stratos-dev
>
>
>
> _______________________________________________
> Stratos-dev mailing list
> Stratos-dev at wso2.org
> https://wso2.org/cgi-bin/mailman/listinfo/stratos-dev
--
Ruwan Linton
Software Architect& Product Manager, WSO2 ESB; http://wso2.org/esb
WSO2 Inc.; http://wso2.com
Lean . Enterprise . Middleware
phone: +1 408 754 7388 ext 51789
email: ruwan at wso2.com; cell: +94 77 341 3097
blog: http://blog.ruwan.org
linkedin: http://www.linkedin.com/in/ruwanlinton
tweet: http://twitter.com/ruwanlinton
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://wso2.org/pipermail/stratos-dev/attachments/20101109/97a533f4/attachment-0001.htm>
More information about the Stratos-dev
mailing list