Can't create a new domain in a subscription

[Martin_Masson]

Hello,

Since about a week, we've been having trouble creating new domains in an existing subscription, we always get this error message:

Error: mailmng-outgoing failed: ERRORutgoing:domains.subscription_id may not be NULL

We tried the suggested fix in the KB (http://kb.odin.com/en/122104) but we get this output:

# /usr/local/psa/admin/sbin/mchk
==> Checking for: mailsrv_conf_init... ok
==> Checking for: mail_handlers_init... ok
==> Checking for: mailsrv_entities_dump... ok
==> Checking for: mail_admin_aliases... ok
==> Checking for: mail_auth_dump... ok
==> Checking for: mailman_lists_dump... ok
==> Checking for: mail_kav8_restore... ok
==> Checking for: mail_responder_restore... ok
==> Checking for: mail_imap_restore... ok
==> Checking for: mail_spam_restore... ok
==> Checking for: mail_grey_restore... ok
==> Checking for: mail_mailbox_restore... ok
==> Checking for: mail_spf_restore... ok
==> Checking for: mail_dk_restore... ok
==> Checking for: mail_drweb_restore... ok
==> Checking for: mail_outgoing_restore... fail
==> Checking for: mail_transport_restore... ok
Errors occured in mail restore procedure
Some utilities have exited with errors:
/usr/lib64/plesk-9.0/remote_mail_restore/mail_outgoing_restore

Can you suggest anything to fix this?

Thanks
Martin Masson

 

[IgorG]

This looks like a known problem. Have you checked KB - http://kb.odin.com/ru/122512?

 

[Martin_Masson]

This looks like a known problem. Have you checked KB - http://kb.odin.com/ru/122512?

Thanks Igor,

I've looked at the KB, and did what it says, and I got exactly the problem described in the it:

[2015-02-02 12:07:34] DEBUG [util_exec] [54cfaed6d6a8a] Starting: send-error-report /usr/local/psa/admin/bin/send-error-report
[2015-02-02 12:07:34] DEBUG [util_exec] [54cfaed6d6a8a] Finished in 0.00305s, Result: TRUE
Not a main domain of subscription.

Do you have any tip at finding the orphaned entry in the database?

Thanks again
Martin

 

[IgorG]

You can try to find excess records with something like:

mysql> select * from Subscriptions where object_type='domain' and object_id not in (select id from domains where webspace_id=0);

And then delete them from this table Subscriptions and related records in SubscriptionProperties for corresponding subscription_id.

Do not forget create dump of psa database before any changes just in case.

 

[Martin_Masson]

Hi thanks for helping me,

I just did it, I found 4 entries matching this and deleted them from Subscriptions and SubscriptionProperties.

mysql> select * from Subscriptions where object_type='domain' and object_id not in (select id from domains where webspace_id=0);
+----+-----------+-------------+--------+--------------+--------+--------------------------------------+-------------+
| id | object_id | object_type | locked | synchronized | custom | uuid | external_id |
+----+-----------+-------------+--------+--------------+--------+--------------------------------------+-------------+
| 49 | 66 | domain | false | true | true | xxxxxxxx-xxxxxxxxx-xxxx-xxxxxxxxxxxx | |
| 50 | 69 | domain | false | true | true | xxxxxxxx-xxxxxxxxx-xxxx-xxxxxxxxxxxx | |
| 51 | 71 | domain | false | true | true | xxxxxxxx-xxxxxxxxx-xxxx-xxxxxxxxxxxx | |
| 52 | 73 | domain | false | true | true | xxxxxxxx-xxxxxxxxx-xxxx-xxxxxxxxxxxx | |
+----+-----------+-------------+--------+--------------+--------+--------------------------------------+-------------+
4 rows in set (0.00 sec)

mysql> delete from SubscriptionProperties where subscription_id=49;
Query OK, 11 rows affected (0.04 sec)

mysql> delete from SubscriptionProperties where subscription_id=50;
Query OK, 11 rows affected (0.01 sec)

mysql> delete from SubscriptionProperties where subscription_id=51;
Query OK, 11 rows affected (0.00 sec)

mysql> delete from SubscriptionProperties where subscription_id=52;
Query OK, 11 rows affected (0.01 sec)

mysql> delete from Subscriptions where id=49;
Query OK, 1 row affected (0.05 sec)

mysql> delete from Subscriptions where id=50;
Query OK, 1 row affected (0.04 sec)

mysql> delete from Subscriptions where id=51;
Query OK, 1 row affected (0.00 sec)

mysql> delete from Subscriptions where id=52;
Query OK, 1 row affected (0.05 sec)

mysql> select * from Subscriptions where object_type='domain' and object_id not in (select id from domains where webspace_id=0);
Empty set (0.00 sec)


I tried adding the domain, it didn't work.
So I reran /usr/local/psa/admin/sbin/mchk, and got the same 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:
/usr/lib64/plesk-9.0/remote_mail_restore/mail_outgoing_restore

But then reran /usr/lib64/plesk-9.0/remote_mail_restore/mail_outgoing_restore and it ran without any error!?

# /usr/lib64/plesk-9.0/remote_mail_restore/mail_outgoing_restore
# echo $?
0

I then reran /usr/local/psa/admin/sbin/mchk and it went without any error.

# /usr/local/psa/admin/sbin/mchk
==> Checking for: mailsrv_conf_init... ok
==> Checking for: mail_handlers_init... ok
==> Checking for: mailsrv_entities_dump... ok
==> Checking for: mail_admin_aliases... ok
==> Checking for: mail_auth_dump... ok
==> Checking for: mailman_lists_dump... ok
==> Checking for: mail_kav8_restore... ok
==> Checking for: mail_responder_restore... ok
==> Checking for: mail_imap_restore... ok
==> Checking for: mail_spam_restore... ok
==> Checking for: mail_grey_restore... ok
==> Checking for: mail_mailbox_restore... ok
==> Checking for: mail_spf_restore... ok
==> Checking for: mail_dk_restore... ok
==> Checking for: mail_drweb_restore... ok
==> Checking for: mail_outgoing_restore... ok
==> Checking for: mail_transport_restore... ok

I tried adding the domain again and it worked!!

Not sure what happened after I deleted the orphaned entries, but it works now!!

Thanks a lot!