Issue Newly installed server having issues with IPV6 then Plesk database issue

[WiseWill]

Server operating system version

Ubuntu 24.04

Plesk version and microupdate number

18.0.74 Update #3

New server install. IPV6 worked fine until added the first domain name and then it broke and repair ip would not fix it. Once that got fixed it created a secondary issue of:


root@redacted:~# plesk repair db


Checking the Plesk database using the native database server tools .. [OK]



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



Checking the consistency of the Plesk database



Inconsistency in the table 'DomainServices' for the column

ipCollectionId: Web service cannot operate: the IP address list with

ID 2 is empty ..................................................... [ERROR]

Generate an IP address list based on DNS records? [Y/n] y

Creating a database dump ........................................ [OK]

A dump of the database was created before an attempt to repair the database: /var/lib/psa/dumps/mysql.preresolve.20260101-074511.dump.gz

Generating an IP address list ................................... [FAILED]

- No IP addresses found in DNS records.



Inconsistency in the table 'DomainServices' for the column

ipCollectionId: Web service cannot operate: the IP address list with

ID 4 is empty ..................................................... [ERROR]

Generate an IP address list based on DNS records? [Y/n] y

Generating an IP address list ................................... [FAILED]

- No IP addresses found in DNS records.



Inconsistency in the table 'DomainServices' for the column

ipCollectionId: Web service cannot operate: the IP address list with

ID 6 is empty ..................................................... [ERROR]

Generate an IP address list based on DNS records? [Y/n] y

Generating an IP address list ................................... [FAILED]

- No IP addresses found in DNS records.



Inconsistency in the table 'DomainServices' for the column

ipCollectionId: Web service cannot operate: the IP address list with

ID 10 is empty .................................................... [ERROR]

Generate an IP address list based on DNS records? [Y/n] y

Generating an IP address list ................................... [FAILED]

- No IP addresses found in DNS records.



Inconsistency in the table 'DomainServices' for the column

ipCollectionId: Web service cannot operate: the IP address list with

ID 12 is empty .................................................... [ERROR]

Generate an IP address list based on DNS records? [Y/n] y

Generating an IP address list ................................... [FAILED]

- No IP addresses found in DNS records.


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

exit status 1

root@redacted:~#

I am using external DNS hosting with Cloudflare.

 

[WiseWill]

root@redacted:~# plesk repair db -n -v

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 DomainKeys

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 Fail2BanIps

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

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

Run query: CHECK TABLE WebsitesDiagnostic

Run query: CHECK TABLE WebsitesDiagnosticDomains



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



Checking the consistency of the Plesk database



Inconsistency in the table 'DomainServices' for the column

ipCollectionId: Web service cannot operate: the IP address list with

ID 2 is empty ..................................................... [ERROR]



Inconsistency in the table 'DomainServices' for the column

ipCollectionId: Web service cannot operate: the IP address list with

ID 4 is empty ..................................................... [ERROR]



Inconsistency in the table 'DomainServices' for the column

ipCollectionId: Web service cannot operate: the IP address list with

ID 6 is empty ..................................................... [ERROR]



Inconsistency in the table 'DomainServices' for the column

ipCollectionId: Web service cannot operate: the IP address list with

ID 10 is empty .................................................... [ERROR]



Inconsistency in the table 'DomainServices' for the column

ipCollectionId: Web service cannot operate: the IP address list with

ID 12 is empty .................................................... [ERROR]



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

exit status 1

 

[scsa20]

If IPs was removed manually (and re-added and such) and not through the GUI can cause this. refer to https://support.plesk.com/hc/en-us/...rate-the-IP-address-list-with-ID-101-is-empty for fixing the plesk database.