October 2019 - BaseX-Talk - mailman.uni-konstanz.de

// versus /*/
by thufir 07 Oct '19

07 Oct '19

Do these have the same meaning? Might there be a subtle distinction, or might they be read differently but functionally identical? > > xquery /*/book[@id="bk112"] <book id="bk112"> <author>Galos, Mike</author> <title>Visual Studio 7: A Comprehensive Guide</title> <genre>Computer</genre> <price>49.95</price> <publish_date>2001-04-16</publish_date> <description>Microsoft Visual Studio 7 is explored in depth, looking at how Visual Basic, Visual C++, C#, and ASP+ are integrated into a comprehensive development environment.</description> </book> Query executed in 1.22 ms. > > xquery //book[@id="bk112"]/title <title>Visual Studio 7: A Comprehensive Guide</title> Query executed in 1.52 ms. > > xquery /*/book[@id="bk112"]/title <title>Visual Studio 7: A Comprehensive Guide</title> Query executed in 1.67 ms. > They're equally efficient, at least as used above? thanks, Thufir

2 2

Unidentified java processes keeping locks on DBs (BaseX 9.2.3)
by France Baril 07 Oct '19

07 Oct '19

Hi, We have been getting process issues on Windows installations for a while now. Has anyone had fantom locks (non-existent processes locking indices) and if so, can you point to clues that could help resolve the issue? [image: image.png] This leads to batch processes failure and DB corruption so we are eager even for the tiniest clues. Thank you -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

1 0

get list of databases
by thufir 07 Oct '19

07 Oct '19

Hi, pardon the silly question, but how do I get a list of databases exactly? I'm looking at: https://github.com/BaseXdb/basex/blob/master/basex-examples/src/main/java/o… and want output like: > list Name Resources Size Input Path ---------------------------------- books 0 4570 1 database(s). > but using: http://docs.basex.org/javadoc/org/basex/core/cmd/List.html thanks, Thufir

2 2

basex OOM on 30GB database upon running /dba/db-optimize/
by first name last name 06 Oct '19

06 Oct '19

Hi, Let's say there's a 30GB dataset [3] containing most threads/posts from [1]. After importing all of it, when I try to run /dba/db-optimize/ on it (which must have some corresponding command) I get the OOM error in the stacktrace attached. I am using -Xmx2g so BaseX is limited to 2GB of memory (the machine I'm running this on doesn't have a lot of memory). I was looking at [2] for some estimates of peak memory usage for this "db-optimize" operation, but couldn't find any. Actually it would be nice to know peak memory usage because.. of course, for any database (including BaseX) a common operation is to do server sizing, to know what kind of server would be needed. In this case, it seems like 2GB memory is enough to import 340k documents, weighing in at 30GB total, but it's not enough to run "dba-optimize". Is there any info about peak memory usage on [2] ? And are there guidelines for large-scale collection imports like I'm trying to do? Thanks, Stefan [1] https://www.linuxquestions.org/ [2] http://docs.basex.org/wiki/Statistics [3] https://drive.google.com/open?id=1lTEGA4JqlhVf1JsMQbloNGC-tfNkeQt2

3 13

Does BaseX used as a command line XQuery processor build a full tree of an input document passed with -i option?
by Martin Honnen 03 Oct '19

03 Oct '19

If I use BaseX (9.2.4) simply as an XQuery 3.1 processor from the command line with e.g. basex.bat -i input.xml query.xq does BaseX then first always parse the input.xml into an XDM tree, meaning if I use huge input documents that way I can run easily run out of memory? Or does that depend on the type of query or some other settings? I was wondering whether a "tumbling window" based split algorithm like declare namespace output = "http://www.w3.org/2010/xslt-xquery-serialization"; declare option output:method 'xml'; declare option output:indent 'yes'; declare variable $chunk-size as xs:integer external := 500; for tumbling window $chunk in /*/* start at $sp when $sp mod $chunk-size = 1 count $p return put(document { element { node-name(head($chunk)/..) } { $chunk } }, 'xquery-split-result-' || $p || '.xml') would run/work without memory problems for huge inputs.

2 1

Re: [basex-talk] HTTPServer + gzip compression
by Stefan Koch 03 Oct '19

03 Oct '19

2 1

Re: [basex-talk] Connection timeout
by Marie Starck 01 Oct '19

01 Oct '19

I am using an ssl certificate and have a keystore on my production Basex instance. Are there extra steps needed to make an HTTPS request from a server to a basex server when those are in place? On Thu, Sep 26, 2019 at 6:14 PM Marie Starck <marie.compsci14(a)gmail.com> wrote: > Hey Christian, > > This error message is from doing it with the nodejs basex client. I get > the same connection time out when doing an http or https request on 8984 > and 8986 (non-ssl and ssl respectively). > > Thank you, > > Marie > > On Thu, Sep 26, 2019 at 5:54 PM Christian Grün <christian.gruen(a)gmail.com> > wrote: > >> Hi Marie, >> >> SOCKET ERROR: { Error: connect ETIMEDOUT 159.89.126.125:1984 >>> >> >> By default, the REST endpoints are available on port 8984. >> >> Maybe this helps, >> Christian >> >> >>

2 1

HTTPServer + gzip compression
by Stefan Koch 01 Oct '19

01 Oct '19

Hi, I'm struggling to get gzip compression working. I'm using the REST module. http://docs.basex.org/wiki/REST Version: BaseX 9.2.2 Tried to add the handler in jetty.xml as descriped here: https://www.eclipse.org/jetty/documentation/current/gzip-filter.html But it didn't work. Tried gzip filter via web.xml - but it is deprecated since jetty 9.3. Gzip handler is the correct way to do it. Searched the mailling list, similar problem was reported here: https://mailman.uni-konstanz.de/pipermail/basex-talk/2019-February/014160.h… Unfortunately no solution :( Not much experience with embedded jetty - but adding gzip compression is straight forward in tomcat or apache - no clue why it doesn't work.Shouldn't be that hard - and it's kinda a default feature. Did anybody get it to work? Any tipps? Thanks Stefan Koch B&IT Solutions Dipl.-Kfm. Rudolf Markus Petri Lietzenburger Str. 77 10719 Berlin Tel: 0049 30 8867 6099 Fax: 0049 30 8867 6159 Mail: koch(a)buit-solutions.com Web: www.buit-solutions.com

2 1