Unable to remove a customer in Plesk: Unable to load object of type Mailname with id

Symptoms

• The following error appears in Plesk UI during an attempt to delete a customer:

  CONFIG_TEXT: Error: Some of the selected customers were not deleted. Unable to remove customer: Unable to load object of type Mailname with id=64: Unable to create domain with ID "498"

• The same error can be obtained in the Plesk panel logs.

Cause

The issue is caused by a psa database inconsistency. It occurs if a record in the psa.mail table points to a non-existent domain ID.

Resolution

1. Connect to the Plesk server via RDP or SSH.
2. Create a database backup.

3. Make sure that the domain with id mentioned in the warning does not exist:

   MYSQL_LIN: mysql> select id, name from domains where id=498;
   Empty set (0.00 sec)

4. Check how many mailnames belong to the non-existent domain:

   MYSQL_LIN: mysql> select id,mail_name,dom_id from mail where dom_id=498;
   +----+-----------+--------+
   | id | mail_name | dom_id |
   +----+-----------+--------+
   | 26 | user1     | 498 |
   | 10 | user2     | 498 |
   | 11 | user3     | 498 |
   | 23 | user4     | 498 |
   | 64 | user5     | 498 |
   +----+-----------+--------+

5. Remove these mailnames:

   MYSQL_LIN: mysql> delete from mail where dom_id=498;

6. Remove the customer in Hosting Services > Customers