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 <[email protected]
<mailto:[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] <mailto:[email protected]>; Mobile: +94 77
431 3585
Blog: http://supunk.blogspot.com
_______________________________________________
Stratos-dev mailing list
[email protected] <mailto:[email protected]>
https://wso2.org/cgi-bin/mailman/listinfo/stratos-dev
_______________________________________________
Stratos-dev mailing list
[email protected]
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: [email protected]; cell: +94 77 341 3097
blog: http://blog.ruwan.org
linkedin: http://www.linkedin.com/in/ruwanlinton
tweet: http://twitter.com/ruwanlinton
_______________________________________________
Carbon-dev mailing list
[email protected]
https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev
