1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Cannot upgrade from 9.2.2

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by scottthepotter, Mar 20, 2010.

  1. scottthepotter

    scottthepotter Basic Pleskian

    24
    73%
    Joined:
    Jun 4, 2007
    Messages:
    51
    Likes Received:
    0
    I am currently running Plesk 9.2.2 on a Centos 5.4 64-bit box. When I go to 'Updates' in the Plesk control panel it currently indicates (yellow icon) that there are updates to my 9.2.2 version, even though there are none. If I go ahead and 'install' all updates for 9.2.2 it reports a 'success'. However whenever I try to update to 9.2.3 or 9.3.0 I get the following:

    ERROR: PleskMainDBException MySQL query failed: MySQL server has gone away Additionally, an exception has occurred while trying to report this error: PleskMainDBException MySQL query failed: MySQL server has gone away
    0: common_func.php3:168 db_query(string 'select `id`,`name`,`type`,`uri` from DashboardPreset where `id`=5')
    1: class.Table.php:183 Table->select()
    2: class.cObject.php:479 cObject->fetchAttrsFromTable_()
    3: DashboardPreset.php:29 DashboardPreset->__construct(integer '5')
    4: common_func.php3:3115 objectMaker(string 'DashboardPreset', integer '5', boolean false, NULL null)
    5: common_func.php3:3124 objectMakerEx(string 'DashboardPreset', integer '5')
    6: UserAdmin.php:205 UserAdmin->getDashboardCustomPreset()
    7: Favorites.php:100 Favorites::renderFavoritesDropDown(boolean false)
    8: class.Form.php:286 Form->assign()
    9: AutoInstallerInstallForm.php:124 AutoInstallerInstallForm->assignComponent(object of type AutoInstallerRelease, object of type AutoInstallerComponent, boolean true, array)
    10: AutoInstallerInstallForm.php:66 AutoInstallerInstallForm->assign(object of type AutoInstallerRelease, array, array, array, boolean false, boolean false, string '', boolean false)
    11: autoinstaller_install.php:132

    I have restarted the MySQL server, and run an extended database check on the 'PSA' database and it reports that all tables are 'OK'

    So what now?
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Did you tried to execute this sql select directly in Plesk database?

    Seems you haven't this record there. Check it.
     
  3. scottthepotter

    scottthepotter Basic Pleskian

    24
    73%
    Joined:
    Jun 4, 2007
    Messages:
    51
    Likes Received:
    0
    Forgot to mention, that was the first thing I checked, here is the row:

    id='5'
    name='1-0'
    uri='/plesk/dashboard'
    type='admin'

    All values are present
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    There is "MySQL server has gone away" error. Try to increase wait_timeout in /etc/my.cnf:

    wait_timeout 20000

    Restart MySQL after that.
     
  5. scottthepotter

    scottthepotter Basic Pleskian

    24
    73%
    Joined:
    Jun 4, 2007
    Messages:
    51
    Likes Received:
    0
    Thanks! that did it!
     
Loading...