aptitude upgrade broke plesk

[LIcon]

Hi, I am currently unable to access the web interface control panel for Plesk for my Debian 6.x server.

When I go to the address where I usually find a Plesk login, I am getting...

Unable to connect

Firefox can't establish a connection to the server at {my server's IP address}:8443​

How I got to this point...

1. I was in the web interface control panel and noticed that I had version 10.x and Plesk is not at a version in the 12.x range.
2. Attempted to upgrade through the web interface. It wouldn't finish because I had an Apache configuration issue (manually deleted a directory and forgot to tell the config file it was gone).
3. Used SSH to fix the Apache configuration issue
4. Went ahead and ran "update" then "upgrade" on aptitude from the command line... notice a munch of Plesk file activity I don't usually see when doing this
5. Restarted the server to have a nice clean restart of Apache
6. Unable to reach the Pleask control panel

Other notes...

Some Googling led me to a support forum page that suggested looking for errors in /usr/local/psa/admin/logs/panel.log and right now what I am seeing is this...

2013-02-27T06:25:23+01:00 ERR (3): KeyUpdate Result code: 2 Network failure

2013-02-27T06:25:23+01:00 ERR (3): KeyUpdate Result desc: Couldn't connect to server

2013-08-26T06:25:38+02:00 ERR (3): KeyUpdate Result code: 2 Network failure

2013-08-26T06:25:38+02:00 ERR (3): KeyUpdate Result desc: SSL connect error

2013-08-27T06:25:23+02:00 ERR (3): KeyUpdate Result code: 2 Network failure

2013-08-27T06:25:23+02:00 ERR (3): KeyUpdate Result desc: Couldn't connect to server

2013-08-28T06:25:23+02:00 ERR (3): KeyUpdate Result code: 2 Network failure

2013-08-28T06:25:23+02:00 ERR (3): KeyUpdate Result desc: Couldn't connect to server

2013-09-25T06:25:23+02:00 ERR (3): KeyUpdate Result code: 2 Network failure

2013-09-25T06:25:23+02:00 ERR (3): KeyUpdate Result desc: Couldn't connect to server

2014-07-11T02:36:21+02:00 ERR (3): sappmng: Unable to enter directory d�: Permission denied
System error 13: Permission denied

2014-07-11T02:36:21+02:00 ERR (3): Can not remove package from APS controller: [MySQL][ODBC 5.1 Driver][mysqld-5.1.66-0+squeeze1]Cannot delete or update a parent row: a foreign key constraint fails (`apsc`.`aps_application$
2014-10-23T06:25:24+02:00 ERR (3): KeyUpdate Result code: 2 Network failure

2014-10-23T06:25:24+02:00 ERR (3): KeyUpdate Result desc: Couldn't connect to server
​

... I don't knwo if that is relevant at all.

So, that's where I am right now. Server is running fine, mail is working, websites are up, but I can't get back into the Plesk control panel and I don't know or understand what is broken.

 

[IgorG]

Have you read this thread?
http://talk.plesk.com/threads/impor...ution-for-the-existing-issue-question.334123/

 

[LIcon]

Working from that now.

I ran...

/usr/local/psa/admin/bin/autoinstaller --select-product-id plesk --select-release-current --reinstall-patch --install-component base​

... as suggeted. Control Panel still unavailable.

Ran...

/usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh repair​

... error message:

***** 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​

... navigated to that log file and it says...

START Bootstrapper 12.0.18 repair AT Tue Sep 8 05:30:46 CEST 2015

**** 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 1400) is running...
done
Trying to establish test connection... connected
done
Trying to start service mysql... /usr/sbin/mysqld (pid 1400) 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-12.0.18.20150908-053046.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/psa/dumps/mysql.preupgrade.apsc.10.13.4-12.0.18.20150908-053047.dump.gz
ERROR 1146 (42S02) at line 89: Table 'apsc.aps_application_resource' doesn't exist
InnoDB
=====================================
150908 5:30:47 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 55 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1097, signal count 1079
Mutex spin waits 0, rounds 6334, OS waits 87
RW-shared spins 1814, OS waits 906; RW-excl spins 106, OS waits 102
------------
TRANSACTIONS
------------
Trx id counter 0 8888672
Purge done for trx's n < 0 8888639 undo n < 0 0
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 1400, OS thread id 139640220305152
MySQL thread id 127437, query id 2263774 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: 0; buffer pool: 0
746 OS file reads, 17668 OS file writes, 9485 OS fsyncs
1.00 reads/s, 21448 avg bytes/read, 0.16 writes/s, 0.13 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 17393, node heap has 3 buffer(s)
0.33 hash searches/s, 0.71 non-hash searches/s
---
LOG
---
Log sequence number 0 1221791566
Log flushed up to 0 1221791566
Last checkpoint at 0 1221791566
0 pending log writes, 0 pending chkp writes
6844 log i/o's done, 0.05 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 22417608; in additional pool allocated 1048576
Dictionary memory allocated 1381800
Buffer pool size 512
Free buffers 0
Database pages 509
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 995, created 228, written 10976
1.31 reads/s, 0.00 creates/s, 0.07 writes/s
Buffer pool hit rate 967 / 1000
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 1400, id 139640230885120, state: sleeping
Number of rows inserted 2599, updated 738, deleted 2007, read 1140283
0.00 inserts/s, 0.00 updates/s, 0.04 deletes/s, 18.56 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/psa/dumps/mysql.preupgrade.apsc.10.13.4-12.0.18.20150908-053047.dump.gz'

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


**** Product repair failed.

***** 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
STOP Bootstrapper 12.0.18 repair AT Tue Sep 8 05:30:53 CEST 2015
​

... so that is where I am now. I usually employ PHP MyAdmin to edit MySQL, but it's in the Plesk control panel I cannot access.

I'm looking at this forum entry:

http://talk.plesk.com/threads/upgrade-error-11-0-9-12-0-18.306521/#post-737810
​

In that thread you suggested that the user...

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

... however, that link no longer seems to work.

 

[LIcon]

I also got this email.

Subject: Parallels Plesk key update deferral notification
Body: Unable to update . An error occurred while processing your key. You can try updating it later.

 

[IgorG]

In that thread you suggested that the user...

Try to ask help here - http://www.parallels.com/products/plesk/free-assistance/
... however, that link no longer seems to work.

Use this link - https://www.odin.com/products/plesk/free-assistance/

 

[LIcon]

I went through the form, but didn't get any sort of confirmation at the end. How long does it usually take to get help?

 

[LIcon]

It has been about a month since I tried to use the free assistance, but I haven't gotten any response after going through the support request process. Is my ticket actually in your system?

 

[LIcon]

I still haven't heard anything and the link https://www.odin.com/products/plesk/free-assistance/ doesn't work anymore.