Unable to find service node for ip address

[AandCmedia]

Hello,
I read through this:
http://kb.parallels.com/en/113826

But does not seem to solve my problem I keep getting a:
Internal error: Unable to find service node for ip address with id=4

Message Unable to find service node for ip address with id=4
File ServiceNodes.php
Line 41
Type PleskDBException

 

[IgorG]

It is related to database inconsistency. There is something wrong for this ip_address_id 4 in tables IP_Addresses, ip_pool, IpAddressesCollections and maybe somewhere else. Contact Support Team if you can't fix this inconsistency by yourself.

 

[AandCmedia]

It is related to database inconsistency. There is something wrong for this ip_address_id 4 in tables IP_Addresses, ip_pool, IpAddressesCollections and maybe somewhere else. Contact Support Team if you can't fix this inconsistency by yourself.

Any help:

mysql> select * from IP_Addresses
    -> ;
+----+--------------+-----------------+--------+--------------------+-------------------+-------+-------+--------+---------------+
| id | ip_address   | mask            | iface  | ssl_certificate_id | default_domain_id | ftps  | main  | status | serviceNodeId |
+----+--------------+-----------------+--------+--------------------+-------------------+-------+-------+--------+---------------+
|  1 | 72.10.37.143 | 255.255.255.255 | venet0 |                 17 |                95 | false | true  |      0 |             1 |
|  2 | 72.10.39.59  | 255.255.255.255 | venet0 |                 15 |                96 | false | false |      0 |             1 |
|  5 | 72.10.37.139 | 255.255.255.255 | venet0 |                 14 |                 0 | false | false |      0 |             1 |
+----+--------------+-----------------+--------+--------------------+-------------------+-------+-------+--------+---------------+
3 rows in set (0.00 sec)

mysql> select * from ip_pool;
+----+---------------+--------+
| id | ip_address_id | type   |
+----+---------------+--------+
|  1 |             1 | shared |
|  1 |             2 | shared |
|  1 |             4 | shared |
|  1 |             5 | shared |
|  2 |             1 | shared |
|  3 |             1 | shared |
|  4 |             1 | shared |
|  5 |             1 | shared |
|  8 |             5 | shared |
| 11 |             1 | shared |
| 13 |             1 | shared |
| 14 |             1 | shared |
| 25 |             1 | shared |
| 37 |             1 | shared |
| 38 |             1 | shared |
| 41 |             1 | shared |
| 63 |             1 | shared |
| 64 |             1 | shared |
| 65 |             1 | shared |
+----+---------------+--------+
19 rows in set (0.00 sec)

mysql> select * from IpAddressesCollections;
+----------------+-------------+
| ipCollectionId | ipAddressId |
+----------------+-------------+
|              1 |           1 |
|             26 |           1 |
|             42 |           1 |
|             43 |           1 |
|             63 |           5 |
|             64 |           5 |
|             82 |           5 |
|             83 |           5 |
|             86 |           5 |
|             87 |           5 |
|             93 |           1 |
|             94 |           1 |
|             95 |           1 |
|             96 |           1 |
|             97 |           1 |
|             98 |           1 |
|            102 |           1 |
|            103 |           1 |
|            106 |           5 |
|            107 |           5 |
|            126 |           5 |
|            127 |           5 |
|            128 |           1 |
|            129 |           1 |
|            130 |           1 |
|            131 |           1 |
|            156 |           1 |
|            157 |           1 |
|            183 |           1 |
|            184 |           1 |
|            187 |           1 |
|            188 |           1 |
|            189 |           1 |
|            190 |           1 |
|            191 |           2 |
|            192 |           2 |
|            197 |           1 |
|            198 |           1 |
|            241 |           1 |
|            242 |           1 |
|            243 |           1 |
|            244 |           1 |
|            245 |           1 |
|            246 |           1 |
+----------------+-------------+
44 rows in set (0.00 sec)

 

[IgorG]

As you can see there is record only in ip_pool table for ip_address_id=4.

 

[DenixS]

Hello!
I was forced to change the ip-address on the hosting and now there i have a various problems. For example now I'm faced with such a problem. I cant edit hosting parametres any clients and delete em. Everytime when i try to change hosting parametres of the customers, i've got this error: "Internal error: Unable to find service node for ip address with id=4". When i try to delete a customer/site/subscribe, i've got "Ошибка: Невозможно удалить клиента: Unable to find service node for web service on domain with id=xx". I used a query, that i see above, there is my result:

