Cannot delete rows from a NDB table

[Mouhsen Ibrahim]

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.