DailyMaintainance ERR [panel]

[TairkH]

Hello,

Plesk 12 fully updated mu#18
Centos 6.5

Statics is not updating traffic is not caclulating if i run DailyMaintainance i get this messages

[root@xxxxx ~]# /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/DailyMaintainance/script.php
[2014-10-06 13:20:01] ERR [panel] Unable to process instance #39: Unable to load object of type Domain with id=162: Domain does not exist.
[2014-10-06 13:20:12] ERR [util_exec] proc_close() failed

How to fix this error.......?
Also when i try to debug like this http://kb.odin.com/en/114065

de log file (50plesk-daily.log) only show this:

+ export PLESK_DEBUG_LEVEL=4
+ PLESK_DEBUG_LEVEL=4
+ /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/DailyMaintainance/script.php
+ /usr/local/psa/bin/mysqldump.sh



Greetz

 

[IgorG]

Unable to load object of type Domain with id=162: Domain does not exist.

It is database inconsistency. Domain with id 162 was not correctly removed. Try to find related records in 'domains', 'hosting', 'dom_param' and other tables for domain id 162. Contact Support Team if you are not familiar with SQL troubleshooting.

 

[TairkH]

Where to contact support?

 

[IgorG]

Support is here - http://odin.com/hcap/support/plesk-suite/plesk/

 

[TairkH]

Can you give me some commands? to find and deleet the rows?

 

[IgorG]

Can you give me some commands? to find and deleet the rows?

I gave you direction. It is impossible to provide concrete commands because a lot of different reasons and conditions can be there.

 

[TairkH]

I ran this:

[root@reseller ~]# for table in domain_aliases hosting dom_param DomainServices subdomains;do echo TABLE: $table; mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -e"select * from $table where dom_id=162";done

TABLE: domains
TABLE: domain_aliases
TABLE: hosting
TABLE: dom_param
TABLE: DomainServices
TABLE: subdomains

but still i get

ERR [panel] Unable to process instance #39: Unable to load object of type Domain with id=162: Domain does not exist.

Is there anoter table for stats?

 

[IgorG]

Try to find inconsistencies between tables "log_rotation" and "dom_param" for this dom_id.
Contact Support Team if you can't find inconsistencies by yourself.

 

[TairkH]

Thank you for replying.... the problem is i always need to pay for the support, and they give yah KB's first....


mysql> DESCRIBE dom_param;
+--------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+------------------+------+-----+---------+-------+
| dom_id | int(10) unsigned | NO | PRI | NULL | |
| param | varchar(245) | NO | PRI | NULL | |
| val | varbinary(255) | YES | | NULL | |
+--------+------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> select * from dom_param where dom_id='162';
Empty set (0.00 sec)

mysql>

mysql> DESCRIBE log_rotation;
+------------------------+---------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+---------------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| period_type | enum('by_time','by_size') | NO | | by_time | |
| period | varchar(50) | YES | | NULL | |
| max_number_of_logfiles | bigint(20) unsigned | YES | | 0 | |
| compress_enable | enum('false','true') | NO | | false | |
| email | varchar(255) | YES | | NULL | |
| turned_on | enum('false','true') | NO | | false | |
+------------------------+---------------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

mysql>


log_rotation has no dom_id.....

 

[IgorG]

mysql> select * from dom_param;
+--------+---------------------+--------------------------------------+
| dom_id | param | val |
+--------+---------------------+--------------------------------------+
| 1 | apacheErrorDocs | false |
| 1 | gl_filter | on |
| 1 | ip_addr_id | 1 |
| 1 | lastVisitTime | 2014-11-05T11:46:50+07:00 |
| 1 | logrotation_id | 5 |
| 1 | quickStartBar | true |
| 1 | stat_ttl | 3 |
| 1 | vhost_id | fbd7bd62-0a32-4348-9995-0a1f55e27599 |
| 1 | webmail | roundcube |
| 1 | webServerSettingsId | 2 |
| 1 | wu_script | true |
+--------+---------------------+--------------------------------------+
11 rows in set (0.00 sec)

mysql> select * from log_rotation;
+----+-------------+----------+------------------------+-----------------+-------+-----------+
| id | period_type | period | max_number_of_logfiles | compress_enable | email | turned_on |
+----+-------------+----------+------------------------+-----------------+-------+-----------+
| 1 | by_size | 10485760 | 10 | true | | true |
| 2 | by_size | 10485760 | 10 | true | | true |
| 3 | by_size | 10485760 | 10 | true | | true |
| 4 | by_size | 10485760 | 10 | true | | true |
| 5 | by_size | 10485760 | 1 | true | | false |
| 6 | by_size | 10485760 | 10 | true | | true |
+----+-------------+----------+------------------------+-----------------+-------+-----------+
6 rows in set (0.00 sec)

Relation in logrotation_id in dom_param and id in log_rotation.

 

[TairkH]

Thank you for the reply the problem is that dom_id 162 is deleted from dom_param table. so how i can't find the logrotation id.
How to find that ID if i can find it the problem is solved i think

 

[TairkH]

Anyone?

 

[IgorG]

Anyone?

Have you contacted Support Team? Any result? Believe me it is very difficult to fix database inconsistency remotely through forum discussion. Therefore I suggest you contact Support Team because experienced supporters can fix it directly on your server.