Looks like database got busy at that moment. Did you try the same operation again n see? H2 has more tendency to deadlock. /sumedha
On 11/26/11, Jorge Infante Osorio <jorg...@uci.cu> wrote: > Hi all. > Time to time when I update a proxy service in the filesystem I see this > error: > > [2011-11-26 01:09:42,765] ERROR - JDBCResourceDAO Failed to check the > existence of the resource > /_system/config/repository/synapse/default/proxy-services/DirectorioEstudian > ProxyTransac. Tiempo vencido intentando trabar (lock) la tabla > "REG_RESOURCE" > Timeout trying to lock table "REG_RESOURCE"; SQL statement: > SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=? AND > REG_TENANT_ID=? [50200-140] > org.h2.jdbc.JdbcSQLException: Tiempo vencido intentando trabar (lock) la > tabla "REG_RESOURCE" > Timeout trying to lock table "REG_RESOURCE"; SQL statement: > SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=? AND > REG_TENANT_ID=? [50200-140] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at org.h2.table.RegularTable.doLock(RegularTable.java:466) > at org.h2.table.RegularTable.lock(RegularTable.java:404) > at org.h2.table.TableFilter.lock(TableFilter.java:139) > at org.h2.command.dml.Select.queryWithoutCache(Select.java:554) > at org.h2.command.dml.Query.query(Query.java:241) > at org.h2.command.CommandContainer.query(CommandContainer.java:80) > at org.h2.command.Command.executeQuery(Command.java:132) > at > org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96 > ) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP > reparedStatement.java:96) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP > reparedStatement.java:96) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResour > ceDAO.java:191) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCRe > sourceDAO.java:142) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCRe > sourceDAO.java:151) > at > org.wso2.carbon.registry.core.jdbc.Repository.resourceExists(Repository.java > :164) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.resourceExists(EmbeddedR > egistry.java:644) > at > org.wso2.carbon.registry.core.caching.CacheBackedRegistry.resourceExists(Cac > heBackedRegistry.java:197) > at > org.wso2.carbon.registry.core.session.UserRegistry.resourceExists(UserRegist > ry.java:636) > at > org.wso2.carbon.mediation.initializer.persistence.registry.ProxyServiceRegis > tryStore.deleteElement(ProxyServiceRegistryStore.java:88) > at > org.wso2.carbon.mediation.initializer.persistence.AbstractStore.deleteFromRe > gistry(AbstractStore.java:200) > at > org.wso2.carbon.mediation.initializer.persistence.AbstractStore.delete(Abstr > actStore.java:107) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManage > r.deleteElement(MediationPersistenceManager.java:448) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManage > r.access$1500(MediationPersistenceManager.java:51) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManage > r$MediationPersistenceWorker.run(MediationPersistenceManager.java:420) > [2011-11-26 01:09:42,781] ERROR - AbstractRegistryStore Error in deleting > the proxy service at path : > /repository/synapse/default/proxy-services/DirectorioEstudiantesMultiP > sac > org.wso2.carbon.registry.core.exceptions.RegistryException: Failed to check > the existence of the resource > /_system/config/repository/synapse/default/proxy-services/Director > antesMultiProxyTransac. Tiempo vencido intentando trabar (lock) la tabla > "REG_RESOURCE" > Timeout trying to lock table "REG_RESOURCE"; SQL statement: > SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=? AND > REG_TENANT_ID=? [50200-140] > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResour > ceDAO.java:200) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCRe > sourceDAO.java:142) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCRe > sourceDAO.java:151) > at > org.wso2.carbon.registry.core.jdbc.Repository.resourceExists(Repository.java > :164) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.resourceExists(EmbeddedR > egistry.java:644) > at > org.wso2.carbon.registry.core.caching.CacheBackedRegistry.resourceExists(Cac > heBackedRegistry.java:197) > at > org.wso2.carbon.registry.core.session.UserRegistry.resourceExists(UserRegist > ry.java:636) > at > org.wso2.carbon.mediation.initializer.persistence.registry.ProxyServiceRegis > tryStore.deleteElement(ProxyServiceRegistryStore.java:88) > at > org.wso2.carbon.mediation.initializer.persistence.AbstractStore.deleteFromRe > gistry(AbstractStore.java:200) > at > org.wso2.carbon.mediation.initializer.persistence.AbstractStore.delete(Abstr > actStore.java:107) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManage > r.deleteElement(MediationPersistenceManager.java:448) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManage > r.access$1500(MediationPersistenceManager.java:51) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManage > r$MediationPersistenceWorker.run(MediationPersistenceManager.java:420) > Caused by: org.h2.jdbc.JdbcSQLException: Tiempo vencido intentando trabar > (lock) la tabla "REG_RESOURCE" > Timeout trying to lock table "REG_RESOURCE"; SQL statement: > SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=? AND > REG_TENANT_ID=? [50200-140] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at org.h2.table.RegularTable.doLock(RegularTable.java:466) > at org.h2.table.RegularTable.lock(RegularTable.java:404) > at org.h2.table.TableFilter.lock(TableFilter.java:139) > at org.h2.command.dml.Select.queryWithoutCache(Select.java:554) > at org.h2.command.dml.Query.query(Query.java:241) > at org.h2.command.CommandContainer.query(CommandContainer.java:80) > at org.h2.command.Command.executeQuery(Command.java:132) > at > org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96 > ) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP > reparedStatement.java:96) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP > reparedStatement.java:96) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResour > ceDAO.java:191) > ... 12 more > [2011-11-26 01:09:42,781] ERROR - MediationPersistenceManager Error while > saving mediation configuration changes > org.wso2.carbon.mediation.initializer.persistence.ServiceBusPersistenceExcep > tion: Error in deleting the proxy service at path : > /repository/synapse/default/proxy-services/D > oEstudiantesMultiProxyTransac > at > org.wso2.carbon.mediation.initializer.persistence.registry.AbstractRegistryS > tore.handleException(AbstractRegistryStore.java:94) > at > org.wso2.carbon.mediation.initializer.persistence.registry.ProxyServiceRegis > tryStore.deleteElement(ProxyServiceRegistryStore.java:92) > at > org.wso2.carbon.mediation.initializer.persistence.AbstractStore.deleteFromRe > gistry(AbstractStore.java:200) > at > org.wso2.carbon.mediation.initializer.persistence.AbstractStore.delete(Abstr > actStore.java:107) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManage > r.deleteElement(MediationPersistenceManager.java:448) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManage > r.access$1500(MediationPersistenceManager.java:51) > at > org.wso2.carbon.mediation.initializer.persistence.MediationPersistenceManage > r$MediationPersistenceWorker.run(MediationPersistenceManager.java:420) > Caused by: org.wso2.carbon.registry.core.exceptions.RegistryException: > Failed to check the existence of the resource > /_system/config/repository/synapse/default/proxy-servic > torioEstudiantesMultiProxyTransac. Tiempo vencido intentando trabar (lock) > la tabla "REG_RESOURCE" > Timeout trying to lock table "REG_RESOURCE"; SQL statement: > SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=? AND > REG_TENANT_ID=? [50200-140] > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResour > ceDAO.java:200) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCRe > sourceDAO.java:142) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCRe > sourceDAO.java:151) > at > org.wso2.carbon.registry.core.jdbc.Repository.resourceExists(Repository.java > :164) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.resourceExists(EmbeddedR > egistry.java:644) > at > org.wso2.carbon.registry.core.caching.CacheBackedRegistry.resourceExists(Cac > heBackedRegistry.java:197) > at > org.wso2.carbon.registry.core.session.UserRegistry.resourceExists(UserRegist > ry.java:636) > at > org.wso2.carbon.mediation.initializer.persistence.registry.ProxyServiceRegis > tryStore.deleteElement(ProxyServiceRegistryStore.java:88) > ... 5 more > Caused by: org.h2.jdbc.JdbcSQLException: Tiempo vencido intentando trabar > (lock) la tabla "REG_RESOURCE" > Timeout trying to lock table "REG_RESOURCE"; SQL statement: > SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=? AND > REG_TENANT_ID=? [50200-140] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at org.h2.table.RegularTable.doLock(RegularTable.java:466) > at org.h2.table.RegularTable.lock(RegularTable.java:404) > at org.h2.table.TableFilter.lock(TableFilter.java:139) > at org.h2.command.dml.Select.queryWithoutCache(Select.java:554) > at org.h2.command.dml.Query.query(Query.java:241) > at org.h2.command.CommandContainer.query(CommandContainer.java:80) > at org.h2.command.Command.executeQuery(Command.java:132) > at > org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96 > ) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP > reparedStatement.java:96) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP > reparedStatement.java:96) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResour > ceDAO.java:191) > ... 12 more > > Saludos, > Ing. Jorge Infante Osorio. > J´Dpto Soluciones SOA. > CDAE. > Fac. 5. > UCI. > > > > > Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE > ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU! > http://www.antiterroristas.cu > http://justiciaparaloscinco.wordpress.com > _______________________________________________ > Carbon-dev mailing list > Carbon-dev@wso2.org > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > -- Sent from my mobile device _______________________________________________ Carbon-dev mailing list Carbon-dev@wso2.org http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
