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,557
    Likes Received:
    8
    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,557
    Likes Received:
    8
    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,557
    Likes Received:
    8
    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,557
    Likes Received:
    8
    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. vbgamer45

    Update mysql to 5.6.30

    vbgamer45, Apr 20, 2016, in forum: Database Discussions
    Replies:
    1
    Views:
    1,254
    cPTerrance
    Apr 21, 2016
  2. davidcm

    Update mysql 5.1 to 5.5

    davidcm, Oct 21, 2015, in forum: Database Discussions
    Replies:
    3
    Views:
    1,180
    cPanelMichael
    Nov 4, 2015
  3. Un Area

    MySQL Backup Error After Update

    Un Area, Oct 7, 2015, in forum: Database Discussions
    Replies:
    7
    Views:
    972
    cPanelMichael
    Oct 27, 2015
  4. Jerms

    Cron job killing mysql - /usr/local/cpanel/scripts/update_db_cache

    Jerms, Oct 1, 2015, in forum: Database Discussions
    Replies:
    3
    Views:
    1,320
    cPanelMichael
    Oct 5, 2015
  5. Hosted Power

    In Progress Issue with openssl after EA4 update

    Hosted Power, Aug 9, 2017, in forum: EasyApache
    Replies:
    19
    Views:
    266
    Infopro
    Aug 16, 2017 at 1:57 PM

Share This Page