Recreating a subscription or enabling the mail service fails with: mailmng-outgoing failed: ERROR:__main__:column name is not unique

Symptoms

• Recreating a subscription stall while creating the mail accounts.

• Enabling the mail service after creating the subscription example.com fails with the following error:

  mailmng-outgoing failed: ERROR:__main__:column name is not unique

Cause

The outgoing mail control database already contains records about the subscription with the same name.

Resolution

1. Connect to the server via SSH

2. Reconfigure the mail subsystem:

   # plesk repair mail

3. In case the issue persists, try manually deleting the record associated with the affected subscription:

   # /usr/local/psa/admin/bin/mailmng-outgoing --remove-subscription --main-domain-name=example.com