Cannot create domain with web hosting: Domain Service Web already exists

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

1. Connect to the server via SSH or RDP

2. Create Plesk database backup

3. Access Plesk database

4. 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;’