deadlock found when trying to get lock try restarting transaction mysql

abruck's profile image abruck posted 4 years ago in General Permalink

I am getting a "SQL Error (1213): Deadlock found when trying to get lock try restarting transaction mysql when running many thousands of procedures, one at a time."

The it says: "Notice: You can disable the "Stop on errors in batch mode" option to ignore such errors"

But where is the "Stop on errors in batch mode" option?

See attached for exact error message

1 attachment(s):
  • error_1213
ansgar's profile image ansgar posted 4 years ago Permalink

Please look into this thread - that button should be twice as big I guess.

Please login to leave a reply, or register at first.