Skip to main content

Error #1286 - Unknown table engine 'InnoDB' on my server

markuswest
Hi, I have seen on my server the websites are down and they return an error: Notice: Error: Unknown table engine 'InnoDB' Error No: 1286 SELECT * FROM oc_store WHERE REPLACE(`url`, 'www.', '') = 'http://website.com/' in /home/website/public_html/system/database/mysql.php on line 50 and in phpmyadmin when I click on a table to view the contents of anydatabase I receive this error: #1286 - Unknown table engine 'InnoDB' and when I view the MySQL Databases in cPanel I also see this error: The adminbin "cpmysql" in the "Cpanel" namespace call to function "DBCACHE" ended prematurely: The subprocess reported the "" (255) error when it ended. I really need to get this error fixed, can you please help out? My websites is: - Removed - Best Regards, Lloyd

Comments

4 comments

Date Votes
  • markuswest
    We have looked into the problem, it seems the problem originates from the /tmp/ directory which is completely full, and we tried to delete all the files in the /tmp/ directory but we end up with an error: -bash: /bin/rm: Argument list too long
    here is the log from SSH: root@111.222.333.444's password: Last login: Fri Dec 19 12:29:20 2014 from 999.888.777.666 2013-09-17 Firewall turned on root@server [~]# rm -rf /tmp/* -bash: /bin/rm: Argument list too long We also tried to delete the files in pieces, but that also doesn't work, how can I clean up this directory?
    0
  • cPanelMichael
    Hello :) You could use the "tmpwatch" script to clean your /tmp partition. Please see the following thread for information about setting up this utility: Tmpwatch Thank you.
    0
  • markuswest
    Good Day, To followup on the thread, the solution to my problem was on the root directory of the server, we have a /tmp/ folder, that folder needed to be cleaned up and then the websites started working fine again. I guess if the /tmp/ folder is full then InnoDB automatically shuts down. Best Regards, Lloyd
    0
  • cPanelPeter cPanel Staff
    Hello, Yes that is correct. By default, MySQL stores temp tables in the /tmp folder. So if /tmp runs out, temporary tables can not be created and that causes issues. I'm glad you were able to solve the issue.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post