MySQL Forums
Forum List  »  NDB clusters

Re: error 293 Inconsistent trigger state in TC block
Posted by: Mikael Ronström
Date: March 15, 2018 05:45PM

My first thought was that it is hard to see this information.
Then I brought forth my own book about NDB and started reading.
The good news is that writing a book is good for me as well. I
tend to forget most things, but I usually have a hunch about where
to look for it, and a book helps there.

Anyways I looked into the chapter on ndbinfo tables.
There are two interesting ones here.

The first is the counters table. This table will give you stats on number
of reads, writes, local reads, local writes, scans, transactions and so
forth.

Executing the following query before and after your problem query will give
you some insights into what happened when executing the query.

SELECT counter_name, sum(val) from counters group by counter_name;

The second table that can be useful here is the cluster_operations table.
This table should be used with caution and not in production.

Running a query against this ndbinfo table while the query is ongoing
could be interesting and give you detailed insights into what is going on
while executing the query.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: error 293 Inconsistent trigger state in TC block
580
March 15, 2018 05:45PM


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.