The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' started by markuswest, Dec 18, 2014.

  1. markuswest

    markuswest Active Member

    Joined:
    Oct 21, 2013
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    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
     
    #1 markuswest, Dec 18, 2014
    Last edited: Dec 19, 2014
  2. markuswest

    markuswest Active Member

    Joined:
    Oct 21, 2013
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    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:

    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?
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  4. markuswest

    markuswest Active Member

    Joined:
    Oct 21, 2013
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    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
     
  5. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    569
    Likes Received:
    15
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
Loading...

Share This Page