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 acts strange after stable update

Discussion in 'General Discussion' started by MMarko, Jun 4, 2006.

  1. MMarko

    MMarko Well-Known Member

    Joined:
    Apr 18, 2005
    Messages:
    316
    Likes Received:
    0
    Trophy Points:
    16
    Everytime mysql is updated via WHM / cPanel updater to new version it start to act very strange.

    Does anybody else experienced this problem? What's causing it?
     
  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
    That's way too vague. What, exactly are the problem that you are seeing?
     
  3. MMarko

    MMarko Well-Known Member

    Joined:
    Apr 18, 2005
    Messages:
    316
    Likes Received:
    0
    Trophy Points:
    16
    Mysql doesn't want to exit normaly. Then some db went corupted and when trying to restart mysql it becomes unpossible.

    Before mysql returned some errors about not having enough memory (which was false because there is always enough memory).
     
  4. MMarko

    MMarko Well-Known Member

    Joined:
    Apr 18, 2005
    Messages:
    316
    Likes Received:
    0
    Trophy Points:
    16
    I manage to fix this by killing all mysql processes manualy and then restart it. This time there were no corupted dbs (they can be repaired via WHM or phpMyAdmin).
     
  5. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    One thing to check is that if you have a separate /tmp partition make sure it has plenty of free space as MySQL will, by default, store temporary data in there.
     
  6. MMarko

    MMarko Well-Known Member

    Joined:
    Apr 18, 2005
    Messages:
    316
    Likes Received:
    0
    Trophy Points:
    16
    One more interesting thing about mysql.


    Release version uses mysql v 4.1.18 and stable uses 4.1.19 :eek:
     
  7. MMarko

    MMarko Well-Known Member

    Joined:
    Apr 18, 2005
    Messages:
    316
    Likes Received:
    0
    Trophy Points:
    16
    Yes there is plenty of space there.



    Right now I'm unable to update to latest release. There seems to be problem with cpanel update server?
     
  8. Canadahost2

    Canadahost2 Registered

    Joined:
    Jun 4, 2006
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    We are having similar problems with mysql on at least two of our servers requiring repeated restarts after the update. I've had to restart mysql numerious times in the last couple hours on two different servers (both had previously been running fine for months).
     
  9. cooldude7273

    cooldude7273 Well-Known Member

    Joined:
    Jan 11, 2004
    Messages:
    363
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Roswell, GA
    Release actually does use 4.1.19 - x86 that is, x64 is still on 4.1.18
     
Loading...

Share This Page