Senaka, In this instance it was just trying to create an individual resource in the config registry.
Thanks, Hiranya On Wed, Feb 24, 2010 at 11:38 AM, Senaka Fernando <[email protected]> wrote: > This could be due to overlapping transactions in this particular component > that attempts to write to the registry at once. > > Thanks, > Senaka. > > On Wed, Feb 24, 2010 at 11:28 AM, Hiranya Jayathilaka <[email protected]>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: [email protected]; Mobile: +94 77 633 3491 >> Blog: http://techfeast-hiranya.blogspot.com >> >> _______________________________________________ >> Carbon-dev mailing list >> [email protected] >> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >> >> > > > -- > Senaka Fernando > Software Engineer > WSO2 Inc. > E-mail: senaka AT wso2.com; Mobile: +94 77 322 1818 > > http://www.wso2.com/ - "Lean . Enterprise . Middleware" > > _______________________________________________ > Carbon-dev mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > -- Hiranya Jayathilaka Software Engineer; WSO2 Inc.; http://wso2.org E-mail: [email protected]; Mobile: +94 77 633 3491 Blog: http://techfeast-hiranya.blogspot.com
_______________________________________________ Carbon-dev mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
