Subscription resource usage parameters are changed randomly

Refers to:

  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:17:46 UTC

Modified:

2016-12-21 20:23:25 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Subscription resource usage parameters are changed randomly

Symptoms

  • Subscriptions keep becoming suspended in Plesk.

  • Sometimes, resource usage limits for different subscriptions are changed or reset randomly.

  • Subscriptions can not be synced correctly. Every day all of them are marked with red question (?). The subscriptions with red questionmark have 'Expiration Date' set to today. When trying to sync these subscriptions with Service Plan, nothing is changed.

  • Select from psa database shows that SubscriptionProperties table has duplicate limit IDs:

    mysql> select count(*), value from SubscriptionProperties where name='limitsId' group by 2  order by 1 desc limit 2;
    +----------+-------+
    | count(*) | value |
    +----------+-------+
    | 152 | 101 |
    | 1 | 99 |

Cause

Exact cause is under investigation. During Plesk upgrade values for limits are not generated correctly in SubscriptionProperties table.

Resolution

To fix the issue it is needed to generate such records manually. This requires good DB structure knowledge and solution is unique in every case, thus it is not shared publicly.

Please contact Plesk support for the assistance: https://cscontact.plesk.com/

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