Re: Lock wait timeout exceeded; try restarting transaction

[Mikael Ronström]

Lock wait timeout can happen if your application is experiencing a deadlock. It can also happen due to a node failure when the transaction is aborted and rolled back as a consequence of one node failing in the middle of a transaction. Finally it could be that overload causes the progress to be so slow that the timeout occurs. What happens in your case I don't know. But overload looks to be fully possible with 155 concurrent insert clients. Deadlocks should not happen if all concurrent clients are pure inserters. Node failure I presume haven't happened since you haven't mentioned it. So the most likely cause is that the system slowed down due to overload.