Re: [bdbxml] Can't allocate memory error

After I deleted the log and __db files in dbEnv directory, my query got stuck
and would not finish.

The XML documents I loaded are quite simple. Total size is 110MB (in 5000 small
XML documents).

<employees>
  <employee>
   <empno>...</empno>
   <salary>...</salary>
  </employee>
</employees>

The query is: /employees/employee[empno='100002']/salary

Frank


--- Javier Fernandez Rodriguez 
<javifer2000-Re5JQEeQqe8AvxtiuMwx3w@xxxxxxxxxxxxxxxx> wrote:
> Hi!
> 
> Can you delete all files of the Environment? Because yesterday i have
> the same problem and although i put a size of 100000000000000 :) the
> problem was there. But when i deleted all files, i finish with the
> problem.
> 
> I hope help you.
> 
> Regards
> 
> Javier
> 
> 
> On Tue, 15 Mar 2005 07:45:19 -0800 (PST), Fusheng Wang
> <wang_fusheng-/E1597aS9LQAvxtiuMwx3w@xxxxxxxxxxxxxxxx> wrote:
> > Hi John,
> > 
> > I increased the maxs  to more than 1,000,000, the problem still happens.
> >        config.setMaxLockers(1000000);
> >        config.setMaxLocks(2000000);
> >        config.setMaxLockObjects(2000000);
> > I got errors when I specify an XPath query, or create an index on
> > "/employees/employee[empno='100002']/salary".
> > 
> > Lock table is out of available locks
> > Error adding index to container temporal.dbxml
> >   Message: Error: Db::get: Cannot allocate memory
> > Exception in thread "main" com.sleepycat.dbxml.XmlException: Error:
> Db::get:
> > Cannot allocate memory, errcode = DATABASE_ERROR
> >        at
> >
>
com.sleepycat.dbxml.dbxml_javaJNI.XmlContainer_setIndexSpecification__SWIG_1(Native
> > Method)
> >        at
> >
> com.sleepycat.dbxml.XmlContainer.setIndexSpecification(XmlContainer.java:240)
> >        at AddIndex.AddIndex(AddIndex.java:42)
> >        at AddIndex.main(AddIndex.java:96)
> > 
> > Frank
> > 
> > 
> > --- John Snelson <john-fpVSrmTEiiv3oGB3hsPCZA@xxxxxxxxxxxxxxxx> wrote:
> > > Fusheng Wang wrote:
> > > > I am writing a simple query to search a collection of 5000 XML
> documents
> > > (with
> > > > total size 110MB).
> > > > I got the following error:
> > > >
> > > > Lock table is out of available locker entries
> > > > Erro performing against xyz.dbxml
> > > > Message:Error: Dbc::get: Connot allocate memory
> > > > Error code = DATABASE_ERROR.
> > > >
> > > > I do have 1GB memory on my machine, and I have allocated 700MB memory
> for
> > > JVM.
> > > >
> > > > What can be the problems? Thanks a lot.
> > >
> > > This is not a memory issue, this is to do with the fixed resources that
> > > the DbEnv object has allocated to it. You need to increase the number of
> > > locker entries by using DbEnv::set_lk_max_lockers(). While you are doing
> > > that, you may want to increase other lock related resources, using
> > > DbEnv::set_lk_max_locks() and DbEnv::set_lk_max_objects(). See
> > > http://www.sleepycat.com/xmldocs/api_cxx/lock_list.html
> > >
> > > It sounds like you have plenty of memory, but if you had less and didn't
> > > want to allocate more locker entries, you could reduce the amount of
> > > data that you read/write in a single transaction, or reduce the number
> > > of node level storage documents that you keep open at any one time.
> > > Transactions, and node level storage documents need a locker entry each
> > > while they are active/open.
> > >
> > > Hope this helps,
> > >
> > > John Snelson
> > >
> > > --
> > > John Snelson, XML Consultant           +44-1865-811184
> > > Parthenon Computing Ltd                http://blog.parthcomp.com/dbxml
> > >
> > 
> > __________________________________
> > Do you Yahoo!?
> > Make Yahoo! your home page
> > http://www.yahoo.com/r/hs
> > 
> > 
> > ------------------------------------------
> > To remove yourself from this list, send an
> > email to xml-unsubscribe-E1rGyZxLSgzby3iVrkZq2A@xxxxxxxxxxxxxxxx
> > 
> > 
> 
> 
> -- 
> Javier Fernández Rodriguez
> Email_1: javifer2000-Re5JQEeQqe8AvxtiuMwx3w@xxxxxxxxxxxxxxxx
> Email_2 y Messenger: javifer2000-PkbjNfxxIARBDgjK7y7TUQ@xxxxxxxxxxxxxxxx
> Web: http://www.pikarin.tk
> 


                
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 


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