update, "11.0.9", (Debian 6.0) to "12.0.18", FAILED

[MoL]

Hi , I tried update from 11.0.9 to 12.0.18 and i have problems . The site work fine
but i can't enter in my Plesk Panel . When i tried to enter on login page appeare what is below.


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 'DELETE FROM `ServiceNodeProperties` WHERE (name LIKE '%.synced')', array)
3: Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'DELETE FROM `ServiceNodeProperties` WHERE (name LIKE '%.synced')', array)
4: Mysql.php:19
Db_Adapter_Pdo_Mysql->query(string 'DELETE FROM `ServiceNodeProperties` WHERE (name LIKE '%.synced')')
5: Abstract.php:663
Zend_Db_Adapter_Abstract->delete(string 'ServiceNodeProperties', string 'name LIKE '%.synced'')
6: Abstract.php:1184
Zend_Db_Table_Abstract->delete(string 'name LIKE '%.synced'')
7: ServiceNode.php:84
Db_Table_Row_ServiceNode->refreshProperties()
8: auth.php3:511


In thr ERROR LOG file:

<--
Installation started in background

Getting bootstrapper packages to installation list:
Following bootstrapper packages will be installed: pp12.0.18-bootstrapper-12.0.18-debian6.0.build1200140821.14.amd64
----------------
Getting packages to installation list:
Package mailman with version '1:2.1.13-5' is available from apt
skip keypackage 'mailman-1:2.1.13-5.amd64' from component mailman - same or newer version of this package is already installed (in system mailman-1:2.1.13-5.amd64)
skip package 'psa-qmail-rblsmtpd-0.88-debian6.0.build120140331.11.amd64' from component qmail - there is same or newer version of this package is installed (in system psa-qmail-rblsmtpd-0.88-debian6.0.build1012110621.18.amd64)
Following packages will be installed: pp12.0.18-bootstrapper-12.0.18-debian6.0.build1200140821.14.amd64 plesk-base-12.0.18-debian6.0.build1200140606.15.amd64 psa-12.0.18-debian6.0.build1200140606.15.amd64 libpam-plesk-12.0.18-debian6.0.build1200140606.15.amd64 plesk-aps-php-runtime-12.0.18-1016274.14060313.all plesk-completion-12.0.18-debian6.0.build1200140606.15.all plesk-core-12.0.18-debian6.0.build1200140606.15.amd64 plesk-l10n-12.0.18-

------------------------------
--------------------------------
--------------------------------

migration-manager amd64 12.0.18-debian6.0.build1200140606.15 [571 kB]
Get:86 http://autoinstall.plesk.com/debian/PSA_12.0.18/ squeeze/all psa-migration-agents amd64 12.0.18-debian6.0.build1200140606.15 [35.5 kB]
Get:87 http://autoinstall.plesk.com/debian/PSA_12.0.18/ squeeze/all psa-mnemo all 4.2.1-debian6.0.build1200140818.13 [1237 kB]
Get:88 http://autoinstall.plesk.com/debian/PSA_12.0.18/ squeeze/all psa-passwd all 5.0.1-debian6.0.build1200140818.13 [1149 kB]
Get:89 http://autoinstall.plesk.com/debian/PSA_12.0.18/ squeeze/all psa-rubyrails-configurator amd64 1.1.6-debian6.0.build1200140526.11 [12.4 kB]
Get:90 http://autoinstall.plesk.com/debian/PSA_12.0.18/ squeeze/all psa-turba all 4.2.1-debian6.0.build1200140818.13 [2001 kB]
Failed to fetch http://autoinstall.plesk.com/debian..._64/contrib/sw-rsync_3.1.0-14041818_amd64.deb 504 Gateway Timeout
Fetched 332 MB in 3min 0s (1836 kB/s)
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?
Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_12_0_18', sequence='pkgs', stage='rollback', sequence_order='1', operation='install', exec_cmd='rm -f /tmp/pp-bootstrapper-mode.flag; rm -f /var/lock/parallels-panel-maintenance-mode.flag; touch /var/lock/parallels-panel-upgrade-failure.flag; :'
Execute command /opt/psa/admin/bin/send-error-report install
Error: An error occurred on attempt to install packages.
Attention! Your software might be inoperable.
Please, contact product technical support.
-->


Can i use a command via ssh for this problem?
Can you help me pls? Tks in advance.

 

[MoL]

I tried again via SSh with :

/usr/local/psa/admin/bin/autoinstaller --select-release-latest --upgrade-installed-components

and now when i want enter on my Plesk Panel the page is blank and the Site work ok

Then i check the error reason in file: /var/log/plesk/install/plesk_12.0.18_installation.log


-------------------
------------------

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 30679) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... ERROR 1286 (42000) at line 1: Unknown table engine 'InnoDB'
ERROR 1286 (42000) at line 1: Unknown table engine 'innodb'
DATABASE ERROR!!!
Database psa found, but version undefined

ERROR while trying to find psa database
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_installation.log), fix and try again


Trying to start psa...
Stopping psa... done

**** Product prep-install for BASE failed.

***** problem report *****
ERROR while trying to find psa database
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_installation.log), fix and try again
STOP Bootstrapper 12.0.18 prep-install for BASE AT Sun Sep 7 00:11:25 EEST 2014

 

[IgorG]

There are several KB articles regarding error message "Unknown table engine 'innodb'" Try to use this phrase for KB search engine and try to find appropriate method for fixing this issue.