Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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

Discussion in 'Database Discussion' 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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,532
    Likes Received:
    1,966
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  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:
    575
    Likes Received:
    20
    Trophy Points:
    143
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice