Hi, I have 1 SP that does INSERT and UPDATE query to 1-2 tables. It runs ok for sometime, but i sometime got this error message:
"ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction" The message would ussually dissapear and the SP runs well for sometime until the same error message comes again. How can this be happening since I am the only who is doing anything with the DB? Rgds/Hardi
