On Jul 2, 6:37 am, Geoff [EMAIL PROTECTED] wrote:
Hi,
I'm getting this exception: 'Lock wait timeout exceeded; try
restarting transaction.
you shouldn't have transactions locking for so long that you're
getting such an error. meaning, try not to have long-running
transactions open.
Hi! thanks for replying :)
I agree that transactions shouldn't be timing out, the problem happens
when we do a database dump, this locks all the tables for a while and
it happens once a day.
I think I'll go fix it at the source rather than handling it in the
code - i.e. find another way of