1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.1 An exception occurred: Mysqli prepare error: Unknown storage engine 'InnoDB'

Discussion in 'Troubleshooting and Problems' started by Vijay, Jun 27, 2012.

  1. Vijay

    Vijay Member

    My site went offline moments ago with this error:

    An exception occurred: Mysqli prepare error: Unknown storage engine 'InnoDB' in /home/myaccount/public_html/library/Zend/Db/Statement/Mysqli.php on line 77

    Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
    Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Error.php at line 50
    XenForo_Error::unexpectedException() in XenForo/Application.php at line 295
    XenForo_Application::handleException()

    Suggestions?
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Contact your host or server person. Ask them to edit the MySQL configuration to enable the InnoDB storage engine. XenForo uses InnoDB.
     
  3. Vijay

    Vijay Member

    Thanks for the reply Jake. I have now opened a ticket with the host (with the information you provided).
     
  4. Vijay

    Vijay Member

    Now the error changed to An exception occurred: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/stockmar/public_html/library/Zend/Db/Adapter/Mysqli.php on line 333

    Has my mysql server crashed?

    My host sucks - This is the 4th time this month the site has gone offline with same MySQL issues. In cpanel I tried to access mysql, it shows MySQL server is offline and phpmyadmin says MySQL said:
    #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

     
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Assuming the info in your library/config.php file is correct, it appears that the MySQL server is down. Contact your host and ask them to restart MySQL.
     
  6. Vijay

    Vijay Member

    I spoke with my host. They told me that mysql was abused by some other account in shared hosting and it led to this issue. They were working on removing the abusive account from the server. It has been more than two hours and site is still down. This is the fourth time this month I am facing outage due to their MySQL server offline issue. I wonder if it violates their 99.9% uptime guarantee.

    3 months of hosting in India has resulted in 4 tickets in 1 month for the same MySQL problem. I had my peace of mind when the site was hosted in US. Just 1 Mysql issue in 5 years!
     
  7. CyclingTribe

    CyclingTribe Well-Known Member

    Maybe time to start shopping around for a new host Vijay? ;)
     
  8. Vijay

    Vijay Member

    I guess so. This is so awful. I just received my first reply to a ticket marked as critical.

    On the phone the guy told me that since one customer abused MySQL, there was a server wide downtime. I fail to understand how much time does it take to disable one customer and restart SQL services for the rest of the customers?

    Current downtime: 5 hours
    Hosting Company: Hostgator India (www.hostgator.in)

    :(
     
  9. MattW

    MattW Well-Known Member

    5 hours downtime is poor to take down a single client affecting a whole shared hosting platform. They should just disable their account.
     
  10. Vijay

    Vijay Member

    They gave me an ETA of 1-2 hours at 3pm local time. It is 6.17pm right now. Forum is still down.
    I have updated the ticket. Let's see what they say.
     
  11. Vijay

    Vijay Member

    Thats the reply.
    :(
     
  12. Sadik B

    Sadik B Well-Known Member

    Sorry to hear that Vijay. It takes less than 2 hours to transfer a site from one host to another.... (assuming you aren't a big board!).

    The main hostgator.com host isn't bad, though they aren't the best. You can switch to hostgator or try one of the smaller hosts who are known for better service. You can research about hosts on webhostingtalk.com
     
  13. Vijay

    Vijay Member

    It's not a large forum and I can migrate within an hour. But I chose an Indian host due to the speed advantage. I have experience with US based hosts and they have been excellent.

    Update to ticket:


    I fail to understand what are they doing since past 8 hours!! I hope they have not lost the db.
     
  14. Vijay

    Vijay Member

    Update: Site still down. 13 hours.

    Got hold of someone in chat. Man, they just don't want to tell what is going on. All canned responses. Someone told me that INNODB engine has crashed. They're trying to recover data and some data is unrecoverable. He told me they have a backup. Just wondering why would it take 12 hours if they have a back up?

    I am expecting the worst here.
     
  15. Sadik B

    Sadik B Well-Known Member

    Bad luck buddy.... Since MySQL is down, you will not be able to take a backup yourself either.
     
  16. Vijay

    Vijay Member

    Sigh. They have lost the db :(

    My last backup was on July 17. This is so awful. I ran an ad campaign online from June 22 to attract new visitors. Lost all new members, posts, threads and the 50$ on the ads.

    What do I do now. I have a July 17 back up. Should simply get a new host or give them the backup to restore it? I don't think Hostgator India is competent enough: technically or otherwise. I considering hosting at Liquidweb.
     
  17. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    If that is your most recent backup then that is what you will have to use. But you should get a new host while you are at it.
     
  18. CyclingTribe

    CyclingTribe Well-Known Member

    Agreed - get a new host first - then restore your latest backup (to get you up and running again) - then explain to your membership what has happened and put a more regular backup system in place.

    Chalk it up to experience, pick yourself up, dust yourself down - and crack on with building your community. (y)

    Cheers,
    Shaun :D
     
  19. Vijay

    Vijay Member

    Thanks for the response guys. I was angry but I calmed down and asked them one question "What caused this crash?" This is their reply:


    Do you think this can happen on any host that I choose?

    My site in Mumbai on Hostgator India is reachable in 6 hops while a competitor's site on Liquidweb is reachable in 11 hops. Should I make the move back to US or give benefit to Hostgator India this time?
    So confused (n)
     
  20. CyclingTribe

    CyclingTribe Well-Known Member

    I suspect they've messed up and just don't want to admit it. You could stick with them, but if you do make sure you have a method of taking your backups off-server so that your own data is safe if things go wrong again.

    There are plenty of cheap FTP storage accounts you can rent - giving you server-to-server higher bandwidth backup speed - which should allow you to do overnight daily backups (there's plenty of software to automate such things and if you set it up with email notification you'll know, each morning, that your data has been backed-up safe and sound!).

    I've been through something similar and it can really get you down (as I'm sure many others have here), but the one thing that came out of it was a better backup plan and some additional redundancy built in to my operation; plus the confidence of knowing you can recover from such things in the future. ;)

    Good luck and I hope you're back up and running ASAP. (y)

    Cheers,
    Shaun :D
     

Share This Page