On Mon, Apr 22, 2013 at 9:38 PM, Eranda Sooriyabandara <[email protected]>wrote:
> Hi Sanjeewa, > > > On Mon, Apr 22, 2013 at 6:59 PM, Sanjeewa Malalgoda <[email protected]>wrote: > >> Hi All, >> I'm executing following code block to create wsdl and add it to registry. >> But if i entered wsdl url which does not exists it gives following error. >> In addition to that registry become totally unusable until we restart >> server. I have tested scenario in standalone pack and distributed >> setup(mysql and shared registry). Please let us know what is the issue here. >> >> Thanks. >> Sanjeewa. >> >> Code block >> ---------------- >> WsdlManager wsdlManager = new WsdlManager(registry); >> Wsdl wsdl = wsdlManager.newWsdl(wsdlUrl); >> wsdlManager.addWsdl(wsdl); >> > > > Use Governance Registry instead normal registry should solve the problem. > Governance Registry can be obtain using the following code. > > Registry governanceRegistry = > GovernanceUtils.getGovernanceUserRegistry(registry, username); > Hi Eranda, I'm getting registry as follows which is the same way you mentioned. this.registry = ServiceReferenceHolder.getInstance(). getRegistryService().getGovernanceUserRegistry(tenantUserName, tenantId); Any idea? Thanks, Sanjeewa > > thanks > Eranda > > >> >> >> Server Log >> --------------- >> [2013-04-22 18:52:32,026] ERROR - GovernanceUtils Error in getting the >> result for media type: application/vnd.wso2.registry-ext-type+xml. >> 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:242) >> at >> org.wso2.carbon.registry.core.jdbc.queries.QueryProcessorManager.executeQuery(QueryProcessorManager.java:137) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.executeQuery(EmbeddedRegistry.java:2276) >> at >> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.executeQuery(CacheBackedRegistry.java:354) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.executeQuery(UserRegistry.java:1252) >> at >> org.wso2.carbon.governance.api.util.GovernanceUtils.getResultPaths(GovernanceUtils.java:176) >> at >> org.wso2.carbon.governance.api.util.GovernanceUtils.findGovernanceArtifacts(GovernanceUtils.java:119) >> at >> org.wso2.carbon.governance.api.util.GovernanceUtils.findGovernanceArtifactConfigurations(GovernanceUtils.java:398) >> at >> org.wso2.carbon.governance.api.util.GovernanceUtils.loadGovernanceArtifacts(GovernanceUtils.java:226) >> at >> org.wso2.carbon.apimgt.impl.utils.APIUtil.getArtifactManager(APIUtil.java:622) >> at >> org.wso2.carbon.apimgt.impl.AbstractAPIManager.getAllAPIs(AbstractAPIManager.java:239) >> at >> org.wso2.carbon.apimgt.hostobjects.APIProviderHostObject.jsFunction_getAllAPIs(APIProviderHostObject.java:997) >> 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.callProp0(OptRuntime.java:119) >> at >> org.jaggeryjs.rhino.publisher.modules.api.c2._c3(/publisher/modules/api/list.jag:97) >> at >> org.jaggeryjs.rhino.publisher.modules.api.c2.call(/publisher/modules/api/list.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.jaggeryjs.rhino.publisher.modules.api.c0._c8(/publisher/modules/api/module.jag:31) >> at >> org.jaggeryjs.rhino.publisher.modules.api.c0.call(/publisher/modules/api/module.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119) >> at >> org.jaggeryjs.rhino.publisher.site.blocks.listing.c0._c3(/publisher/site/blocks/listing/block.jag:37) >> at >> org.jaggeryjs.rhino.publisher.site.blocks.listing.c0.call(/publisher/site/blocks/listing/block.jag) >> at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66) >> at >> org.jaggeryjs.rhino.publisher.jagg.c0._c30(/publisher/jagg/jagg.jag:211) >> at org.jaggeryjs.rhino.publisher.jagg.c0.call(/publisher/jagg/jagg.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97) >> at >> org.jaggeryjs.rhino.publisher.jagg.c0._c31(/publisher/jagg/jagg.jag:274) >> at org.jaggeryjs.rhino.publisher.jagg.c0.call(/publisher/jagg/jagg.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97) >> at >> org.jaggeryjs.rhino.publisher.jagg.c0._c30(/publisher/jagg/jagg.jag:206) >> at org.jaggeryjs.rhino.publisher.jagg.c0.call(/publisher/jagg/jagg.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97) >> at >> org.jaggeryjs.rhino.publisher.jagg.c0._c31(/publisher/jagg/jagg.jag:271) >> at org.jaggeryjs.rhino.publisher.jagg.c0.call(/publisher/jagg/jagg.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97) >> at >> org.jaggeryjs.rhino.publisher.jagg.c0._c30(/publisher/jagg/jagg.jag:206) >> at org.jaggeryjs.rhino.publisher.jagg.c0.call(/publisher/jagg/jagg.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97) >> at >> org.jaggeryjs.rhino.publisher.jagg.c0._c42(/publisher/jagg/jagg.jag:436) >> at org.jaggeryjs.rhino.publisher.jagg.c0.call(/publisher/jagg/jagg.jag) >> at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66) >> at >> org.jaggeryjs.rhino.publisher.site.pages.c3._c1(/publisher/site/pages/index.jag:17) >> at >> org.jaggeryjs.rhino.publisher.site.pages.c3.call(/publisher/site/pages/index.jag) >> at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57) >> at >> org.jaggeryjs.rhino.publisher.site.pages.c3._c0(/publisher/site/pages/index.jag:10) >> at >> org.jaggeryjs.rhino.publisher.site.pages.c3.call(/publisher/site/pages/index.jag) >> at >> org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401) >> at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003) >> at >> org.jaggeryjs.rhino.publisher.site.pages.c3.call(/publisher/site/pages/index.jag) >> at >> org.jaggeryjs.rhino.publisher.site.pages.c3.exec(/publisher/site/pages/index.jag) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:441) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:191) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.execute(WebAppManager.java:269) >> at org.jaggeryjs.jaggery.core.JaggeryServlet.doGet(JaggeryServlet.java:24) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:735) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> 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:222) >> 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:171) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:177) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:161) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:57) >> 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:1004) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) >> 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:619) >> [2013-04-22 18:52:32,029] ERROR - APIUtil Failed to initialize >> GenericArtifactManager >> 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:180) >> at >> org.wso2.carbon.governance.api.util.GovernanceUtils.findGovernanceArtifacts(GovernanceUtils.java:119) >> at >> org.wso2.carbon.governance.api.util.GovernanceUtils.findGovernanceArtifactConfigurations(GovernanceUtils.java:398) >> at >> org.wso2.carbon.governance.api.util.GovernanceUtils.loadGovernanceArtifacts(GovernanceUtils.java:226) >> at >> org.wso2.carbon.apimgt.impl.utils.APIUtil.getArtifactManager(APIUtil.java:622) >> at >> org.wso2.carbon.apimgt.impl.AbstractAPIManager.getAllAPIs(AbstractAPIManager.java:239) >> at >> org.wso2.carbon.apimgt.hostobjects.APIProviderHostObject.jsFunction_getAllAPIs(APIProviderHostObject.java:997) >> 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.callProp0(OptRuntime.java:119) >> at >> org.jaggeryjs.rhino.publisher.modules.api.c2._c3(/publisher/modules/api/list.jag:97) >> at >> org.jaggeryjs.rhino.publisher.modules.api.c2.call(/publisher/modules/api/list.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.jaggeryjs.rhino.publisher.modules.api.c0._c8(/publisher/modules/api/module.jag:31) >> at >> org.jaggeryjs.rhino.publisher.modules.api.c0.call(/publisher/modules/api/module.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119) >> at >> org.jaggeryjs.rhino.publisher.site.blocks.listing.c0._c3(/publisher/site/blocks/listing/block.jag:37) >> at >> org.jaggeryjs.rhino.publisher.site.blocks.listing.c0.call(/publisher/site/blocks/listing/block.jag) >> at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66) >> at >> org.jaggeryjs.rhino.publisher.jagg.c0._c30(/publisher/jagg/jagg.jag:211) >> at org.jaggeryjs.rhino.publisher.jagg.c0.call(/publisher/jagg/jagg.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97) >> at >> org.jaggeryjs.rhino.publisher.jagg.c0._c31(/publisher/jagg/jagg.jag:274) >> at org.jaggeryjs.rhino.publisher.jagg.c0.call(/publisher/jagg/jagg.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97) >> at >> org.jaggeryjs.rhino.publisher.jagg.c0._c30(/publisher/jagg/jagg.jag:206) >> at org.jaggeryjs.rhino.publisher.jagg.c0.call(/publisher/jagg/jagg.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97) >> at >> org.jaggeryjs.rhino.publisher.jagg.c0._c31(/publisher/jagg/jagg.jag:271) >> at org.jaggeryjs.rhino.publisher.jagg.c0.call(/publisher/jagg/jagg.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97) >> at >> org.jaggeryjs.rhino.publisher.jagg.c0._c30(/publisher/jagg/jagg.jag:206) >> at org.jaggeryjs.rhino.publisher.jagg.c0.call(/publisher/jagg/jagg.jag) >> at >> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97) >> at >> org.jaggeryjs.rhino.publisher.jagg.c0._c42(/publisher/jagg/jagg.jag:436) >> at org.jaggeryjs.rhino.publisher.jagg.c0.call(/publisher/jagg/jagg.jag) >> at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66) >> at >> org.jaggeryjs.rhino.publisher.site.pages.c3._c1(/publisher/site/pages/index.jag:17) >> at >> org.jaggeryjs.rhino.publisher.site.pages.c3.call(/publisher/site/pages/index.jag) >> at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57) >> at >> org.jaggeryjs.rhino.publisher.site.pages.c3._c0(/publisher/site/pages/index.jag:10) >> at >> org.jaggeryjs.rhino.publisher.site.pages.c3.call(/publisher/site/pages/index.jag) >> at >> org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401) >> at >> org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003) >> at >> org.jaggeryjs.rhino.publisher.site.pages.c3.call(/publisher/site/pages/index.jag) >> at >> org.jaggeryjs.rhino.publisher.site.pages.c3.exec(/publisher/site/pages/index.jag) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:441) >> at >> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:191) >> at >> org.jaggeryjs.jaggery.core.manager.WebAppManager.execute(WebAppManager.java:269) >> at >> org.jaggeryjs.jaggery.core.JaggeryServlet.doGet(JaggeryServlet.java:24) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:735) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> 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:222) >> 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:171) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:177) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:161) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:57) >> 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:1004) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) >> 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:619) >> 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:242) >> at >> org.wso2.carbon.registry.core.jdbc.queries.QueryProcessorManager.executeQuery(QueryProcessorManager.java:137) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.executeQuery(EmbeddedRegistry.java:2276) >> at >> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.executeQuery(CacheBackedRegistry.java:354) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.executeQuery(UserRegistry.java:1252) >> at >> org.wso2.carbon.governance.api.util.GovernanceUtils.getResultPaths(GovernanceUtils.java:176) >> ... 77 more >> >> >> -- >> *Sanjeewa Malalgoda* >> WSO2 Inc. >> Mobile : +14084122175 | +94713068779 >> >> <http://sanjeewamalalgoda.blogspot.com/>blog >> :http://sanjeewamalalgoda.blogspot.com/<http://sanjeewamalalgoda.blogspot.com/> >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > *Eranda Sooriyabandara > *Software Engineer; > Integration Technologies Team; > WSO2 Inc.; http://wso2.com > Lean . Enterprise . Middleware > > E-mail: eranda AT wso2.com > Mobile: +94 716 472 816 > Linked-In: http://www.linkedin.com/in/erandasooriyabandara > Blog: http://emsooriyabandara.blogspot.com/ > > > > * > * > -- *Sanjeewa Malalgoda* WSO2 Inc. Mobile : +14084122175 | +94713068779 <http://sanjeewamalalgoda.blogspot.com/>blog :http://sanjeewamalalgoda.blogspot.com/<http://sanjeewamalalgoda.blogspot.com/>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
