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!

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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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 Discussion
    Replies:
    4
    Views:
    480
    cPanelMichael
    Oct 27, 2017
  2. Josh Strike

    pkgacct mysql error since 70.0.42 update

    Josh Strike, May 17, 2018, in forum: Data Protection
    Replies:
    3
    Views:
    122
    cPanelMichael
    May 21, 2018
  3. Curt McKinney

    SOLVED MySQL Updates acting strange after updating my.cnf

    Curt McKinney, Feb 9, 2018, in forum: Database Discussion
    Replies:
    4
    Views:
    244
    Curt McKinney
    Feb 14, 2018
  4. cPStacy

    EasyApache 4 Update - June 19, 2018

    cPStacy, Jun 19, 2018 at 3:49 PM, in forum: EasyApache
    Replies:
    0
    Views:
    42
    cPStacy
    Jun 19, 2018 at 3:49 PM
  5. Nirjonadda

    In Progress [CPANEL-21254] cPanel version change from “11.72.0.3” to “” failed during updatenow

    Nirjonadda, Jun 15, 2018 at 9:29 PM, in forum: General Discussion
    Replies:
    7
    Views:
    111
    cPanelLauren
    Jun 18, 2018 at 12:27 PM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice