Article ID: 114632, created on Apr 10, 2013, last review on May 11, 2014

  • Applies to:
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 10.4 for Linux/Unix



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


Error: SQLSTATE[23000]: 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.


该 web 服务升级脚本失败因为在升级前数据库不一致(主机域在 主机转发 表格中没有相应的记录)。 通常这表示该域在升级前也无法使用。


Parallels Plesk Panel (PP) 任何版本都适用的版本:

1. 创建数据库的转储:
# DUMP_D=`cat /etc/psa/psa.conf | grep DUMP_D | awk '{print $2}'`
# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > $DUMP_D/psadb_fix.dump.`date +"%F_%H:%M:%S"`

2. 找到并删除有关数据库受损坏的域的记录:
mysql> select,, d.htype from domains d LEFT JOIN hosting h ON = h.dom_id LEFT JOIN forwarding f ON where h.dom_id IS NULL and f.dom_id is NULL and htype != 'none';
| id | name | htype |
| 5 | broken.phys | vrt_hst |
| 6 | broken.frm | frm_fwd |
1 row in set (0.00 sec)

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "delete from domains where id=$BROKEN_DOMAIN_ID"

# for i in `mysql -uadmin -p\`cat /etc/psa/.psa.shadow\` psa -e 'show tables'`; do mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -e "select * from $i where dom_id=$BROKEN_DOMAIN_ID" 2>/dev/null && echo "Deleting domain data from table $i" && mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -e "delete from $i where dom_id=$BROKEN_DOMAIN_ID" ;done

为下一个 domain_id 重复该步骤。

3. 升级 PP.

对 PP 版本 > 10.0:

4. 如果 PP 已升级请再次运行 web 服务升级脚本:
# /opt/psa/bin/sw-engine-pleskrun /opt/psa/admin/plib/scripts/upgrade_web_domain_services_1010.php

56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 aea4cd7bfd353ad7a1341a257ad4724a 0a53c5a9ca65a74d37ef5c5eaeb55d7f e8756e9388aeca36710ac39e739b2b37 dd0611b6086474193d9bf78e2b293040 01bc4c8cf5b7f01f815a7ada004154a2

Email subscription for changes to this article