dbxml hangs

[Rémi Dewitte-4]

Hello !
I'm trying to query over a big xml database (2.3G) and dbxml seems to
hang out after a while. Which means dbxml process has no activity.

With a ps:
500      32500 10.3 52.0 575544 536308 pts/1 S    16:52   0:20 dbxml

with a top :
32500 webmaste  21   0  529M 504M  105M S     0.0 50.1   0:20   0 dbxml

My query is composed an xquery with 2 indexed values for selection.

Is it a known memory (RAM) limitation ?

Remi



------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe@...

[Antony Grinyer]

Hi,

How do you overwrite an existing file with the same name in a container?
If I try to load a file with the same name twice I get a DB XML
exception saying the file exist - I'd just like the file to be
overwrited automatically if possible,


Thanks in advance,
Ant



------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe@...

[John Snelson]

If you use the updateDocument() method, then the document will be
overwriten.

John

Antony Grinyer wrote:

> Hi,
>
> How do you overwrite an existing file with the same name in a container?
> If I try to load a file with the same name twice I get a DB XML
> exception saying the file exist - I'd just like the file to be
> overwrited automatically if possible,
>
>
> Thanks in advance,
> Ant
>
>
>
> ------------------------------------------
> To remove yourself from this list, send an
> email to xml-unsubscribe@...
>

--
John Snelson, Berkeley DB XML Engineer
Sleepycat Software, Inc
http://www.sleepycat.com

Contracted to Sleepycat through Parthenon Computing Ltd
http://blog.parthcomp.com/dbxml


------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe@...

[George Feinberg-3]

Remi,

A hang without CPU activity is usually an indication of a lock
conflict.  Are you using transactions?  If so, what do the calls
involving, and surrounding your current transaction look like?
Also, you can use the db_stat command to look at lock state
during a hang:
        db_stat -CA
Will give you a lot of information (maybe too much).  See
        http://www.sleepycat.com/xmldocs/utility/db_stat.html

Depending on whether the indexes are being used, and
the nature of the query and data, a query on 2.3 GB could run
out of memory, but that would not typically result in a hang -- it's
throw an exception.

Regards,

George

On Jul 4, 2006, at 11:03 AM, Remi Dewitte wrote:

> Hello !
> I'm trying to query over a big xml database (2.3G) and dbxml seems  
> to hang out after a while. Which means dbxml process has no activity.
>
> With a ps:
> 500      32500 10.3 52.0 575544 536308 pts/1 S    16:52   0:20 dbxml
>
> with a top :
> 32500 webmaste  21   0  529M 504M  105M S     0.0 50.1   0:20   0  
> dbxml
>
> My query is composed an xquery with 2 indexed values for selection.
>
> Is it a known memory (RAM) limitation ?
>
> Remi

------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe@...