May 2022 - BaseX-Talk - mailman.uni-konstanz.de

Not sure if feature/bug/my mistake!
by Patrick Durusau 06 May '22

06 May '22

Greetings! I have a directory of files that I use to create a database, using the directory as my starting point. On Debian, the files appear in this order: 01-matthew.xml 02-mark.xml 03-luke.xml 04-john.xml If I create an empty database and then add the files one by one, in that order, then //title[@type="main"] returns: ΚΑΤΑ ΜΑΘΘΑΙΟΝ ΚΑΤΑ ΜΑΡΚΟΝ ΚΑΤΑ ΙΩΑΝΗΝ ΚΑΤΑ ΙΩΑΝΗΝ On the other hand, if I start at the directory, add xml files, the database is created and //title[@type="main"] returns: ΚΑΤΑ ΙΩΑΝΗΝ ΠΡΟΣ ΕΦΕΣΙΟΥΣ ΚΑΤΑ ΜΑΘΘΑΙΟΝ ΙΩΑΝΟΥ Α Question (sorry for the long setup): Is the sort order of manually added files an artifact of the manual addition? That is I cannot expect users across systems to experience the same load order as I do? Asking because I'm writing documentation along with example queries for several datasets and documenting random results, isn't likely to be helpful to readers. I am aware I can use db:list(database-name) to obtain and sort on the original file names but that takes me away from the file content. Ah, BaseX 9.7.1 on Debian. You know, the files don't have internal sort attributes. ntorder = "digit" would be enough to sort on that attribute and return the book names in the expected order. I'm sure there are better solutions, suggestions appreciated! Patrick -- Patrick Durusau patrick(a)durusau.net Technical Advisory Board, OASIS (TAB) Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300 Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps) Another Word For It (blog): http://tm.durusau.net Homepage: http://www.durusau.net Twitter: patrickDurusau

3 3

Session issue
by Bondeson, Carl 04 May '22

04 May '22

We are seeing the following exception if we run under very heavy multi-thread conditions. ERROR] 2022-05-04 08:49:41.345 [Thread-3012] - General Throwable occurred message: No buffer space available (maximum connections reached?): connect Caused by this // create BaseX session on singleton server mapperSession = new ClientSession(BaseXDictionary.BASEX_HOST, basexdict.baseXPort, basexdict.baseXUser, basexdict.baseXPass); We are using XSLT and invoking Java methods to handle the things not easily managed in XSLT. Should we be closing sessions in Java classes or is this supposed to be handled by the JVM? This is running under Windows Server 2016 , deployed using JBoss 7.3.9, with 16 GB ram, and 4 cores. Thanks Carl R Bondeson IT Analyst 3 Department of Public Health Operation & Support Services Information Technology Phone: 860-509-7434 Carl.Bondeson(a)ct.gov<mailto:Carl.Bondeson@ct.gov> [cid:image001.jpg@01D85F9D.FCF29490][cid:image002.png@01D85F9D.FCF29490]

2 2

Re: [basex-talk] [basex-announce] BaseX 9.7.1: Tweaks, Fixes, Features
by Christian Grün 03 May '22

03 May '22

Confirmed, thanks. A new snapshot is available [1]. If you want to stick with BaseX 9.7.1, you can remove the trailing slash in your URL. [1] https://files.basex.org/releases/latest/ On Tue, May 3, 2022 at 5:13 PM Majewski, Steven Dennis (sdm7g) < sdm7g(a)virginia.edu> wrote: > > I’m also seeing a new error crop up with 9.7.1 > > Could this be connected ? > > ( I’ll try to revert to previous version to make sure that there hasn’t > been a change at the source URL that would cause a change in result. ) > > *WTJU$* basex 'html:doc( "https://www.wtju.net/recent-shows/" )' > Stopped at /Users/sdm7g/Desktop/WTJU/, 1/9: > [FODC0002] URI 'https://www.wtju.net/recent-shows/' points to directory. > *WTJU$* > *WTJU$* curl -I https://www.wtju.net/recent-shows/ > HTTP/2 200 > *server*: nginx/1.10.3 > *date*: Tue, 03 May 2022 15:10:52 GMT > *content-type*: text/html; charset=UTF-8 > *x-pingback*: https://www.wtju.net/xmlrpc.php > *link*: <https://www.wtju.net/wp-json/>; rel="https://api.w.org/" > *link*: <https://www.wtju.net/?p=173>; rel=shortlink > >

1 0

Re: [basex-talk] [basex-announce] BaseX 9.7.1: Tweaks, Fixes, Features
by Majewski, Steven Dennis (sdm7g) 03 May '22

03 May '22

I still had BaseX971-20220411.133348.zip ( 9.7.1 beta) sitting around to try And I don’t get that error using it. > On May 3, 2022, at 11:12 AM, sdm7g <sdm7g(a)virginia.edu> wrote: > > > I’m also seeing a new error crop up with 9.7.1 > > Could this be connected ? > > ( I’ll try to revert to previous version to make sure that there hasn’t been a change at the source URL that would cause a change in result. ) > > WTJU$ basex 'html:doc( "https://www.wtju.net/recent-shows/ <https://www.wtju.net/recent-shows/>" )' > Stopped at /Users/sdm7g/Desktop/WTJU/, 1/9: > [FODC0002] URI 'https://www.wtju.net/recent-shows/ <https://www.wtju.net/recent-shows/>' points to directory. > WTJU$ > WTJU$ curl -I https://www.wtju.net/recent-shows/ <https://www.wtju.net/recent-shows/> > HTTP/2 200 > server: nginx/1.10.3 > date: Tue, 03 May 2022 15:10:52 GMT > content-type: text/html; charset=UTF-8 > x-pingback: https://www.wtju.net/xmlrpc.php <https://www.wtju.net/xmlrpc.php> > link: <https://www.wtju.net/wp-json/ <https://www.wtju.net/wp-json/>>; rel="https://api.w.org/ <https://api.w.org/>" > link: <https://www.wtju.net/?p=173 <https://www.wtju.net/?p=173>>; rel=shortlink >

1 0

Text index requires `/text()` in query
by Matthew Dziuban 02 May '22

02 May '22

Hi all, I was recently debugging performance of a query with an exact string comparison and discovered that it seems the query was only rewritten to use the text index [1] if I explicitly added `/text()` to the path I was comparing. My data looks like this: <data> <element><id>123</id></element> </data> And my original query was: for $el in db:open('DatabaseName')/data/element where $el/id = '123' return $el With 3 million <element> nodes in the database, this query took about 4 seconds, which made me question whether the text index was being used. I then changed the query to add `/text()` to the `where` clause, like so: for $el in db:open('DatabaseName')/data/element where $el/id/text() = '123' return $el With this change, the query only takes 0.4 seconds. Is it expected that `/text()` is required to get the text index to kick in? Thanks in advance, Matt [1] https://docs.basex.org/wiki/Indexes#Text_Index

2 6