Hi Malaka, I was advised by Chandana @Registry team that my error is due to frequency of the indexer job.
my "registry.xml" contains <indexingConfiguration> <startingDelayInSeconds>60</startingDelayInSeconds> <indexingFrequencyInSeconds>2</indexingFrequencyInSeconds> indexingFrequencyInSeconds is recommended to be 3~4 seconds rather than 2 seconds. Cheers, Ruwan On Fri, Jul 10, 2015 at 11:24 AM, Ruwan Abeykoon <[email protected]> wrote: > 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 > -- *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
