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.

Remote MySQL server shuts down after upcp command

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

  1. abrakadabra

    abrakadabra Member

    Joined:
    Dec 14, 2010
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,762
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. abrakadabra

    abrakadabra Member

    Joined:
    Dec 14, 2010
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    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. cPTerrance

    cPTerrance *nix Technical Analyst II / Migrations Specialist
    Staff Member

    Joined:
    Jul 9, 2015
    Messages:
    72
    Likes Received:
    8
    Trophy Points:
    8
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Twitter:
Loading...

Share This Page