Hi Marco, My hint is to read the BDB section of the manual:
http://dev.mysql.com/doc/refman/5.0/en/bdb-start.html specifically the part that says: " With the bdb_max_lock variable, you can specify the maximum number of locks that can be active on a BDB table. The default is 10,000. You should increase this if errors such as the following occur when you perform long transactions or when mysqld has to examine many rows to execute a query: bdb: Lock table is out of available locks Got error 12 from ... You may also want to change the binlog_cache_size and max_binlog_cache_size variables if you are using large multiple-statement transactions. See Section 5.11.3, "The Binary Log". " What is your binlog_cache_size and max_binlog_cache_size? -Sheeri On 12/7/05, Marco Baroetto <[EMAIL PROTECTED]> wrote: > Hi, > I have a berkeley db table containing about 50000 rows where I do this > transaction (pseudocode follows): > > begin work > delete from mytable where myfield='boo' /*delete about 100 rows*/ > for (i=0; i<=100; i++){ > insert into mytable values(...); > } > commit > > During the insert command i get the following error: > "Lock table is out of available locks" > > I tried to resolve the problem starting mysqld with -O > bdb_max_lock=60000 and later with -O bdb_max_lock=120000 but i still > receive the same error. > > dbd related variables follows: > > mysql> show variables like "%bdb%"; > +---------------------+--------------------------------------------------------+ > | Variable_name | > Value | > +---------------------+--------------------------------------------------------+ > | bdb_cache_size | > 8388600 | > | bdb_home | > /var/lib/mysql/ | > | bdb_log_buffer_size | > 32768 | > | bdb_logdir > | | > | bdb_max_lock | > 120000 | > | bdb_shared_data | > OFF | > | bdb_tmpdir | > /tmp/ | > | have_bdb | > YES | > | version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (May 13, > 2005) | > +---------------------+--------------------------------------------------------+ > 9 rows in set (0.00 sec) > > Any hint is welcome.. > > Thanx in advance for the help, > Marco > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
