Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am using the mysql version 5.5.29 in my production server. while executing set of update statement inside the procedure it is throughing the following error: ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction update and its not updating all statements too in the SP.

the table which i am updating is used in so many reports. and is used by so many people. can't i avoid this error and make my SP execute all the time??.

the variable innodb_table_locks is on.. do i need to turn off this variable?

share|improve this question
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.