Symptoms
-
Domain provision fails with an error:
PLESK_ERROR: Error: Domain Service Web already exists: domain=example.org, id=5, ds_web_id=9
-
The resulting domain has Hosting Type set to No hosting, as can be seen in Domains > example.org:
-
There are orphan records in the DomainServices table:
# plesk db -Ne ‘SELECT COUNT(*) FROM DomainServices ds LEFT JOIN domains d ON ds.dom_id = d.id WHERE d.name IS NULL;’
10
Cause
Plesk backends prevents creation of the web hosting because the records in the DomainServices table with corresponding IDs already exist.
Resolution
-
Remove the orphan records from the database:
# plesk db ‘DELETE ds FROM DomainServices ds LEFT JOIN domains d ON ds.dom_id = d.id WHERE d.name IS NULL;’