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!

Remote MySQL server shuts down after upcp command

Discussion in 'Database Discussion' started by abrakadabra, May 7, 2016.

  1. abrakadabra

    abrakadabra Member

    Joined:
    Dec 14, 2010
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    51
    WHM Server 56 on CentOS 6.7.
    Remote MySQL-Server 5.5.49 on CentOS 6.7.

    This is ongoing issue since WHM 56, running
    /usr/local/cpanel/scripts/upcp, the remote MySQL server is receiving shutdown command and is entering normal shutdown. Once the cPanel update (upcp) is finished, the remote MySQL remains in shutdown state.

    mysqld.log
    Code:
    160507  1:23:08 [Note] /usr/sbin/mysqld: Normal shutdown
    
    
    160507  1:23:08 [Note] Event Scheduler: Purging the queue. 0 events
    
    160507  1:23:10 [Warning] /usr/sbin/mysqld: Forcing close of thread 164473  user: 'eximstats'
    
    
    160507  1:23:10 [Warning] /usr/sbin/mysqld: Forcing close of thread 164440  user: 'modsec'
    
    
    160507  1:23:10 [Warning] /usr/sbin/mysqld: Forcing close of thread 162135  user: 'leechprotect'
    
    
    160507  1:23:10  InnoDB: Starting shutdown...
    
    160507  1:23:10  InnoDB: Waiting for 56 pages to be flushed
    
    160507  1:23:11  InnoDB: Shutdown completed; log sequence number 115570048662
    
    160507  1:23:11 [Note] /usr/sbin/mysqld: Shutdown complete
    
    
    
    160507 01:23:11 mysqld_safe mysqld from pid file /var/lib/mysql/xxx.xxx.com.pid ended
    
    The log timestamp matches those of cPanel upcp update.
     
    #1 abrakadabra, May 7, 2016
    Last edited: May 7, 2016
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,726
    Likes Received:
    1,883
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Could you verify if you are using the "WHM >> Manage MySQL Profiles" feature to manage the remote MySQL server? We have an internal case open to address an issue similar to what you have reported, but it's isolated to servers that have configured a redirect from localhost via a direct edit to the /root/.my.cnf file.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. abrakadabra

    abrakadabra Member

    Joined:
    Dec 14, 2010
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    51
    MySQL profiles are being used, Auto-Migrated active profile.

    /root/.my.cnf:
    Code:
    [client]
    host="db1.xxx.xxx"
    user="root"
    password="xxx"
    
     

    Attached Files:

  4. TerranceR

    TerranceR Well-Known Member

    Joined:
    Jul 9, 2015
    Messages:
    74
    Likes Received:
    10
    Trophy Points:
    83
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
Loading...

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.
    Dismiss Notice