<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.3.2">
</HEAD>
<BODY>
<BR>
Forgive an uneducated and probably irrelevant response, but I got the same error when I <BR>
was accidentally opening a separate connection in each of my tests. I was creating several dozens<BR>
or hundreds of store controllers, I think. When I solved that problem, I don't thnk this has <BR>
reoccurred for me.<BR>
<BR>
Forgive my not being able to be more specific.<BR>
<BR>
<BR>
On Wed, 2005-02-23 at 17:44 +0100, Walter C. Pelissero wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Looks as I've been hitting some DB limit but I haven't found out which</FONT>
<FONT COLOR="#000000">one.</FONT>
<FONT COLOR="#000000">At the 376th iteration of a stress test I got a sleepycat:db-error</FONT>
<FONT COLOR="#000000">(Berkeley DB error: Cannot allocate memory). Each test iteration is</FONT>
<FONT COLOR="#000000">wrapped in a transaction, so I really don't understand what is</FONT>
<FONT COLOR="#000000">consuming Sleepycat DB resources.</FONT>
<FONT COLOR="#000000">If I had to guess from "db_stat -c" I'd say I'm running out of locks:</FONT>
<FONT COLOR="#000000"> 360% db_stat-4.2 -c</FONT>
<FONT COLOR="#000000"> 18 Last allocated locker ID.</FONT>
<FONT COLOR="#000000"> 2147M Current maximum unused locker ID.</FONT>
<FONT COLOR="#000000"> 9 Number of lock modes.</FONT>
<FONT COLOR="#000000"> 1000 Maximum number of locks possible.</FONT>
<FONT COLOR="#000000"> 1000 Maximum number of lockers possible.</FONT>
<FONT COLOR="#000000"> 1000 Maximum number of lock objects possible.</FONT>
<FONT COLOR="#000000"> 1004 Number of current locks.</FONT>
<FONT COLOR="#000000"> 1005 Maximum number of locks at any one time.</FONT>
<FONT COLOR="#000000"> 10 Number of current lockers.</FONT>
<FONT COLOR="#000000"> 11 Maximum number of lockers at any one time.</FONT>
<FONT COLOR="#000000"> 576 Number of current lock objects.</FONT>
<FONT COLOR="#000000"> 897 Maximum number of lock objects at any one time.</FONT>
<FONT COLOR="#000000"> 5305968 Total number of locks requested.</FONT>
<FONT COLOR="#000000"> 5296499 Total number of locks released.</FONT>
<FONT COLOR="#000000"> 0 Total number of lock requests failing because DB_LOCK_NOWAIT was set.</FONT>
<FONT COLOR="#000000"> 0 Total number of locks not immediately available due to conflicts.</FONT>
<FONT COLOR="#000000"> 0 Number of deadlocks.</FONT>
<FONT COLOR="#000000"> 0 Lock timeout value.</FONT>
<FONT COLOR="#000000"> 0 Number of locks that have timed out.</FONT>
<FONT COLOR="#000000"> 0 Transaction timeout value.</FONT>
<FONT COLOR="#000000"> 0 Number of transactions that have timed out.</FONT>
<FONT COLOR="#000000"> 360KB The size of the lock region..</FONT>
<FONT COLOR="#000000"> 0 The number of region locks granted after waiting.</FONT>
<FONT COLOR="#000000"> 5331227 The number of region locks granted without waiting.</FONT>
<FONT COLOR="#000000">Is that right? If so, how am I supposed to limit the number of locks</FONT>
<FONT COLOR="#000000">held by my code/elephant?</FONT>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>