This content has been marked as final.
Show 4 replies
-
1. Re: When i run load test on oracle RDF i get the following modelname_RI busy
715399 Feb 17, 2010 2:07 AM (in response to 688006)Hi,
What is the Oracle database and Jena Adaptor version you are using? Could you specify the error number and stack trace if possible?
Thanks,
Vlad -
2. Re: When i run load test on oracle RDF i get the following modelname_RI busy
688006 Feb 17, 2010 3:13 AM (in response to 715399)database:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
Jena:2.0
Stack trace:
SEVERE: rethrew: oracle.spatial.rdf.client.jena.InvalidStatusException: executeBindings: ORA-20000: We do not have a valid rules index for this Model-Rulebase combination
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 695
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 222
ORA-06512: at line 1
oracle.spatial.rdf.client.jena.InvalidStatusException: executeBindings: ORA-20000: We do not have a valid rules index for this Model-Rulebase combination
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 695
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 222
ORA-06512: at line 1
at oracle.spatial.rdf.client.jena.OracleSemQueryPlan.executeBindings(OracleSemQueryPlan.java:329)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterBlockTriplesQH$StagePattern.<init>(QueryIterBlockTriplesQH.java:89)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterBlockTriplesQH.nextStage(QueryIterBlockTriplesQH.java:55)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.makeNextStage(QueryIterRepeatApply.java:92)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.hasNextBinding(QueryIterRepeatApply.java:54)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:69)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterSort.sort(QueryIterSort.java:47)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterSort.<init>(QueryIterSort.java:39)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterSort.<init>(QueryIterSort.java:34)
at com.hp.hpl.jena.sparql.engine.main.OpCompiler.compile(OpCompiler.java:355)
at com.hp.hpl.jena.sparql.engine.main.CompilerDispatch.visit(CompilerDispatch.java:163)
at com.hp.hpl.jena.sparql.algebra.op.OpOrder.visit(OpOrder.java:28)
at com.hp.hpl.jena.sparql.engine.main.CompilerDispatch.compile(CompilerDispatch.java:33)
at com.hp.hpl.jena.sparql.engine.main.OpCompiler.compileOp(OpCompiler.java:94)
at com.hp.hpl.jena.sparql.engine.main.OpCompiler.compile(OpCompiler.java:361)
at com.hp.hpl.jena.sparql.engine.main.CompilerDispatch.visit(CompilerDispatch.java:170)
at com.hp.hpl.jena.sparql.algebra.op.OpProject.visit(OpProject.java:38)
at com.hp.hpl.jena.sparql.engine.main.CompilerDispatch.compile(CompilerDispatch.java:33)
at com.hp.hpl.jena.sparql.engine.main.OpCompiler.compileOp(OpCompiler.java:94)
at com.hp.hpl.jena.sparql.engine.main.OpCompiler.compile(OpCompiler.java:72)
at com.hp.hpl.jena.sparql.engine.main.QueryEngineMain.eval(QueryEngineMain.java:44)
at com.hp.hpl.jena.sparql.engine.QueryEngineBase.createPlan(QueryEngineBase.java:86)
at com.hp.hpl.jena.sparql.engine.QueryEngineBase.getPlan(QueryEngineBase.java:75)
at com.hp.hpl.jena.sparql.engine.main.QueryEngineMain$1.create(QueryEngineMain.java:67)
at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.getPlan(QueryExecutionBase.java:282)
at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.startQueryIterator(QueryExecutionBase.java:259)
at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execResultSet(QueryExecutionBase.java:264)
at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execSelect(QueryExecutionBase.java:92)
at my.mimos.stp.kbinterface.impl.rdbms.common.UtilCommon.doSparqlSelect(UtilCommon.java:320)
at my.mimos.stp.kbinterface.impl.rdbms.oracle.OracleKBInterfaceDAO.processSPARQLQuery(OracleKBInterfaceDAO.java:1722)
at my.mimos.stp.kbinterface.impl.rdbms.oracle.OracleKBInterfaceDAO.processSPARQLQuery(OracleKBInterfaceDAO.java:1613)
at my.mimos.stp.kbinterface.impl.rdbms.common.RdbmsImpl.processSPARQLQuery(RdbmsImpl.java:245)
at my.mimos.stp.kbinterface.webservice.KBInterfaceService.processSPARQLQuery(Unknown Source)
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 com.sun.xml.ws.api.server.InstanceResolver$1.invoke(InstanceResolver.java:246)
at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146)
at com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:257)
at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:93)
at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:598)
at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:557)
at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:542)
at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:439)
at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:243)
at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:470)
at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:244)
at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:135)
at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doGet(WSServletDelegate.java:129)
at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doPost(WSServletDelegate.java:160)
at com.sun.xml.ws.transport.http.servlet.WSServlet.doPost(WSServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
com.hp.hpl.jena.shared.JenaException: rethrew: oracle.spatial.rdf.client.jena.InvalidStatusException: executeBindings: ORA-20000: We do not have a valid rules index for this Model-Rulebase combination
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 695
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 222
ORA-06512: at line 1
at oracle.spatial.rdf.client.jena.OracleSemQueryPlan.executeBindings(OracleSemQueryPlan.java:352)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterBlockTriplesQH$StagePattern.<init>(QueryIterBlockTriplesQH.java:89)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterBlockTriplesQH.nextStage(QueryIterBlockTriplesQH.java:55)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.makeNextStage(QueryIterRepeatApply.java:92)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.hasNextBinding(QueryIterRepeatApply.java:54)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:69)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterSort.sort(QueryIterSort.java:47)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterSort.<init>(QueryIterSort.java:39)
at com.hp.hpl.jena.sparql.engine.iterator.QueryIterSort.<init>(QueryIterSort.java:34)
at com.hp.hpl.jena.sparql.engine.main.OpCompiler.compile(OpCompiler.java:355)
at com.hp.hpl.jena.sparql.engine.main.CompilerDispatch.visit(CompilerDispatch.java:163)
at com.hp.hpl.jena.sparql.algebra.op.OpOrder.visit(OpOrder.java:28)
at com.hp.hpl.jena.sparql.engine.main.CompilerDispatch.compile(CompilerDispatch.java:33)
at com.hp.hpl.jena.sparql.engine.main.OpCompiler.compileOp(OpCompiler.java:94)
at com.hp.hpl.jena.sparql.engine.main.OpCompiler.compile(OpCompiler.java:361)
at com.hp.hpl.jena.sparql.engine.main.CompilerDispatch.visit(CompilerDispatch.java:170)
at com.hp.hpl.jena.sparql.algebra.op.OpProject.visit(OpProject.java:38)
at com.hp.hpl.jena.sparql.engine.main.CompilerDispatch.compile(CompilerDispatch.java:33)
at com.hp.hpl.jena.sparql.engine.main.OpCompiler.compileOp(OpCompiler.java:94)
at com.hp.hpl.jena.sparql.engine.main.OpCompiler.compile(OpCompiler.java:72)
at com.hp.hpl.jena.sparql.engine.main.QueryEngineMain.eval(QueryEngineMain.java:44)
at com.hp.hpl.jena.sparql.engine.QueryEngineBase.createPlan(QueryEngineBase.java:86)
at com.hp.hpl.jena.sparql.engine.QueryEngineBase.getPlan(QueryEngineBase.java:75)
at com.hp.hpl.jena.sparql.engine.main.QueryEngineMain$1.create(QueryEngineMain.java:67)
at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.getPlan(QueryExecutionBase.java:282)
at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.startQueryIterator(QueryExecutionBase.java:259)
at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execResultSet(QueryExecutionBase.java:264)
at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execSelect(QueryExecutionBase.java:92)
at my.mimos.stp.kbinterface.impl.rdbms.common.UtilCommon.doSparqlSelect(UtilCommon.java:320)
at my.mimos.stp.kbinterface.impl.rdbms.oracle.OracleKBInterfaceDAO.processSPARQLQuery(OracleKBInterfaceDAO.java:1722)
at my.mimos.stp.kbinterface.impl.rdbms.oracle.OracleKBInterfaceDAO.processSPARQLQuery(OracleKBInterfaceDAO.java:1613)
at my.mimos.stp.kbinterface.impl.rdbms.common.RdbmsImpl.processSPARQLQuery(RdbmsImpl.java:245)
at my.mimos.stp.kbinterface.webservice.KBInterfaceService.processSPARQLQuery(Unknown Source)
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 com.sun.xml.ws.api.server.InstanceResolver$1.invoke(InstanceResolver.java:246)
at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146)
at com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:257)
at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:93)
at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:598)
at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:557)
at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:542)
at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:439)
at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:243)
at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:470)
at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:244)
at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:135)
at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doGet(WSServletDelegate.java:129)
at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doPost(WSServletDelegate.java:160)
at com.sun.xml.ws.transport.http.servlet.WSServlet.doPost(WSServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
Caused by: oracle.spatial.rdf.client.jena.InvalidStatusException: executeBindings: ORA-20000: We do not have a valid rules index for this Model-Rulebase combination
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 695
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 222
ORA-06512: at line 1
at oracle.spatial.rdf.client.jena.OracleSemQueryPlan.executeBindings(OracleSemQueryPlan.java:329)
... 65 more -
3. Re: When i run load test on oracle RDF i get the following modelname_RI busy
688006 Feb 17, 2010 3:53 AM (in response to 715399)2010-02-17 11:48:31,328 [oracle.spatial.rdf.client.jena.SimpleLog] DEBUG - deleteInference: stmt BEGIN SDO_RDF_INFERENCE.DROP_RULES_INDEX(?); END;
2010-02-17 11:48:31,328 [oracle.spatial.rdf.client.jena.SimpleLog] DEBUG - executeCall: stmt = BEGIN SDO_RDF_INFERENCE.DROP_RULES_INDEX(?); END; bv1 = IB000104SRC001A_RI
2010-02-17 11:48:31,343 [my.mimos.stp.kbinterface.impl.rdbms.oracle.OracleKBInterfaceDAO] DEBUG - ERROR message : ORA-55330: rulebase or rules index "IB000104SRC001A_RI" (Rules Index) is busy
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.RDF_APIS_INTERNAL", line 2357
ORA-06512: at "MDSYS.RDF_APIS", line 463
ORA-06512: at line 1 -
4. Re: When i run load test on oracle RDF i get the following modelname_RI busy
715399 Feb 22, 2010 5:11 PM (in response to 688006)Hi,
According to the last error message (55330), the rules index was locked when you tried to drop it. Is it possibl somebody else was using it? Can you tell us more about the load testing set up (e.g., how many times do you perform inference, how many concurrent sessions, etc.) ?
Cheers,
Vlad