MySQL Forums
Forum List  »  InnoDB

Re: Lock wait timeout exceeded; try restarting transaction
Posted by: Vector Thorn
Date: June 15, 2010 07:27PM

FYI: you cannot use 'truncate table_name' in a stored function, as i alluded to before, as it will give you this error: 'Explicit or implicit commit is not allowed in stored function or trigger. (errno: 1422)'

Still never found what would have caused that problem, and it has not been repeated, so i will never know. All i can do is assume that optimizing the sql itself, OR upgrading the server, or both, was the solution. I hate half-assed answers to question like this one, but that's life.

Thanks for all your help.

premium domain names that i'm selling



Edited 1 time(s). Last edit at 06/15/2010 09:03PM by Vector Thorn.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Lock wait timeout exceeded; try restarting transaction
3093
June 15, 2010 07:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.