BaseX-Talk

basex-talk@mailman.uni-konstanz.de

4 participants
5268 discussions

xquery insert via REST API
by Liedtke, Alexander 28 Aug '24

28 Aug '24

Hallo in die Runde, vielleicht kann mir hierzu jmd einen Tipp geben. Ich nutze die Rest API um via post xqueries (mit python requests) zu machen - das klappt mit z.B. replace auch problemlos. Gerne würde ich jedoch auch insert nutzen - allerdings bekomme ich hier grundsätzlich eine 500 response. Die query mache ich gemäß der Doku nach dem Beispielschema: insert nodes (<phone/>, <mail/>) into //name In den Logs von dba sehe ich hierzu nichts. Ich bekomme auch sonst keine Info auf der shell in Form einer Fehlermeldung. Der Test Request sieht wie folgt aus: xq = '<query><text> insert node <test/> into //object[@id="574"]</text></query>' url = 'http://localhost:8080/rest/ids/ObjectIDs.xml' header = {'Media-Type': 'application/xml', 'charset':'utf-8'} res = requests.post(url, headers=header, data=xq, auth=_auth.getBaseXAuth()) Hat hierzu vielleicht jemand Anmerkungen / Ideen? Vielen Dank im Voraus Alexander Liedtke

1 1

Basex java.lang.ArrayIndexOutOfBoundsException
by Chavez, Robert 19 Aug '24

19 Aug '24

Greetings, We are suddenly seeing the following error message when using the REST API and also when using to Web GUI when trying to list the contents of a database by clicking on the database name and also when clicking on “optimize” (screen shot of gui attached). Does anyone have experience with hw to handle this? Version: BaseX 10.4 Java: Amazon.com Inc., 17.0.12 OS: Linux, amd64 Thank you, Robert Unexpected error: Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de<mailto:basex-talk@mailman.uni-konstanz.de> Version: BaseX 10.4 Java: Amazon.com Inc., 17.0.12 OS: Linux, amd64 Stack Trace: java.lang.ArrayIndexOutOfBoundsException: Index 2147483647 out of bounds for length 17322 at org.basex.io.random.TableDiskAccess.fpre(TableDiskAccess.java:514) at org.basex.io.random.TableDiskAccess.cursor(TableDiskAccess.java:474) at org.basex.io.random.TableDiskAccess.read5(TableDiskAccess.java:180) at org.basex.data.Data.textRef(Data.java:467) at org.basex.data.DiskData.text(DiskData.java:272) at org.basex.query.func.db.DbListDetails$2.get(DbListDetails.java:96) at org.basex.query.func.db.DbListDetails$2.get(DbListDetails.java:1) at org.basex.query.func.fn.FnSubsequence.value(FnSubsequence.java:108) at org.basex.query.expr.IterMap.value(IterMap.java:106) at org.basex.query.expr.gflwor.Let$LetEval.next(Let.java:146) at org.basex.query.expr.gflwor.GFLWOR$1.next(GFLWOR.java:78) at org.basex.query.QueryContext.next(QueryContext.java:375) at org.basex.query.expr.constr.Constr.add(Constr.java:73) at org.basex.query.expr.constr.CElem.item(CElem.java:149) at org.basex.query.expr.constr.CElem.item(CElem.java:1) at org.basex.query.expr.ParseExpr.value(ParseExpr.java:51) at org.basex.query.expr.ParseExpr.iter(ParseExpr.java:46) at org.basex.query.expr.constr.Constr.add(Constr.java:72) at org.basex.query.expr.constr.CElem.item(CElem.java:149) at org.basex.query.expr.constr.CElem.item(CElem.java:1) at org.basex.query.expr.ParseExpr.value(ParseExpr.java:51) at org.basex.query.expr.ParseExpr.iter(ParseExpr.java:46) at org.basex.query.expr.List$1.iter(List.java:213) at org.basex.query.expr.List$1.next(List.java:181) at org.basex.query.QueryContext.next(QueryContext.java:375) at org.basex.query.expr.constr.Constr.add(Constr.java:73) at org.basex.query.expr.constr.CElem.item(CElem.java:149) at org.basex.query.expr.constr.CElem.item(CElem.java:1) at org.basex.query.expr.ParseExpr.value(ParseExpr.java:51) at org.basex.query.func.StaticFuncCall.evalArgs(StaticFuncCall.java:147) at org.basex.query.func.FuncCall.value(FuncCall.java:53) at org.basex.query.expr.ParseExpr.iter(ParseExpr.java:46) at org.basex.query.expr.gflwor.GFLWOR$1.next(GFLWOR.java:82) at org.basex.query.scope.MainModule$1.next(MainModule.java:55) at org.basex.http.restxq.RestXqResponse.serialize(RestXqResponse.java:79) at org.basex.http.web.WebResponse.create(WebResponse.java:58) at org.basex.http.restxq.RestXqServlet.run(RestXqServlet.java:72) at org.basex.http.BaseXServlet.service(BaseXServlet.java:69) at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:840)

