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
