On Fri, Jul 13, 2012 at 7:46 PM, Sumedha Rubasinghe <[email protected]>wrote:
> On Fri, Jul 13, 2012 at 7:36 PM, Sumedha Rubasinghe <[email protected]>wrote: > >> >> >> On Fri, Jul 13, 2012 at 7:25 PM, Senaka Fernando <[email protected]> wrote: >> >>> Hi Janaka, >>> >>> Does this have any connection with the way in which UUID >>> setting/fetching happens. Because that's something that happens when adding >>> a WSDL. Also, doesn't this get reproduced on G-Reg? Why only on AM? >>> >> >> API Manager just uses WS API to add an WSDL. So it should be easy to >> reproduce this. Janaka is doing that. >> > > Sorry. What I said is incorrect. We are directly using WSDLManager to add > WSDL. > https://svn.wso2.org/repos/wso2/branches/apimgt/1.0.0-beta2/platform/components/apimgt/org.wso2.carbon.apimgt.impl/src/main/java/org/wso2/carbon/apimgt/impl/utils/APIUtil.java Search for 'createWSDL' >> >>> >>> Thanks, >>> Senaka. >>> >>> >>> On Fri, Jul 13, 2012 at 9:47 AM, Sumedha Rubasinghe <[email protected]>wrote: >>> >>>> G-Reg team, >>>> Can we check the table access order again? >>>> The problem is only appearing when adding a WSDL. So I suspect the >>>> logic in WSDL media type handler. >>>> >>>> >>>> >>>> On Fri, Jul 13, 2012 at 7:08 PM, Charitha Kankanamge <[email protected] >>>> > wrote: >>>> >>>>> This is very simple to reproduce and an absolute blocker in >>>>> standalone H2 based deployment because if API provider mistakenly give >>>>> inaccessible or wrong WSDL url, whole registry becomes unusable. >>>>> >>>>> 1. In API manager, login to API publisher app >>>>> 2. Add a new API with a WSDL and make sure to specify a wsdl which is >>>>> not accessible >>>>> 3. Submit the form, you will get an error >>>>> 4. Now, correct the WSDL url and resubmit. >>>>> >>>>> Registry will be dead locked. After this, you will not be able to do >>>>> any registry related task. >>>>> >>>>> TID: [-1234] [WSO2 API Manager] [2012-07-13 18:48:34,054] ERROR >>>>> {org.wso2.carbon.governance.api.util.GovernanceUtils} - Error in getting >>>>> the result for media type: application/vnd.wso2.registry-ext-type+xml. >>>>> {org.wso2.carbon.governance.api.util.GovernanceUtils} >>>>> org.wso2.carbon.registry.core.exceptions.RegistryException: Timeout >>>>> trying to lock table "REG_RESOURCE"; SQL statement: >>>>> SELECT DISTINCT REG_PATH_ID, REG_NAME FROM REG_RESOURCE WHERE >>>>> (REG_RESOURCE.REG_TENANT_ID=?) AND REG_MEDIA_TYPE=? [50200-140] >>>>> at >>>>> org.wso2.carbon.registry.core.jdbc.dataaccess.SQLQueryProcessor.executeQuery(SQLQueryProcessor.java:240) >>>>> at >>>>> org.wso2.carbon.registry.core.jdbc.queries.QueryProcessorManager.executeQuery(QueryProcessorManager.java:137) >>>>> at >>>>> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.executeQuery(EmbeddedRegistry.java:2271) >>>>> at >>>>> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.executeQuery(CacheBackedRegistry.java:305) >>>>> at >>>>> org.wso2.carbon.registry.core.session.UserRegistry.executeQuery(UserRegistry.java:1246) >>>>> at >>>>> org.wso2.carbon.governance.api.util.GovernanceUtils.getResultPaths(GovernanceUtils.java:171) >>>>> at >>>>> org.wso2.carbon.governance.api.util.GovernanceUtils.findGovernanceArtifacts(GovernanceUtils.java:114) >>>>> at >>>>> org.wso2.carbon.governance.api.util.GovernanceUtils.findGovernanceArtifactConfigurations(GovernanceUtils.java:383) >>>>> at >>>>> org.wso2.carbon.governance.api.util.GovernanceUtils.findGovernanceArtifactConfiguration(GovernanceUtils.java:144) >>>>> at >>>>> org.wso2.carbon.governance.api.generic.GenericArtifactManager.<init>(GenericArtifactManager.java:83) >>>>> at >>>>> org.wso2.carbon.apimgt.impl.AbstractAPIManager.isContextExist(AbstractAPIManager.java:260) >>>>> at >>>>> org.wso2.carbon.apimgt.hostobjects.APIProviderHostObject.jsFunction_isContextExist(APIProviderHostObject.java:1213) >>>>> 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.mozilla.javascript.MemberBox.invoke(MemberBox.java:160) >>>>> at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:411) >>>>> at >>>>> org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76) >>>>> at >>>>> org.wso2.carbon.rhino.modules.api.c3._c2(/publisher/modules/api/add.jag:31) >>>>> at >>>>> org.wso2.carbon.rhino.modules.api.c3.call(/publisher/modules/api/add.jag) >>>>> at >>>>> org.mozilla.javascript.ScriptRuntime.applyOrCall(ScriptRuntime.java:2347) >>>>> at >>>>> org.mozilla.javascript.BaseFunction.execIdCall(BaseFunction.java:272) >>>>> at >>>>> org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:127) >>>>> at >>>>> org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76) >>>>> at >>>>> org.wso2.carbon.rhino.modules.api.c0._c3(/publisher/modules/api/module.jag:12) >>>>> at >>>>> org.wso2.carbon.rhino.modules.api.c0.call(/publisher/modules/api/module.jag) >>>>> at >>>>> org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76) >>>>> at >>>>> org.wso2.carbon.rhino.site.blocks.item_add.ajax.c0._c1(/publisher/site/blocks/item-add/ajax/add.jag:73) >>>>> at >>>>> org.wso2.carbon.rhino.site.blocks.item_add.ajax.c0.call(/publisher/site/blocks/item-add/ajax/add.jag) >>>>> at >>>>> org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57) >>>>> at >>>>> org.wso2.carbon.rhino.site.blocks.item_add.ajax.c0._c0(/publisher/site/blocks/item-add/ajax/add.jag:4) >>>>> at >>>>> org.wso2.carbon.rhino.site.blocks.item_add.ajax.c0.call(/publisher/site/blocks/item-add/ajax/add.jag) >>>>> at >>>>> org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401) >>>>> at >>>>> org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003) >>>>> at >>>>> org.wso2.carbon.rhino.site.blocks.item_add.ajax.c0.call(/publisher/site/blocks/item-add/ajax/add.jag) >>>>> at >>>>> org.wso2.carbon.rhino.site.blocks.item_add.ajax.c0.exec(/publisher/site/blocks/item-add/ajax/add.jag) >>>>> at >>>>> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:443) >>>>> at >>>>> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:202) >>>>> at >>>>> org.jaggeryjs.jaggery.core.manager.WebAppManager.execute(WebAppManager.java:223) >>>>> at >>>>> org.jaggeryjs.jaggery.core.JaggeryServlet.doPost(JaggeryServlet.java:51) >>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) >>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >>>>> 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.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:133) >>>>> 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:49) >>>>> 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) >>>>> TID: [-1234] [WSO2 API Manager] [2012-07-13 18:48:34,074] ERROR >>>>> {org.wso2.carbon.apimgt.impl.UserAwareAPIProvider} - Failed to check >>>>> context availability : /aaa >>>>> {org.wso2.carbon.apimgt.impl.UserAwareAPIProvider} >>>>> org.wso2.carbon.governance.api.exception.GovernanceException: Unable >>>>> to obtain governance artifact configuration >>>>> at >>>>> org.wso2.carbon.governance.api.generic.GenericArtifactManager.<init>(GenericArtifactManager.java:93) >>>>> at >>>>> org.wso2.carbon.apimgt.impl.AbstractAPIManager.isContextExist(AbstractAPIManager.java:260) >>>>> at >>>>> org.wso2.carbon.apimgt.hostobjects.APIProviderHostObject.jsFunction_isContextExist(APIProviderHostObject.java:1213) >>>>> 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.mozilla.javascript.MemberBox.invoke(MemberBox.java:160) >>>>> at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:411) >>>>> at >>>>> org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76) >>>>> at >>>>> org.wso2.carbon.rhino.modules.api.c3._c2(/publisher/modules/api/add.jag:31) >>>>> at >>>>> org.wso2.carbon.rhino.modules.api.c3.call(/publisher/modules/api/add.jag) >>>>> at >>>>> org.mozilla.javascript.ScriptRuntime.applyOrCall(ScriptRuntime.java:2347) >>>>> at >>>>> org.mozilla.javascript.BaseFunction.execIdCall(BaseFunction.java:272) >>>>> at >>>>> org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:127) >>>>> at >>>>> org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76) >>>>> at >>>>> org.wso2.carbon.rhino.modules.api.c0._c3(/publisher/modules/api/module.jag:12) >>>>> at >>>>> org.wso2.carbon.rhino.modules.api.c0.call(/publisher/modules/api/module.jag) >>>>> at >>>>> org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76) >>>>> at >>>>> org.wso2.carbon.rhino.site.blocks.item_add.ajax.c0._c1(/publisher/site/blocks/item-add/ajax/add.jag:73) >>>>> at >>>>> org.wso2.carbon.rhino.site.blocks.item_add.ajax.c0.call(/publisher/site/blocks/item-add/ajax/add.jag) >>>>> at >>>>> org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57) >>>>> at >>>>> org.wso2.carbon.rhino.site.blocks.item_add.ajax.c0._c0(/publisher/site/blocks/item-add/ajax/add.jag:4) >>>>> at >>>>> org.wso2.carbon.rhino.site.blocks.item_add.ajax.c0.call(/publisher/site/blocks/item-add/ajax/add.jag) >>>>> at >>>>> org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401) >>>>> at >>>>> org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003) >>>>> at >>>>> org.wso2.carbon.rhino.site.blocks.item_add.ajax.c0.call(/publisher/site/blocks/item-add/ajax/add.jag) >>>>> at >>>>> org.wso2.carbon.rhino.site.blocks.item_add.ajax.c0.exec(/publisher/site/blocks/item-add/ajax/add.jag) >>>>> at >>>>> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:443) >>>>> at >>>>> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:202) >>>>> at >>>>> org.jaggeryjs.jaggery.core.manager.WebAppManager.execute(WebAppManager.java:223) >>>>> at >>>>> org.jaggeryjs.jaggery.core.JaggeryServlet.doPost(JaggeryServlet.java:51) >>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) >>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >>>>> 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.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:133) >>>>> 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:49) >>>>> 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) >>>>> Caused by: >>>>> org.wso2.carbon.governance.api.exception.GovernanceException: Error in >>>>> getting the result for media type: >>>>> application/vnd.wso2.registry-ext-type+xml. >>>>> at >>>>> org.wso2.carbon.governance.api.util.GovernanceUtils.getResultPaths(GovernanceUtils.java:175) >>>>> at >>>>> org.wso2.carbon.governance.api.util.GovernanceUtils.findGovernanceArtifacts(GovernanceUtils.java:114) >>>>> at >>>>> org.wso2.carbon.governance.api.util.GovernanceUtils.findGovernanceArtifactConfigurations(GovernanceUtils.java:383) >>>>> at >>>>> org.wso2.carbon.governance.api.util.GovernanceUtils.findGovernanceArtifactConfiguration(GovernanceUtils.java:144) >>>>> at >>>>> org.wso2.carbon.governance.api.generic.GenericArtifactManager.<init>(GenericArtifactManager.java:83) >>>>> ... 52 more >>>>> Caused by: org.wso2.carbon.registry.core.exceptions.RegistryException: >>>>> Timeout trying to lock table "REG_RESOURCE"; SQL statement: >>>>> SELECT DISTINCT REG_PATH_ID, REG_NAME FROM REG_RESOURCE WHERE >>>>> (REG_RESOURCE.REG_TENANT_ID=?) AND REG_MEDIA_TYPE=? [50200-140] >>>>> at >>>>> org.wso2.carbon.registry.core.jdbc.dataaccess.SQLQueryProcessor.executeQuery(SQLQueryProcessor.java:240) >>>>> at >>>>> org.wso2.carbon.registry.core.jdbc.queries.QueryProcessorManager.executeQuery(QueryProcessorManager.java:137) >>>>> at >>>>> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.executeQuery(EmbeddedRegistry.java:2271) >>>>> at >>>>> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.executeQuery(CacheBackedRegistry.java:305) >>>>> at >>>>> org.wso2.carbon.registry.core.session.UserRegistry.executeQuery(UserRegistry.java:1246) >>>>> at >>>>> org.wso2.carbon.governance.api.util.GovernanceUtils.getResultPaths(GovernanceUtils.java:171) >>>>> ... 56 more >>>>> >>>>> >>>>> Apparently, this seems to be a known issue and reported multiple >>>>> times(e.g: https://wso2.org/jira/browse/CARBON-11409), the suggested >>>>> workaround is to use mysql. However, in API manager scenario, the error is >>>>> very prominent. >>>>> >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> [email protected] >>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> /sumedha >>>> +94 773017743 >>>> >>> >>> >>> >>> -- >>> *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 >>> >>> >> >> >> -- >> /sumedha >> +94 773017743 >> > > > > -- > /sumedha > +94 773017743 > -- /sumedha +94 773017743
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
