Articles in this section

Inconsistency in the table 'SubscriptionOutgoingMessagesStats' for the column subscriptionId: No rows in the table 'Subscriptions'

Renan Poss Moreira
Updated
Plesk for Windows Plesk for Linux kb: technical

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

Symptoms

  • Plesk Database repair reports following warning:

    MYSQL_LIN: # 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

  1. Connect to the server via SSH or RDP

  2. Make a backup of the Plesk database: How to backup/restore a Plesk database dump.

  3. Execute the following command and remove the orphaned entries when it's prompted:

    # plesk repair db

Manually
  1. Connect to the server via SSH or RDP
  2. Make a backup of the Plesk database: How to backup/restore a Plesk database dump.
  3. Use the next command to remove the orphaned records:

    # plesk db "delete from SubscriptionOutgoingMessagesStats where subscriptionId=70;"

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.