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.
Hi Marco.
What does 'SHOW CREATE TABLE' look like for your table?
You may want to file a bug about this and attach your data and the
actual queries being run. I was not able to come up with a test case to
reproduce this problem, but you haven't provided much information to go
on.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
