Domains suspending for no reason every day

Created:

2016-11-16 13:11:57 UTC

Modified:

2017-08-16 16:51:51 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Domains suspending for no reason every day

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 10.x for Linux
  • Plesk 11.x for Windows
  • Plesk 11.x for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux
  • Plesk 12.5 for Windows
  • Plesk 9.x for Linux

Symptoms

Domains are suspending for no reason. Accounts are locked out every night and their sites/services stop functioning.

It seems that subscriptions get automatically disabled when statistics are recalculated. This happens for several subscriptions.

We have checked this and all subscriptions are assigned to a custom plan where resource overusage is allowed, so subscriptions should not be suspended at all.

Cause

Parallels Plesk suspends subscriptions automatically if their expiration date passes. Plesk does not renew subscriptions automatically, so it suspends a subscription when the subscription expiration date comes. By default, the expiration date is "Setup date + 1 year".

Check if the expiration date for the affected subscription is earlier than the current date:

Subscriptions > domain.tld > Customize settings > Expiration date

You can find all domains with expired dates directly in the database:

How to access the Parallels Plesk database

For Plesk 11.5 for Linux:

SELECT  domains.name, FROM_UNIXTIME(Limits.value),  Limits.limit_name FROM Limits,     SubscriptionProperties       INNER JOIN Subscriptions         ON SubscriptionProperties.subscription_id = Subscriptions.id       INNER JOIN domains         ON Subscriptions.object_id = domains.id WHERE SubscriptionProperties.name = 'LimitsId' AND Limits.limit_name = 'expiration' AND SubscriptionProperties.value = Limits.id AND FROM_UNIXTIME(Limits.value) <= CURDATE();

+---------------------+-----------------------------+------------+
| name | FROM_UNIXTIME(Limits.value) | limit_name |
+---------------------+-----------------------------+------------+
| testpara.com | 2013-12-22 00:00:00 | expiration |
| testpara2.com | 2012-12-20 00:00:00 | expiration |
+---------------------+-----------------------------+------------+
2 rows in set (0.01 sec)

For Plesk 11.5 for Windows:

SELECT
domains.name,
limits.value,
limits.limit_name
FROM limits,
subscriptionproperties
INNER JOIN subscriptions
ON subscriptionproperties.subscription_id = subscriptions.id
INNER JOIN domains
ON subscriptions.object_id = domains.id
WHERE subscriptionproperties.name = 'limitsId' AND limits.limit_name = 'expiration' AND subscriptionproperties.value = limits.id;

For Plesk 10.4.4 for Linux:

SELECT  Limits.id, Limits.limit_name, FROM_UNIXTIME(Limits.value), domains.name FROM Limits  LEFT OUTER JOIN domains    ON Limits.id = domains.limits_id AND domains.limits_id = Limits.id WHERE Limits.limit_name = 'expiration' AND FROM_UNIXTIME(Limits.value) <= CURDATE();
+----+------------+-----------------------------+------------+
| id | limit_name | FROM_UNIXTIME(Limits.value) | name |
+----+------------+-----------------------------+------------+
| 5 | expiration | 2013-12-22 00:00:00 | domain.tld |
+----+------------+-----------------------------+------------+
1 row in set (0.00 sec)

Resolution

To renew an expired subscription, go to:

Subscriptions -> domain.tld -> Customize -> Expiration date -> Update & Lock

Note: After this step, the system will not apply further changes to plan settings for this subscription. If you try to sync the subscription with the plan, the subscription will expire again unless you set an unlimited validity period for the plan.

Change the expiration date in the menu:

Service Plans > My plan > Expiration date

Suggestion: Configure Email notifications for the event type 'Subscription expiration'.

Have more questions? Submit a request
Please sign in to leave a comment.