From: Date: January 2 2006 8:08pm
Subject: Re: Table Lock issue on insert
List-Archive: http://lists.mysql.com/mysql/193422
Message-Id: <43B97A1C.4050805@chello.nl>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi john,

When did you start getting this error message?
There aren't any trouble with MyIsam tables?

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?
>>
>> 
>>
>>
> 
> 
>