mysqldump error on NDB

08 02 2008

Whilst doing work on our development server at work today I tried to do an export of our live database and got the following error:

mysqldump: Error 1297: Got temporary error 233 'Out of operation records in transaction coordinator (increase MaxNoOfConcurrentOperations)' from ndbcluster when dumping table `xxxxxxxxxxxx` at row: 37542

After trying several things to get mysqldump to actually export the data I gave in and changed MaxNoOfConcurrentOperations to twice its current size, did a rolling restart and it was successful.

My main worry was that MaxNoOfConcurrentOperations would require a complete cluster restart which would mean downtime as with MaxNoOfConcurrentTransactions, luckily this wasn't the case and I have one happy and healthy cluster again.

Comments : No comments »
Categories : MySQL
Trackbacks : No Trackbacks »
Defined tags for this entry: ,
Related entries by tags:
Catchup
Curse of Virgin, new job at Sun
ndb_watch 0.6.1 released
ndb_watch 0.6.0 released
MySQL Certified DBA
Bookmark mysqldump error on NDB at del.icio.us Digg mysqldump error on NDB

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)
No comments

Add Comment


Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA