Forwarded to devs Plesk repair db throws error "The following domains are assigned to already removed IP addresses.", but no domain name given

[Bitpalast]

Username: Peter Debik

TITLE

Plesk repair db throws error "The following domains are assigned to already removed IP addresses.", but no domain name given

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

Obsidian, 18.0.35 MU #1
CentOS 7.9

PROBLEM DESCRIPTION

A "plesk repair db -y" shows an irrecoverable error
" The following domains are assigned to already removed IP addresses.
Reassign the domains to existing IP addresses:"
But it does not mention any domains so that it is impossible to find the root cause.

See Issue - Plesk repair: The following domains are assigned to already removed IP addresses. for details.

STEPS TO REPRODUCE

# plesk repair db -y

ACTUAL RESULT

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

The following domains are assigned to already removed IP addresses.
Reassign the domains to existing IP addresses:
.................................................................. [ERROR]

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

EXPECTED RESULT

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 ..................... [OK]

ANY ADDITIONAL INFORMATION

Reread IP addresses exposes two addresses: one IPv4 and one IPv6. Both are valid and have never changed. All subscriptions on the server are using at least the IPv4, some also use IPv6, but none uses an invalid address. All web server configuration files are good.

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug

 

[IgorG]

Peter, thank you, request PPPM-12988 created.
This issue is the following: due to the bug plesk repair utility tries to find IP address with "NULL" id, which obvious absentee.
The bug does not affect functionality.
As temporary workaround you may remove entries with "param" = ipv6_addr_id and "val" = NULL from psa.dom_param table.

 

[StefSabi]

Peter, thank you, request PPPM-12988 created.
This issue is the following: due to the bug plesk repair utility tries to find IP address with "NULL" id, which obvious absentee.
The bug does not affect functionality.
As temporary workaround you may remove entries with "param" = ipv6_addr_id and "val" = NULL from psa.dom_param table.

THX for the solution