[bdbxml] Locker entries exceeded?
"Antony Grinyer" <antony.grinyer-TjPRh57ScDpaa/[email protected]> Mon, 26 Sep 2005 09:49:56 +0100
| Newsgroups | gmane.comp.db.dbxml.general |
|---|---|
| Message-ID | <989E1989F3130042879B902D175842163EFD70@msxmigration.cswgroup.local> |
------_=_NextPart_001_01C5C277.4559272E Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Hi, We're getting an error when running queries against a container holding thousands of small XML documents: Lock table is out of available locker entries com.sleepycat.dbxml.XmlException: Error: Dbc::get: Not enough space, errcode =3D DATABASE_ERROR We've increased the 3 parameters on the DB XML Environment objects to 10,000: envConfig.setMaxLocks(10000); envConfig.setMaxLockers(10000); envConfig.setMaxLockObjects(10000); ...but we still get the error after a few queries, can anyone shed some light please? Thanks, Ant ------_=_NextPart_001_01C5C277.4559272E Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE></TITLE> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR></HEAD> <BODY><!-- Converted from text/plain format --> <P><FONT face=3DVerdana size=3D2>Hi,<BR><BR>We're getting an error when = running=20 queries against a container holding thousands of small XML=20 documents:<BR><BR><STRONG>Lock table is out of available locker entries=20 com.sleepycat.dbxml.XmlException: Error: Dbc::get: Not enough space, = errcode =3D=20 DATABASE_ERROR</STRONG><BR><BR>We’ve increased the 3 parameters on = the DB XML=20 Environment objects to=20 10,000:<BR><BR>envConfig.setMaxLocks(10000);<BR>envConfig.setMaxLockers(1= 0000);<BR>envConfig.setMaxLockObjects(10000);<BR><BR>...but=20 we still get the error after a few queries, can anyone shed some light=20 please?<BR><BR>Thanks,<BR>Ant<BR><BR></FONT></P></BODY></HTML> ------_=_NextPart_001_01C5C277.4559272E--