Strapi bug causing mysql ER_LOCK_WAIT_TIMEOUT

System randomly gives this error: ER_LOCK_WAIT_TIMEOUT. (Once a few days)
Lock wait timeout exceeded; try restarting transaction.
It happens when trying to save an invoice object that contains 62 subchild components.
Solution: i restart the server and all ok, request can be made.
Currently can’t replicate problem it happens randomly.
How can i debug mysql transactions within strapi ? any ideeas ?

This topic has been created from a Discord post (1228227892958466079) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord