BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

basex RUN local script when talking to Remote server
by bryan rasmussen 12 Nov '12

12 Nov '12

Hi, I have started the basexclient with a -n and -parameter to point to my server, what I would like to do is to execute scripts that I have laying around locally by doing something like RUN name_of_local_script.bsx and not get back a response that it cannot find name_of_local_script.bsx in the folder /home/account that has basex installation... Thanks, Bryan Rasmussen

2 3

UPDINDEX performance problem
by The Trainspotter 11 Nov '12

11 Nov '12

Hi, Just thought I'd share a problem I've got and to see if I'm solving it in the most efficient way. One of the XML documents I process contains various attributes which contain dates in non xs:date forat, e.g. "2010/1/20", "2010/12/1". In order to use the various date functions in XQuery I first need to bulk change all of these attribute values so they're in xs:date format. What I've found is that if I set the UPDINDEX property before I create the database, the XQuery function I have to change the date formats takes an age to complete. If I don't set it then the function completes pretty quickly. I need to use the UPDINDEX setting as I do a lot of updates and queries and I don't want to manually have to keep the indexes up to date. The solution I have at the moment is to create two databases, the first doesn't have UPDINDEX set, I load the document, do the date conversion, then export to a temporary file. I then create a second database from the temporary file, this time with UPDINDEX set. Is there a better/more efficient way of doing this? My date conversion function is this: declare updating function ts:convertToXsDate() { for $e in /*:NML/*:COLLECTION/*:ENTRY/@MODIFIED_DATE union /*:NML/*:COLLECTION/*:ENTRY/INFO/@RELEASE_DATE union /*:NML/*:COLLECTION/*:ENTRY/INFO/@LAST_PLAYED union /*:NML/*:COLLECTION/*:ENTRY/INFO/@IMPORT_DATE let $dateParts:= tokenize( data($e), "/") let $year:= $dateParts[1] let $month:= if( string-length($dateParts[2]) = 1) then concat("0",$dateParts[2]) else $dateParts[2] let $day:= if( string-length($dateParts[3]) = 1) then concat("0",$dateParts[3]) else $dateParts[3] return try { replace value of node $e with xs:date(concat($year,"-",$month,"-",$day)) } catch FORG0001 { () } }; Thanks in advance, Gary

2 3

Documents added by db:add(...) not visible for other existing database connections?
by Arjan van Bentem 10 Nov '12

10 Nov '12

Hi all, I noticed that TCP/IP clients are not seeing new documents that are created using db:add(...) in another client: Once a query has been executed, subsequent queries using the very same database connection do not see/return new documents that were meanwhile created using another connection. When creating some (different) document using one's own existing connection, then everything seems to be in-sync for a moment. But right after that, any new documents are again not seen. Updates made in other clients are visible just fine. So, the documents that are returned are up-to-date. It's just that not all documents are retrieved. I can see that in the query plans, the size in <DBNodeSeq size="..."> does not change, and is lower than the size that clients with a newer connection would show. Should it be okay to keep a connection open? Or is the expected behaviour to need a new connection to see new documents? Details below. Thanks, Arjan. 1. Start the server and a client in debugging mode: ./basexserver -d -S ./basexclient -U admin -P admin -d -x 2. Create and open a database: create database db1 open db1 3. Keep the client open, and make another client insert some documents. Like every second for about 2 minutes, each time using a new connection: for i in {1..120}; \ do doc="<test><a>`uuidgen`</a></test>"; \ echo $i, $doc; \ ./basexclient -U admin -P admin "db:add('db1', '$doc', 'dummy')"; \ sleep 1; \ done 4. While Step 3 is running, back in the first client, execute: xquery count(/test) The log in data/.logs shows: REQUEST XQUERY count(/test) OK Query executed in 25.74 ms. 223.77 ms So far, so good. 5. Repeat Step 4 to see the result NOT change, while the loop from Step 3 is still adding new documents. Logs show a faster result, but otherwise are the same. Also the query plans are always the same. (Typically: the size in <DBNodeSeq size="..."> does not change.) REQUEST XQUERY count(/test) OK Query executed in 5.48 ms. 7.29 ms 6. Using "close" followed by "open db1" gets one a more up-to-date value for "count". Also, using the connection to add some random other type of document, updates the value for "count(/test)" as well: xquery db:add('db1', '<another-test><xyz>123</xyz></another-test>', 'dummy') 7. It's not just "count" that does not change its value. Also, one can only query documents up to that count as returned by Step 4. Like if Step 4 returned "15", then the following would return 5 results, not 10: xquery (/test)[position()=10 to 20] Also, the following would only return the count as returned earlier: xquery /test Like noted, UPDATES made in other clients are visible just fine: xquery replace value of node /another-test/xyz with '456' xquery for $n in /test/a return replace value of node $n with fn:generate-id($n) Tested in both 7.3 and 7.5-20120929.201251 from http://files.basex.org/releases/latest/, in Oracle Java 7 on Mac OS X 10.8.2. I first noticed that my running application did not see new documents created by a test script. But the command line tools show the same issue. Any clue?

2 2

Crash when opening a BaseX database
by Rémi Jannel 10 Nov '12

10 Nov '12

Hi! After crashing my computer while editing a BaseX database, BaseX now returns an error when trying to access the database .I was editing the database through a web application (in Javascript) communicating with BaseX through the PHP wrapper and not with BaseX GUI. My system is Ubuntu 12.04 in a VirtualBox for the development on a Win7 64bits host system. All the other BaseX databases are working properly but when I'm trying to open the one I need, an error is returned. I put the message at the end of the email. I checked on my filesystem, the files corresponding to the database are still present in the BaseX data directory if you think it could be useful to debug what happened I could provide it. Is there something wrong on the BaseX version I'm using that could explain the data being corrupted? And is there a way for me to recover the database? The error message: Potential bug? Improper use? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 7.0.2 Java: Sun Microsystems Inc., 1.6.0_24 OS: Linux, i386 Stack Trace: java.lang.RuntimeException: Not expected: Data Access out of bounds [pre:1078, indexSize:9, access:9 > 8]. org.basex.util.Util.notexpected(Util.java:67) org.basex.io.random.TableDiskAccess.cursor(TableDiskAccess.java:394) org.basex.io.random.TableDiskAccess.read1(TableDiskAccess.java:107) org.basex.data.Data.kind(Data.java:319) org.basex.query.item.DBNode$4.next(DBNode.java:317) org.basex.query.path.IterStep$1.next(IterStep.java:46) org.basex.query.path.IterStep$1.next(IterStep.java:33) org.basex.query.path.IterPath$1.next(IterPath.java:68) org.basex.query.path.IterPath$1.next(IterPath.java:40) org.basex.core.cmd.AQuery.query(AQuery.java:102) org.basex.core.cmd.XQuery.run(XQuery.java:22) org.basex.core.Command.run(Command.java:328) org.basex.core.Command.exec(Command.java:309) org.basex.core.Command.execute(Command.java:77) org.basex.server.ClientListener.run(ClientListener.java:200) Thanks, Remi Jannel

2 3

passwords
by pw＠themail.co.uk 09 Nov '12

09 Nov '12

trying out changing passwords with BaseX7.5 with a Tomcat war installation. I changed the UID and pwd in web.xml and it doesn't let me authorise.... keeps on asking for the credentials. Am I missing something?

2 1

BaseXException when renaming a database
by Rainer Klute 09 Nov '12

09 Nov '12

I got the exception below when renaming a database. The renaming operation as such succeeded. It is just that exception that bothers me. org.basex.core.BaseXException: Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 7.3 Java: The Android Project, 0 OS: Linux, armv7l Stack Trace: java.lang.ArrayIndexOutOfBoundsException: length=8; index=-1 org.basex.util.list.TokenList.get(TokenList.java:106) org.basex.util.list.TwoWayTokenMap.set(TwoWayTokenMap.java:72) org.basex.util.list.TwoWayTokenMap.set(TwoWayTokenMap.java:87) org.basex.core.Databases.alter(Databases.java:72) org.basex.core.cmd.AlterDB.alter(AlterDB.java:63) org.basex.core.cmd.AlterDB.run(AlterDB.java:48) org.basex.core.Command.run(Command.java:326) org.basex.core.Command.exec(Command.java:305) org.basex.core.Command.execute(Command.java:77) org.basex.core.Command.execute(Command.java:89) ... -- Best regards Rainer Klute

2 2

webapp - set index to be index.xquery or .xml instead of .html
by Colin McEnearney 08 Nov '12

08 Nov '12

Hi, I want my basex webapp's root url, ie domain.com/ to default not to index.html, but to index.xquery or any kind of "x" :-) Currently running with nginx # pass requests for content to basex location / { index index.xqy index.xquery index.xml; proxy_pass http://127.0.0.1:8984; } But only index.html behaves this way. (all others show directory contents) I think maybe this is set somewhere in the jetty context, but can't find it. Does anyone know the answer?

2 1

Best way to run basex webapp in live environment
by Colin McEnearney 08 Nov '12

08 Nov '12

Hi, What is the best way to run a basex webapp for a live site? Right now I've got it started with nohup sh bin/basexhttp -d > nohup_logs/stdout.txt 2> nohup_logs/stderr.txt < /dev/null & Many thanks, Colin

2 1

deploy basex webapp to a linux / apache envinroment?
by Colin McEnearney 08 Nov '12

08 Nov '12

Hi, Can anyone point to some help with deploying a basex webapp to a linux / apache envinroment? I don't have much experience with Apache config. Is it best to leave basex running on port 8984 and proxy the port 80 requests? Or to config basex to operate on port 80? Any info on this topic is greatly appreciated. I wonder if maybe it's easier to run something else altogether, such as nginx? Thanks, Colin

2 4

basex two nodes, cannot talk with server
by bryan rasmussen 08 Nov '12

08 Nov '12

Hi, I'm running two nodes, server and client. If I run my basexclient on the same network node as the server and do basexclient -c LIST I get name Resources Size Input Path ------------------------------------------------ dkcontent 290422 10716470599 /data-test/dk 1 Databases. which is correct. When I try to do it on my local machine I get Can't communicate with server. I'm on Windows, my server is on Redhat. My local windows .basex file is DBPATH = C:\Program Files\BaseX\data HTTPPATH = C:\Program Files\BaseX\http REPOPATH = C:\Program Files\BaseX\repo LANG = English LANGKEYS = false HOST = localhost PORT = 1984 SERVERHOST = xmldbtest02 SERVERPORT = 1984 EVENTPORT = 1985 HTTPPORT = 8984 STOPPORT = 8985 PROXYHOST = PROXYPORT = 80 NONPROXYHOSTS = TIMEOUT = 0 KEEPALIVE = 0 DEBUG = false PARALLEL = 8 When I do nmap -p 1984 -PN xmldbtest02.domain.com I get Starting Nmap 5.21 ( http://nmap.org ) at 2012-11-08 13:24 CET Nmap scan report for xmldbtest02.domain.com (10.223.101.59) Host is up (0.00064s latency). PORT STATE SERVICE 1984/tcp open bigbrother Nmap done: 1 IP address (1 host up) scanned in 0.07 seconds I've also tried with the ip address for the value of SERVERHOST in my configuration. Thanks, Bryan Rasmussen

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk