I think I know the reason for this issue. The code had an error where all tenant's stuff are persisted into the STs registry. The deployment tasks of the ST & tenant azeez.org would have clashed causing this issue.
On Wed, May 30, 2012 at 9:47 PM, Afkham Azeez <[email protected]> wrote: > I ran a distributed load test today on a tenant in AppServer, and under > load, the following exception was being printed from time to time. Possibly > a registry issue or an issue with the stats persistence code. This > deployment task runs every 15 seconds or so. I'd advice that we remove the > stat persistence code until it is properly reviewed & tested. > > > [2012-05-30 21:42:28,675] ERROR > {org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO} - Failed to get > the resource at path > /_system/local/repository/components/org.wso2.carbon.system.statistics/services/echo. > Timeout trying to lock table "REG_RESOURCE"; SQL statement: > SELECT REG_MEDIA_TYPE, REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, > REG_LAST_UPDATED_TIME, REG_VERSION, REG_DESCRIPTION, REG_CONTENT_ID, > REG_UUID FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME IS NULL AND > REG_TENANT_ID=? [50200-140] > org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "REG_RESOURCE"; > SQL statement: > SELECT REG_MEDIA_TYPE, REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, > REG_LAST_UPDATED_TIME, REG_VERSION, REG_DESCRIPTION, REG_CONTENT_ID, > REG_UUID FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME IS NULL 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(DelegatingPreparedStatement.java:96) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getResourceMetaData(JDBCResourceDAO.java:1131) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getResourceMetaData(JDBCResourceDAO.java:1084) > at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:209) > at > org.wso2.carbon.registry.core.jdbc.handlers.filters.MediaTypeMatcher.handleGet(MediaTypeMatcher.java:130) > at > org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.get(HandlerManager.java:2439) > at > org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.get(HandlerLifecycleManager.java:955) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.get(EmbeddedRegistry.java:512) > at > org.wso2.carbon.registry.core.caching.CacheBackedRegistry.get(CacheBackedRegistry.java:133) > at > org.wso2.carbon.registry.core.session.UserRegistry.get(UserRegistry.java:516) > at > org.wso2.carbon.statistics.persistance.StatisticsPersistenceScheduler.persistServiceStatistics(StatisticsPersistenceScheduler.java:101) > at > org.wso2.carbon.statistics.persistance.StatisticsPersistenceScheduler.invoke(StatisticsPersistenceScheduler.java:38) > at > org.wso2.carbon.core.deployment.CarbonDeploymentSchedulerTask.invokeCarbonDeploymentSchedulerExtenders(CarbonDeploymentSchedulerTask.java:101) > > -- > *Afkham Azeez* > Director of Architecture; WSO2, Inc.; http://wso2.com > Member; Apache Software Foundation; http://www.apache.org/ > * <http://www.apache.org/>** > email: **[email protected]* <[email protected]>* cell: +94 77 3320919 > blog: **http://blog.afkham.org* <http://blog.afkham.org>* > twitter: **http://twitter.com/afkham_azeez*<http://twitter.com/afkham_azeez> > * > linked-in: **http://lk.linkedin.com/in/afkhamazeez* > * > * > *Lean . Enterprise . Middleware* > > -- *Afkham Azeez* Director of Architecture; WSO2, Inc.; http://wso2.com Member; Apache Software Foundation; http://www.apache.org/ * <http://www.apache.org/>** email: **[email protected]* <[email protected]>* cell: +94 77 3320919 blog: **http://blog.afkham.org* <http://blog.afkham.org>* twitter: **http://twitter.com/afkham_azeez*<http://twitter.com/afkham_azeez> * linked-in: **http://lk.linkedin.com/in/afkhamazeez* * * *Lean . Enterprise . Middleware*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
