On Wed, Feb 24, 2010 at 12:03 PM, Sumedha Rubasinghe <[email protected]>wrote:
> > On Wed, Feb 24, 2010 at 11:57 AM, Ruwan Linton <[email protected]> wrote: > >> 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 :-( >> > > If an insert (write) happens the database locks the table allowing only > read. So the only option available for us is to speed up write operation. > working on it.. > hi Sumedha, What is the transaction isolation level you use for these transactions? Amila. > > /sumedha > > >> Thanks, >> Ruwan >> > >> > Thanks, >> > Senaka. >> > >> > On Wed, Feb 24, 2010 at 11:28 AM, Hiranya Jayathilaka >> > <[email protected] <mailto:[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] <mailto:[email protected]>; Mobile: +94 >> > 77 633 3491 >> > Blog: http://techfeast-hiranya.blogspot.com >> > >> > _______________________________________________ >> > Carbon-dev mailing list >> > [email protected] <mailto:[email protected]> >> > 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 >> > [email protected] >> > 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: [email protected]; cell: +94 77 341 3097 >> blog: http://blog.ruwan.org >> >> Lean . Enterprise . Middleware >> >> >> _______________________________________________ >> Carbon-dev mailing list >> [email protected] >> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >> > > > _______________________________________________ > Carbon-dev mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > >
_______________________________________________ Carbon-dev mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
