Re: error 293 Inconsistent trigger state in TC block
293 is equal to ZINCONSISTENT_TRIGGER_STATE. This error code is set
in DbtcMain.cpp. In the code when set we find this comment:
/* Trigger entry found but either :
* - Overload resulted in loss of Trig_Attrinfo
* : Release resources + Abort transaction
* - Bad transaction id due to concurrent abort?
* : Release resources
*/
jam();
errorCode = ZINCONSISTENT_TRIGGER_STATE;
In your case the most likely case is Overload resulted in loss of
Trig_Attrinfo. TRIG_ATTRINFO is a signal sent containing the trigger
information.
Given that you have had to setup the parameters to be so high I presume
you have a significant amount of triggers firing.
Loss of signals is only allowed for a few select signals and
handled in
void Dbtc::execSIGNAL_DROPPED_REP(Signal* signal)
So my presumption is that you ran out of LongMessageBuffer.
Another possible but less likely alternative is that you ran out
SendBufferMemory.
Anyways if you are a customer you should report this incident.
There might be other reasons you get this problem other than the
one I can think of.
Subject
Views
Written By
Posted
1092
March 14, 2018 02:19PM
Re: error 293 Inconsistent trigger state in TC block
587
March 14, 2018 09:07PM
546
March 15, 2018 12:45PM
548
March 15, 2018 05:45PM
576
March 16, 2018 12:52PM
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.