Transaction rolled back mid-query

Help Procedural SQL
1

In my procedure, I am updating the column using 2 tables join conditions some times I am getting the below error message, not every time… what is the region there…

procedure_name line 284: ER_ROLLED_BACK_TRANSACTION (1857), Leaf Error (ddltlmem207:3306): Leaf Error (ddltlmem204:3306): Transaction rolled back mid-query

2

What’s the SQL statement you are running when you get this error?

And what else is happening on the cluster when you get the error?

3

Thanks Hason
it is just updating the table in the procedure and cluster not sure