4 Replies Latest reply on Feb 22, 2010 5:11 PM by 715399

    When i run load test on oracle RDF i get the following modelname_RI busy

    688006
      Hi
      Issue:
      When running load test for 250 VU on oracle RDF getting the following error:

      modelname_RI table busy

      This happens for all methods that use inferencing.

      Inferencing used in the application is:

      graph.performInference();

      Kindly suggest wts the remedy for the issue
        • 1. Re: When i run load test on oracle RDF i get the following modelname_RI busy
          715399
          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
            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
              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
                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