mardi 3 février 2015

MySQL Cluster error on UPDATE: increase MaxNoOfConcurrentOperations


I had a table with ~0.5M rows and tried to exec simple query, something like


UPDATE table SET col1=-90 + RAND()*90, col2=-180+RAND()*360 WHERE col1=9999


but result was


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


Ok, I have MaxNoOfConcurrentOperations=100000 and slightly more than 100000 rows which satisfy where condition, so i have changed this query:


UPDATE table SET col1=-90 + RAND()*90, col2=-180+RAND()*360 WHERE col1=9999 ORDER BY ID LIMIT 100000


and got same error. And same error whith LIMIT 1000.


I have updated rows using query with LIMIT 100 in loop, but I think that it bad solution.


Why MySQL Cluster behave in such way? How can I just update many rows in single table?





Aucun commentaire:

Enregistrer un commentaire