Re: Cannot delete rows from a NDB table
MaxNoOfTriggers specifies how many meta data objects you can have at most.
So this setting defines how many tables you can define with triggers. For
example defining an ordered index uses one trigger object, defining a
foreign key uses at least 3 trigger objects.
MaxNoOfFiredTriggers sets the number of concurrently firing triggers you
can have. So this is short term memory that you have that is used for
execution of transactions.
Your problem was that MaxNoOfFiredTriggers was too low for your environment.
Normally this is very unusual, but I presume there is something special that
you do, either large transactions or a highly concurrent environment combined
with various foreign keys.
Subject
Views
Written By
Posted
1454
October 24, 2017 11:56AM
729
October 28, 2017 03:46AM
566
November 07, 2017 02:10PM
Re: Cannot delete rows from a NDB table
501
November 09, 2017 03:27AM
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.