Re: Querying and times

I'll attach an example tomorrow.  Also the jmeter documentation is great.
Eric Palmer
Director of Web Services
University of Richmond
________________________________________
From: José Angel [templerioinmortal <at> gmail.com]
Sent: Wednesday, November 30, 2011 10:08 AM
To: Palmer, Eric
Cc: exist-open <at> lists.sourceforge.net
Subject: Re: [Exist-open] Querying and times

Thanks Both!. Eric can you give me an example or instruction of how to load the queries that i want, send them
to exist-db and just record the results time? That's all that i need.

Thanks once again!.

On Mon, Nov 28, 2011 at 10:24 AM, Palmer, Eric <epalmer <at> richmond.edu<mailto:epalmer <at> richmond.edu>> wrote:
Jmeter is a good benchmark client that we use all the time. A java app, open source and allows recording the results.

Eric Palmer

Sent from my iPhone

On Nov 28, 2011, at 9:42 AM, "José Angel"
<templerioinmortal <at> gmail.com<mailto:templerioinmortal <at> gmail.com>> wrote:

> Hello, i'm trying to test a benchmark with exist and i have one question. Is there any way to run something
like 20 or 40 queries that could take a lot of time, and at the end to check a file with the response times for
each query?. I mean a file like:
>

Re: Querying eXist from Java

No, i want to made all code myself, just a class that can make the
queries. Is there an api or something to make queries to exist?

I want something like if i am on PHP and send a Query to MySQL.
Something like that but sending a query to exist from java.

Example:
Connect exist using user X and password Y.
Send query Q1 and get result
Send query Q2 and get result
...

2011/11/30, Patrick Bosek <patrick.bosek <at> jorsek.com>:
> Is this other application JMeter?
>
> On Wed, Nov 30, 2011 at 5:38 PM, José Angel
> <templerioinmortal <at> gmail.com>wrote:
>
>> Another application, yes, the query is going to be on the same
>> machine. I just want to know how to make a query, i don't even need
>> the result, just want to know how many time it took. I can use java
>> api to get initial time and final time based on my system but i need
>> to know how to run the query. Thanks!.
>>
>> 2011/11/30, Patrick Bosek <patrick.bosek <at> jorsek.com>:
>> > Are you trying to write a Java module? Or are you trying to query eXist
>> > from another Java application? If it is another app, is it going to be
>> > on
>> > the same machine?
>> >

Re: Querying and times

Thanks! Really appreciate it!. I just need to run like 120 queries and
get the result time in this application. I don't know which port uses
exist to receive queries, how to configure JMeter to use it, etc...

2011/11/30, Palmer, Eric <epalmer <at> richmond.edu>:
> I'll attach an example tomorrow.  Also the jmeter documentation is great.
> Eric Palmer
> Director of Web Services
> University of Richmond
> ________________________________________
> From: José Angel [templerioinmortal <at> gmail.com]
> Sent: Wednesday, November 30, 2011 10:08 AM
> To: Palmer, Eric
> Cc: exist-open <at> lists.sourceforge.net
> Subject: Re: [Exist-open] Querying and times
>
> Thanks Both!. Eric can you give me an example or instruction of how to load
> the queries that i want, send them to exist-db and just record the results
> time? That's all that i need.
>
> Thanks once again!.
>
> On Mon, Nov 28, 2011 at 10:24 AM, Palmer, Eric
> <epalmer <at> richmond.edu<mailto:epalmer <at> richmond.edu>> wrote:
> Jmeter is a good benchmark client that we use all the time. A java app, open
> source and allows recording the results.
>
> Eric Palmer
>
> Sent from my iPhone

Re: Querying eXist from Java

José,

> I want something like if i am on PHP and send a Query to MySQL.
> Something like that but sending a query to exist from java.

There seems to be documentation on issuing queries with Java, no?

  http://demo.exist-db.org/exist/xquery/search.xql?q=java+query

leads to

  http://exist-db.org/devguide.html

and especially

  http://exist-db.org/devguide_xmldb.html

Joe

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Exist-open mailing list
Exist-open <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/exist-open

Re: Querying eXist from Java

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d

_______________________________________________
Exist-open mailing list
Exist-open <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/exist-open

Re: XQuery wrong xpath resolution bug ?

2011/11/25 Wolfgang Meier <wolfgang <at> exist-db.org>:
> Hi Jens,
>
> Thanks for tracking this down to my change. I will look into it.
>
> Wolfgang
>
> Am 25.11.2011 13:14 schrieb "Jens Østergaard Petersen" <oesterg <at> gmail.com>:
>
>> Hi Wolfgang,
>>
>> This bug was introduced with your revision 15457 changes
>> to Optimizer.java.
>>
>> Best,
>>
>> Jens
>>

Seems like the problem maybe deeper -- I switched to the prior r15456,
and while this particular bug is not manifested, I am getting other
weird failures --

