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.

mySQL error 1030

Discussion in 'General Discussion' started by GrimReaper, Sep 20, 2003.

  1. GrimReaper

    GrimReaper Active Member

    Joined:
    Jul 27, 2003
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    Hi All,

    I have recently had a few mySQL database problems on one of my servers running cpanel and have managed to fix 99% of them. The only one I can't fix is any site running invision board appears to get an error like:

    ---- [ CUT ] ----

    mySQL query error: SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
    c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
    from ibf_forums f, ibf_categories c
    LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
    WHERE f.category=c.id
    order by c.position, f.position

    mySQL error: Got error 28 from table handler
    mySQL error code: 1030
    Date: Saturday 20th of September 2003 09:15:52 PM

    ---- [ CUT ] ----

    Now, I have found that error 1030 in mySQL means there is no hard drive space left. However I have about 10gig free.

    Has anyone run into this error before or know any way I could fix this?

    Thanks
    Chris.

    cPanel.net Support Ticket Number:
     
  2. GrimReaper

    GrimReaper Active Member

    Joined:
    Jul 27, 2003
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    I just figured this out myself and when I do figure something out I like to post it so that if someone has the same problem at some time they can fix it. :) .. so here's the solution:

    It really is that your drive is full... but don't bother looking in account usage, or on your normal drive. mySQL stores stuff in /tmp and if /tmp is full then your up the creek without a paddle. Now, DONT go and delete /tmp as there is stuff in there that is in use so its NOT A GOOD IDEA here was my problem.

    1) Earlier in the day I decided to move an account and stopped it half way through.
    2) I started getting mySQL problems.
    3) Upon checking /tmp it was 100% full.
    4) Checked and there was a directory in there for the move called "cp-mov" with the username attached.

    Solution.

    Login using SSH

    type:
    cd /tmp
    rm -rf [directory name]
    logout

    that should fix the problem, be careful though don't delete the "users" directory if you have one.

    This worked for me, I hope it helps someone else.

    Chris Out.

    cPanel.net Support Ticket Number:
     
  3. pingo

    pingo Well-Known Member

    Joined:
    Nov 16, 2002
    Messages:
    430
    Likes Received:
    0
    Trophy Points:
    16
    Thanks Chris - the tmp folder were full :)

    John
     
  4. hostit1

    hostit1 Well-Known Member

    Joined:
    Jul 24, 2003
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    0
    GrimReaper . . . YouDaMan! Thanks
     
Loading...

Share This Page