Hi Anjana, That solves the problem. I took update of ntask core and tried, now the problem is not there.
Thanks, Sinthuja. On Thu, Oct 4, 2012 at 12:51 PM, Anjana Fernando <[email protected]> wrote: > Hi Sinthuja, > > I've removed some scenarios of creating registry transaction contexts in > the ntask code, which were really not needed. But ideally, they should not > have any affect also, since this worked fine earlier also. Still, can you > just build the ntask.core and copy it to your product and see. I myself > couldn't properly build the full platform yet. > > Cheers, > Anjana. > > 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. >> > > > > -- > *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
