java.sql.SQLException: The total number of locks exceeds the lock table size

[purushotham podaralla]

Hi,

i am getting the below error.

java.sql.SQLException: The total number of locks exceeds the lock table size.

The same query what it is generating at the time of the above error is.

INSERT INTO xxx (date,id,F1,F2,F3,F4,F5,F6,F7,F11,F12, COUNT) SELECT date,id,F1,F2,F3,F4,F5,F6,F7,round(avg(F11),2) F11,round(avg(F12),2) F12,COUNT(*) COUNT FROM yyy WHERE date >= ? AND date <= ? AND id = ? GROUP BY date,F1,F2,F3, F4,F5,F6,F7.

when executing the select query of insert on select. i am getting 0 rows as shown below.

mysql> select count(*) from yyy WHERE date >= '2010-08-12' AND date <= '2010-08-13' AND ID = 11;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.10 sec)

Please let me know how to resolve this issue.

Thanks in Advance.

Regards,
Purushotham