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! 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. 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 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. 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
Archived
This topic is now archived and is closed to further replies.