mysql> select * from ip_pool;
+----+---------------+-----------+
| id | ip_address_id | type      |
+----+---------------+-----------+
|  1 |             3 | shared    |
|  1 |             4 | exclusive |
|  4 |             3 | shared    |
|  5 |             3 | shared    |
|  6 |             3 | shared    |
|  8 |             3 | shared    |
| 13 |             3 | shared    |
| 15 |             3 | shared    |
| 16 |             3 | shared    |
| 18 |             3 | shared    |
| 19 |             3 | shared    |
| 20 |             3 | shared    |
| 21 |             3 | shared    |
| 22 |             3 | shared    |
| 23 |             3 | shared    |
| 24 |             3 | shared    |
| 25 |             3 | shared    |
| 26 |             3 | shared    |
| 27 |             3 | shared    |
+----+---------------+-----------+
19 rows in set (0.00 sec)

mysql> select * from IP_Addresses;
+----+---------------+-----------------+---------------+-------+--------------------+-------------------+-------+------+--------+
| id | serviceNodeId | ip_address      | mask          | iface | ssl_certificate_id | default_domain_id | ftps  | main | status |
+----+---------------+-----------------+---------------+-------+--------------------+-------------------+-------+------+--------+
|  3 |             1 | 123.123.123.123 | 255.255.224.0 | eth0  |                  9 |                35 | false | true |      0 |
+----+---------------+-----------------+---------------+-------+--------------------+-------------------+-------+------+--------+
1 row in set (0.00 sec)

mysql> select * from IpAddressesCollections;
+----------------+-------------+
| ipCollectionId | ipAddressId |
+----------------+-------------+
|              5 |           3 |
|              6 |           3 |
|              7 |           3 |
|              8 |           3 |
|              9 |           3 |
|             10 |           3 |
|             11 |           3 |
|             12 |           3 |
|             15 |           3 |
|             16 |           3 |
|             25 |           3 |
|             26 |           3 |
|             29 |           3 |
|             30 |           3 |
|             31 |           3 |
|             32 |           3 |
|             35 |           3 |
|             36 |           3 |
|             37 |           3 |
|             38 |           3 |
|             41 |           3 |
|             42 |           3 |
|             43 |           3 |
|             44 |           3 |
|             45 |           3 |
|             46 |           3 |
|             47 |           3 |
|             48 |           3 |
|             49 |           3 |
|             50 |           3 |
|             51 |           3 |
|             52 |           3 |
|             53 |           3 |
|             55 |           3 |
|             56 |           3 |
|             57 |           3 |
|             58 |           3 |
|             59 |           3 |
|             60 |           3 |
|             61 |           3 |
|             62 |           3 |
|             63 |           3 |
|             64 |           3 |
|             65 |           3 |
|             66 |           3 |
|             67 |           3 |
|             68 |           3 |
|             69 |           3 |
|             70 |           3 |
|             71 |           3 |
|             72 |           3 |
|             73 |           3 |
|             74 |           3 |
|             75 |           3 |
|             76 |           3 |
+----------------+-------------+
55 rows in set (0.00 sec)

As i can see ip-address with id=4 not used in IP_Addresses and IpAddressesCollections tables. How i can fix a query instead 4 to 3? Please, give me solution of this problem.
Thanks in advance.

 

[IgorG]

Just try to remove record about exclusive IP from ip_pool table. Or update 4 to 3.

 

[DenixS]

Thank you, Igor, it helped! But still have one problem, I can't delete a site/customer which I tried to remove before that i fix id in table. When I try to delete a customer, i've got this errors: "Ошибка: Некоторые из выбранных клиентов не были удалены." and just below the
"Ошибка: Невозможно удалить клиента: Unable to find service node for web service on domain with id=27" How to fix it? I've read a few articles, but they are for the version 10.x, i tried, but nothing changed. Perhaps because in my hosting a different version of the Panel Plesk (i have 11 ver.)

 

[IgorG]

It is database inconsistency. Mentioned articles http://kb.parallels.com/114632 and http://kb.parallels.com/113475 basically should help or give a right direction. Try to find missing reference in psa database for this domain_id=27 and fix it. Or contact Support Team if you are not familiar enough with SQL.