Diagnose and repair Plesk WARNING in database

Category：Plesk

Pub.date：2021-03-03

CentOS Linux 7.9<br>
Plesk Obsidian version 18.0.33 Update #1

Checking the consistency of the Plesk database Inconsistency in the table 'MailOutgoingMessagesStats' for the column mailId: No rows in the table 'mail' with id = 10

Inconsistency in the table 'Configurations' for the column objectId: No rows in the table 'domains' with id = 28

We know that 28 is the domain we deleted the other day in light of the backup.

## Check details with SSH

```
[~]# plesk repair db -n -verbose

Checking the Plesk database using the native database server tools
  Run query: CHECK TABLE accounts
  Run query: CHECK TABLE actions
  Run query: CHECK TABLE admin_aliases
  Run query: CHECK TABLE admin_aliases_param
  Run query: CHECK TABLE anon_ftp
  Run query: CHECK TABLE ApiRpcCallsStat
  Run query: CHECK TABLE APSApplicationItems
  Run query: CHECK TABLE APSCatalogUpdates
  Run query: CHECK TABLE apscategories
  Run query: CHECK TABLE APSClientApplicationItems
  Run query: CHECK TABLE apsContexts
  Run query: CHECK TABLE apsContextsApplications
  Run query: CHECK TABLE apsInstancesParameters
  Run query: CHECK TABLE APSLicenses
  Run query: CHECK TABLE APSLicenseTypes
  Run query: CHECK TABLE apsResources
  Run query: CHECK TABLE apsResourcesParameters
  Run query: CHECK TABLE ApsTokens
  Run query: CHECK TABLE avstatistics
  Run query: CHECK TABLE BackendCache
  Run query: CHECK TABLE BackupExcludeFiles
  Run query: CHECK TABLE BackupsScheduled
  Run query: CHECK TABLE BackupsSettings
  Run query: CHECK TABLE badmailfrom
  Run query: CHECK TABLE BlUpgradeActions
  Run query: CHECK TABLE BlUpgrades
  Run query: CHECK TABLE CertificateRepositories
  Run query: CHECK TABLE certificates
  Run query: CHECK TABLE cl_param
  Run query: CHECK TABLE CliCallsStat
  Run query: CHECK TABLE clients
  Run query: CHECK TABLE ClientsTraffic
  Run query: CHECK TABLE Configurations
  Run query: CHECK TABLE cp_access
  Run query: CHECK TABLE custom_buttons
  Run query: CHECK TABLE data_bases
  Run query: CHECK TABLE DatabaseCustomHosts
  Run query: CHECK TABLE DatabaseServers
  Run query: CHECK TABLE DatabaseUserRemoteAccessRules
  Run query: CHECK TABLE db_users
  Run query: CHECK TABLE disk_usage
  Run query: CHECK TABLE dns_recs
  Run query: CHECK TABLE dns_recs_t
  Run query: CHECK TABLE dns_refs
  Run query: CHECK TABLE dns_zone
  Run query: CHECK TABLE dom_param
  Run query: CHECK TABLE domain_aliases
  Run query: CHECK TABLE DomainAliasesParameters
  Run query: CHECK TABLE DomainOutgoingMessagesPeaks
  Run query: CHECK TABLE DomainOutgoingMessagesStats
  Run query: CHECK TABLE domains
  Run query: CHECK TABLE DomainServices
  Run query: CHECK TABLE DomainsTraffic
  Run query: CHECK TABLE dsn
  Run query: CHECK TABLE DynamicIpSecurity
  Run query: CHECK TABLE EmailActivations
  Run query: CHECK TABLE event_handlers
  Run query: CHECK TABLE exp_event
  Run query: CHECK TABLE externalWebmails
  Run query: CHECK TABLE forwarding
  Run query: CHECK TABLE ftp_users
  Run query: CHECK TABLE GL_remote_domains
  Run query: CHECK TABLE GL_settings
  Run query: CHECK TABLE hosting
  Run query: CHECK TABLE hotlink_friends
  Run query: CHECK TABLE hotlink_prot
  Run query: CHECK TABLE IisAppPoolDomains
  Run query: CHECK TABLE IisAppPools
  Run query: CHECK TABLE IisAppPoolsPolicy
  Run query: CHECK TABLE IP_Addresses
  Run query: CHECK TABLE ip_pool
  Run query: CHECK TABLE IpAddressesCollections
  Run query: CHECK TABLE IpCollections
  Run query: CHECK TABLE key_history
  Run query: CHECK TABLE key_history_params
  Run query: CHECK TABLE Limits
  Run query: CHECK TABLE LimitsReservation
  Run query: CHECK TABLE locales
  Run query: CHECK TABLE log_actions
  Run query: CHECK TABLE log_components
  Run query: CHECK TABLE log_rotation
  Run query: CHECK TABLE Logos
  Run query: CHECK TABLE longtaskparams
  Run query: CHECK TABLE longtasks
  Run query: CHECK TABLE mail
  Run query: CHECK TABLE mail_aliases
  Run query: CHECK TABLE mail_redir
  Run query: CHECK TABLE mail_resp
  Run query: CHECK TABLE MailLists
  Run query: CHECK TABLE MailMessagesStat
  Run query: CHECK TABLE MailOutgoingMessagesPeaks
  Run query: CHECK TABLE MailOutgoingMessagesStats
  Run query: CHECK TABLE mass_mail
  Run query: CHECK TABLE mass_mail_clients
  Run query: CHECK TABLE mass_mail_domains
  Run query: CHECK TABLE misc
  Run query: CHECK TABLE mn_param
  Run query: CHECK TABLE module_firewall_objects
  Run query: CHECK TABLE module_firewall_rules
  Run query: CHECK TABLE Modules
  Run query: CHECK TABLE ModuleSettings
  Run query: CHECK TABLE Notes
  Run query: CHECK TABLE Notifications
  Run query: CHECK TABLE PackageUpdateLocks
  Run query: CHECK TABLE PackageUpdateNotifications
  Run query: CHECK TABLE PanelNotificationMessages
  Run query: CHECK TABLE PanelNotificationTemplateSettings
  Run query: CHECK TABLE Parameters
  Run query: CHECK TABLE password_secrets
  Run query: CHECK TABLE pd_users
  Run query: CHECK TABLE Permissions
  Run query: CHECK TABLE PersistentCache
  Run query: CHECK TABLE PhpSettings
  Run query: CHECK TABLE PhpSettingsCustom
  Run query: CHECK TABLE PhpSettingsParameters
  Run query: CHECK TABLE PlanItemProperties
  Run query: CHECK TABLE PlanItems
  Run query: CHECK TABLE PlansSubscriptions
  Run query: CHECK TABLE PleskStats
  Run query: CHECK TABLE protected_dirs
  Run query: CHECK TABLE report
  Run query: CHECK TABLE report_auto
  Run query: CHECK TABLE report_section
  Run query: CHECK TABLE Repository
  Run query: CHECK TABLE resp_attach
  Run query: CHECK TABLE resp_forward
  Run query: CHECK TABLE resp_freq
  Run query: CHECK TABLE RestrictedDomains
  Run query: CHECK TABLE SBConfig
  Run query: CHECK TABLE SBResellers
  Run query: CHECK TABLE ScheduledTasks
  Run query: CHECK TABLE SchemaVersions
  Run query: CHECK TABLE secret_keys
  Run query: CHECK TABLE SecretKeys
  Run query: CHECK TABLE SecretKeysIpAddresses
  Run query: CHECK TABLE ServiceNodeCache
  Run query: CHECK TABLE ServiceNodeCertificates
  Run query: CHECK TABLE ServiceNodeConfiguration
  Run query: CHECK TABLE ServiceNodeEnvironment
  Run query: CHECK TABLE ServiceNodes
  Run query: CHECK TABLE SessionContexts
  Run query: CHECK TABLE sessions
  Run query: CHECK TABLE SiteAppsHitsStat
  Run query: CHECK TABLE SitePagesStat
  Run query: CHECK TABLE Skins
  Run query: CHECK TABLE smb_apsBundleFilterItems
  Run query: CHECK TABLE smb_apsBundleFilters
  Run query: CHECK TABLE smb_apsCategories
  Run query: CHECK TABLE smb_apsContexts
  Run query: CHECK TABLE smb_apsInstanceErrors
  Run query: CHECK TABLE smb_apsInstances
  Run query: CHECK TABLE smb_apsMetas
  Run query: CHECK TABLE smb_apsPackages
  Run query: CHECK TABLE smb_apsPackagesCategories
  Run query: CHECK TABLE smb_apsPackageUpdates
  Run query: CHECK TABLE smb_apsProvisionEnvironments
  Run query: CHECK TABLE smb_apsProvisions
  Run query: CHECK TABLE smb_apsResourceParameters
  Run query: CHECK TABLE smb_apsResources
  Run query: CHECK TABLE smb_apsSettings
  Run query: CHECK TABLE smb_componentUpdates
  Run query: CHECK TABLE smb_generalPermissions
  Run query: CHECK TABLE smb_locales
  Run query: CHECK TABLE smb_productUpgrades
  Run query: CHECK TABLE smb_roleGeneralPermissions
  Run query: CHECK TABLE smb_roles
  Run query: CHECK TABLE smb_roleServicePermissions
  Run query: CHECK TABLE smb_serviceEntryPoints
  Run query: CHECK TABLE smb_serviceInstances
  Run query: CHECK TABLE smb_servicePermissionAccounts
  Run query: CHECK TABLE smb_servicePermissions
  Run query: CHECK TABLE smb_serviceProviders
  Run query: CHECK TABLE smb_settings
  Run query: CHECK TABLE smb_users
  Run query: CHECK TABLE smb_userServicePermissions
  Run query: CHECK TABLE smtp_poplocks
  Run query: CHECK TABLE spamfilter
  Run query: CHECK TABLE spamfilter_preferences
  Run query: CHECK TABLE stat
  Run query: CHECK TABLE subdomains
  Run query: CHECK TABLE SubscriptionOutgoingMessagesPeaks
  Run query: CHECK TABLE SubscriptionOutgoingMessagesStats
  Run query: CHECK TABLE SubscriptionProperties
  Run query: CHECK TABLE Subscriptions
  Run query: CHECK TABLE suspend_handler_history
  Run query: CHECK TABLE sys_users
  Run query: CHECK TABLE Templates
  Run query: CHECK TABLE TmplData
  Run query: CHECK TABLE TraceFailedRequestsProviderAreas
  Run query: CHECK TABLE TraceFailedRequestsProviders
  Run query: CHECK TABLE TraceFailedRequestsRules
  Run query: CHECK TABLE upgrade_history
  Run query: CHECK TABLE UserSettings
  Run query: CHECK TABLE web_users
  Run query: CHECK TABLE webalizer_group_referrer
  Run query: CHECK TABLE webalizer_hidden_referrer
  Run query: CHECK TABLE Webmails
  Run query: CHECK TABLE WebServerSettings
  Run query: CHECK TABLE WebServerSettingsParameters

Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database

Inconsistency in the table 'MailOutgoingMessagesStats' for the
  column mailId: No rows in the table 'mail' with id = 10 ........... [WARNING]

Broken references in table 'MailOutgoingMessagesStats':
  *************************** 1. row ***************************
             mailId: 10
        collectDate: 2021-02-12 08:00:00
         limitValue: 100
             passed: 1
           rejected: 0
       passed_fixed: 0
  rejected_verified: 0

Inconsistency in the table 'Configurations' for the column objectId:
  No rows in the table 'domains' with id = 28 ....................... [WARNING]

Broken references in table 'Configurations':
  *************************** 1. row ***************************
             id: 411
           name: nginxDomainModSecurity
  serviceNodeId: 1
           file: /var/www/vhosts/system/smile7.jp/conf/modsecurity_nginx.conf
        version: 16126744150.45954600
     objectType: nginxDomain
       objectId: 28
         status: ok
         active: false
    description:
      errorFile:

Error messages: 0; Warnings: 2; Errors resolved: 0

[~]#
```
The option -n is a check only. It will not be repaired. <br>
The optional -verbose prints detailed information.

## Perform automatic repair of Plesk

```
warning	Checking the consistency of the Plesk database Inconsistency in the table 'MailOutgoingMessagesStats' for the column mailId: No rows in the table 'mail' with id = 10

fixed	Removing unnecessary rows

warning	Inconsistency in the table 'Configurations' for the column objectId: No rows in the table 'domains' with id = 28

fixed	Removing unnecessary rows
```

It was repaired automatically.

CONTENTS

Android

Unresolved reference: constraintlayout

Plesk

How to install SSH2 extension for PHP8.3 on Plesk

Flutter

Android Studio. Could not determine java version. Unable to find bundled Java version.

JavaScript