Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
purushotham podaralla
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic