Plesk unavailable!! - Urgent - Error while upgrading from Plesk 10.4 to 11.5

[NikosA]

Hi,

i tried to upgrade Plesk from 10.4.4 to 11.5 and got following error:

Installation started in background
Checking whether the package dependencies are resolved.
Installing packages
Error: An error occurred on attempt to install packages.
Attention! Your software might be inoperable.
Please, contact product technical support.

Since then i have no access to plesk panel!

More Details about Plesk and OS:

10.4.4 Ubuntu 10.04 1013111102.18

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<patches>
    <product id="plesk" version="10.4.4" installed-at="20120328T140652">
        <patch version="56" timestamp="" installed-at="20130930T064020" />
    </product>
</patches>


/var/log/sw-cp-server/error.log
2014-01-27 04:24:25: (mod_fastcgi.c.2588) FastCGI-stderr: Check key

Doing restart of Parallels Installer...
Doing restart of Parallels Installer...
Doing restart of Parallels Installer...
2014-01-28 06:33:19: (connections.c.299) SSL: 1 error:140780E5:SSL routines:SSL23_READ:ssl handshake failure
2014-01-28 06:33:19: (connections.c.299) SSL: 1 error:140780E5:SSL routines:SSL23_READ:ssl handshake failure
2014-01-28 06:33:19: (connections.c.299) SSL: 1 error:140780E5:SSL routines:SSL23_READ:ssl handshake failure
2014-01-28 06:33:26: (log.c.135) server stopped

After Plesk restart with "/etc/init.d/psa start" i get following errors:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.ServiceNodeProperties' doesn't exist
0: Pdo.php:234
Zend_Db_Statement_Pdo->_execute(array)
1: Statement.php:300
Zend_Db_Statement->execute(array)
2: Abstract.php:479
Zend_Db_Adapter_Abstract->query(string 'DESCRIBE `ServiceNodeProperties`', array)
3: Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'DESCRIBE `ServiceNodeProperties`')
4: Mysql.php:169
Zend_Db_Adapter_Pdo_Mysql->describeTable(string 'ServiceNodeProperties', NULL null)
5: Abstract.php:835
Zend_Db_Table_Abstract->_setupMetadata()
6: Abstract.php:874
Zend_Db_Table_Abstract->_setupPrimaryKey()
7: Abstract.php:982
Zend_Db_Table_Abstract->info()
8: Select.php:100
Zend_Db_Table_Select->setTable(object of type Db_Table_Broker_ServiceNodeProperties)
9: Select.php:78
Zend_Db_Table_Select->__construct(object of type Db_Table_Broker_ServiceNodeProperties)
10: Abstract.php:1018
Zend_Db_Table_Abstract->select()
11: Abstract.php:1331
Zend_Db_Table_Abstract->fetchAll(string '`serviceNodeId` = '1'')
12: Abstract.php:110
Db_Table_Abstract->findByField(string 'serviceNodeId', string '1')
13: Dictionary.php:74
Db_Table_Dictionary->setId(string '1')
14: ServiceNodeProperties.php:36
Db_Table_Dictionary_ServiceNodeProperties->setId(string '1')
15: Dictionary.php:56
Db_Table_Dictionary->__construct(string '1')
16: ServiceNodeProperties.php:27
Db_Table_Dictionary_ServiceNodeProperties->__construct(string '1')
17: ServiceNode.php:56
Db_Table_Row_ServiceNode->properties()
18: ServiceNode.php:70
Db_Table_Row_ServiceNode->refreshProperties()
19: auth.php3:506

Please help!

 

[IgorG]

Have you tried to troubleshoot it with reading error messages in /tmp/autoinstall3.log ?
Also try to run bootstrapper repair procedure at least.

 

[NikosA]

I already ran /usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/bootstrapper.sh repair
with following errors:

START Bootstrapper 11.5.30 repair AT Tue Jan 28 07:11:24 CET 2014

**** Product repair started.

===> Checking for previous installation ... found.
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.

 Trying to start service mysql... /usr/sbin/mysqld (pid 15838) is running...
done
 Trying to establish test connection... connected
done
 Trying to find psa database... version is 011005030
Version is OK, no need to create psa database.
 Trying to backup MySQL database... Warning: Not dumping MySQL database 'atmail' as it doesn't exist
done
 MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.10.13.4-11.5.30.20140128-071124.dump.gz
 Finishing up upgrade procedures and rerunning previously failed upgrade actions...
===> Cumulative Plesk database upgrade and repair (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
 Trying to resolve hostname 'rs200298.rs.hosteurope.de' and validate its IP address... done

httpsd: no process found
 Trying to set psa database version to 011005030... done
===> Cumulative upgrade and repair of Plesk database (revertable stage) has been completed.
===> Cumulative Plesk upgrade and repair (final stage) has been started.
===> Preparing Plesk upgrade (final stage).
httpsd: no process found
 Trying to Upgrade mode of DNS zones for subdomains...
WARNING!
Some problems are found during fail\nnCannot upgrade mode of DNS zones for subdomains. Please run /opt/psa/admin/plib/scripts/upgrade_subdomains_zones_1013.php manually.(see log file: /tmp/plesk_11.5.30_repair.log)

Continue...

done

WARNING!
Some problems are found during fail\nfix secret keys clients ids(see log file: /tmp/plesk_11.5.30_repair.log)

Continue...

 Trying to Upgrade permissions for Admin Simple Plan...
WARNING!
Some problems are found during fail\nnCannot upgrade permissions for Admin Simple Plan. Please run /opt/psa/admin/plib/scripts/upgrade_admin_simple_plan_permissions_1013.php manually.(see log file: /tmp/plesk_11.5.30_repair.log)

Continue...

Could not open input file: /opt/psa/admin/plib/scripts/license_upgrade_1013.php
Skip qmail specific upgrade actions
 Trying to update check-quota handler recipients address column in handlers DB... done
 Trying to Create subscription records... done
 Trying to Move limits and permissions from main domain of subscription to subscription properties...
WARNING!
Some problems are found during fail\nCannot update subscription properties. Please run /opt/psa/admin/plib/scripts/upgrade_subscription_properties_11.1.16.php manually.(see log file: /tmp/plesk_11.5.30_repair.log)

Continue...

 Trying to rename mailboxes to lower case format...
WARNING!
Some problems are found during rename mailboxes to lower case format. Please run /opt/psa/bin/repair --convert-mailboxes-to-lowercase manually.(see log file: /tmp/plesk_11.5.30_repair.log)

Continue...

 Trying to register service sw-engine... update-rc.d: /etc/init.d/sw-engine: file does not exist
done
 Trying to reload service postfix...  * Reloading Postfix configuration...
   ...done.
done
 Trying to drop unused 'statistics' directory from vhost skeletons... done
 Trying to upgrade vhost directories for domains...
WARNING!
Some problems are found during fail\nCannot upgrade vhost directories for domains. Please run /opt/psa/bin/repair --update-vhosts-structure manually.(see log file: /tmp/plesk_11.5.30_repair.log)

Continue...


WARNING!
Some problems are found during fail\nencryption of secret keys(see log file: /tmp/plesk_11.5.30_repair.log)
Continue...

 Trying to register service bind9...  System start/stop links for /etc/init.d/bind9 already exist.
done
 Trying to restart service bind9... done
 Trying to connect to apsc database... failed
 Trying to reset database user password for 'apsc'@'localhost'... done

ERROR while trying to can not find "register_apsc_database.php"
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again


===> Restoring database from backup /var/lib/psa/dumps/mysql.preupgrade.10.13.4-11.5.30.20140128-071124.dump.gz


**** Product repair failed.

*****  problem report *****
ERROR while trying to can not find "register_apsc_database.php"
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again
STOP Bootstrapper 11.5.30 repair AT Tue Jan 28 07:12:17 CET 2014

I have no "/tmp/autoinstall3.log" just "/tmp/plesk_11.5.30_installation.log" with following content:

START pp11.5.30-bootstrapper-11.5.30-ubuntu10.04.build115131216.11 installing (deb action: configure) AT Tue Jan 28 06:33:21 CET 2014

**** Package pp11.5.30-bootstrapper scriptlet completed successfully.

STOP pp11.5.30-bootstrapper-11.5.30-ubuntu10.04.build115131216.11 installing (deb action: configure) AT Tue Jan 28 06:33:21 CET 2014
START Bootstrapper 11.5.30 prep-install for BASE AT Tue Jan 28 06:33:22 CET 2014

**** Product prep-install started.

===> Checking for previous installation ... found.
Create user 'psaadm' and group 'psaadm'
 Checking for the group 'psaadm'...
 Group 'psaadm' already exists

 Checking for the user 'psaadm'...
 User 'psaadm' already exists

Create group swkey-data
 Checking for the group 'swkey-data'...
 Group 'swkey-data' already exists

 Checking for the group 'swkey-data'...
 Trying to add supplementary group 'swkey-data' for user 'psaadm'...  already there
Create Mail accounts
 Checking for the group 'popuser'...
 Group 'popuser' already exists

 Checking for the user 'popuser'...
 User 'popuser' already exists

 Checking for the user 'mhandlers-user'...
 User 'mhandlers-user' already exists

 Trying to got legacy variables... done
config updated
===> Updated /etc/psa/psa.conf
 Trying to save legacy variables... done
 Trying to resolve hostname 'rs200298.rs.hosteurope.de' and validate its IP address... done

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
 Trying to allow INNODB engine... done
Restarting mysql Trying to restart service mysql... /usr/sbin/mysqld (pid 1012) is running...
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the restart(8) utility, e.g. restart mysql
mysql start/running, process 15838
done

===> Checking for the necessary system accounts
 Checking for the system groups and users necessary for MySQL...
 Checking for the group 'mysql'...
 Group 'mysql' already exists

 Checking for the user 'mysql'...
 User 'mysql' already exists

 Checking for the system groups and users necessary for admin server...
 Checking for the group 'psaadm'...
 Group 'psaadm' already exists

 Checking for the user 'psaadm'...
 User 'psaadm' already exists

 Checking for the group 'psaserv'...
 Group 'psaserv' already exists

 Checking for the group 'psaserv'...
 Trying to add supplementary group 'psaserv' for user 'psaadm'...  already there
 Checking for the group 'psacln'...
 Group 'psacln' already exists

 Checking that /opt/psa/bin/chrootsh registered as login shell...


===> Performing safe prep-install database actions


===> Upgrading database

 Trying to start service mysql... /usr/sbin/mysqld (pid 15838) is running...
done
 Trying to establish test connection... connected
done
 Trying to find psa database... version is 010134
 Trying to backup MySQL database... Warning: Not dumping MySQL database 'atmail' as it doesn't exist
done
 MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.10.13.4-11.5.30.20140128-063327.dump.gz
 Trying to upgrade APS controller database... 
===> Cumulative APS controller database (apsc) upgrade has been started.
 Trying to backup MySQL database... done
 MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.apsc.10.13.4-11.5.30.20140128-063328.dump.gz
===> Upgrade of APS controller database has been completed.
done
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
 Trying to Converting custom buttons from domain to client level... Fix web proxy settings for service node 1
Frontend port = , backend port = 7080, proxy enabled = false
 Trying to drop rows from psa.dns_recs_t with empty values of column 'type'... done
 Trying to set psa database version to 011005030... done
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.

**** Product prep-install for BASE completed successfully.

STOP Bootstrapper 11.5.30 prep-install for BASE AT Tue Jan 28 06:33:36 CET 2014
START Bootstrapper 11.5.30 prep-install for horde AT Tue Jan 28 06:33:36 CET 2014

**** Product prep-install started.

===> Checking for previous installation ... found.

**** Product prep-install for horde completed successfully.

STOP Bootstrapper 11.5.30 prep-install for horde AT Tue Jan 28 06:33:36 CET 2014
START Bootstrapper 11.5.30 prep-install for drweb-configurator AT Tue Jan 28 06:33:36 CET 2014

**** Product prep-install started.

===> Checking for previous installation ... found.
 Trying to upgrade Parallels Premium antivirus (DrWeb) service configuration (bootstrapper-prep stage)... done

**** Product prep-install for drweb-configurator completed successfully.

STOP Bootstrapper 11.5.30 prep-install for drweb-configurator AT Tue Jan 28 06:33:36 CET 2014

The result in plesk is the same error as above mentioned.

 

[IgorG]

ERROR while trying to can not find "register_apsc_database.php"
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again

Do you have file /usr/local/psa/admin/plib/scripts/register_apsc_database.php ? It is part of plesk-core package.
Have you checked related content of /tmp/plesk_11.5.30_repair.log ?

 

[NikosA]

Do you have file /usr/local/psa/admin/plib/scripts/register_apsc_database.php ? It is part of plesk-core package.

No there is no such file.

Have you checked related content of /tmp/plesk_11.5.30_repair.log ?

Sorry, what exactly do you mean to check?

 

[IgorG]

Sorry, what exactly do you mean to check?

Something useful.
BTW, do you have enough free disk space on this server?

 

[NikosA]

Yes, there is a lot of space (~70% free hdd)

 

[NikosA]

Any idea how to proceed? We have a major problem with this issue.

Thank you in advance!

 

[IgorG]

Try to ask help here - https://www.parallels.com/support/plesk/free11assistance/

 

[Nhanbacdoi]

Yes what you are looking for, thank you for sharing