I'm confused - what's the connection to the update stacktrace?
On 10/02/2021 02:17, Sushanth Vaddaram wrote:
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?
Try one or more of: 1/ Materializes the inference. 2/ Use simpler rules. 3/ Run in memory.
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]
