Hi Malaka, This error might have been caused by one of the other method accessing the DB(embedded h2) fails, thus causing lock.
I have not got this error after I fixed other areas accessing DB. Please check if there is any failure prior to seeing above error. Cheers, Ruwan On Fri, Jul 10, 2015 at 10:38 AM, Malaka Silva <[email protected]> wrote: > We are also getting this while running the integration tests for ESB 4.9.0. > > What can be the cause of the issue? > > On Fri, Jul 3, 2015 at 10:40 AM, Ruwan Abeykoon <[email protected]> wrote: > >> Hi G-Reg team, >> I have encountered the following error while upgrading AppManager to use >> carbon 4.4.0 >> >> Registry version : 4.4.3 >> Governance Version : 4.5.1 >> >> What could be the cause? >> >> -------------------------------------------------- >> >> [2015-07-02 19:00:18,911] ERROR - AsyncIndexer Error while indexing. >> >> org.wso2.carbon.registry.core.exceptions.RegistryException: Error at >> IndexDocumentCreator when getting Registry Comment. >> >> at >> org.wso2.carbon.registry.indexing.indexer.IndexDocumentCreator.addComments(IndexDocumentCreator.java:217) >> >> at >> org.wso2.carbon.registry.indexing.indexer.IndexDocumentCreator.createIndexDocument(IndexDocumentCreator.java:110) >> >> at >> org.wso2.carbon.registry.indexing.AsyncIndexer$IndexingTask.createIndexDocument(AsyncIndexer.java:212) >> >> at >> org.wso2.carbon.registry.indexing.AsyncIndexer$IndexingTask.run(AsyncIndexer.java:196) >> >> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:262) >> >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> >> at java.lang.Thread.run(Thread.java:745) >> >> Caused by: org.wso2.carbon.registry.core.exceptions.RegistryException: >> Failed to check the existence of the resource >> /_system/governance/appmgt/applicationdata/provider/admin/a31/a31/webapp. >> 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(JDBCResourceDAO.java:206) >> >> at >> org.wso2.carbon.registry.core.utils.RegistryUtils.getResourceWithMinimumData(RegistryUtils.java:1804) >> >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCCommentsVersionDAO.getResourceWithMinimumData(JDBCCommentsVersionDAO.java:521) >> >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.getComments(EmbeddedRegistry.java:1980) >> >> at >> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.getComments(CacheBackedRegistry.java:381) >> >> at >> org.wso2.carbon.registry.core.session.UserRegistry.getCommentsInternal(UserRegistry.java:1590) >> >> at >> org.wso2.carbon.registry.core.session.UserRegistry.access$3100(UserRegistry.java:60) >> >> at >> org.wso2.carbon.registry.core.session.UserRegistry$32.run(UserRegistry.java:1573) >> >> at >> org.wso2.carbon.registry.core.session.UserRegistry$32.run(UserRegistry.java:1570) >> >> at java.security.AccessController.doPrivileged(Native Method) >> >> at >> org.wso2.carbon.registry.core.session.UserRegistry.getComments(UserRegistry.java:1570) >> >> at >> org.wso2.carbon.registry.indexing.indexer.IndexDocumentCreator.addComments(IndexDocumentCreator.java:213) >> >> ... 8 more >> >> Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table >> "REG_RESOURCE"; SQL statement: >> >> -- >> >> *Ruwan Abeykoon* >> *Architect,* >> *WSO2, Inc. http://wso2.com <http://wso2.com/> * >> *lean.enterprise.middleware.* >> >> email: [email protected] >> phone:(+94) 777739736 >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > > Best Regards, > > Malaka Silva > Senior Tech Lead > M: +94 777 219 791 > Tel : 94 11 214 5345 > Fax :94 11 2145300 > Skype : malaka.sampath.silva > LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 > Blog : http://mrmalakasilva.blogspot.com/ > > WSO2, Inc. > lean . enterprise . middleware > http://www.wso2.com/ > http://www.wso2.com/about/team/malaka-silva/ > <http://wso2.com/about/team/malaka-silva/> > > Save a tree -Conserve nature & Save the world for your future. Print this > email only if it is absolutely necessary. > -- *Ruwan Abeykoon* *Architect,* *WSO2, Inc. http://wso2.com <http://wso2.com/> * *lean.enterprise.middleware.* email: [email protected] phone:(+94) 777739736
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
