In Amazon-RDS I have table where insertion occurs automatically by python code, it works but sometimes the insertion stops and when i see the log it shows "lock wait timeout exceeded try restarting transaction" its happening randomly. the size of my table 'Transaction' is 288 Mb. Is it happening because of the size or previous transaction is not completed? if so please help me out how to solve in rds.. Thanks.
1 Answers
It might be related to the a timeout (as the error message suggests). Most likely it has nothing to do with transaction size; its the time to commit (or rollback) your transaction is what is getting in the way.
I'm assuming you're using MySql, is that right?
You might try to increase the timeout or review your process and understand if it should, actually, take that much of time to complete.
Related