Re: Lock wait timeout exceeded; try restarting transaction

[Lars Gustafsson]

No, it should be a few hundred row insert. It ads the daily stats from Google. To trigger it all I have to do is an update of the corrupt row. It stands there for a while and the exits with a "Lock Wait Timeout". If I restart MySQL it starts working again. But now a special job has experienced more severe problems of this nature. I restart mysql and the job works when triggered manually but not when triggered chronologically on schedule. Actually all failed first and then a few worked but most failed. It's the same job executing multiple times.