Question:
Inconsistency in the table 'SubscriptionOutgoingMessagesStats' for the column subscriptionId: No rows in the table 'Subscriptions'
Symptoms
- Plesk Database repair reports following warning:
# plesk repair db -n
Inconsistency in the table 'SubscriptionOutgoingMessagesStats' for
the column subscriptionId: No rows in the table 'Subscriptions' with = 70 ..... [WARNING]
Broken references in table 'data_bases':
*************************** 1. row ***************************
subscriptionId: 70
collectDate: 2018-12-01 16:00:00
limitValue: 1000
passed: 1
rejected: 0
Error messages: 0; Warnings: 1; Errors resolved: 0- No such domain exists in the psa database with ID mentioned.
Cause
Database inconsistency with the unknown root cause.
Resolution
Using plesk repair db
- Connect to the server via SSH or RDP
- Make a backup of the Plesk database: How to backup/restore a Plesk database dump.
- Execute the following command and remove the orphaned entries when it's prompted
:
#plesk repair db
Manually
- Connect to the server via SSH or RDP
- Make a backup of the Plesk database: How to backup/restore a Plesk database dump.
- Use the next command to remove the orphaned records:
#plesk db "delete from SubscriptionOutgoingMessagesStats where subscriptionId=70;"