Upgrade error 11.0.9 -> 12.0.18

[ArkadiC]

Hi

I'm getting the error below when upgrading from 11.0.9 to 12.0.18 through the web interface. Anybody an idea?

------------------------------
Preparing to replace psa-mnemo 2.2.5-debian6.0.build110120606.19 (using .../psa-mnemo_4.1.3-debian6.0.build1200140526.11_all.deb) ...
Unpacking replacement psa-mnemo ...
Preparing to replace psa-passwd 3.1.3-debian6.0.build1013111101.14 (using .../psa-passwd_5.0.1-debian6.0.build1200140526.11_all.deb) ...
Unpacking replacement psa-passwd ...
Preparing to replace psa-tomcat-configurator 11.0.9-debian6.0.build110120606.19 (using .../psa-tomcat-configurator_12.0.18-debian6.0.build1200140604.14_all.deb) ...
Unpacking replacement psa-tomcat-configurator ...
Preparing to replace psa-turba 2.3.6-debian6.0.build110120606.19 (using .../psa-turba_4.1.4-debian6.0.build1200140526.11_all.deb) ...
Unpacking replacement psa-turba ...
Processing triggers for man-db ...
Errors were encountered while processing:
/var/cache/apt/archives/wpb-designs-00_12.0.4-43480.14051315_all.deb
/var/cache/apt/archives/wpb-designs-01_12.0.4-43480.14051315_all.deb
/var/cache/apt/archives/wpb-designs-03_12.0.4-43480.14051315_all.deb
/var/cache/apt/archives/wpb-designs-04_12.0.4-43480.14051315_all.deb
/var/cache/apt/archives/wpb-designs-05_12.0.4-43480.14051315_all.deb
/var/cache/apt/archives/wpb-designs-07_12.0.4-43480.14051315_all.deb
/var/cache/apt/archives/wpb-designs-09_12.0.4-43480.14051315_all.deb
/var/cache/apt/archives/wpb-designs-12_12.0.4-43480.14051315_all.deb
/var/cache/apt/archives/wpb-designs-14_12.0.4-43480.14051315_all.deb
/var/cache/apt/archives/wpb-designs-20_12.0.4-43480.14051315_all.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
sh: getcwd() failed: No such file or directory
Bootstrapper has finished action (exec time: 0.01 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.
--------------------------------

Thx!

 

[IgorG]

Try to fix it with bootstrapper repair procedure.

 

[ArkadiC]

Repair failed also.

root@plesk3:~# /usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh repair
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.

-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
Finishing up upgrade procedures and rerunning previously failed upgrade actions...
===> Cumulative APS controller database (apsc) upgrade and repair has been started.

**** 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 1832) is running...
done
Trying to establish test connection... connected
done
Trying to start service mysql... /usr/sbin/mysqld (pid 1832) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 012000018
Version is OK, no need to create psa database.
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/plesk/dump/mysql.preupgrade.11.0.9-12.0.18.20140710-101813.dump.gz
Finishing up upgrade procedures and rerunning previously failed upgrade actions...
===> Cumulative APS controller database (apsc) upgrade and repair has been started.
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/plesk/dump/mysql.preupgrade.apsc.11.0.9-12.0.18.20140710-101830.dump.gz
ERROR 1146 (42S02) at line 89: Table 'apsc.aps_application_resource' doesn't exist
InnoDB
=====================================
140710 10:18:31 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 49 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 189, signal count 189
Mutex spin waits 0, rounds 57, OS waits 2
RW-shared spins 58, OS waits 29; RW-excl spins 159, OS waits 158
------------
TRANSACTIONS
------------
Trx id counter 0 57213464
Purge done for trx's n < 0 57212901 undo n < 0 0
History list length 14
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 1832, OS thread id 140260361094912
MySQL thread id 6622, query id 25304 localhost admin
SHOW ENGINE innodb status
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio writes: 0,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 1; buffer pool: 0
7452 OS file reads, 8 OS file writes, 7 OS fsyncs
20.29 reads/s, 19993 avg bytes/read, 0.02 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7,
0 inserts, 0 merged recs, 0 merges
Hash table size 17393, node heap has 1 buffer(s)
0.00 hash searches/s, 0.37 non-hash searches/s
---
LOG
---
Log sequence number 2 1539905763
Log flushed up to 2 1539905753
Last checkpoint at 2 1539905753
1 pending log writes, 0 pending chkp writes
11 log i/o's done, 0.02 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 34749160; in additional pool allocated 1048576
Dictionary memory allocated 11809112
Buffer pool size 512
Free buffers 0
Database pages 511
Modified db pages 1
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 9083, created 0, written 1
24.75 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 965 / 1000
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 1832, id 140260209985280, state: flushing log
Number of rows inserted 0, updated 0, deleted 0, read 123679
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 2513.93 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================


ERROR while trying to upgrade APSC SQL database from 11.1.0
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_repair.log), fix and try again

===> Restoring APS controller database from backup '/var/lib/plesk/dump/mysql.preupgrade.apsc.11.0.9-12.0.18.20140710-101830.dump.gz'
***** problem report *****
ERROR while trying to upgrade APSC SQL database from 11.1.0
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_repair.log), fix and try again

 

[IgorG]

Try to ask help here - http://www.parallels.com/products/plesk/free-assistance/

 

[ArkadiC]

Ok. Ticket created. One more question. Is it still possible to upgrade to 11.5 first?

Here is some additional information:
root@plesk3:~# apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these.
The following packages have unmet dependencies:
pp-sitebuilder : Depends: wpb-designs-00 (>= 12.0.0) but it is not installable
Depends: wpb-designs-01 (>= 12.0.0) but it is not installable
Depends: wpb-designs-03 (>= 12.0.0) but it is not installable
Depends: wpb-designs-04 (>= 12.0.0) but it is not installable
Depends: wpb-designs-05 (>= 12.0.0) but it is not installable
Depends: wpb-designs-07 (>= 12.0.0) but it is not installable
Depends: wpb-designs-09 (>= 12.0.0) but it is not installable
Depends: wpb-designs-12 (>= 12.0.0) but it is not installable
Depends: wpb-designs-14 (>= 12.0.0) but it is not installable
Depends: wpb-designs-20 (>= 12.0.0) but it is not installable
E: Unmet dependencies. Try using -f.

root@plesk3:~# apt-get upgrade -f
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following packages will be REMOVED:
plesk-management-node pp-sitebuilder
0 upgraded, 0 newly installed, 2 to remove and 0 not upgraded.
82 not fully installed or removed.
After this operation, 61.4 kB disk space will be freed.
Do you want to continue [Y/n]?

 

[IgorG]

Ok. Ticket created. One more question. Is it still possible to upgrade to 11.5 first?

Yes. Just use --all-versions for autoinstaller:

# /usr/local/psa/admin/sbin/autoinstaller --all-versions

 

[Jammyamerica]

Working Good