Symptoms
- The following error is displayed when running
plesk repair dbon the server:
# plesk repair db
Inconsistency in the table 'domains' for the column id: No rows in
the table 'hosting' with dom_id ='11'
- The ID mentioned in the error message does not exist in the
hostingtable, but it does have a record in thedomainstable:
select * from hosting where dom_id=11;
Empty set (0.00 sec)
select name from domains where id=11;
+---------------+
| name |
+---------------+
| example.com |
+---------------+
1 row in set (0.000 sec)
- Trying to access Domains > example.com > Hosting Settings menu of the affected domain fails:
external error: Full path is undefined.
Message Full path is undefined.
File Webspace.php
Line 399
Type PleskFatalException
- The example.com domain's status is Disabled
Cause
Database inconsistency - there is missing record from the hosting table.
Resolution
-
Make a copy of
psadatabase:
# plesk db dump psa > "psa.sql.$(date +'%Y-%m-%d_%T').backup"
- Run a Plesk database check and repair the inconsistencies in the database:
# plesk repair db -v -y
If the automatic repair has failed, restore the record from daily dumps:
As a workaround:
1. Connect to the server via SSH
2. Locate the missing record in one of the daily database dumps using the ID mentioned in the error message:
# zgrep "INSERT INTO .hosting." /var/lib/psa/dumps/mysql.daily.dump.2.gz | grep 11
The required record would look similar to the following:
(11,229,0,'true','false','true','false','plesk-php73-fpm','true','false','false','false','false','','true','awstats','false',NULL,'/var/www/vhosts/example.com/httpdocs','false',444,-1,-1,'false','true','true')
3. Back up the Plesk database:
# plesk db dump psa > "psa.sql.$(date +'%Y-%m-%d_%T').backup"
4. Access the Plesk database and insert the recovered record:
# plesk db
mysql> insert into hosting values (11,229,0,'true','false','true','false','plesk-php73-fpm','true','false','false','false','false','','true','awstats','false',NULL,'/var/www/vhosts/example.com/httpdocs','false',444,-1,-1,'false','true','true');
Query OK, 1 row affected (0.01 sec)