BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

Fwd: Re : Basex Query Optimization Support
by Adi Babu 18 Sep '15

18 Sep '15

Dear Team, I am facing performance issue taking long time to execute the Xquery in Basex(Client Server architecture), can you please guide me to optimize the query performance. Below are the statistics & Basex server hardware specifications. Statistics : ------------- Total Records count : 6000000 Fetch count : 10000 Hits Parallel hits : 100 Time Taking : 750 seconds Architecture : Client Server Architecture Hardware Specifications of Basex Sever : ---------------------------------------------------------- Operating System : Red Hat Enterprise Linux 64bit OS Version : Linux 2.6.32 Hard Disk : 500 GB Memory Capacity : 16 GB Ram Processor Family : Intel (R) Xeon(R) CPU E5 -2680 V2 Processor Speed : 2.80 GHz Physical Processors : 8 Virtual Processors/cores : 4 Server Version : basex 7.9 Note : I have attached the sample xml data and Xquery . Thanks & Regards Adi

4 9

array:for-each issue
by Andy Bunce 18 Sep '15

18 Sep '15

Hi, Using 8.2.3 (and the latest beta) this code seems to be invoking the JSON serializer. I don't understand why. declare function local:wrap2($doc,$x as xs:integer*){ $doc }; let $b:=doc("file.xml") return array:for-each([1],local:wrap2($b,?)) And if file.xml is <doc> <p style="prior"/> <p style="target"/> <p style="later"/> </doc> Error: Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 8.3 beta 89201d1 Java: Oracle Corporation, 1.8.0_45 OS: Windows 7, amd64 Stack Trace: java.lang.NullPointerException at org.basex.util.Token.eq(Token.java:619) at org.basex.io.serial.json.JsonNodeSerializer.finishOpen(JsonNodeSerializer.java:145) at org.basex.io.serial.Serializer.prepare(Serializer.java:524) at org.basex.io.serial.Serializer.openElement(Serializer.java:229) at org.basex.io.serial.Serializer.node(Serializer.java:437) at org.basex.io.serial.Serializer.node(Serializer.java:176) at org.basex.io.serial.StandardSerializer.node(StandardSerializer.java:99) at org.basex.io.serial.json.JsonNodeSerializer.node(JsonNodeSerializer.java:89) at org.basex.io.serial.Serializer.serialize(Serializer.java:126) at org.basex.io.serial.StandardSerializer.serialize(StandardSerializer.java:84) at org.basex.io.serial.json.JsonSerializer.serialize(JsonSerializer.java:57) at org.basex.io.serial.json.JsonSerializer.serialize(JsonSerializer.java:76) at org.basex.io.serial.json.JsonSerializer.function(JsonSerializer.java:120) at org.basex.io.serial.AdaptiveSerializer.function(AdaptiveSerializer.java:78) at org.basex.io.serial.Serializer.serialize(Serializer.java:128) at org.basex.io.serial.AdaptiveSerializer.serialize(AdaptiveSerializer.java:63) at org.basex.query.value.Value.serialize(Value.java:223) at org.basex.core.cmd.AQuery.query(AQuery.java:85) at org.basex.core.cmd.XQuery.run(XQuery.java:22) at org.basex.core.Command.run(Command.java:398) at org.basex.core.Command.execute(Command.java:100) at org.basex.gui.GUI.exec(GUI.java:472) at org.basex.gui.GUI.access$4(GUI.java:425) at org.basex.gui.GUI$7.run(GUI.java:412)

2 3

Different result in BaseX 8.1 vs. 8.2.3 for path starting with slash
by Amanda Galtman 18 Sep '15

18 Sep '15

Hi, While debugging a query, I noticed a difference in behavior between BaseX 8.1 and BaseX 8.2.3. I boiled it down to this short example, which I hope is understandable even if you don't have my database at hand. for $node in collection("DocLibrary")//chapter return $node/ends-with(/book/title,'Examples') In version 8.2.3, all the results are false, which is unexpected. In version 8.1, I get a mix of true and false values, which is what I expect based on the documents in the database. The XQuery 3.0 and 3.1 specs say the following in the "Path Expressions" section: A "/" at the beginning of a path expression is an abbreviation for the initial step (fn:root(self::node()) treat as document-node())/ (however, if the "/" is the entire path expression, the trailing "/" is omitted from the expansion.) The effect of this initial step is to begin the path at the root node of the tree that contains the context node. If I make the substitution mentioned in the spec, for $node in collection("DocLibrary")//chapter return $node/ends-with((fn:root(self::node()) treat as document-node())/book/title,'Examples') then I get expected results in both BaseX 8.1 and BaseX 8.2.3. Do my unexpected results with 8.2.3 arise from a bug? Perhaps the syntax is not that intuitive in either case (my real query is generated rather than coded by hand, so normally no human needs to look at it), but I still wanted to pose this question in case there is a bug. Thanks, Amanda