2 4

recursively used variables
by Rob Stapper 12 Aug '24

12 Aug '24

Hi, The code[1] below and send as attachment generates a error message: “Static variable depends on itself: $Q{http://www.w3.org/2005/xquery-local-functions}test”. I use these variables to refer to my private functions in my modules so I can easyly refer to them in a inheritance situation. It’s not a big problem for me but I was wondering if the error-triggering is justified or that it should work. [1]=========================================== declare variable $local:test := local:test#1 ; declare %private function local:test( $i) { if ( $i > 0) then $local:test( $i - 1) } ; $local:test( 10) =========================================== Kind regards, Rob Stapper Sent from Mail for Windows 10 -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

4 7

Bug report
by Csaba Fekete 12 Aug '24

12 Aug '24

Hello The following works on Basex 10.7 but fails on Basex 11.1. The command I'm trying to run is: /opt/basex/bin/basex -v -c'OPEN mydb; ADD "/tmp/ZTH4ZRO.xml"' I've attached the XML file.The output I'm getting: Database 'mydb' was opened in 54.52 ms. Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 11.1 Java: Ubuntu, 11.0.19 OS: Linux, amd64 Stack Trace: java.lang.ArrayIndexOutOfBoundsException: arraycopy: length -1 is negative at java.base/java.lang.System.arraycopy(Native Method) at org.basex.util.Array.insert(Array.java:99) at org.basex.util.list.ObjectList.insert(ObjectList.java:153) at org.basex.index.resource.Docs.insert(Docs.java:166) at org.basex.index.resource.Resources.insert(Resources.java:71) at org.basex.data.Data.indexAdd(Data.java:1098) at org.basex.data.Data.insert(Data.java:836) at org.basex.query.up.atomic.Insert.apply(Insert.java:44) at org.basex.query.up.atomic.AtomicUpdateCache.applyUpdates(AtomicUpdateCache.java:291) at org.basex.query.up.atomic.AtomicUpdateCache.execute(AtomicUpdateCache.java:275) at org.basex.core.cmd.Add.lambda$run$0(Add.java:62) at org.basex.core.cmd.ACreate.update(ACreate.java:90) at org.basex.core.cmd.Add.run(Add.java:56) at org.basex.core.Command.run(Command.java:233) at org.basex.core.Command.execute(Command.java:93) at org.basex.api.client.LocalSession.execute(LocalSession.java:131) at org.basex.api.client.Session.execute(Session.java:36) at org.basex.core.CLI.execute(CLI.java:94) at org.basex.core.CLI.execute(CLI.java:78) at org.basex.core.CLI.execute(CLI.java:65) at org.basex.BaseX.<init>(BaseX.java:82) at org.basex.BaseX.main(BaseX.java:44)

2 3

Typos in BaseX documentation
by Amanda Galtman 09 Aug '24

09 Aug '24

Hi, BaseX team. I found a couple of typos in the BaseX documentation. I wouldn't mind fixing them myself if I knew how to do so in the new RESTXQ format. Is the source in GitHub, and are BaseX users encouraged to contribute corrections to the documentation? Here are the details, in case you'd rather fix them yourself. Typo 1: The page https://docs.basex.org/main/Standard_Functions starts with a stray "f" ("fThis page presents") Typo 2: On the page https://docs.basex.org/main/File_Functions, the following example is missing a closing curly brace before the final parenthesis: file:write('data.bin', xs:hexBinary('414243'), { 'method': 'basex') Thanks, Amanda

2 1

Ignoring non-fatal XML syntax issues in third-party HTML from command line
by Ross Goldberg 08 Aug '24

08 Aug '24

I am trying to use an xpath passed to basex on the macOS command line to extract data from a downloaded third-party HTML file. The file isn't completely valid xml syntax (but only in elements that aren't referenced by my xpath), so basex outputs errors instead of the data that I want. How can I configure basex to ignore xml syntax issues that aren't fatal for my xpath? If it cannot be so configured: - could that option be added as a new feature? - in the meantime, what other macOS command-line xpath parsers can ignore non-fatal XML syntax issues? Which of those support the newest versions of xpath, are performant, etc.? Thanks. Sent with Proton Mail secure email.

2 1

Performance & scaling
by Csaba Fekete 29 Jul '24

