Pleskの診断して修復　データベースでWARNING

カテゴリー：Plesk

記事作成日：2021-03-03

CentOS Linux 7.9<br>
Plesk Obsidian バージョン 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

28 は先日削除したドメインであることはバックアップと照らし合わせてわかっている。

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

[~]#
```
オプションの -n はチェックのみ。修復はしない。<br>
オプションの -verbose は詳細情報を出力。

## 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
```

自動修復された。

CONTENTS

Android

Androidアプリの合計ダウンロード数、iOSアプリの合計ダウンロード数

Flutter

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

その他

XAMPPのMySQLを復旧

ブラウザ