Senaka Fernando wrote: > This could be due to overlapping transactions in this particular > component that attempts to write to the registry at once. So does this mean that Registry cannot handle concurrent connections to a particular registry resource/collection? Well, even in that case it shouldn't deadlock :-(
Thanks, Ruwan > > Thanks, > Senaka. > > On Wed, Feb 24, 2010 at 11:28 AM, Hiranya Jayathilaka > <hira...@wso2.com <mailto:hira...@wso2.com>> wrote: > > Following exception encountered in the ESB while updating a proxy > service: > > > Exception in thread "Thread-23" > > org.wso2.carbon.mediation.initializer.persistence.ServiceBusPersistenceException: > Error while saving mediation configuration changes > at > > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager.handleException(MediationPersistenceManager.java:278) > at > > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager.access$1200(MediationPersistenceManager.java:48) > at > > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager$MediationPersistenceWorker.run(MediationPersistenceManager.java:320) > Caused by: > > org.wso2.carbon.mediation.initializer.persistence.ServiceBusPersistenceException: > Unable to persist the proxy service in the path : > /repository/synapse/proxy-services/FooProxy > at > > org.wso2.carbon.mediation.initializer.persistence.registry.AbstractRegistryStore.handleException(AbstractRegistryStore.java:101) > at > > org.wso2.carbon.mediation.initializer.persistence.registry.ProxyServiceRegistryStore.persistElement(ProxyServiceRegistryStore.java:72) > at > > org.wso2.carbon.mediation.initializer.persistence.AbstractStore.saveToRegistry(AbstractStore.java:154) > at > > org.wso2.carbon.mediation.initializer.persistence.AbstractStore.save(AbstractStore.java:82) > at > > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager.persistElement(MediationPersistenceManager.java:335) > at > > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager.access$1000(MediationPersistenceManager.java:48) > at > > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManager$MediationPersistenceWorker.run(MediationPersistenceManager.java:314) > Caused by: > org.wso2.carbon.registry.core.exceptions.RegistryException: Unable > to persist element > at > > org.wso2.carbon.mediation.initializer.persistence.registry.AbstractRegistryStore.persistElement(AbstractRegistryStore.java:95) > at > > org.wso2.carbon.mediation.initializer.persistence.registry.ProxyServiceRegistryStore.persistElement(ProxyServiceRegistryStore.java:69) > ... 5 more > Caused by: > org.wso2.carbon.registry.core.exceptions.RegistryException: Failed > to add log entry for resource > /_system/config/repository/synapse/proxy-services. Deadlock > detected. The current transaction was rolled back. Details: > Session #9 (user: WSO2CARBON) is waiting to lock > PUBLIC.REG_RESOURCE while locking PUBLIC.REG_ASSOCIATION > (exclusive), PUBLIC.REG_LOG (exclusive). > Session #12 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_LOG > while locking PUBLIC.REG_CONTENT_HISTORY (exclusive), > PUBLIC.REG_RESOURCE_HISTORY (exclusive), PUBLIC.REG_RESOURCE > (exclusive), PUBLIC.REG_CONTENT (exclusive), PUBLIC.REG_SNAPSHOT > (exclusive).; SQL statement: > INSERT INTO REG_LOG (REG_PATH, REG_USER_ID, REG_LOGGED_TIME, > REG_ACTION, REG_ACTION_DATA, REG_TENANT_ID) VALUES (?, ?, ?, ?, ?, > ?) [40001-112] > at > org.wso2.carbon.registry.core.jdbc.dao.LogsDAO.addLog(LogsDAO.java:79) > at > org.wso2.carbon.registry.core.jdbc.Repository.update(Repository.java:966) > at > > org.wso2.carbon.registry.core.jdbc.Repository.updateParent(Repository.java:947) > at > org.wso2.carbon.registry.core.jdbc.Repository.delete(Repository.java:403) > at > > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.delete(EmbeddedRegistry.java:807) > at > > org.wso2.carbon.registry.core.session.UserRegistry.delete(UserRegistry.java:625) > at > > org.wso2.carbon.mediation.initializer.persistence.registry.AbstractRegistryStore.persistElement(AbstractRegistryStore.java:79) > ... 6 more > Caused by: org.h2.jdbc.JdbcSQLException: Deadlock detected. The > current transaction was rolled back. Details: > Session #9 (user: WSO2CARBON) is waiting to lock > PUBLIC.REG_RESOURCE while locking PUBLIC.REG_ASSOCIATION > (exclusive), PUBLIC.REG_LOG (exclusive). > Session #12 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_LOG > while locking PUBLIC.REG_CONTENT_HISTORY (exclusive), > PUBLIC.REG_RESOURCE_HISTORY (exclusive), PUBLIC.REG_RESOURCE > (exclusive), PUBLIC.REG_CONTENT (exclusive), PUBLIC.REG_SNAPSHOT > (exclusive).; SQL statement: > INSERT INTO REG_LOG (REG_PATH, REG_USER_ID, REG_LOGGED_TIME, > REG_ACTION, REG_ACTION_DATA, REG_TENANT_ID) VALUES (?, ?, ?, ?, ?, > ?) [40001-112] > at org.h2.message.Message.getSQLException(Message.java:107) > at org.h2.message.Message.getSQLException(Message.java:118) > at org.h2.message.Message.getSQLException(Message.java:77) > at org.h2.table.TableData.doLock(TableData.java:428) > at org.h2.table.TableData.lock(TableData.java:375) > at org.h2.command.dml.Insert.update(Insert.java:99) > at org.h2.command.CommandContainer.update(CommandContainer.java:71) > at org.h2.command.Command.executeUpdate(Command.java:207) > at > > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139) > at > > org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128) > at > > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) > at > org.wso2.carbon.registry.core.jdbc.dao.LogsDAO.addLog(LogsDAO.java:72) > ... 12 more > > Thanks > -- > Hiranya Jayathilaka > Software Engineer; > WSO2 Inc.; http://wso2.org > E-mail: hira...@wso2.com <mailto:hira...@wso2.com>; Mobile: +94 > 77 633 3491 > Blog: http://techfeast-hiranya.blogspot.com > > _______________________________________________ > Carbon-dev mailing list > Carbon-dev@wso2.org <mailto:Carbon-dev@wso2.org> > https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > > > > -- > Senaka Fernando > Software Engineer > WSO2 Inc. > E-mail: senaka AT wso2.com <http://wso2.com>; Mobile: +94 77 322 1818 > > http://www.wso2.com/ - "Lean . Enterprise . Middleware" > ------------------------------------------------------------------------ > > _______________________________________________ > Carbon-dev mailing list > Carbon-dev@wso2.org > https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > -- Ruwan Linton Technical Lead & Product Manager; WSO2 ESB; http://wso2.org/esb WSO2 Inc.; http://wso2.org email: ru...@wso2.com; cell: +94 77 341 3097 blog: http://blog.ruwan.org Lean . Enterprise . Middleware _______________________________________________ Carbon-dev mailing list Carbon-dev@wso2.org https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev