After an upgrade procedure some domains are unavailable with the following error message:
Internal error: Unable to find service node for web service on domain with id=10
Message Unable to find service node for web service on domain with id=10
In the upgrade log
/tmp/autoinstaller3.log you can find this error message:
Error: SQLSTATE: Integrity constraint violation: 1048 Column 'ipAddressId' cannot be null
Cannot update web domain services information. Please run /usr/local/psa/admin/plib/scripts/upgrade_web_domain_services_1010.php manually.
The web service upgrade script failed because of a database inconsistency that existed before the upgrade (the domain with hosting did not have a corresponding record in the hosting or forwarding table). Usually, this means the domain was unavailable before the upgrade.
Launch the script manually to get more information about the error:
If you have any questions, please contact Plesk Technical Support