Hi Ajith, Senaka I saw that there have been some changes in registry.core recently, can this have any affect on this issue? .. basically currently in my local setup this works fine, because I haven't updated the kernel for a while, and my latest ntask code works properly with that. I'm anyway updating the whole platform code and going to do a build soon and check.
Cheers, Anjana. On Wed, Oct 3, 2012 at 6:53 PM, Senaka Fernando <[email protected]> wrote: > Hi Sinthuja, > > Please have a look @ Database Query Execution Statistics in [1]. This > should give a picture of what blocks the registry. > > [1] > http://docs.wso2.org/wiki/display/Governance450/System+Logs#SystemLogs-DatabaseQueryExecutionStatistics > > Thanks, > Senaka. > > On Wed, Oct 3, 2012 at 4:17 PM, Sinthuja Ragendran <[email protected]>wrote: > >> Hi, >> >> I'm unable to access registry and do any registry related operations >> after scheduling the script. But I can save the script without scheduling >> and every thing works fine. The problem comes only after scheduling the >> script. >> >> This is the exception trace. >> >> [2012-10-03 16:05:34,252] INFO >> {org.wso2.carbon.ntask.core.impl.AbstractQuartzTaskManager} - Task >> scheduled: test1 >> [2012-10-03 16:06:01,019] INFO >> {org.wso2.carbon.analytics.hive.task.HiveScriptExecutorTask} - Running >> script executor task for script test1. [Wed Oct 03 16:06:01 IST 2012] >> [2012-10-03 16:06:35,226] ERROR >> {org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO} - Failed to check >> the existence of the resource /_system/config/repository/hive/scripts. >> Timeout trying to lock table "REG_RESOURCE"; SQL statement: >> SELECT REG_VERSION 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_VERSION 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.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResourceDAO.java:184) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCResourceDAO.java:147) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCResourceDAO.java:156) >> at >> org.wso2.carbon.registry.core.jdbc.Repository.resourceExists(Repository.java:159) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.resourceExists(EmbeddedRegistry.java:644) >> at >> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.resourceExists(CacheBackedRegistry.java:249) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.resourceExists(UserRegistry.java:624) >> at >> org.wso2.carbon.analytics.hive.persistence.HiveScriptPersistenceManager.getAllHiveScriptNames(HiveScriptPersistenceManager.java:132) >> at >> org.wso2.carbon.analytics.hive.web.HiveScriptStoreService.getAllScriptNames(HiveScriptStoreService.java:130) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at >> org.apache.axis2.rpc.receivers.RPCUtil.invokeServiceClass(RPCUtil.java:212) >> at >> org.apache.axis2.rpc.receivers.RPCMessageReceiver.invokeBusinessLogic(RPCMessageReceiver.java:117) >> at >> org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40) >> at >> org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110) >> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:181) >> at >> org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:169) >> at >> org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:82) >> at >> org.wso2.carbon.core.transports.local.CarbonLocalTransportSender.finalizeSendWithToAddress(CarbonLocalTransportSender.java:45) >> at >> org.apache.axis2.transport.local.LocalTransportSender.invoke(LocalTransportSender.java:77) >> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443) >> at >> org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:406) >> at >> org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229) >> at >> org.apache.axis2.client.OperationClient.execute(OperationClient.java:165) >> at >> org.wso2.carbon.analytics.hive.stub.HiveScriptStoreServiceStub.getAllScriptNames(HiveScriptStoreServiceStub.java:653) >> at >> org.wso2.carbon.analytics.hive.ui.client.HiveScriptStoreClient.getAllScriptNames(HiveScriptStoreClient.java:51) >> at >> org.apache.jsp.hive_002dexplorer.listscripts_jsp._jspService(listscripts_jsp.java:143) >> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >> at >> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332) >> at >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) >> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >> at org.wso2.carbon.ui.JspServlet.service(JspServlet.java:161) >> at org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:80) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >> at >> org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPathServletAdaptor.java:36) >> at >> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:67) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >> at >> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:690) >> at >> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:599) >> at >> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:536) >> at >> org.eclipse.equinox.http.servlet.internal.RequestDispatcherAdaptor.include(RequestDispatcherAdaptor.java:37) >> at >> org.eclipse.equinox.http.helper.ContextPathServletAdaptor$RequestDispatcherAdaptor.include(ContextPathServletAdaptor.java:265) >> at >> org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966) >> at >> org.apache.jasper.runtime.PageContextImpl.doInclude(PageContextImpl.java:643) >> at >> org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:637) >> at sun.reflect.GeneratedMethodAccessor42.invoke(Unknown Source) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at org.apache.tiles.jsp.context.JspUtil.doInclude(JspUtil.java:87) >> at >> org.apache.tiles.jsp.context.JspTilesRequestContext.include(JspTilesRequestContext.java:88) >> at >> org.apache.tiles.jsp.context.JspTilesRequestContext.dispatch(JspTilesRequestContext.java:82) >> at >> org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:465) >> at >> org.apache.tiles.jsp.taglib.InsertAttributeTag.render(InsertAttributeTag.java:140) >> at >> org.apache.tiles.jsp.taglib.InsertAttributeTag.render(InsertAttributeTag.java:117) >> at >> org.apache.tiles.jsp.taglib.RenderTagSupport.execute(RenderTagSupport.java:171) >> at >> org.apache.tiles.jsp.taglib.RoleSecurityTagSupport.doEndTag(RoleSecurityTagSupport.java:75) >> at >> org.apache.tiles.jsp.taglib.ContainerTagSupport.doEndTag(ContainerTagSupport.java:80) >> at >> org.apache.jsp.admin.layout.template_jsp._jspx_meth_tiles_insertAttribute_7(template_jsp.java:539) >> at >> org.apache.jsp.admin.layout.template_jsp._jspService(template_jsp.java:290) >> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >> at >> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332) >> at >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) >> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >> at org.wso2.carbon.ui.JspServlet.service(JspServlet.java:161) >> at org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:80) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >> at >> org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPathServletAdaptor.java:36) >> at >> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:67) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >> at >> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:690) >> at >> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:477) >> at >> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) >> at >> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) >> at >> org.eclipse.equinox.http.servlet.internal.RequestDispatcherAdaptor.forward(RequestDispatcherAdaptor.java:30) >> at >> org.eclipse.equinox.http.helper.ContextPathServletAdaptor$RequestDispatcherAdaptor.forward(ContextPathServletAdaptor.java:258) >> at >> org.apache.tiles.servlet.context.ServletTilesRequestContext.forward(ServletTilesRequestContext.java:198) >> at >> org.apache.tiles.servlet.context.ServletTilesRequestContext.dispatch(ServletTilesRequestContext.java:185) >> at >> org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:419) >> at >> org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:370) >> at org.wso2.carbon.ui.action.ActionHelper.render(ActionHelper.java:52) >> at >> org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:101) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >> at >> org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPathServletAdaptor.java:36) >> at >> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:67) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >> at >> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.wso2.carbon.tomcat.ext.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:61) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:172) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:156) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:52) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) >> at >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) >> at java.lang.Thread.run(Thread.java:662) >> >> And further more... >> >> Caused by: org.wso2.carbon.registry.core.exceptions.RegistryException: >> Failed to check the existence of the resource >> /_system/config/repository/hive/scripts. Timeout trying to lock table >> "REG_RESOURCE"; SQL statement: >> SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME IS >> NULL 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.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCResourceDAO.java:147) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCResourceDAO.java:156) >> at >> org.wso2.carbon.registry.core.jdbc.Repository.resourceExists(Repository.java:159) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.resourceExists(EmbeddedRegistry.java:644) >> at >> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.resourceExists(CacheBackedRegistry.java:249) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.resourceExists(UserRegistry.java:624) >> at >> org.wso2.carbon.analytics.hive.persistence.HiveScriptPersistenceManager.getAllHiveScriptNames(HiveScriptPersistenceManager.java:132) >> ... 118 more >> Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table >> "REG_RESOURCE"; SQL statement: >> SELECT REG_VERSION 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.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResourceDAO.java:184) >> ... 125 more >> >> >> Thanks, >> Sinthuja. >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > *Senaka Fernando* > Member - Integration Technologies Management Committee; > Technical Lead; WSO2 Inc.; http://wso2.com* > Member; Apache Software Foundation; http://apache.org > > E-mail: senaka AT wso2.com > **P: +1 408 754 7388; ext: 51736*; *M: +94 77 322 1818 > Linked-In: http://linkedin.com/in/senakafernando > > *Lean . Enterprise . Middleware > > -- *Anjana Fernando* Associate Technical Lead WSO2 Inc. | http://wso2.com lean . enterprise . middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
