0

i started to take backup of site using admin panel > system > backup

after Internet got disconnected. Now i am unable to open the frontend and backend of site.

Error:

There has been an error processing your request

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

please help me to find solution.

  • 1
    Clear /var/locks and restart mysql what happens? – SR_Magento May 25 '15 at 11:29
  • 1
    restart your mysql and try it will work – hari haran May 25 '15 at 11:31
  • @sr_magento is it safe to delete " var/locks? – Baby in Magento May 25 '15 at 11:33
  • 1
    no. if u restart it will not affect anything.. just try – hari haran May 25 '15 at 11:37
  • 1
    yes its safe to clear the locks, clear them restart mysql. As Marius pointed out if there is a maintenance flag you will need to clear that as well. – SR_Magento May 25 '15 at 11:43
1

Its deadlocked. Restart your mysql and clear cache.

| improve this answer | |
2

When a backup is starting the website is put on maintenance. Remove the file maintanance.flag and it should work again.

| improve this answer | |
  • unfortunately , there is no maintanace.flag is added at root of the site? – Baby in Magento May 25 '15 at 11:32
  • 1
    @BabyinMagento2. No problem. sorry I wasn't spot on, on this one. I took a shot. This is what usually happened to me. – Marius May 25 '15 at 11:56
  • you don't need to be sorry, i know you faced all kinds of problems happened in magento. – Baby in Magento May 25 '15 at 12:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.