Hi John,
I have looked around a bit and you might be interested in this part:
InnoDB: Do not intentionally crash mysqld if the buffer pool is
exhausted by the lock table; return error 1206 instead ...
check this link: http://dev.mysql.com/doc/refman/4.1/en/news-4-1-8.html
it is quite interesting and i am trying to get this error on my mysql
databases by changing the bufferpool and inserting a lot of data;
Best regards,
Danny
Brittingham, John wrote:
> They are InnoDB and max_write_lock_count=4294967295.
> The same thing happens when I create a copy of the table.
>
> -----Original Message-----
> From: Danny Stolle [mailto:danny-boy@stripped]
> Sent: Saturday, December 31, 2005 2:59 AM
> To: Brittingham, John; mysql@stripped
> Subject: Re: Table Lock issue on insert
>
> Hi John,
>
> What kind of engine are you using on your table? MyIsam or InnoDB or are
>
> you using merged tables?
> If you query your system variables what is your max_write_lock_count?
>
> If you create a copy of the table: mysql>create table cp1 like
> USERS_PER_HOUR; and you try the insert again; is the error gone?
>
> Danny
>
>
>
> Brittingham, John wrote:
>
>>I am having trouble with table lock.
>>
>>The query is as follows:
>>
>>INSERT INTO USERS_PER_HOUR SELECT count( DISTINCT (
>>
>>CUID
>>
>>) ),`TV_LOG_DATE`,`TV_LOG_TIME`, INTERFACE_ID
>>
>>FROM `TV_LOG_ALL`
>>
>>group by 2,3;
>>
>>
>>
>>I keep getting this error: #1206 - The total number of locks exceeds
>
> the
>
>>lock table size
>>
>>
>>
>>How do I fix this?
>>
>>
>>
>>
>
>
>