29 Jul '24

Hi I have read the Advanced User Guide section in the documentation and I got a lot of useful information but I'm still a little bit stuck. I have large (1 GB+) mostly single document databases and complex queries that often take too long to execute. Apart from optimizing the queries, what are my options to speed things up? Any ideas are welcome. 1) Vertical scaling - how does a single BaseX instance respond to adding more CPUs or RAM? Which one could improve performance? Apart from indexing, are there any fine-tuning options that could help improve performance? 2) Partitioning: would it make sense to break my documents into several smaller ones, run the queries against them in parallel and then merge the results? Has anyone done such optimization? Did it work? 2) Horizontal scaling: the docs read: *"The BaseX client-server architecture offers ACID-safe transactions, with multiple readers and writers."* - Where can I get a guide on how to set up a single writer - multiple readers architecture? Thank you Csaba

2 1

Duplicate IDs and function id()
by Andrew Sales 26 Jul '24

26 Jul '24

Hello, If I understand the spec for this function[1] correctly, at most one element should be returned for a given ID value: "If several elements have the same ID value, then E is the one that is first in document order." ("Rules", item 3) BaseX behaves differently from e.g. Saxon in this respect. The query: let $doc := document{<foo xml:id='a1'><bar xml:id='a1'/></foo>} return ( 'Saxon-HE 11.6:', xslt:transform($doc, <xsl:stylesheet xmlns:xsl=" http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" exclude-result-prefixes="xs" version="3.0"> <xsl:template match="/"> <xsl:sequence select="id('a1')"/> </xsl:template> </xsl:stylesheet>), 'BaseX 10.7:', $doc/id('a1') ) returns: Saxon-HE 11.6: <foo xml:id="a1"><bar xml:id="a1"/></foo> BaseX 10.7: <foo xml:id="a1"><bar xml:id="a1"/></foo> <bar xml:id="a1"/> i.e. Saxon returns only the first in document order, whereas BaseX returns both of them. Grateful for your thoughts, Andrew [1] https://www.w3.org/TR/xpath-functions-31/#func-id

2 1

BaseX 9.7 to BaseX 11: find a regex in an external file
by Josselin Morvan 19 Jul '24

19 Jul '24

Hi Everyone, I'm migrating a webapp from BaseX 9.7 to BaseX 11 and I'm having a problem with a wrapper function (just a function for adding content to an xml template file) Basically, this function looks for nodes in a template.xml file that matche regex to update the content of this file. Here is a small example : template.xml <foo> <bar>{content}</bar> </foo> Query: let $file := 'template.xml' let $wrap := fn:doc($file) let $regex := '\{(.+?)\}’ (: looking for something between curly braces :) return for $node in $data//* where $node[fn:matches(text(), $regex)] return $node This function worked with BaseX 9.7, but returns an error with BaseX 11 : [XPTY0004] Item expected, sequence found: ("
 ", "
"). However, if I put the content of template.xml in a variable, it works (even with BaseX 11): let $wrap := <foo> <bar>{{content}}</bar> (: just escaped curly braces :) </foo> let $regex := '\{(.+?)\}' return for $node in $wrap//* where $node[fn:matches(text(), $regex)] return $node (:<bar>{content}</bar>:) Do you have any idea of what I'm doing wrong or what I’m missing? Thanks for your help! Best, Josselin

2 2

Server becomes unresponsive after several large database updates (db:delete())
by Eliot Kimber 17 Jul '24

17 Jul '24

(Using 10.7 on Centos): I have some databases with many large documents (1000s of docs ranging from 6KB to 2MB). I need to clean out older files, so I wrote this simple query, which looks at the time stamps in the doc filenames: let $db := '_valrep_validation_reports_internal' let $paths := (db:open($db)/* ! db:path(.)[matches(., '2024-0[123456]')] => sort()) return for $path in $paths return db:delete($db, $path) With only the dba app deployed, I ran this query on the four databases and it ran in a few seconds and removed the files as expected, but then I ran it on one more database and the query never returned and the dba app became unresponsive (Databases view doesn’t refresh). On the server I can see that a Java process, which can only be BaseX on this server, is at 100%: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 8376 eliot.k+ 20 0 9251688 1.1g 16124 S 101.0 3.5 14:02.42 java What would cause this kind of behavior? Cheers, E. _____________________________________________ Eliot Kimber Sr Staff Content Engineer Digital Content & Design O: 512 554 9368 M: 512 554 9368 servicenow.com<https://www.servicenow.com> LinkedIn<https://www.linkedin.com/company/servicenow> | Twitter<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Facebook<https://www.facebook.com/servicenow>

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk