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

xquery hangs in 7.7 release version (used to work fine in 7.7 beta)
by Srinivasan Muthu 18 Aug '13

18 Aug '13

Hi, We have been using basex 7.7 snapshot from June 20 and wanted to upgrade to the release version but looks like I have hit a bug with BaseX 7.7 release version while running a set of xqueries in sequence. I am able to reproduce this in BaseX 7.7 running in client-server mode on two different machines. Here are the steps to reproduce: - Launch BaseX 7.7 server (with defaults) - Launch BaseX command line client (run the file under bin/basexclient.bat that comes in zip) and run the following commands (also attached a screenshot): ---------------------------------------------------------- Username: admin Password: BaseX 7.7 [Client] Try help to get more information. *> create db d1 <hello/>* Database 'd1' created in 103.22 ms. *> xquery delete node doc('d1')//oops* Query executed in 25.03 ms. *> xquery let $doc := 'd1' return doc($doc)* ---------------------------------------------------------- At this point BaseX 7.7 server cannot be stopped using the stop batch file and I have to kill all processes using Task Manager. These set of commands works fine on BaseX 7.7 snapshot from June 20th. Let me know if this is a bug or am I missing something here. Thanks, Srini

2 1

BaseX77 db:optimize exception
by Freihalter Thomas 17 Aug '13

17 Aug '13

Hi all, After migration to BaseX77, db:optimize is running into an exception: java.io.IOException: Stopped at ., 8/20: [java] [FOUP0002] Database 'xxx' is currently opened by another process. Before migration, I used BaseX761-20130303.204518, and this version worked well. I have an additional question: My task is to read objects from a file and replace (if already exists) or insert (if new) the objects in the database. The key is a specific attribute (@n). Parallel threads could exist. Could you suggest a better solution? Here is the log with the exception: 21:32:37.860 127.0.0.1:48933 admin OK Database 'stock_stock_work__DOM' was opened in 74.98 ms. 78.19 ms 21:32:37.865 127.0.0.1:48933 admin REQUEST SET BINDINGS 'b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13':db=stock_stock_work__DOM,'b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13':destination=/tmp/basex/82e63b48-978d-4498-97bc-e90c8a3cd357/stock_stock_work__DOM,'b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13':uuid=82e63b48-978d-4498-97bc-e90c8a3cd357 21:32:37.866 127.0.0.1:48933 admin OK BINDINGS: 'b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13':db=stock_stock_work__DOM,'b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13':destination=/tmp/basex/82e63b48-978d-4498-97bc-e90c8a3cd357/stock_stock_work__DOM,'b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13':uuid=82e63b48-978d-4498-97bc-e90c8a3cd357 6.11 ms 21:32:37.869 127.0.0.1:48933 admin REQUEST SET AUTOFLUSH FALSE 21:32:37.869 127.0.0.1:48933 admin OK AUTOFLUSH: OFF 1.36 ms 21:32:37.915 127.0.0.1:48933 admin OK QUERY[0] xquery version '3.0'; declare namespace uuid='b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13'; declare variable $uuid:db as xs:string external; declare variable $uuid:destination as xs:string external; let $step := ( 1 ) return db:add($uuid:db, $uuid:destination) 44.64 ms 21:32:38.208 127.0.0.1:48933 admin OK RESULTS[0] 291.49 ms 21:32:38.208 127.0.0.1:48933 admin OK INFO[0] 0.19 ms 21:32:38.249 127.0.0.1:48933 admin OK QUERY[1] xquery version '3.0'; declare namespace uuid='b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13'; declare variable $uuid:db as xs:string external; declare variable $uuid:uuid as xs:string external; let $step := ( 1 ) let $prefix := concat($uuid:uuid, '/') let $suffix := concat('.', $uuid:uuid, '.xml') let $new := distinct-values( for $i in db:list($uuid:db) let $n := data(db:open($uuid:db,$i)/*/@n) where ends-with($i,$suffix) return $n ) for $i in db:list($uuid:db) let $old := concat($prefix, $i) where (index-of($new, data(db:open($uuid:db, $i)/*/@n))) and not(ends-with($i,$suffix)) return db:rename($uuid:db, $i, $old) 42.09 ms 21:32:38.359 127.0.0.1:48933 admin OK RESULTS[1] 108.12 ms 21:32:38.360 127.0.0.1:48933 admin OK INFO[1] 0.2 ms 21:32:38.400 127.0.0.1:48933 admin OK QUERY[2] xquery version '3.0'; declare namespace uuid='b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13'; declare variable $uuid:db as xs:string external; declare variable $uuid:uuid as xs:string external; let $prefix := concat($uuid:uuid, '/') return db:delete($uuid:db,$prefix) 40.65 ms 21:32:38.444 127.0.0.1:48933 admin OK RESULTS[2] 43.14 ms 21:32:38.484 127.0.0.1:48933 admin OK INFO[2] 39.64 ms 21:32:38.525 127.0.0.1:48933 admin OK QUERY[3] xquery version '3.0'; declare namespace uuid='b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13'; declare variable $uuid:db as xs:string external; declare variable $uuid:uuid as xs:string external; let $suffix := concat('.', $uuid:uuid, '.xml') for $i in db:list($uuid:db) let $new := substring-before($i,$suffix) where ends-with($i,$suffix) return db:rename($uuid:db, $i, $new) 41.45 ms 21:32:38.576 127.0.0.1:48933 admin OK RESULTS[3] 49.48 ms 21:32:38.616 127.0.0.1:48933 admin OK INFO[3] 39.85 ms 21:32:38.657 127.0.0.1:48933 admin OK QUERY[4] xquery version '3.0'; declare namespace uuid='b1b987d9-3cdb-4ac4-bc83-13bd03eb7a13'; declare option db:queryinfo 'true'; declare variable $uuid:db as xs:string external; declare variable $uuid:uuid as xs:string external; let $step := ( 1 ) return db:optimize($uuid:db, true()) 41.18 ms 21:32:38.727 127.0.0.1:48933 admin REQUEST RESULTS[4] 21:32:38.727 127.0.0.1:48933 admin ERROR Stopped at ., 8/20: [FOUP0002] Database 'stock_stock_work__DOM' is currently opened by another process. 69.73 ms 21:32:38.731 127.0.0.1:48933 admin REQUEST EXIT 21:32:38.739 127.0.0.1:48933 admin OK 8.69 ms And yet another question: Is it possible to store the backup-files (CREATE BACKUP) in another location than the database-directory (e.g. backup-directory)? Thank's in advance for help Thomas

2 1

Inserts into root nodes within if statements
by Marcel Hanser 15 Aug '13

15 Aug '13

Hi there, i'm confused about following behavior. Consider the query: "insert node <c/> into /" it evaluates perfectly if a DB is opened within the BaseX Gui (7.7). But if i put it into an if statement like: "if(true())then insert node <c/> into / else()" i got the error message that the if statement is not complete. Adding a dot behind the slash solves the problem. "if(true())then insert node <c/> into /. else()" Is there a specific reason behind that? Regards and thanks in advanced, Marcel

3 3

Disable locking capability of BaseX
by Marcel Hanser 15 Aug '13

15 Aug '13

Hi there, is there the possibility to disable the locking of databases in BaseX? I would like to see changes performed concurrently from another process on my database on the fly using the GUI for debugging issues. Best Regards, Marcel

2 2

Re: [basex-talk] Partnering with basex.org for software monetization
by Victor Vlad 15 Aug '13

15 Aug '13

RE: Partnering with basex.org for software monetization Hi, I just wanted to make sure you got my email below. I look forward to hearing from you. Best, Victor http://click.m.conduit.com/?qs=bf1055b1294b1ee92114349482724b073184d9aa794d… Victor Vlad mailto:victorv@conduit.com victorv(a)conduit.com Team Leader, Qualification Management | Global Business p. +972.8.946.1713 ext. +771 | w. http://click.m.conduit.com/?qs=bf1055b1294b1ee92114349482724b073184d9aa794d… www.conduit.com From: Victor Vlad mailto:victor@conduit.com [mailto:victor@conduit.com] To: basex-talk(a)mailman.uni-konstanz.de Subject: Partnering with basex.org for software monetization Hi, My name is Victor Vlad and I'm part of the Business Development team at Conduit. I'm contacting you to discuss possible partnership between Conduit and basex.org. Conduit offers a free software monetization platform, including browser extensions, a download manager, and more. Our platform has already been adopted by thousands of software publishers like you, including http://click.m.conduit.com/?qs=bf1055b1294b1ee967ee0181521467c91a7ba0b732da… Brothersoft.com , http://click.m.conduit.com/?qs=bf1055b1294b1ee955937ae86dbc6bd28a48df7d3445… 4shared.com , and many others. Conduit's tools are 100% Google-compliant, and certified by eTrust and MacAfee. Our platform is fully customizable to your target audience, market, and brand. And we offer free support and service. I'd like to discuss our possible partnership via phone or Skype at your earliest convenience. When would be the best time for you to speak? Best, Victor http://click.m.conduit.com/?qs=bf1055b1294b1ee92114349482724b073184d9aa794d… Victor Vlad mailto:victorv@conduit.com victorv(a)conduit.com Team Leader, Qualification Management | Global Business p. +972.8.946.1713 ext. +771|w. http://click.m.conduit.com/?qs=bf1055b1294b1ee92114349482724b073184d9aa794d… www.conduit.com This message may contain confidential and/or privileged information. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any uses, copy, disclose or distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please notify the sender by reply email or by telephone and delete or destroy any copy of this message. Thank you. (c)2013 Conduit.com. All rights reserved. 950 Tower Lane, Suite 1788, Foster City, CA, 94404 If you can't see my email below, click http://click.m.conduit.com/?qs=bf1055b1294b1ee9c0f74d0e66ef2a2ef018d2b36876… here to view it on the web.

