Thanks Andy. We have about 7 lakh records in Jena . With inference all the queries are taking long time to process. Some of the queries are taking more than a minute to process. Without inference it is taking about a couple of seconds to process. How can we find what the issue might be in this scenario? With inference if normally Apache Jena takes this much time to process, what do you suggest so that the performance improves?
Thanks, Sushanth On 2021/02/09 09:05:19, Andy Seaborne <a...@apache.org> wrote: > This is rather terse. There's an exception during update ... that's > about all tells us. Can't see what is being updated or what the update is. > > If it is exactly the same setup as your other email, which service is > being updated? > > The nature of the update may be a factor. > > Could you produce a complete, minimal example please? > The current version of Jena s 3.17.0. > > Andy > > BTW: > > > tdb:fileMode "direct" ; > > Why? Not that the out of place declaration will have an effect. > > > > > <#tdbGraph> rdf:type tdb2:GraphTDB ; > > tdb2:location "C:\\etc\\fuseki/databases/dip5" ; > > tdb2:unionDefaultGraph true ; > > Better to use tdb2:database and link to a single, shared declaration. > > Andy > > On 09/02/2021 01:58, Sushanth Vaddaram wrote: > > Hi Andy, > > Please find the complete log > > > > org.apache.jena.fuseki.servlets.ActionErrorException: Can't become a write > > transaction > > at > > org.apache.jena.fuseki.servlets.ServletOps.errorOccurred(ServletOps.java:165) > > ~[jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.servlets.SPARQL_Update.execute(SPARQL_Update.java:239) > > ~[jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.servlets.SPARQL_Update.executeBody(SPARQL_Update.java:183) > > ~[jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.servlets.SPARQL_Update.execute(SPARQL_Update.java:98) > > ~[jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.servlets.ActionService.executeLifecycle(ActionService.java:58) > > ~[jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.servlets.SPARQL_Update.execPost(SPARQL_Update.java:83) > > ~[jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.servlets.ActionProcessor.process(ActionProcessor.java:34) > > ~[jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.servlets.ActionBase.process(ActionBase.java:55) > > ~[jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.servlets.ActionExecLib.execAction(ActionExecLib.java:106) > > [jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.server.Dispatcher.dispatchAction(Dispatcher.java:113) > > [jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.server.Dispatcher.process(Dispatcher.java:105) > > [jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.server.Dispatcher.dispatch(Dispatcher.java:99) > > [jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.servlets.FusekiFilter.doFilter(FusekiFilter.java:51) > > [jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) > > [catalina.jar:8.5.46] > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) > > [catalina.jar:8.5.46] > > at > > org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) > > [shiro-core-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) > > [shiro-core-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) > > [shiro-core-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) > > [shiro-web-1.5.1.jar:1.5.1] > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) > > [catalina.jar:8.5.46] > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) > > [catalina.jar:8.5.46] > > at > > org.apache.jena.fuseki.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:284) > > [jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:247) > > [jena-fuseki-core-3.15.0.jar:3.15.0] > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) > > [catalina.jar:8.5.46] > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) > > [catalina.jar:8.5.46] > > at > > org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) > > [log4j-web-2.13.1.jar:2.13.1] > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) > > [catalina.jar:8.5.46] > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) > > [catalina.jar:8.5.46] > > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) > > [catalina.jar:8.5.46] > > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) > > [catalina.jar:8.5.46] > > at > > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:528) > > [catalina.jar:8.5.46] > > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) > > [catalina.jar:8.5.46] > > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) > > [catalina.jar:8.5.46] > > at > > org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) > > [catalina.jar:8.5.46] > > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) > > [catalina.jar:8.5.46] > > at > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) > > [catalina.jar:8.5.46] > > at > > org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798) > > [tomcat-coyote.jar:8.5.46] > > at > > org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) > > [tomcat-coyote.jar:8.5.46] > > at > > org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:810) > > [tomcat-coyote.jar:8.5.46] > > at > > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500) > > [tomcat-coyote.jar:8.5.46] > > at > > org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) > > [tomcat-coyote.jar:8.5.46] > > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) > > [?:?] > > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) > > [?:?] > > at > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > > [tomcat-util.jar:8.5.46] > > at java.lang.Thread.run(Thread.java:834) [?:?] > > Caused by: org.apache.jena.dboe.transaction.txn.TransactionException: Can't > > become a write transaction > > at > > org.apache.jena.dboe.transaction.txn.Transaction.ensureWriteTxn(Transaction.java:256) > > ~[jena-dboe-transaction-3.15.0.jar:3.15.0] > > at > > org.apache.jena.tdb2.store.StorageTDB.ensureWriteTxn(StorageTDB.java:234) > > ~[jena-tdb2-3.15.0.jar:3.15.0] > > at org.apache.jena.tdb2.store.StorageTDB.add(StorageTDB.java:107) > > ~[jena-tdb2-3.15.0.jar:3.15.0] > > at > > org.apache.jena.dboe.storage.system.DatasetGraphStorage.add(DatasetGraphStorage.java:163) > > ~[jena-dboe-storage-3.15.0.jar:3.15.0] > > at > > org.apache.jena.sparql.core.DatasetGraphWrapper.add(DatasetGraphWrapper.java:176) > > ~[jena-arq-3.15.0.jar:3.15.0] > > at org.apache.jena.sparql.core.GraphView.performAdd(GraphView.java:149) > > ~[jena-arq-3.15.0.jar:3.15.0] > > at org.apache.jena.graph.impl.GraphBase.add(GraphBase.java:184) > > ~[jena-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.reasoner.rulesys.FBRuleInfGraph.performAdd(FBRuleInfGraph.java:620) > > ~[jena-core-3.15.0.jar:3.15.0] > > at org.apache.jena.graph.impl.GraphBase.add(GraphBase.java:184) > > ~[jena-core-3.15.0.jar:3.15.0] > > at > > org.apache.jena.sparql.core.DatasetGraphCollection.add(DatasetGraphCollection.java:46) > > ~[jena-arq-3.15.0.jar:3.15.0] > > at > > org.apache.jena.sparql.modify.UpdateEngineWorker.addToDatasetGraph(UpdateEngineWorker.java:540) > > ~[jena-arq-3.15.0.jar:3.15.0] > > at > > org.apache.jena.sparql.modify.UpdateEngineWorker.visit(UpdateEngineWorker.java:309) > > ~[jena-arq-3.15.0.jar:3.15.0] > > at > > org.apache.jena.sparql.modify.request.UpdateDataInsert.visit(UpdateDataInsert.java:27) > > ~[jena-arq-3.15.0.jar:3.15.0] > > at > > org.apache.jena.sparql.modify.UpdateVisitorSink.send(UpdateVisitorSink.java:46) > > ~[jena-arq-3.15.0.jar:3.15.0] > > at > > org.apache.jena.sparql.modify.UpdateVisitorSink.send(UpdateVisitorSink.java:26) > > ~[jena-arq-3.15.0.jar:3.15.0] > > at org.apache.jena.atlas.iterator.Iter.sendToSink(Iter.java:678) > > ~[jena-base-3.15.0.jar:3.15.0] > > at > > org.apache.jena.sparql.modify.UpdateProcessorBase.execute(UpdateProcessorBase.java:60) > > ~[jena-arq-3.15.0.jar:3.15.0] > > at org.apache.jena.update.UpdateAction.execute$(UpdateAction.java:228) > > ~[jena-arq-3.15.0.jar:3.15.0] > > at org.apache.jena.update.UpdateAction.execute(UpdateAction.java:194) > > ~[jena-arq-3.15.0.jar:3.15.0] > > at > > org.apache.jena.fuseki.servlets.SPARQL_Update.execute(SPARQL_Update.java:223) > > ~[jena-fuseki-core-3.15.0.jar:3.15.0] > > ... 55 more > > > > > > > > > > > > > > > > > > > > On 2021/02/08 22:52:35, Andy Seaborne <a...@apache.org> wrote: > >> Was there a "cause" exception recorded as well? > >> > >> On 08/02/2021 15:05, Sushanth Vaddaram wrote: > >>> [2021-02-08 20:26:03] Log4jLogger WARN ActionErrorException with cause > >>> org.apache.jena.fuseki.servlets.ActionErrorException: Can't become a > >>> write transaction > >>> at > >>> org.apache.jena.fuseki.servlets.ServletOps.errorOccurred(ServletOps.java:165) > >>> ~[jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.jena.fuseki.servlets.SPARQL_Update.execute(SPARQL_Update.java:239) > >>> ~[jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.jena.fuseki.servlets.SPARQL_Update.executeBody(SPARQL_Update.java:183) > >>> ~[jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.jena.fuseki.servlets.SPARQL_Update.execute(SPARQL_Update.java:98) > >>> ~[jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.jena.fuseki.servlets.ActionService.executeLifecycle(ActionService.java:58) > >>> ~[jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.jena.fuseki.servlets.SPARQL_Update.execPost(SPARQL_Update.java:83) > >>> ~[jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.jena.fuseki.servlets.ActionProcessor.process(ActionProcessor.java:34) > >>> ~[jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.jena.fuseki.servlets.ActionBase.process(ActionBase.java:55) > >>> ~[jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.jena.fuseki.servlets.ActionExecLib.execAction(ActionExecLib.java:106) > >>> [jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.jena.fuseki.server.Dispatcher.dispatchAction(Dispatcher.java:113) > >>> [jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.jena.fuseki.server.Dispatcher.process(Dispatcher.java:105) > >>> [jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.jena.fuseki.server.Dispatcher.dispatch(Dispatcher.java:99) > >>> [jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.jena.fuseki.servlets.FusekiFilter.doFilter(FusekiFilter.java:51) > >>> [jena-fuseki-core-3.15.0.jar:3.15.0] > >>> at > >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) > >>> [catalina.jar:8.5.46] > >>> at > >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) > >>> [catalina.jar:8.5.46] > >>> at > >>> org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) > >>> [shiro-web-1.5.1.jar:1.5.1] > >>> at > >>> org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) > >>> [shiro-web-1.5.1.jar:1.5.1] > >>> at > >>> org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) > >>> [shiro-web-1.5.1.jar:1.5.1] > >>> at > >>> org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) > >>> [shiro-web-1.5.1.jar:1.5.1] > >>> at > >>> org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) > >>> [shiro-web-1.5.1.jar:1.5.1] > >>> at > >>> org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) > >>> [shiro-web-1.5.1.jar:1.5.1] > >>> at > >>> org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) > >>> [shiro-web-1.5.1.jar:1.5.1] > >> >