2 2

Re: [basex-talk] XSD 1.1
by Christian Grün 17 Sep '15

17 Sep '15

Hi Alex (cc to the list), Your feedback was very helpful. And I've finally learnt more about XML Schema 1.1 validation, which is now available in the new snapshot [1]. I have also completely revised the documentation on our Validation Module [2]. Looking forward to your feedback on your first tests, Christian [1] http://files.basex.org/releases/latest/ [2] http://docs.basex.org/wiki/Validation_Module#XML_Schema_Validation

2 1

Db creation
by meumapple 17 Sep '15

17 Sep '15

Hi, I am trying to open a collection of files where some of them contain character entity references like – which are not declared in the document and so make basex crash if I use collection() If I use file:read-text for each file and then put this functioni in file:write, the saved text will show < > instead of < and >: why? Moreover, if I create a database from the GUI and select the option "skip corrupt", the database is created. However if I follow instruction here http://docs.basex.org/wiki/Parsers In order to add single files to a db usind db:add and precede the query with declare option db:skipcorrupt 'true', the files are not added because I get an error message due to the not well-formed xml. I have tried to declare other db options in the same way but they seem not be read. Giuseppe

3 6

Database corruption
by France Baril 16 Sep '15

16 Sep '15

Hi, Once in a while, when saving a file that is not well formed from Oxygen, instead of just getting a raw file in the server, we end up with a corrupted database. It's not a constant occurrence meaning that it doesn't happen all the time, but we were able to get what we think is a relevant error message. We think saving 310.mot.com:8984/webdav/en-us/topics/legal-privacy-modular.xml while it wasn't well formed is what caused the issue. local:8984/webdav/en-us/topics/legal-privacy-modular.xml [qtp1977419222-62] INFO com.bradmcevoy.http.HttpManager - PUT :: http://~ local:8984/webdav/en-us/topics/legal-privacy-modular.xml - http://~ local:8984/webdav/en-us/topics/legal-privacy-modular.xml [qtp1977419222-64] INFO com.bradmcevoy.http.HttpManager - GET :: http://~ local:8984/webdav/AppResources/dtds/catalog.xml - http:// ~local:8984/webdav/AppResources/dtds/catalog.xml [qtp1977419222-65] INFO com.bradmcevoy.http.HttpManager - GET :: http://~ local:8984/webdav/AppResources/dtds/catalog.xml - http:// ~local:8984/webdav/AppResources/dtds/catalog.xml java.lang.NullPointerException java.lang.NullPointerException [qtp1977419222-62] WARN com.bradmcevoy.http.http11.PutHandler - parent exists bu t is not a collection resource: /webdav/en-us/topics [qtp1977419222-61] WARN com.bradmcevoy.http.http11.PutHandler - parent exists bu t is not a collection resource: /webdav/en-us/topics java.lang.NullPointerException java.lang.NullPointerException java.lang.NullPointerException [qtp1977419222-62] WARN com.bradmcevoy.http.http11.PutHandler - Your resource fa ctory returned a resource with a different name to that requested!!! Requested: webdav returned: - resource factory: class org.basex.http.webdav.BXResourceFact ory java.lang.NullPointerException [qtp1977419222-61] WARN com.bradmcevoy.http.http11.PutHandler - Your resource fa ctory returned a resource with a different name to that requested!!! Requested: webdav returned: - resource factory: class org.basex.http.webdav.BXResourceFact ory java.lang.NullPointerException java.lang.NullPointerException [qtp1977419222-61] ERROR com.bradmcevoy.http.StandardFilter - process [qtp1977419222-62] ERROR com.bradmcevoy.http.StandardFilter - process java.lang.NullPointerException at java.text.SimpleDateFormat.parse(Unknown Source) at java.text.DateFormat.parse(Unknown Source) at org.basex.util.DateTime.parse(DateTime.java:66) at org.basex.http.webdav.impl.WebDAVService.timestamp(WebDAVService.java :120) at org.basex.http.webdav.impl.WebDAVService.createDb(WebDAVService.java: 269) at org.basex.http.webdav.BXRoot$3.get(BXRoot.java:77) at org.basex.http.webdav.BXRoot$3.get(BXRoot.java:1) at org.basex.http.webdav.BXCode.eval(BXCode.java:37) at org.basex.http.webdav.BXRoot.createCollection(BXRoot.java:79) at org.basex.http.webdav.BXRoot.createCollection(BXRoot.java:1) at com.bradmcevoy.http.http11.PutHandler.findOrCreateFolders(PutHandler. java:261) at com.bradmcevoy.http.http11.PutHandler.findOrCreateFolders(PutHandler. java:249) at com.bradmcevoy.http.http11.PutHandler.process(PutHandler.java:175) at com.bradmcevoy.http.StandardFilter.process(StandardFilter.java:52) at com.bradmcevoy.http.FilterChain.process(FilterChain.java:40) at com.bradmcevoy.http.HttpManager.process(HttpManager.java:228) at org.basex.http.webdav.WebDAVServlet.run(WebDAVServlet.java:43) at org.basex.http.BaseXServlet.service(BaseXServlet.java:64) at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684 ) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java :503) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j ava:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.jav a:557) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandl er.java:231) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandl er.java:1086) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java: 429) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandle r.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandle r.java:1020) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j ava:135) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper .java:116) at org.eclipse.jetty.server.Server.handle(Server.java:370) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(Abstrac tHttpConnection.java:494) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpC onnection.java:982) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.conten t(AbstractHttpConnection.java:1043) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnecti on.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEn dPoint.java:696) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEnd Point.java:53) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPoo l.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool .java:543) at java.lang.Thread.run(Unknown Source) java.lang.NullPointerException at java.text.SimpleDateFormat.parse(Unknown Source) at java.text.DateFormat.parse(Unknown Source) at org.basex.util.DateTime.parse(DateTime.java:66) at org.basex.http.webdav.impl.WebDAVService.timestamp(WebDAVService.java :120) at org.basex.http.webdav.impl.WebDAVService.createDb(WebDAVService.java: 269) at org.basex.http.webdav.BXRoot$3.get(BXRoot.java:77) at org.basex.http.webdav.BXRoot$3.get(BXRoot.java:1) at org.basex.http.webdav.BXCode.eval(BXCode.java:37) at org.basex.http.webdav.BXRoot.createCollection(BXRoot.java:79) at org.basex.http.webdav.BXRoot.createCollection(BXRoot.java:1) at com.bradmcevoy.http.http11.PutHandler.findOrCreateFolders(PutHandler. java:261) at com.bradmcevoy.http.http11.PutHandler.findOrCreateFolders(PutHandler. java:249) at com.bradmcevoy.http.http11.PutHandler.process(PutHandler.java:175) at com.bradmcevoy.http.StandardFilter.process(StandardFilter.java:52) at com.bradmcevoy.http.FilterChain.process(FilterChain.java:40) at com.bradmcevoy.http.HttpManager.process(HttpManager.java:228) at org.basex.http.webdav.WebDAVServlet.run(WebDAVServlet.java:43) at org.basex.http.BaseXServlet.service(BaseXServlet.java:64) at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684 ) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java :503) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j ava:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.jav a:557) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandl er.java:231) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandl er.java:1086) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java: 429) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandle r.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandle r.java:1020) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j ava:135) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper .java:116) at org.eclipse.jetty.server.Server.handle(Server.java:370) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(Abstrac tHttpConnection.java:494) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpC onnection.java:982) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.conten t(AbstractHttpConnection.java:1043) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnecti on.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEn dPoint.java:696) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEnd Point.java:53) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPoo l.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool .java:543) at java.lang.Thread.run(Unknown Source) [qtp1977419222-49] INFO com.bradmcevoy.http.HttpManager - GET :: http://~ local:8984/webdav/AppResources/dtds/catalog.xml - http:// ~local:8984/webdav/AppResources/dtds/catalog.xml [qtp1977419222-64] INFO com.bradmcevoy.http.HttpManager - GET :: http://~ local:8984/webdav/AppResources/dtds/catalog.xml - http:// ~local:8984/webdav/AppResources/dtds/catalog.xml [qtp1977419222-55] INFO com.bradmcevoy.http.HttpManager - PROPFIND :: http://~local:8984/webdav/html-review/ - http://~local:8984/webd av/html-review/ -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 3

