Unable to manage subscriptions after upgrade: Unable to find service node for web service on domain with id

Created:

2016-11-16 12:50:36 UTC

Modified:

2017-08-16 16:03:03 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to manage subscriptions after upgrade: Unable to find service node for web service on domain with id

Applicable to:

  • Plesk 10.x for Linux
  • Plesk 11.x for Linux

Symptoms

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
File PhDomainBase.php
Line 795
Type PleskDBException

In the upgrade log /tmp/autoinstaller3.log you can find this error message:

Error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ipAddressId' cannot be null

or:

Cannot update web domain services information. Please run /usr/local/psa/admin/plib/scripts/upgrade_web_domain_services_1010.php manually.

Cause

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.

Resolution

Launch the script manually to get more information about the error:

/opt/psa/bin/sw-engine-pleskrun /opt/psa/admin/plib/scripts/upgrade_web_domain_services_1010.php

If you have any questions, please contact Plesk Technical Support

Have more questions? Submit a request
Please sign in to leave a comment.