Forums

OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')

A few days ago, I got this errors in my web2py app. In stackoverflow says about this error: "...changing innodb_lock_wait_timeout might temporarily defer the "Lock wait timeout exceeded" issue".

I cant see the timeout of my db, because i have no privilege to execute SHOW ENGINE INNODB STATUS

The lock wait timeout is 50 seconds on PythonAnywhere, so you'd have to be doing something pretty pathological to cause the timeout. Have a look in your code for any transactions that could be locking lots of rows for a long time.