`
bayaci
  • 浏览: 265677 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

transaction coordinator (increase MaxNoOfConcurrentOperations)' from ndbcluster

阅读更多

mysql> TRUNCATE TABLE `user_ourproperty`;

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

And if I try to empty it with a DELETE command, I get a different error:

mysql> DELETE FROM user_ourproperty WHERE 1 LIMIT 1000000;

ERROR 1297 (HY000): Got temporary error 233 'Out of operation records in
transaction coordinator (increase MaxNoOfConcurrentOperations)' from ndbcluster

在mysql cluster 中进行了较长时间的操作时,就会报这样的提示。当这样时我就用少量数据的操作,减少事务的处理时间,使得事务处理时间在MaxNoOfConcurrentOperations设置范围之内。

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics