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.
subject: java.sql.SQLException: The total number of locks exceeds the lock table size