MySQL Forums
Forum List  »  NDB clusters

Cannot delete rows from a NDB table
Posted by: Mouhsen Ibrahim
Date: October 24, 2017 11:56AM

Hi everyone,

I am trying to delete some rows from a NDB table with this query:

DELETE FROM Users where email is null;

I get the following error:

ERROR 1297 (HY000): Got temporary error 221 'Too many concurrently fired triggers (increase MaxNoOfFiredTriggers)' from NDBCLUSTER

Yes I know I can increase MaxNoOfFiredTriggers and restart the cluster to solve the issue but why is this showing up?

Now I am trying to do this manually what if my web application needed to delete some data and this error showed? I might take long time to detect this and solve it.

Can you help me with knowing why is this happening and how to properly configure NDB Cluster options?

Thanks a lot,
Mouhsen Ibrahim.

Options: ReplyQuote

Written By
Cannot delete rows from a NDB table
October 24, 2017 11:56AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.