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.

Update MySQL problem on FreeBSD

Discussion in 'General Discussion' started by tuxons, Dec 16, 2009.

  1. tuxons

    tuxons Member

    Joined:
    Dec 16, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Good afternoon, I would like to update on the server MySQL to version 5.1 but when I start MySQL Upgrade, and I choose version 5.1 the script mysqlup hangs and loads CPU on 100 %. Excuse for my English.
     
  2. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Via root SSH access, please let us know the output from the following command:
    Code:
    # ps afuxww
     
  3. tuxons

    tuxons Member

    Joined:
    Dec 16, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    secondary part
     
  4. tuxons

    tuxons Member

    Joined:
    Dec 16, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
  5. npluis

    npluis Member

    Joined:
    Feb 21, 2007
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Any news on this? I have the same thing and top shows mysql at about 2-30% busy even though Show MySQL Processes shows nothing.

    # ps afuxww
    root 10069 103.0 0.3 25900 11040 ?? R 2:55PM 309:29.99 /scripts/mysqlup (perl)
    root 18 97.3 0.0 0 16 ?? RL 22Jul09 209064:56.86 [idle: cpu0]
    root 17 97.1 0.0 0 16 ?? RL 22Jul09 210087:27.46 [idle: cpu1]
    root 11 93.6 0.0 0 16 ?? RL 22Jul09 208408:10.13 [idle: cpu7]
    root 13 83.1 0.0 0 16 ?? RL 22Jul09 206763:05.04 [idle: cpu5]
    root 16 82.4 0.0 0 16 ?? RL 22Jul09 204932:24.39 [idle: cpu2]
    root 15 80.7 0.0 0 16 ?? RL 22Jul09 206921:30.05 [idle: cpu3]
    root 14 79.1 0.0 0 16 ?? RL 22Jul09 202736:05.03 [idle: cpu4]
    root 12 68.3 0.0 0 16 ?? RL 22Jul09 201296:10.10 [idle: cpu6]
    mysql 43560 0.8 13.3 1199664 557880 ?? S Mon11AM 718:56.58 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/mysql/host.pid
     
  6. tuxons

    tuxons Member

    Joined:
    Dec 16, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hallo! Any news on this?
     
  7. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Thank you for the information. More information is needed to have a better idea what the issue may be; please let us know the output of the following command:
    Code:
    # grep -H '' /etc/*release /usr/local/cpanel/version
    Please also consider submitting a support request as the issue may need more thorough inspection and diagnosis via direct access. If needed, the link in my forums signature may be used to initiate a ticket submission. When available, please PM me referencing this thread and your new ticket ID number so that I may follow-up internally.

    Internal case notes: #34835, #36352
     
  8. tuxons

    tuxons Member

    Joined:
    Dec 16, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    At performance of this command grep-H "/etc/*release/usr/local/cpanel/version to me informs grep: No match.
     
  9. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    The command included two different paths separated by a space; as an alternative please use the following commands that will obtain the same information:
    Code:
    # cat /etc/*release
    # cat /usr/local/cpanel/version && echo
     
  10. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    The FreeBSD-specific correction in the "mysqlup" script is available in the latest EDGE build (42275) and will be in upcoming CURRENT and RELEASE builds of cPanel 11.25.

    For additional reference information and to check the latest change log entries and build information please use the following two resources:
    http://httpupdate.cpanel.net/#builds
    http://changelog.cpanel.net/

    Here is a quote of the relevant change log entry:
    Edge 42275, 2009-12-21 14:14:27
    Fixed mysqlup to handle versions newer than 5.01 on FreeBSD and not stop after deinstalling packages
     
Loading...

Share This Page