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 troubleshoot/reinst

Discussion in 'General Discussion' started by JohnodACD, Feb 15, 2006.

  1. JohnodACD

    JohnodACD Active Member

    Joined:
    Oct 21, 2005
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    6
    I am all the sudden getting errors that says

    MySQL Error: 1 (Can't create/write to file '/tmp/#sql_7425_0.MYD' (Errcode: 17))
    Session halted.

    I have 7 boxes all running the sql version 4.1 and am not having this on then on 2 i have the sql version 4.0 and am getting this error on both.

    When i go to the temp folder i am seeing a file called #sql_7425_0.MYD. If i change that file to be 666 permissions it does no good if i just delete it i am ok and teh scripts run for about 13-16 hours before that error comes back.

    I am thinking that if i upgrade mysql that would fix the problem, I rad the update from WHM and it did not update the sql version.

    i then went to the MYSQL website and searched and was not abke to find this error there.

    PLEASE can anyone tell me what to do or how to force the upgrade of mysql?
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    1. Make sure that /tmp isn't out of space

    2. Make sure that /tmp is chmod 1777

    3. If you're using a virtual /tmp partition make sure it's not corrupt - if so replace it
     
  3. JohnodACD

    JohnodACD Active Member

    Joined:
    Oct 21, 2005
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    6
    i have checked permissiona and they are correct. not sure how to check the other 2 but this is happening on 2 vps environments on this same machine.

    When it happens it only effectes some of the sites and not all. but if i restart sql or delete the file it is fine.
     
  4. dasonix

    dasonix Member

    Joined:
    Sep 27, 2005
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    how do you replace a virtual tmp directory?

    I'm haveing the same problem as the guy above had
     
  5. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
  6. dasonix

    dasonix Member

    Joined:
    Sep 27, 2005
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    your directions worked and tmp was deleted and recreated, will let you know in a few hrs if it fixed the problem for good :)

    TY
     
Loading...

Share This Page