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.

Updatenow / MySQL error

Discussion in 'Database Discussions' started by Jonathan Wise, May 16, 2015.

  1. Jonathan Wise

    Jonathan Wise Registered

    Joined:
    May 16, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    United Kingdom
    cPanel Access Level:
    Root Administrator
    Hi,

    I seem to keep running into the error below whilst trying to run an update. I don't quite understand it because although it tells me that to MySQL PID files exist the first has no full pathname and I also cannot find it on the server.

    Any advice? Thank you in advance for any responses.

    ----

    Code:
    [20150516.135142]   You have more than one PID file:
    [20150516.135142]   drwxr-x--x 23 mysql mysql 4096 May 16 13:42 /var/lib/mysql/
    [20150516.135142]   -rw-rw----  1 mysql mysql    6 May 16 13:42 /var/lib/mysql/xxx.xxx.org.pid
    [20150516.135142]   Please check which one (if any) corresponds to a running server
    [20150516.135142]   and delete all others before repeating the MySQL upgrade.
    [20150516.135142]   error: %pre(MySQL55-server-5.5.42-2.cp1148.x86_64) scriptlet failed, exit status 1
    [20150516.135142]   error:   install: %pre scriptlet failed (2), skipping MySQL55-server-5.5.42-2.cp1148
    [20150516.135142] W Error Code: 1
    
     
  2. lldeepakll

    lldeepakll Well-Known Member

    Joined:
    May 20, 2012
    Messages:
    86
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello :)

    Run following command as root to check the running mysql processes

    # ps aux | grep mysql
    # kill -9 xxxx (Pid which you get from above command)

    And then start the mysql update again.
     
  3. Jonathan Wise

    Jonathan Wise Registered

    Joined:
    May 16, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    United Kingdom
    cPanel Access Level:
    Root Administrator
    Thanks, I did as advised, killed both of the running MySQL processes but still received the same problem (see below) :(

    What might I be doing wrong here?

    Code:
    [20150517.092247]   You have more than one PID file:
    [20150517.092247]   drwxr-x--x 23 mysql mysql 4096 May 16 21:44 /var/lib/mysql/
    [20150517.092247]   -rw-rw----  1 mysql mysql    6 May 16 13:42 /var/lib/mysql/xxxxxxxxx.pid
    [20150517.092247]   Please check which one (if any) corresponds to a running server
    [20150517.092247]   and delete all others before repeating the MySQL upgrade.
    [20150517.092247]   error: %pre(MySQL55-server-5.5.42-2.cp1148.x86_64) scriptlet failed, exit status 1
    [20150517.092247]   error:   install: %pre scriptlet failed (2), skipping MySQL55-server-5.5.42-2.cp1148
    [20150517.092247] W Error Code: 1
    
     
  4. madmanmachines

    madmanmachines Well-Known Member

    Joined:
    Nov 28, 2014
    Messages:
    94
    Likes Received:
    3
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    HI,

    Why are you using this update script?
    Code:
    root@host [~]# /scripts/updatenow --help
    Usage: /scripts/updatenow [options]
    
        Options:
          --help     Brief help message
          --man      Detailed help
    
         Note: This script is designed to be run by cPanel programs directly ONLY. Please see upcp instead. It's probably what you want.
    
    root@host [~]# /scripts/updatenow --man
    UPDATENOW(1)          User Contributed Perl Documentation         UPDATENOW(1)
    
    NAME
           updatenow - updates /usr/local/cpanel from update servers
    
    USAGE
               # Called from upcp like this:
               # --force tells updatenow to sync even if the version has not changed (similar to --sync). This setting will also bypass cron detection.
               updatenow --upcp
    
               # upcp will call this script like this if upcp is called with --force
               updatenow --upcp --force
    
               # If files which this script manages somehow get deleted, this will re-sync them but not upgrade.
               # This is used by other cpanel scripts as a safety measure.
               updatenow.static --sync
    
               # Used by cpanel installer prior to vps optimization
               updatenow --no-check-perl
    
    DESCRIPTION
           NOTE: Under most circumstances, you should never call this script directly.
           /usr/local/cpanel/scripts/upcp, called with an optional [--force] should be all you need. --sync is only
           intended to be called by other cpanel scripts when it appears that cpanel managed files have been
           deleted.
    
           The normal usage of this script is to update cpanel to the latest version of your TIER (see
           /etc/cpupdate.conf).  By default, no update is done by default if you are already on that version. The
           UPDATES setting in cpupdate.conf is also honored when the environment variable CPANEL_IS_CRON is set
           (usually from upcp).
    
           If an HTTPUPDATE= setting is present in /etc/cpsources.conf with a hostname, this will be the preferred
           source to sync from.
    
    perl v5.10.1                      2015-05-14                      UPDATENOW(1)
    [/QUOTE]
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    649
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page