duplicate declaration error-message when using dynamic module-imports ( inspect:functions)
by Rob Stapper 16 Sep '15

16 Sep '15

Hi, I get a "duplicate declaration" error-message when I using the inspect:functions-function. Consider program: testRun1-2a.xq. The program imports module: module1.xqm and module2a.xqm. Module: module1.xqm, declares a variable: $mod1:x, and a function: mod1:show( $x). Module: module2a.xqm, declare a function: mod2a:run, which calls a function by a given function-name: $name in a dynamically imported module by a given module-uri: $uri. Program: testRun1-2a.xq, calls the run-function in module2a and tells it to use variable: $mod1:x, on function: mod1:show in module: module1.xqm. This triggers an error: Duplicate declaration on static variable $mod1:x. On the other hand, program: testRun1-2b.xq, does exactly the same except that module:module2b.xqm, is statically linked to module: module1.xqm, instead of dynamically as happens in module:module2a.xqm. Shouldn't the dynamically import of modules behave in the same manner as its static counterpart? Is it possible to achieve this? Cheers, Rob PS the examples are a bit awkward but in my real-life program this construction makes sense (to my anyway). --- Dit e-mailbericht is gecontroleerd op virussen met Avast antivirussoftware. https://www.avast.com/antivirus

2 1

Stopword-related NullPointerException (in FTWords.java)
by Ron Katriel 15 Sep '15

15 Sep '15

Hi, I encountered a peculiar error with a query using a stopwords file in the context of a full text search. The query joins two XML databases: CT.gov (containing 86635503 nodes) and the 2015 MeSH dictionary (containing 12064461 nodes). I am debugging using CT.gov trial NCT00303472, hardcoded in the ‘where' clause of the following query: let $trees := db:open('MeSH')/DescriptorRecordSet/DescriptorRecord for $article in db:open('CTGov')/clinical_study where $article/id_info/nct_id = 'NCT00303472' let $mesh := $article/condition_browse/mesh_term let $tn1 := $trees[DescriptorName/String contains text { $mesh }] let $tn2 := $trees[DescriptorName/String contains text { $mesh } using stop words at "/Volumes/Extra/Documents/Standards/MeSH/stopwords.txt"]/TreeNumberList/TreeNumber return <match> { $article/id_info/nct_id, $mesh, $tn2 } </match> When the return clause contains the variable $tn2 (i.e., using stopwords - as shown above) a Java NullPointerException is generated (see the stack trace below). However, when only $tn1 is returned there is no problem (the code for $tn2 is removed by the optimizer). The issue is related to a specific stopword (“syndrome”). When the stopword is removed from the file the exception does not occur. Surprisingly, when the stopword is in uppercase (“Syndrome”) the issue does not occur - even though the target MeSH term in this CT.gov trial is in uppercase, that is <mesh_term>Syndrome</mesh_term> Am I doing something wrong, or is this a real bug in BaseX? If the former, please suggest a workaround as I would like to filter out generic MeSH terms that match the stopwords before any further processing (I removed a lot of code from the above query to make it easier to debug). Thanks, Ron Error: Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 8.2 Java: Oracle Corporation, 1.8.0_20 OS: Mac OS X, x86_64 Stack Trace: java.lang.NullPointerException at org.basex.query.expr.ft.FTWords$1.next(FTWords.java:166) at org.basex.query.expr.ft.FTIndexAccess$1.next(FTIndexAccess.java:48) at org.basex.query.expr.ft.FTIndexAccess$1.next(FTIndexAccess.java:45) at org.basex.query.iter.Iter.value(Iter.java:53) at org.basex.query.expr.ParseExpr.value(ParseExpr.java:67) at org.basex.query.QueryContext.value(QueryContext.java:421) at org.basex.query.expr.path.CachedPath.iter(CachedPath.java:41) at org.basex.query.expr.path.CachedPath.iter(CachedPath.java:22) at org.basex.query.QueryContext.iter(QueryContext.java:410) at org.basex.query.expr.List$1.next(List.java:133) at org.basex.query.expr.constr.Constr.add(Constr.java:70) at org.basex.query.expr.constr.CElem.item(CElem.java:92) at org.basex.query.expr.constr.CElem.item(CElem.java:23) at org.basex.query.expr.ParseExpr.iter(ParseExpr.java:43) at org.basex.query.expr.gflwor.GFLWOR$1.next(GFLWOR.java:99) at org.basex.query.MainModule$1.next(MainModule.java:114) at org.basex.query.QueryContext.cache(QueryContext.java:660) at org.basex.query.QueryProcessor.cache(QueryProcessor.java:103) at org.basex.core.cmd.AQuery.query(AQuery.java:83) at org.basex.core.cmd.XQuery.run(XQuery.java:22) at org.basex.core.Command.run(Command.java:398) at org.basex.core.Command.execute(Command.java:100) at org.basex.gui.GUI.exec(GUI.java:472) at org.basex.gui.GUI.access$400(GUI.java:43) at org.basex.gui.GUI$7.run(GUI.java:412) Compiling: - pre-evaluating db:open("MeSH") - pre-evaluating db:open("CTGov") - inlining $trees_0 - applying full-text index for { $mesh_2 } using language 'English' - applying full-text index for { $mesh_2 } using language 'English' - inlining $tn2_4 - removing variable $tn1_3 - applying text index for "NCT00303472" - rewriting where clause(s) Query: let $trees := db:open('MeSH')/DescriptorRecordSet/DescriptorRecord for $article in db:open('CTGov')/clinical_study where $article/id_info/nct_id = 'NCT00303472' let $mesh := $article/condition_browse/mesh_term let $tn1 := $trees[DescriptorName/String contains text { $mesh }] let $tn2 := $trees[DescriptorName/String contains text { $mesh } using stop words at "/Volumes/Extra/Documents/Standards/MeSH/stopwords.txt"]/TreeNumberList/TreeNumber return <match> { $article/id_info/nct_id, $mesh, $tn2 } </match> Optimized Query: for $article_1 in db:text("CTGov", "NCT00303472")/parent::*:nct_id/parent::*:id_info/parent::*:clinical_study let $mesh_2 := $article_1/*:condition_browse/*:mesh_term return element match { (($article_1/*:id_info/*:nct_id, $mesh_2, ft:search("MeSH", { $mesh_2 } using language 'English')/parent::*:String/parent::*:DescriptorName/parent::*:DescriptorRecord/TreeNumberList/TreeNumber)) } Query plan: <QueryPlan compiled="true"> <GFLWOR> <For> <Var name="$article" id="1"/> <IterPath> <ValueAccess data="CTGov" type="TEXT" name="*:nct_id"> <Str value="NCT00303472" type="xs:string"/> </ValueAccess> <IterStep axis="parent" test="*:id_info"/> <IterStep axis="parent" test="*:clinical_study"/> </IterPath> </For> <Let> <Var name="$mesh" id="2"/> <IterPath> <VarRef> <Var name="$article" id="1"/> </VarRef> <IterStep axis="child" test="*:condition_browse"/> <IterStep axis="child" test="*:mesh_term"/> </IterPath> </Let> <CElem> <QNm value="match" type="xs:QName"/> <List> <IterPath> <VarRef> <Var name="$article" id="1"/> </VarRef> <IterStep axis="child" test="*:id_info"/> <IterStep axis="child" test="*:nct_id"/> </IterPath> <VarRef> <Var name="$mesh" id="2"/> </VarRef> <CachedPath> <FTIndexAccess data="MeSH"> <FTWords> <VarRef> <Var name="$mesh" id="2"/> </VarRef> </FTWords> </FTIndexAccess> <IterStep axis="parent" test="*:String"/> <IterStep axis="parent" test="*:DescriptorName"/> <IterStep axis="parent" test="*:DescriptorRecord"/> <IterStep axis="child" test="TreeNumberList"/> <IterStep axis="child" test="TreeNumber"/> </CachedPath> </List> </CElem> </GFLWOR> </QueryPlan> Ron Katriel, Ph.D. | Senior Data Scientist | Medidata Solutions 350 Hudson Street, 7th Floor, New York, NY 10014 rkatriel(a)mdsol.com | direct: +1 201 337 3622 | mobile: +1 201 675 5598 | main: +1 212 918 1800

