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.

MySQL Upgrade hung.

Discussion in 'Database Discussions' started by OssettAcademy, Jul 21, 2014.

  1. OssettAcademy

    OssettAcademy Registered

    Joined:
    Apr 13, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Morning folks - I finally got a suitable window to upgrade MySQL from 5.1 to 5.5 to 5.6 this morning, so began the process... logged in to WHM, got backups of all databases & related configs, and headed to Software > MySSQL Upgrade and set things going with as an unattended install, auto rebuilding Apache / PHP afterwards.

    That was an hour ago. We've been sat on the output screen in WHM ever since, with very little going on.

    Some digging around in logs shows the MySQL upgrade has completed, and MySQL is now running... as kinda given away by:

    Code:
    140721  8:59:43 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.36-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    
    Note the time - that 2as at 8:59am. It's now 10am. The output window in WHM hasn't updated since 8:58am. Green progress bar is rolling across.

    I'd expect it to be on with the next step of rebuilding Apache & PHP... but checking in /usr/local/cpanel/logs/easy/apache, the last updated file was touched at 9:13am, and it's tail implies that THAT has also completed successfully...

    Code:
    -rw-------  1 root root     469 Jul 21 08:59 build.1405929586.env
    drwx------. 2 root root   12288 Jul 21 09:13 ./
    -rw-------  1 root root 1898036 Jul 21 09:13 build.1405929586
    
    root@websrv01 [/usr/local/cpanel/logs/easy/apache]# tail build.1405929586
    
    !! If you  want to create a support ticket with cPanel regarding this please reference 'BuildAP Report Id': '13978887' !!
    Report processed.
    !! 
    You can change how PHP is configured.
    As root, simply execute:
        /usr/local/cpanel/bin/rebuild_phpconf --help
    for more information.
    !!
    !! Build Complete! !!
    !! Verbose logfile is at '/usr/local/cpanel/logs/easy/apache/build.1405929586' !!
    
    root@websrv01 [/usr/local/cpanel/logs/easy/apache]# 
    Soooo... er... Do I presume we're done here, and bail out of the MySQL Upgrade output window in WHM presuming that the browser (Safari 7.0.4 {9537.76.4} on OS X 10.9.3) has timed out, and just run upcp --force so that I can finally leap from WHM 11.42.1 to 11.44?

    Server detail: CENTOS 6.3 x86_64 vmware – websrv01 WHM 11.42.1 (build 22)
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    The information you provided indicates the upgrade completed successfully, but the UI may have hung. Please feel free to update of cPanel and let us know if you encounter any issues.

    Thank you.
     
  3. OssettAcademy

    OssettAcademy Registered

    Joined:
    Apr 13, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Aye - turns out IT Support had reset the switch i was connected to so IP address had changed, thus UI losing connection to server.

    All done - updated to WHM 11.44 / CENTOS 6.5!
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

Share This Page