Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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:
    51
    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.
     
    #1 tuxons, Dec 16, 2009
  2. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,554
    Likes Received:
    9
    Trophy Points:
    168
    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
     
    #2 cPanelDon, Dec 16, 2009
  3. tuxons

    tuxons Member

    Joined:
    Dec 16, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    secondary part
     
    #3 tuxons, Dec 17, 2009
  4. tuxons

    tuxons Member

    Joined:
    Dec 16, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    #4 tuxons, Dec 17, 2009
  5. npluis

    npluis Member

    Joined:
    Feb 21, 2007
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    151
    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
     
    #5 npluis, Dec 17, 2009
  6. tuxons

    tuxons Member

    Joined:
    Dec 16, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    Hallo! Any news on this?
     
    #6 tuxons, Dec 17, 2009
  7. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,554
    Likes Received:
    9
    Trophy Points:
    168
    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
     
    #7 cPanelDon, Dec 18, 2009
  8. tuxons

    tuxons Member

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

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,554
    Likes Received:
    9
    Trophy Points:
    168
    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
     
    #9 cPanelDon, Dec 21, 2009
  10. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,554
    Likes Received:
    9
    Trophy Points:
    168
    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
     
    #10 cPanelDon, Dec 21, 2009
(You must log in or sign up to post here.)
Loading...
Similar Threads - Update MySQL problem
  1. trucmuche

    permission problem since MySQL 5.6.37 update

    trucmuche, Sep 1, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    428
    cPanelMichael
    Oct 27, 2017
  2. Curt McKinney

    SOLVED MySQL Updates acting strange after updating my.cnf

    Curt McKinney, Feb 9, 2018, in forum: Database Discussions
    Replies:
    4
    Views:
    195
    Curt McKinney
    Feb 14, 2018
  3. vinko

    New Thread sprite_generator error after update (plus all icons missing)

    vinko, Apr 23, 2018 at 6:15 PM, in forum: User Experience
    Replies:
    0
    Views:
    4
    vinko
    Apr 23, 2018 at 6:15 PM
  4. rhm.geerts

    SOLVED Global zone update command not working?

    rhm.geerts, Apr 20, 2018 at 8:07 PM, in forum: Bind / DNS / Nameserver Issues
    Replies:
    6
    Views:
    53
    rhm.geerts
    Apr 23, 2018 at 11:50 AM
  5. Nirjonadda

    You must reboot the server to apply software updates

    Nirjonadda, Apr 20, 2018 at 11:43 AM, in forum: General Discussion
    Replies:
    6
    Views:
    56
    Nirjonadda
    Apr 20, 2018 at 1:47 PM

Share This Page