1 0

We have to talk....
by Dong-Mei Feng 14 Aug '13

14 Aug '13

- This mail is in HTML. Some elements may be ommited in plain text. - Hello, We have to finish this. Mei

1 0

BaseX freezes, no error message on webpage or terminal
by France Baril 14 Aug '13

14 Aug '13

Hi, Setup: http server 7.6. Path to .dtd is in the form http:.../rest/path/mydtd.dtd. Test #1. I call the function that contains dtd:validate from a function. It works. Test #2. I call the function that contains dtd:validate from another function. It freezes. The only different I see is that the 2nd function is an updating function, so I am thinking deadlock. However, the function doesn't update the same DB that holds the file to validate or the .dtd file. How do I find out if this is a dead lock situation? And what would be my options to get out of it since I am not updating the same DB from which I read the content file or the .dtd file? Is there anyway to collect more information from the server to confirm the deadlock theory? The catch is not returning anything about being locked out either. The process doesn't seem to get pass the validate:dtd line in the try... it never makes it into the catch. Thanks, France -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

2 1

Efficiencies for batching
by Wendell Piez 13 Aug '13

13 Aug '13

Hi, Currently when I need to batch a database for processing I do something like this: for $record at $p in $recordSet where ($p ge $start) and ($p ge $end) return $record/process-record(.) I can imagine why this is more efficient. in BaseX, than using an XPath filter expression, as in $recordSet[position() ge $start and position() le $end]/process-record(.) (which is what I might prefer to do in other environments). But is the 'where' clause the best I can do? XQuery 3.0 has tumbling windows. I am not iterating over subsequences, but rather selecting one (arbitrary) subsequence from a sequence. What's my best approach to this in BaseX? Thanks, Wendell For example, XQuery 3.0 has tumbling windows. Wendell Piez | http://www.wendellpiez.com XML | XSLT | electronic publishing Eat Your Vegetables _____oo_________o_o___ooooo____ooooooo_^

3 3

Partnering with basex.org for software monetization
by Victor Vlad 13 Aug '13

13 Aug '13

Partnering with basex.org for software monetization Hi, My name is Victor Vlad and I'm part of the Business Development team at Conduit. I'm contacting you to discuss possible partnership between Conduit and basex.org. Conduit offers a free software monetization platform, including browser extensions, a download manager, and more. Our platform has already been adopted by thousands of software publishers like you, including http://click.m.conduit.com/?qs=8978fb8b31378dcd0f0edc4aab8634dd9c9d07cb9b12… Brothersoft.com , http://click.m.conduit.com/?qs=8978fb8b31378dcdb2da59a3c19124d8faed3f6da04f… 4shared.com , and many others. Conduit's tools are 100% Google-compliant, and certified by eTrust and MacAfee. Our platform is fully customizable to your target audience, market, and brand. And we offer free support and service. I'd like to discuss our possible partnership via phone or Skype at your earliest convenience. When would be the best time for you to speak? Best, Victor http://click.m.conduit.com/?qs=8978fb8b31378dcdde01f09673a7df9da35ff4006034… Victor Vlad mailto:victorv@conduit.com victorv(a)conduit.com Team Leader, Qualification Management | Global Business p. +972.8.946.1713 ext. +771|w. http://click.m.conduit.com/?qs=8978fb8b31378dcdde01f09673a7df9da35ff4006034… www.conduit.com This message may contain confidential and/or privileged information. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any uses, copy, disclose or distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please notify the sender by reply email or by telephone and delete or destroy any copy of this message. Thank you. (c)2013 Conduit.com. All rights reserved. 950 Tower Lane, Suite 1788, Foster City, CA, 94404 If you can't see my email below, click http://click.m.conduit.com/?qs=8978fb8b31378dcd83cb569dd3de1f37170222b4bb84… here to view it on the web.

1 0

Analyze-string unsupported?
by James Wright 09 Aug '13

09 Aug '13

Hey, I am trying to use analyze-string. I have this query: declare namespace str = 'str.analysis';declare function str:analyze-string($string as xs:string, $regex as xs:string,$n as xs:integer ) as xs:string { xslt:transform(<item />, ( <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0"> <xsl:template match='/' > <xsl:analyze-string regex="{$regex}" select="'{$string}'" > <xsl:matching-substring> <xsl:for-each select="1 to {$n}"> <match> <xsl:value-of select="regex-group(.)"/> </match> </xsl:for-each> </xsl:matching-substring> </xsl:analyze-string> </xsl:template> </xsl:stylesheet>))}; let $item as xs:string := 'test MM23423 junk MM11111 junkagain man'let $result := str:analyze-string($item, 'MM', 10)return $result However I am getting an error that this is unsupported. Upon further investigation I found that this is only available in Saxon EE. I'm guessing this is my problem. Is there anything of similar functionality included in basex? Any help would be appreciated. thanks. - james

2 2