| Danny Stolle 2006-01-02, 1:23 pm |
| 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@chello.nl]
> Sent: Saturday, December 31, 2005 2:59 AM
> To: Brittingham, John; mysql@lists.mysql.com
> 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:
>
>
> the
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|