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 Issue after latest update

Discussion in 'General Discussion' started by kris1351, Jul 25, 2004.

  1. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Lewisville, Tx
    For some reasone we have one server that lost its /var/lib/mysql/mysql.sock today after the updates. I run Current on this particular server and it is the only one that had an issue. Have tried just about everything I can think of to get it back. When you reset the MySQL root password you see it get recreated, but then it deletes it while restarting. Anyone seen this before?
     
  2. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    That happened to me one time. I tried all the fixes, but for some reason it would just vanish. Rebooting fixed it and it never happened again...
     
  3. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Lewisville, Tx
    Yea, tried the reboot route already and it was a no go. Nothing seems to fix the issue. Have reverted to every release of CPanel you can upcp to. Am backing up all the DBs now just in case I have to restore something.
     
  4. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
  5. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Lewisville, Tx
    Yea, the ln -s stuff is still in place. It is actually creating the mysql.sock in /var/lib/mysql when it starts the restart then the script deletes it. Got the DC looking into it.
     
  6. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Lewisville, Tx
    DC found the problem. Turned out to be something wrong with the load they put on. Funny it didn't show up until this patch though.
     
  7. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Weird. Glad it's fixed.
     
  8. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Lewisville, Tx
    Well, now it is finally fixed. Wasn't a load issue on our part after all. After a few hours looking through all the oddities, the /scripts/upcp actually loaded some of the BSD components instead of RHE. We aren't quite sure how that happened, but TP does great at helping find these things out. I was at my wits end trying to figure out why it stopped running.
     
  9. Roy@ENHOST

    Roy@ENHOST Well-Known Member

    Joined:
    Mar 5, 2002
    Messages:
    495
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Los Angeles California
    Yeap Cpanel screws up a lot lately when it comes to MySQL.
    My MySQL stopped working twice within a week. :confused:
     
  10. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Manual updates.

    If you have lots of servers, it's still better to do manual updates. If your manual update screws something up, it's better that it be one box instead of multiple ones.
     
  11. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Lewisville, Tx
    I NEVER let Cpanel auto-update. These were all manual updates and even waited a couple of days after they were put out. Just bad ones here and there.
     
Loading...

Share This Page