transaction with bdb table gives error "Lock table is out of available locks"

[Marco Baroetto <suppressed>]

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/suppressed