0

Here is my node, which sometimes freezes by the last INSERT command:

enter image description here

This process sometimes will freeze because the functionality for this node is to truncate the table. But sometimes the previous inserting command is not finished and the truncate is triggered, which will cause this node freeze for 2 hours to complete (originally should be 2 seconds to finish).

So my solution is to set up a timer condition if this node take too long then run the Stored procedure stop all MySQL current database tasks (the inserting Action which insert data to this table).

What stored procedure can do this work?

Adrian Mole
  • 49,934
  • 160
  • 51
  • 83
PEIRAN LIU
  • 157
  • 2
  • 11
  • 1
    You had moved in a wrong direction and finally looking for a solution to patch up. Better to reverse the whole and start afresh by re-designing so that you do not need to truncate often. Also, it is unexpected to truncate when insertion is happening. 2 seconds to 2 hours !!! As I mentioned...better to re-design. – Natarajan N Napoleon Feb 18 '20 at 17:57

1 Answers1

0

Is the previous node that is doing the insert, configured to run multiple instances? If it is then it is probably configured to "Move on when: Each time an instance finishes". If that is the case then you can configure the previous node to "Move on when: All instances are done".

Zubair Suri
  • 361
  • 1
  • 4