e.g. if ($docitem/bu:permissions/bu:permission[ <at> name='zope.View' and
 <at> role='bungeni.Anonymous' and  <at> setting='Allow'])  evaluates to true
even for nodes where  <at> setting=Deny.

The odd thing is the same query works fine in the sandbox -- but when
run from an xql script (presumably because the sandbox uses eval() to
run the queries which bypasses the optimizer ? )

Other odd behaviors found post r15457 --

queries like : collection(...)//bu:legislativeItem[./permissions/permission[...]
]  return incorrect results, i have to xpath to the matching node and
use the ancestor:: axis to return the parent to make it work correctly
0

ashok

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d

Failed to invoke method releaseQueryResult

Hi guys,

When putting the db under (medium) stress after a while we get a group of these on the eXist server side

DEBUG (RpcConnection.java [releaseQueryResult]:2587) - removed query result with handle -1

which translates into a group these on the client side

ERROR [STDERR] (Finalizer:) Failed to release query result on server: Failed to invoke method
releaseQueryResult in class org.exist.xmlrpc.RpcConnection: null

Any idea what could be causing this?

Should we worry ?

Bruno
www.amalto.com

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d

bad link to next page warning

Hi,

After an 'update replace' we get the following Warning in the logs.

Is it just a warning or an actual error ? (e.g. the query did not complete)

Is the DB corrupted?

Many Thanks

Bruno
www.amalto.com

2011-11-30 23:38:17,471 [SocketListener0-2] WARN  (SanityCheck.java [showTrace]:93) - Stacktrace:
org.exist.util.sanity.AssertFailure: TRACE: bad link to next page: 15952; file = dom.dbx; address =
3e51000; page header = 64; data start = 3e51040; previous: 15953; offset = 3528; lastTID = 164
        at org.exist.util.sanity.SanityCheck.TRACE(SanityCheck.java:72)
        at org.exist.storage.dom.RawNodeIterator.next(RawNodeIterator.java:130)
        at org.exist.stax.EmbeddedXMLStreamReader.next(EmbeddedXMLStreamReader.java:237)
        at org.exist.storage.dom.DOMFile.findValue(DOMFile.java:1351)
        at org.exist.storage.dom.DOMFile.getNodeValue(DOMFile.java:2069)
        at org.exist.storage.NativeBroker$14.start(NativeBroker.java:3085)
        at org.exist.storage.dom.DOMTransaction.run(DOMTransaction.java:111)
        at org.exist.storage.NativeBroker.getNodeValue(NativeBroker.java:3083)
        at org.exist.dom.NodeProxy.getNodeValue(NodeProxy.java:680)
        at org.exist.dom.NodeProxy.atomize(NodeProxy.java:724)
        at org.exist.xquery.GeneralComparison.nodeSetCompare(GeneralComparison.java:516)
        at org.exist.xquery.GeneralComparison.quickNodeSetCompare(GeneralComparison.java:742)
        at org.exist.xquery.GeneralComparison.eval(GeneralComparison.java:377)
        at org.exist.xquery.AbstractExpression.eval(AbstractExpression.java:61)
        at org.exist.xquery.PathExpr.eval(PathExpr.java:241)
        at org.exist.xquery.Predicate.selectByNodeSet(Predicate.java:331)
        at org.exist.xquery.Predicate.evalPredicate(Predicate.java:205)
        at org.exist.xquery.LocationStep.processPredicate(LocationStep.java:236)
        at org.exist.xquery.LocationStep.applyPredicate(LocationStep.java:225)
        at org.exist.xquery.LocationStep.eval(LocationStep.java:390)
        at org.exist.xquery.pragmas.Optimize.eval(Optimize.java:171)
        at org.exist.xquery.ExtensionExpression.eval(ExtensionExpression.java:71)
        at org.exist.xquery.AbstractExpression.eval(AbstractExpression.java:61)
        at org.exist.xquery.PathExpr.eval(PathExpr.java:241)
        at org.exist.xquery.AbstractExpression.eval(AbstractExpression.java:61)
	...

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d

building AtomicWiki error

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d

_______________________________________________
Exist-open mailing list
Exist-open <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/exist-open

Looking for best practice / advice on simple Xquery optimisation

Hello,

First of all I apologize if this is a naive question because just a matter of style.

I have some collection with some resources named after a unique id, such as:

/db/mycol/1.xml
/db/mycol/2.xml
...

where each resource also contains the unique id as an attribute on the root element:

1.xml contains <Data id="1">.... </Data>
2.xml contains <Data id="2">.... </Data>
...

My question is to know wether it makes any difference to query a single <Data> element using the doc()
function with a precise resource name or the collection() function with an XPath expression matching on
the id attribute:

doc('/db/mycol/1.xml')/Data
vs.
collection('/db/mycol')/Data[ <at> id = '1']

Does it make any difference, is there a best way to write this query ?

Stéphane S.
----

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d