br0ken Posted March 23, 2009 Share Posted March 23, 2009 Does any one know what this error means? I've tried searching Google but cannot find a conclusive answer! Quote Link to comment https://forums.phpfreaks.com/topic/150699-1205-lock-wait-timeout-exceeded-try-restarting-transaction/ Share on other sites More sharing options...
fenway Posted March 27, 2009 Share Posted March 27, 2009 It means just that... there's a deadlock that timed out. No problem... just restart the transaction again. Quote Link to comment https://forums.phpfreaks.com/topic/150699-1205-lock-wait-timeout-exceeded-try-restarting-transaction/#findComment-795281 Share on other sites More sharing options...
br0ken Posted March 27, 2009 Author Share Posted March 27, 2009 I have an automatic backup script that runs first thing in the morning. Each morning this runs I get an error report with this error. Because of this the backup doesn't complete and is therefore useless. What would actually cause this deadlock? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/150699-1205-lock-wait-timeout-exceeded-try-restarting-transaction/#findComment-795459 Share on other sites More sharing options...
fenway Posted April 1, 2009 Share Posted April 1, 2009 Lots of things... show innodb status would tell you exactly. Quote Link to comment https://forums.phpfreaks.com/topic/150699-1205-lock-wait-timeout-exceeded-try-restarting-transaction/#findComment-798564 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.