Autoinstaller Problems after Upgrade to 8.1

[Lurker]

Hi,

I did an upgrade from 8.01 to 8.1 using the autoinstaller recently, which was working well. Now there are some further updates for 8.1 listed in the updater, but when I try to install these updates I get a mail "Plesk autoupdate failure report".

I try to install these packages (via the Updater):

Component || Your release || Latest release || Status
Base packages of Plesk || Dec 12, 2006 || Dec 26, 2006 || An update is available
Plesk API [former Plesk Agent] || Sept 4, 2006 || Dec 26, 2006 || An update is available
Plesk Backup Manager || Dec 26, 2006 || Dec 26, 2006 || An update is available
Plesk migration manager || Sept 4, 2006 || Dec 26, 2006 || An update is available

The failure report contain this lines:

...
Getting packages to installation list:
Get packages to installation from selected component base
Get packages to installation from selected component backup-vz
Get packages to installation from selected component api
Get packages to installation from selected component pmm
resolve packages with apt-get
apt-get say following:
Reading Package Lists...
Building Dependency Tree...
You might want to run `apt-get -f install' to correct these:
The following packages have unmet dependencies:
psa-hotfix1: Depends: psa-8.0.1 but it is not installable
psa-migration-manager: Depends: db4.2-util but it is not going to be installed
Depends: libdb3-util but it is not going to be installed

catch error with message: Error while resolve packages by apt
ERROR: Error while resolve packages by apt
Check SElinux status after error:
Exit with ERROR status

Any idea what to do? Thanks a lot!

Kind regars,
Juergen

 

[Vengent]

If you're comfortable with the console, you could try a fresh "apt-get update", then "apt-get -f install".

If that doesn't work, post what the response is, and can go from there.

Alternatively, i've seen some cases of debian + plesk where you just need to run the updater through the control panel multiple times.

 

[Lurker]

Thanks for your feedback. I tried what you said, but it wasn't working again. This is the console output (shortened):

...
===> Installing phpMyAdmin
Trying to create pmadb... done
done
===> Installing /usr/lib/apache2/suexec2 replacement
This module is already enabled!
This module is already enabled!
This module is already enabled!
===> Cumulative upgrade has been started

ERROR while trying to upgrade SQL database from 800
Check the error reason(see log file: /tmp/psa_8.1.0_debian3.1.build81061129.22_upgrade.log), fix and try again

Aborting...

And this is the psa_8.1.0_debian3.1.build81061129.22_upgrade.log:

===> Installing phpMyAdmin
Trying to create pmadb... done
done
===> Installing /usr/lib/apache2/suexec2 replacement
Leaving `diversion of /usr/lib/apache2/suexec2 to /usr/lib/apache2/suexec2.distr
ib by psa'
`/opt/psa/suexec/psa-suexec2' -> `/usr/lib/apache2/suexec2'

ERROR 1060 (42S21) at line 8: Duplicate column name 'fastcgi'

=====================================
070106 11:33:01 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 50 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 233, signal count 233
Mutex spin waits 2774, rounds 8864, OS waits 8
RW-shared spins 106, OS waits 53; RW-excl spins 171, OS waits 168
------------
TRANSACTIONS
------------
Trx id counter 0 426699
Purge done for trx's n < 0 426669 undo n < 0 0
History list length 52
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 9782, OS thread id 107167754
MySQL thread id 6533, query id 283556 localhost admin
show 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: 0; buffer pool: 0
3004 OS file reads, 229 OS file writes, 183 OS fsyncs
0.04 reads/s, 16384 avg bytes/read, 0.32 writes/s, 0.28 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf for space 0: size 1, free list len 5, seg size 7, is empty
Ibuf for space 0: size 1, free list len 5, seg size 7,
0 inserts, 0 merged recs, 0 merges
Hash table size 34679, used cells 0, node heap has 1 buffer(s)
0.00 hash searches/s, 3.42 non-hash searches/s
---
LOG
---
Log sequence number 0 374066132
Log flushed up to 0 374066132
Last checkpoint at 0 374044769
0 pending log writes, 0 pending chkp writes
156 log i/o's done, 0.24 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 18639854; in additional pool allocated 1046400
Buffer pool size 512
Free buffers 0
Database pages 511
Modified db pages 23
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 5349, created 4, written 64
0.04 reads/s, 0.08 creates/s, 0.06 writes/s
Buffer pool hit rate 999 / 1000
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
Main thread process no. 24979, id 114696, state: sleeping
Number of rows inserted 23, updated 127, deleted 12, read 2250493
0.08 inserts/s, 0.04 updates/s, 0.00 deletes/s, 1.88 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================


ERROR while trying to upgrade SQL database from 800

Aborting...

Any further idea? Thanks a lot!

Kind Regards,
Jürgen

 

[Vengent]

Could you post all of the response from apt-get -f install?

 

[Lurker]

It is working now: I did a restore from the backup I created before the upgrade to 8.1.

In the plesk interface updater there were two entries, 8.01 and 8.1. There were updates available for both.

The first time I did an update directly to 8.1, because I thought that this will include also all changes from 8.01. But this caused the problems i posted here.

After the restore I did first install all updates for 8.01, and after this I upgraded to 8.1. This was working well, an d I have not found any problems yet.

Cheers,
Lurker