Article ID: 125666, created on May 29, 2015, last review on May 29, 2015

  • Applies to:
  • Plesk 12.0 for Linux


Creation of domain on existed subscription results in error:

ERROR:outgoing:domains.subscription_id may not be NULL

Execution of mchk utility results in another error:

==> Checking for: mail_outgoing_restore... fail
==> Checking for: mail_transport_restore... ok
Errors occured in mail restore procedure
Some utilities have exited with errors:

Manual execution of /usr/lib/plesk-9.0/remote_mail_restore/mail_outgoing_restore utility also results in error:

 Error: PRIMARY KEY must be unique


Duplicate user ID in /etc/passwd.


Users for different subscriptions should have different ID and path.

  1. Use following script to find what user have duplicate ID and belongs to another subscription in /etc/passwd:

    ~]# cat duplicate
    find_duplicate_users() {
    SYS_USERS=$(mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -NBe "select login from sys_users WHERE mapped_to IS NULL;")
    for USER in `echo $SYS_USERS`
    grep "$USER:" /etc/passwd | awk -F":" '{print $1" "$3}'
    find_duplicate_users | sort -k2
    ~]#chmod +x duplicate
  2. Create a backup of /etc/passwd:

    cp -p /etc/passwd /etc/passwd.orig
  3. Change dublicated UID:

    ~]# usermod -u <New UID> <user>

Search Words

ERROR:outgoing:domains.subscription_id may not be NULL

mail_outgoing_restore fail

Error: PRIMARY KEY must be unique

PRIMARY KEY must be unique

Mchk utility fails with error at mail_outgoing_restore step

29d1e90fd304f01e6420fbe60f66f838 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7

Email subscription for changes to this article
Save as PDF