Symptoms
Plesk upgrade fails with the following error:
PLESK_WARN: WARNING: Unable to find “main” IP address in psa database.
Cause
Plesk database inconsistency.
Resolution
-
Connect to the server via SSH
-
Get the list of IP addresses:
# plesk db “select id,ip_address,main from IP_Addresses”
+—+————-+——+
| id| ip_address | main |
+—+————-+——+
| 1 | 203.0.113.2 | false |
| 3 | 203.0.113.1 | false | -
Mark one of the IP Addresses as a “main”. For example:
# plesk db “update IP_Addresses set main =’true’ where ip_address=’203.0.113.2′”
Note: The IP address 203.0.113.2 is marked as the “main” one.
-
Initialize the update once again
Kill Plesk auto-installer processes, if there are any still active:
# ps -ef | grep ‘install’ | grep -v grep | awk ‘{print $2}’ | xargs -r kill -9