2 6

Different behavior with same query in BaseX 7.9 and 8.2.3
by Antoine WOLF 15 Sep '15

15 Sep '15

*Hi,* *We are in the process of evaluating BaseX and recently upgraded from version 7.9 to 8.2.3We have a DB “TESTDB” with 50 xml files, named Fund1.xml, Fund2.xml, Fund3.xml,…. each having the same structure:Fund1.xml--------------< fund>…<properties>…<domain reference=”fund1”>…</domain>…</properties>…</fund>Fund2.xml--------------< fund>…<properties>…<domain reference=”fund2”>…</domain>…</properties>…</fund>….….The following query does not behave the same on both versions :For $d at $i in db:open(“TESTDB”)/fund/properties/domainwhere $i < 2return data($d/@reference)Result in 7.9------------------“Fund1”Result in 8.2.3-----------------“Fund1 Fund2 Fund3 Fund4 …”Is this a bug or is there something wrong with the query ?Best Regards,Antoine Wolf*

3 3

Unexpected error: Improper use? Potential bug?
by Pierre-Yves JALLUD 15 Sep '15

15 Sep '15

Hi all, I have some troubles with BaseX request and webdav access. My situation is the following: the acces to BaseX with webdav is with an oXygen (developer version 17) with Ubuntu 14.0.4 and the BaseX server is running under a Scientific Linux 64b (2.6.32-573.3.1.el6.x86_64 ... if the precision is necessary ;)). The BaseX server is behind a web cluster using a load balancer and an APACHE HTTP server. All the access passing thrue this server and the different ports access are managed with HAProxy. If the context is not clear enough, don't hesitate to ask more precisions. The symptom is that the BaseX server is freezing after a webdav request. The log's extracts you can find below track the following use case: - I try an access to http://BaseX.huma-num.fr/webdav/bvm/bvm.xml with oXygen - I recieve a HTTP error 500 - I try to access to the BaseX server with my web site and more than one minute later, I have a timeout. ... but the worst symptom is that in some cases (not always), the requested db get corrupted and emptied (totally or partly) : resources are missing or they throw End of File exceptions when we then try to reopen them. This use case can appear many times a day... but not systematically. And other colleagues have the same problems with other version of oXygen with other OS (Windows), but allways with the same BaseX server. Does anyone of you have an idea to solve my problem? Thanks Pierre-Yves Some extracts of the log file: ... 17:13:06.694 X.X.X.X:34953 admin REQUEST [GET] http://BaseX.huma-num.fr/webdav/bvm/bvm.xml 17:13:06.845 X.X.X.X:34954 admin REQUEST [LOCK] http://BaseX.huma-num.fr/webdav/bvm/bvm.xml 17:13:06.888 X.X.X.X:34954 admin 200 43.82 ms 17:13:08.437 X.X.X.X:34953 admin 500 Unexpected error: Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 8.2.1 Java: Oracle Corporation, 1.8.0_31 OS: Linux, amd64 Stack Trace: java.lang.RuntimeException: org.eclipse.jetty.io.EofException at org.basex.http.webdav.BXServletResponse.close(BXServletResponse.java:80) at org.basex.http.webdav.WebDAVServlet.run(WebDAVServlet.java:46) at org.basex.http.BaseXServlet.service(BaseXServlet.java:64) at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:503) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextH... 1743.02 ms ... 17:15:20.041 X.X.X.X:38436 admin REQUEST [PROPFIND] http://BaseX.huma-num.fr/webdav/skepsis/Cicero_De_Finibus.xml 17:15:40.067 X.X.X.X:38770 admin REQUEST [PROPFIND] http://BaseX.huma-num.fr/webdav/skepsis/Cicero_De_Finibus.xml 17:16:00.078 X.X.X.X:39090 admin REQUEST [PROPFIND] http://BaseX.huma-num.fr/webdav/skepsis/ 17:16:00.170 X.X.X.X:39091 admin REQUEST [PROPFIND] http://BaseX.huma-num.fr/webdav/bvm/bvm.xml 17:16:20.194 X.X.X.X:39582 admin REQUEST [PROPFIND] http://BaseX.huma-num.fr/webdav/bvm/bvm.xml 17:17:00.904 X.X.X.X:39091 admin 200 60733.77 ms 17:17:00.907 X.X.X.X:39582 admin 200 40712.41 ms 17:17:00.909 X.X.X.X:38770 admin 200 80842.45 ms 17:17:00.910 X.X.X.X:38436 admin 200 100868.15 ms 17:17:01.004 X.X.X.X:39090 admin 200 60926.05 ms 17:19:37.189 Y.Y.Y.Y:39926 admin ERROR Timeout exceeded. 60000.62 ms ...

3 6

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk