Sumedha Rubasinghe wrote: > > On Wed, Feb 24, 2010 at 11:57 AM, Ruwan Linton <[email protected] > <mailto:[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.. Sumedha, I didn't get it. :-( Shouldn't the next write wait till it releases the lock, or throw an error saying cannot insert/update to the database without deadlocking. At least to me, speeding up the write operation doesn't solve the problem. :-(
Thanks, Ruwan > > /sumedha > > > Thanks, > Ruwan > > > > Thanks, > > Senaka. > > > > On Wed, Feb 24, 2010 at 11:28 AM, Hiranya Jayathilaka > > <[email protected] <mailto:[email protected]> > <mailto:[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]> > <mailto:[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]> > <mailto:[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> <http://wso2.com>; > Mobile: +94 77 322 1818 > > > > http://www.wso2.com/ - "Lean . Enterprise . Middleware" > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Carbon-dev mailing list > > [email protected] <mailto:[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] <mailto:[email protected]>; cell: +94 77 341 3097 > blog: http://blog.ruwan.org > > Lean . Enterprise . Middleware > > > _______________________________________________ > Carbon-dev mailing list > [email protected] <mailto:[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 > -- 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
