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

Windows fast, linux very slow
by Sven Rega 03 Nov '11

03 Nov '11

Hy, i'm using the basexserver 6.7.1 on a windows (i7; 8GB; 2,8GHz) and on different linux machines (i7; 16GB, 3,4GHz). the same xml file (~2,5GByte) and one simple query has i big difference in speed between both machines and i don't know, where the bottleneck is coming from. on the windows machine i get througput of ~600 to 1000 xml entities per second. On the linux machine i only get max. 110 xml entities per second. I use the same jvm setting on both machines: -server -Xmx3g I also use the index (text, path, attribtue) on both machines. The query: "declare function local:ProductValues() { for $n in //Product[(@ID='A' or @ID='D' or @ID='G')]/Values return <pv><utid>{data($n/../@ID)}</utid><id>{data($n/../@SecondID)}</id>{$n}</pv> }; local:ProductValues()" I read from the basex server over lan with 1GBit. Does anybody have a idea, what could be the reason for such speed difference between windows and linux? king regards Sven

5 17

Re: [basex-talk] Basex plot view
by Constantine Hondros 03 Nov '11

03 Nov '11

[ahem] ... just to clarify, the scatter-plot renders against a blank background, and not a map, like in the visualisation documentation. Is there any way to specify BaseX to plot the points against a map? ________________________________ From: Constantine Hondros Sent: Thursday, November 03, 2011 4:45 PM To: basex-talk(a)mailman.uni-konstanz.de Subject: Basex plot view Hi, I've got some geographical data loaded in Basex 7.1 and I was hoping to configure the plot view easily to render latitude/longitude values against a map, like the documentation suggests: http://docs.basex.org/wiki/GUI_Tutorial#Visualizations and http://basex.org/products/gui/ I can't seem to figure this one out though - any hints? Thanks ;-) Constantine Hondros | Senior Data Engineer | TomTom Places | constantine.hondros(a)tomtom.com<mailto:constantine.hondros@tomtom.com> | +31 (0) 88 245 6239 office | +31 (0) 6 402 14838 mobile | places.tomtom.com<http://places.tomtom.com/>

2 1

Basex plot view
by Constantine Hondros 03 Nov '11

03 Nov '11

Hi, I've got some geographical data loaded in Basex 7.1 and I was hoping to configure the plot view easily to render latitude/longitude values against a map, like the documentation suggests: http://docs.basex.org/wiki/GUI_Tutorial#Visualizations and http://basex.org/products/gui/ I can't seem to figure this one out though - any hints? Thanks ;-) Constantine Hondros | Senior Data Engineer | TomTom Places | constantine.hondros(a)tomtom.com<mailto:constantine.hondros@tomtom.com> | +31 (0) 88 245 6239 office | +31 (0) 6 402 14838 mobile | places.tomtom.com<http://places.tomtom.com/>

1 0

BaseX server deadlock
by Laurent Chevalier 03 Nov '11

03 Nov '11

Hi, A deadlock occurs in the following situation: a first client program opens an iterative query. For each iteration, this program does some processing and sends another reading request to BaseX (using another BaseX session). All works fine until a second client program (or another thread) sends an updating command to BaseX (like optimize for instance). This locks BaseX server. To unlock it, you have to kill the first program. I have read BaseX server code and found the reason for this behavior in the class org.basex.core.Lock: - with the iterative query, there is always at least one reader alive (readers=1). - when the updating query is received, it is put in the queue (index 0) and remains in it as long as there is a reading query running (that is to say, as long as the iterative reading query is running). - then a second reading request is received, it is put in the queue (index 1 as there is already the updating query in the queue). As it is only the second item of the queue, it remains in the queue as long as the first item in the queue (the updating query) has not been processed (BaseX processes the requests in the order of arrival, FIFO queue). But this first item can not be processed because there is the iterative reading query running. All queries are thus locked. Some may say that we should not send another query while we are in the loop of an iterative query but in our context of many sites being developed by several developers, it is possible that a developer codes this and we do not want BaseX to be locked in this case (whatever it is a mistake of the developer or not). I have found a solution to this problem by modifying the org.basex.core.Lock class. You will find my code hereafter. I do not use a queue anymore and i use a static mutex (called queueMutex) to synchronize all pending queries (threads). The "drawback" of this solution is that the queries are not processed anymore in the order of arrival but randomly. What do you think of this solution ? Do you plan to update BaseX locking mechanism ? I'm using BaseX 6.7.1 but I have seen that Lock.java has not been changed in BaseX 6.7.2. Here is my code : package org.basex.core; import java.util.Date; //import java.util.LinkedList; import java.util.Random; import org.basex.util.Util; /** * Management of executing read/write processes. * Supports multiple readers, limited by {@link MainProp#PARALLEL}, * and single writers (readers/writer lock). * * @author BaseX Team 2005-11, BSD License * @author Christian Gruen */ final class Lock { /** Queue for all waiting processes. */ // private final LinkedList<Object> queue = new LinkedList<Object>(); /** Mutex object. */ private final Object mutex = new Object(); /** Database context. */ private final Context ctx; /** Static mutex used to synchronize all pending queries. **/ private final static Object queueMutex = new Object(); /** Number of active readers. */ private int readers; /** Writer flag. */ private boolean writer; /** * Default constructor. * @param c context */ Lock(final Context c) { ctx = c; } /** * Modifications before executing a command. * @param w writing flag */ void lock(final boolean w) { synchronized(mutex) { int code = new Random(new Date().getTime()).nextInt(); // final Object o = new Object(); // queue.add(o); try { while(true) { synchronized(queueMutex) { // if(o == queue.get(0) && !writer) { if(!writer) { if(w) { if(readers == 0) { writer = true; break; } } else if(readers < Math.max(ctx.mprop.num(MainProp.PARALLEL), 1)) { ++readers; break; } } } mutex.wait(); } } catch(final InterruptedException ex) { Util.stack(ex); } // queue.remove(0); } } /** * Modifications after executing a command. * @param w writing flag */ synchronized void unlock(final boolean w) { synchronized(mutex) { if(w) { writer = false; } else { --readers; } mutex.notifyAll(); } } }

3 21

Re: [basex-talk] user setup and server
by Jan Vlčinský (CAD) 03 Nov '11

03 Nov '11

> > It is all about ease of use and security. As handling user accounts is already not the beginner task, I would see reasonable not to grant any rights by default, as Pascal proposed. Jan On 3 November 2011 05:43, Pascal Heus <pascal.heus(a)gmail.com> wrote: > Christian: > >> Running 7.0.1 under Amazon Linux. I use the "basex" script to create a > >> new user. If I then call basexclient or use a pHp client with the new > >> credentials, I get an access denied. It works fine after I restart the > >> service. Note that server is launched as a service using "basexhttp > >> -S". Could this make any difference? > >> best > *P > > > On 11/2/11 4:37 PM, Christian Grün wrote: > > Hi Pascal, > > > >> Just started to configure various user accounts. Does the server need a > >> restart in order for new accounts to be recognized? > > new user accounts are instantly activated. > > > >> Also, I would recommend the default privileges to be none or read at > >> best. New accounts should not be able to write to the DB by default. > > That could be changed pretty easily; what do others think? > > Christian > > >

2 1

user setup and server
by Pascal Heus 03 Nov '11

03 Nov '11

All: Just started to configure various user accounts. Does the server need a restart in order for new accounts to be recognized? Also, I would recommend the default privileges to be none or read at best. New accounts should not be able to write to the DB by default. best *P

2 2

BaseX 7.0.1 Update - Soft-Files.com
by Soft-Files Team 03 Nov '11

03 Nov '11

Dear Developer, Your product BaseX 7.0.1 has been updated. Your product review page is located at: http://www.soft-files.com/basex_72311.html. Sincerely, The Soft-Files Team

1 0

user password command
by Pascal Heus 02 Nov '11

02 Nov '11

As an admin, I would like to be able to change a user password. The password command however does not seem to support an account name. Could the command be extended to support two paramaters (i.e "password jdoe secret" ) Or is there another way to do this? best *P

2 1

Dynamic function invocation
by Andy Bunce 02 Nov '11

02 Nov '11

declare function local:add($x){ $x+1 }; let $b:=local:add return $b(4) Produces [XPTY0004] Variable(...): no empty sequence allowed. Have I got the syntax wrong, or is this a bug? /Andy

2 1

context for util:eval
by Andy Bunce 01 Nov '11

01 Nov '11

I notice Basex has a util:eval function similar to the eXist db one<http://demo.exist-db.org/exist/functions/util/eval>however it is not clear for the BaseX version what the inherited context, if any, is. The example on the eXist site: let $a := "Hello" return util:eval("$a") Fails with an undefined variable $a with BaseX 7.0.1 /Andy

4 6