Table Lock issue on insert

[John Brittingham]

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?