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.
psadatabase shows that
SubscriptionPropertiestable 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 |
Exact cause is under investigation. During Plesk upgrade values for limits are not generated correctly in
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/